PHONES OPEN: 9:30AM-4:30PM (EST) M-F | P: 718-858-7422 | Toll-Free: 888-8-SCENTS (8-723687) | No Min. | No Tax ID Req.
Over 2500 products, gifts, collectibles, home furnishings, decor, all at wholesale prices!
Welcome Friend!    Sign Me In | Sign Me Up    

DROPSHIP Turnaround: Averaging 1-2 Days USPS Rates Available!
Shipping & Returns
Terms & Conditions
Privacy Policy
Contact Us
My Account        My Shopping Cart My Cart        Checkout Checkout
Specials Helpful Tools Company Info
 PRODUCT LINES

Avg. 1-2 biz days for your items to leave us in CA, unless otherwise posted.

U.S. Transit Times

International Transit Times

Full Price List
Home » Home Décor » Candles & Holders » Candle Holders
Displaying 1 to 20 (of 88 products) Result Pages:  1  2  3  4  5  [Next >>] 
    Item+   [Price][/lb.]    
 (12046) Dragoncrest Candleholder   (12046) Dragoncrest Candleholder   $19.95  $5.18  Buy Now 
 Add a wild edge to any decor with this tattoo-graphic candle lantern! Strikingly stylized dragon pattern casts a fascinating play of light and shadow and flickering flame. Weight 1 lb. Glass. Candle not included. 4 3/4" diameter x 7" high. Sugg. Retail Price per unit: $24.95 
 (12048) Tribal Tealight Holder   (12048) Tribal Tealight Holder   $10.95  $2.24  Buy Now 
 Striking tribal-style carvings lend exotic flair to a gracefully curved candle tray; simply add a trio of tealights for an entrancing centerpiece. MDF wood and metal. Tealights not included. 9 1/2" x 2" x 3 3/4" high. Sugg. Retail Price per unit: $10.95 
 (12168) Skull Votive Holder   (12168) Skull Votive Holder   $12.95  $5.00  Buy Now 
 Set a seriously spooky mood with this creepy candle cup! A trio of cutout skulls gets an eerie glimmer from a candle’s light, adding a fun dash of fright to any night. Weight 0.5 lb. Metal and glass. Candle not included. 2 1/2" diameter x 3" high. Sugg. Retail Price per unit: $12.95 
 (12171) Folk-art Angel Tealight Holder   (12171) Folk-art Angel Tealight Holder   $19.95  $3.85  Buy Now 
 An angel holds out a gift of light, shining faith into the night. Winsome folk-art statuette is charming by day; add a tealight to warm a dark corner with a golden glow. Porcelain. Candle not included. 2 1/2" x 4 3/4" x 8" high. Sugg. Retail Price per unit: $19.95 
 (12290) Granite Dragon Candleholder   (12290) Granite Dragon Candleholder   $29.95  $11.44  Buy Now 
 A granite-gray dragon hisses a warning to those who dare approach; fiercely guarding the tall taper candle held between his unfurling wings. Impressive candle stand adds a magical air anywhere! Weight 2.7 lbs. Polyresin and stone powder. Candle not included. 7" x 4 3/4" x 8 1/8" high 
 (12561) Jeweled Teardrop Votive Stand   (12561) Jeweled Teardrop Votive Stand   $10.95  $4.20  Buy Now 
 Graceful crystal drops turn a candle’s glow into liquid light, adding bewitching beauty to a classic wrought-iron candle stand. An elegantly simple accent piece ideal for any room! Weight 0.7 lb. Metal, plastic beads, and glass cup. Candle not included. 4 3/8" diameter x 9 1/2" high. 
 (12793) Amber Calla Lily Candleholder   (12793) Amber Calla Lily Candleholder   $69.95  $26.80  Buy Now 
 Slender curving stems support iridescent amber lily blossoms, creating an elegant play of form and color. Place a candle into each bloom to enhance the night with dazzling light! Glass, iron and acrylic. Tealight candles not included. May Require Additional Freight Charge. Some Assembly Required. 10" x 10" x 24 1/4" high. 
 (12794) Silver Calla Lily Candleholder   (12794) Silver Calla Lily Candleholder   $79.95  $33.29  Buy Now 
 Slender silver spires and leaves surround delicate frosted lily blooms; lovely by day, and enchanting when crowned with candlelight. An art-house treasure in the classic Art Deco tradition! Weight 4.6 lbs. Iron, glass and acrylic. Tealight candles not included. May Require Additional Freight Charge. Some Assembly Required. 11 1/2" x 8 5/8" x 32" high. 
 (12795) Ivory Tasseled Votive Stand   (12795) Ivory Tasseled Votive Stand   $19.95  $5.35  Buy Now 
 Palatial candleholder adds a lush touch of opulence, with a scrollwork support and pearly ivory trim. Whether your look is Persian or Parisian, this gorgeous candle stand fits right in! Weight 1 lb. Iron and glass. Candles not included. 9" x 4 3/4" x 12" high. 
 (28234) Elegant Metal Candleholders   (28234) Elegant Metal Candleholders   $16.95  $6.50  Buy Now 
 Elegant, Spanish mission style, metal candleholders. Price per pair. 5" diameter, 8" high. Sugg. Retail Price per unit: $12.95 
 (31132) Star Pattern Metal Lantern   (31132) Star Pattern Metal Lantern   $10.95  $4.54  Buy Now 
 Reminiscent of the lamps of colonial times, this "antique" look candle lamp has a burnished finish and glass windows. 5" x 5" x 9 1/2" high. Sugg. Retail Price per unit: $11.95 
 (31574) Metal Moroccan Style Lantern   (31574) Metal Moroccan Style Lantern   $10.95  $4.31  Buy Now 
 Designed in the Moroccan style, this metal candle lantern features intricate detailing. 3 3/4" x 3 3/4" x 11 1/2" high. Sugg. Retail Price per unit: $9.95 
 (32033) Metal White Floral Candleholder   (32033) Metal White Floral Candleholder   $9.95  $1.90  Buy Now 
 Metal is the medium for this unique, wall-decoration, candleholder. A fine addition to your home decor. 9 3/4" x 4 1/2" x 17 3/4" high. Candle not included. Sugg. Retail Price per unit: $14.95 
 (32402) Wrought Iron Swirl Wall Holders   (32402) Wrought Iron Swirl Wall Holders   $19.95  $7.65  Buy Now 
 Swirling and whirling with an unconventional harmony, this is one "twisted," yet lovely, set of wrought iron candle holders! Candles not included. 7"x 5" x 13" high; for 3" diameter candles. Price per pair. Sugg. Retail Price per unit: $19.95 
 (32403) Wrought Iron 5 Wall Candleholder   (32403) Wrought Iron 5 Wall Candleholder   $59.95  $22.94  Buy Now 
 You'll get dizzy trying to follow the twists and turns in this swirly, wrought iron candle holder! Better to just enjoy the lovely display it makes on your wall. Holds five 3" diameter candles. Candles not included. 28" x 5 1/2" x 11 1/2" high. Sugg. Retail Price per unit: $42.95 
 (33144) Large Moroccan Color Glass Lantern   (33144) Large Moroccan Color Glass Lantern   $24.95  $9.55  Buy Now 
 Ornate cut-outs in this Moroccan-style lantern will cast beautiful shadows when lit from within by a candle. Set on a surface, or hang. Metal with colored glass panels. 6 1/2" x 7 1/2" x 13" high. Candle not included. Sugg. Retail Price per unit: $27.95 
 (33145) Moroccan Color Glass Lantern   (33145) Moroccan Color Glass Lantern   $10.95  $4.37  Buy Now 
 A petite Moroccan-style lantern to set on a table or hang. Place a candle inside to create an exotic glow. Metal frame with amber glass. 4 1/8" x 3 5/8" x 10 1/4" high. Candle not included. Sugg. Retail Price per unit: $10.95 
 (33802) Clear Acrylic Drops Candle Holder   (33802) Clear Acrylic Drops Candle Holder   $24.95  $10.29  Buy Now 
 With the elegant look of carved glass, this candlestick features six diamond-shaped pendants. Acrylic with a metal candle cup. For tapers only. 3 3/4" x 3 3/4" x 11 3/4" high. Sugg. Retail Price per unit: $19.95 
 (34690) Moroccan-Style Star Lantern   (34690) Moroccan-Style Star Lantern   $49.95  $19.15  Buy Now 
 The many-pointed Moroccan star is the inspiration for this multicolored lantern. Insert a tealight or votive to set the jewel-tone panels aglow! Metal with glass panels. Uses tealights or votive candles (not included). 11" x 11" x 14" high. Sugg. Retail Price per unit: $49.95 
 (34691) Amber Candle Lantern   (34691) Amber Candle Lantern   $39.95  $15.30  Buy Now 
 Tall Moroccan-style candle lantern with amber glass panels. For pillar candle (not included). Metal. 6 1/4" x 5 3/8" x 19" high. Sugg. Retail Price per unit: $39.95 
Displaying 1 to 20 (of 88 products) Result Pages:  1  2  3  4  5  [Next >>] 
  Friday 18 May, 2012     17996302 requests since Thursday 31 July, 2003  
White Barn Gifts is a division of Save On Scents, Inc. & Roy New York : Copyright Š 2004, All Rights Reserved
388 3rd Avenue, Brooklyn, New York, 11215 : Phone (718) 858-7422 : Fax (801) 382-1487
Partners:
Wholesale Fragrance Oils, Perfume Oils, Body Oils, Incense Supplies ...


Current Parse Time: 32.484 s with 470 queries
QUERY DEBUG: 
Array
(
    [QUERIES] => Array
        (
            [0] => select value from sessions where sesskey = 'cded79b9a7aa4b042f692ce08707a8ec' and expiry > '1337326344'
            [1] => select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies
            [2] => select languages_id, name, code, image, directory from languages order by sort_order
            [3] => select counter from visitors where browser_ip = '38.107.179.222' AND browser_language = 'en-us,en;q=0.5' AND to_days(now()) - to_days(date) < 1
            [4] => update visitors set counter = '2', date = now() where browser_ip = '38.107.179.222' AND browser_language = 'en-us,en;q=0.5' AND to_days(now()) - to_days(date) < 1
            [5] => delete from whos_online where time_last_click < '1337325450'
            [6] => select count(*) as count from whos_online where session_id = 'cded79b9a7aa4b042f692ce08707a8ec'
            [7] => update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '38.107.179.222', time_last_click = '1337326350', last_page_url = '/index.php/cPath/15_16_17/language/en' where session_id = 'cded79b9a7aa4b042f692ce08707a8ec'
            [8] => select banners_id, date_scheduled from banners where date_scheduled != ''
            [9] => select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id
            [10] => select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0
            [11] => select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0
            [12] => select categories_name from categories_description where categories_id = '15' and language_id = '1'
            [13] => select categories_name from categories_description where categories_id = '16' and language_id = '1'
            [14] => select categories_name from categories_description where categories_id = '17' and language_id = '1'
            [15] => select count(*) as total from products_to_categories where categories_id = '17'
            [16] => select title, keywords, description from meta_tags where categories_id = '17'
            [17] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [18] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '253' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [19] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '311' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [20] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '310' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [21] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '425' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [22] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '451' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [23] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '465' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [24] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '466' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [25] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '410' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [26] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '421' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [27] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '418' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [28] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '424' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [29] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '411' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [30] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '423' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [31] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '415' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [32] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '420' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [33] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '422' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [34] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '413' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [35] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '419' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [36] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '417' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [37] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '414' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [38] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '412' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [39] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '416' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [40] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '281' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [41] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '346' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [42] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '285' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [43] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '282' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [44] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '284' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [45] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '264' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [46] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '357' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [47] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '275' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [48] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '364' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [49] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '345' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [50] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '280' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [51] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '276' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [52] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '463' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [53] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '464' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [54] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '272' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [55] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '274' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [56] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '268' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [57] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '356' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [58] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '351' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [59] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '269' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [60] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '354' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [61] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '358' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [62] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '353' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [63] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '361' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [64] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '273' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [65] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '365' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [66] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '442' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [67] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '265' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [68] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '266' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [69] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '348' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [70] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '349' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [71] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '350' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [72] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '267' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [73] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '277' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [74] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '271' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [75] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '1' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [76] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '61' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [77] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '170' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [78] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '8' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [79] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '98' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [80] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '9' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [81] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '236' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [82] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '89' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [83] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '62' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [84] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '63' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [85] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '2' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [86] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '3' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [87] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '68' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [88] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '4' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [89] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '67' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [90] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '5' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [91] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '69' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [92] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '84' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [93] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '6' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [94] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '7' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [95] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '101' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [96] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '108' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [97] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '10' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [98] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '119' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [99] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '102' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [100] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '171' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [101] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '59' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [102] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '82' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [103] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '174' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [104] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '60' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [105] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '83' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [106] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '112' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [107] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '64' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [108] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '209' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [109] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '244' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [110] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '238' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [111] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '210' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [112] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '242' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [113] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '76' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [114] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '65' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [115] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '103' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [116] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '12' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [117] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '15' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [118] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '85' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [119] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '77' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [120] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '16' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [121] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '17' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [122] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '70' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [123] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '130' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [124] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '131' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [125] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '156' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [126] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '132' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [127] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '18' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [128] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '19' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [129] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '163' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [130] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '458' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [131] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '78' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [132] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '20' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [133] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '164' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [134] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '32' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [135] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '111' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [136] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '11' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [137] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '25' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [138] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '27' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [139] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '86' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [140] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '87' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [141] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '135' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [142] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '28' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [143] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '93' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [144] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '29' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [145] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '121' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [146] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '30' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [147] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '31' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [148] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '33' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [149] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '106' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [150] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '136' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [151] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '109' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [152] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '462' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [153] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '41' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [154] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '42' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [155] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '73' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [156] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '43' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [157] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '110' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [158] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '44' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [159] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '45' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [160] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '146' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [161] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '147' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [162] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '46' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [163] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '47' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [164] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '148' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [165] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '95' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [166] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '34' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [167] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '35' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [168] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '90' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [169] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '36' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [170] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '133' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [171] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '137' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [172] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '91' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [173] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '53' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [174] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '152' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [175] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '54' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [176] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '168' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [177] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '172' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [178] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '74' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [179] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '75' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [180] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '21' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [181] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '149' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [182] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '456' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [183] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '22' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [184] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '97' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [185] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '26' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [186] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '428' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [187] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '71' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [188] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '23' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [189] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '150' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [190] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '48' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [191] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '151' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [192] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '140' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [193] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '49' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [194] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '50' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [195] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '113' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [196] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '88' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [197] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '107' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [198] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '344' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [199] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '99' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [200] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '116' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [201] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '450' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [202] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '124' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [203] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '431' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [204] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '445' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [205] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '128' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [206] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '341' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [207] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '118' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [208] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '100' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [209] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '175' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [210] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '122' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [211] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '123' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [212] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '56' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [213] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '57' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [214] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '58' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [215] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '13' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [216] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '14' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [217] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '92' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [218] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '51' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [219] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '79' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [220] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '114' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [221] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '173' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [222] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '352' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [223] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '120' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [224] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '52' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [225] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '328' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [226] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '80' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [227] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '126' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [228] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '81' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [229] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '457' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [230] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '117' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [231] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '436' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [232] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '440' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [233] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '441' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [234] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '438' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [235] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '454' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [236] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '453' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [237] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '437' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [238] => select distinct p.products_id, pd.products_name from products p, products_description pd, products_to_categories p2c, categories c where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '17' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit 25
            [239] => select p.products_id, pd.products_name, products_date_added as date_expected from products p, products_description pd where to_days(products_date_added) <= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '1' order by date_expected desc limit 25
            [240] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [241] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '253' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [242] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '311' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [243] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '310' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [244] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '425' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [245] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '451' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [246] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '465' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [247] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '466' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [248] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '410' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [249] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '421' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [250] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '418' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [251] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '424' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [252] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '411' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [253] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '423' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [254] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '415' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [255] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '420' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [256] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '422' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [257] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '413' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [258] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '419' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [259] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '417' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [260] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '414' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [261] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '412' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [262] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '416' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [263] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '281' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [264] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '346' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [265] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '285' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [266] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '282' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [267] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '284' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [268] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '264' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [269] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '357' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [270] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '275' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [271] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '364' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [272] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '345' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [273] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '280' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [274] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '276' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [275] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '463' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [276] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '464' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [277] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '272' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [278] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '274' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [279] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '268' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [280] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '356' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [281] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '351' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [282] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '269' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [283] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '354' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [284] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '358' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [285] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '353' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [286] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '361' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [287] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '273' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [288] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '365' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [289] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '442' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [290] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '265' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [291] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '266' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [292] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '348' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [293] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '349' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [294] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '350' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [295] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '267' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [296] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '277' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [297] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '271' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [298] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '1' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [299] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '61' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [300] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '170' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [301] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '8' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [302] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '98' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [303] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '9' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [304] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '236' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [305] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '89' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [306] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '62' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [307] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '63' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [308] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '2' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [309] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '3' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [310] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '68' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [311] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '4' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [312] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '67' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [313] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '5' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [314] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '69' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [315] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '84' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [316] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '6' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [317] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '7' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [318] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '101' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [319] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '108' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [320] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '10' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [321] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '119' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [322] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '102' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [323] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '171' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [324] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '59' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [325] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '82' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [326] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '174' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [327] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '60' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [328] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '83' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [329] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '112' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [330] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '64' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [331] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '209' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [332] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '244' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [333] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '238' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [334] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '210' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [335] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '242' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [336] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '76' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [337] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '65' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [338] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '103' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [339] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '12' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [340] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '15' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [341] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '85' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [342] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '77' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [343] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '16' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [344] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '17' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [345] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '70' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [346] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '130' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [347] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '131' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [348] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '156' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [349] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '132' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [350] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '18' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [351] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '19' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [352] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '163' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [353] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '458' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [354] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '78' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [355] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '20' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [356] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '164' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [357] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '32' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [358] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '111' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [359] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '11' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [360] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '25' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [361] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '27' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [362] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '86' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [363] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '87' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [364] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '135' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [365] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '28' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [366] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '93' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [367] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '29' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [368] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '121' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [369] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '30' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [370] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '31' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [371] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '33' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [372] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '106' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [373] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '136' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [374] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '109' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [375] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '462' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [376] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '41' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [377] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '42' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [378] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '73' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [379] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '43' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [380] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '110' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [381] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '44' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [382] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '45' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [383] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '146' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [384] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '147' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [385] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '46' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [386] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '47' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [387] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '148' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [388] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '95' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [389] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '34' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [390] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '35' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [391] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '90' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [392] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '36' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [393] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '133' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [394] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '137' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [395] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '91' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [396] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '53' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [397] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '152' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [398] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '54' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [399] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '168' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [400] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '172' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [401] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '74' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [402] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '75' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [403] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '21' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [404] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '149' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [405] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '456' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [406] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '22' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [407] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '97' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [408] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '26' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [409] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '428' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [410] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '71' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [411] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '23' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [412] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '150' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [413] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '48' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [414] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '151' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [415] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '140' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [416] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '49' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [417] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '50' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [418] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '113' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [419] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '88' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [420] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '107' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [421] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '344' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [422] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '99' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [423] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '116' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [424] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '450' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [425] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '124' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [426] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '431' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [427] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '445' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [428] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '128' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [429] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '341' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [430] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '118' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [431] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '100' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [432] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '175' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [433] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '122' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [434] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '123' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [435] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '56' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [436] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '57' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [437] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '58' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [438] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '13' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [439] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '14' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [440] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '92' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [441] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '51' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [442] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '79' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [443] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '114' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [444] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '173' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [445] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '352' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [446] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '120' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [447] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '52' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [448] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '328' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [449] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '80' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [450] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '126' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [451] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '81' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [452] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '457' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [453] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '117' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [454] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '436' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [455] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '440' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [456] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '441' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [457] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '438' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [458] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '454' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [459] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '453' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [460] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '437' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name
            [461] => select cd.categories_name, cd.categories_heading_title, cd.categories_description, c.categories_image from categories c, categories_description cd where c.categories_id = '17' and cd.categories_id = '17' and cd.language_id = '1'
            [462] => select categories_image from categories where categories_id = '17'
            [463] => select count(p.products_id) as total  from (products_description pd, products p, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '17'
            [464] => select p.products_image, pd.products_name, pd.products_description,  p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (products_description pd, products p, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '17' order by pd.products_name limit 0, 20
            [465] => select products_id, specials_new_products_price from specials where (products_id = '20089' or products_id = '19812' or products_id = '20127' or products_id = '19832' or products_id = '20242' or products_id = '20417' or products_id = '20510' or products_id = '20693' or products_id = '20692' or products_id = '1761' or products_id = '1699' or products_id = '1543' or products_id = '1839' or products_id = '2215' or products_id = '468' or products_id = '131' or products_id = '1638' or products_id = '2222' or products_id = '4115' or products_id = '4116' ) and status = '1' and customers_group_id =  '0'
            [466] => select startdate, counter from counter
            [467] => update counter set counter = '17996302'
            [468] => select count(*) as total from sessions where sesskey = 'cded79b9a7aa4b042f692ce08707a8ec'
            [469] => update sessions set expiry = '1337327817', value = 'cart|O:12:\"shoppingCart\":6:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:6:\"cartID\";N;s:12:\"content_type\";b:0;s:13:\"total_virtual\";i:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:13:{i:0;a:4:{s:4:\"page\";s:7:\"rss.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}i:1;a:4:{s:4:\"page\";s:16:\"cookie_usage.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}i:2;a:4:{s:4:\"page\";s:11:\"account.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:8:\"language\";s:2:\"pi\";}s:4:\"post\";a:0:{}}i:3;a:4:{s:4:\"page\";s:9:\"login.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:8:\"language\";s:2:\"pi\";}s:4:\"post\";a:0:{}}i:4;a:4:{s:4:\"page\";s:17:\"allcategories.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:8:\"language\";s:2:\"pi\";}s:4:\"post\";a:0:{}}i:5;a:4:{s:4:\"page\";s:12:\"allprods.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:8:\"language\";s:2:\"pi\";}s:4:\"post\";a:0:{}}i:6;a:4:{s:4:\"page\";s:32:\"catalog_products_with_images.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}i:7;a:4:{s:4:\"page\";s:21:\"checkout_shipping.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:8:\"language\";s:2:\"pi\";}s:4:\"post\";a:0:{}}i:8;a:4:{s:4:\"page\";s:14:\"conditions.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:8:\"language\";s:2:\"pi\";}s:4:\"post\";a:0:{}}i:9;a:4:{s:4:\"page\";s:14:\"contact_us.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:8:\"language\";s:2:\"pi\";}s:4:\"post\";a:0:{}}i:10;a:4:{s:4:\"page\";s:18:\"create_account.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:8:\"language\";s:2:\"pi\";}s:4:\"post\";a:0:{}}i:11;a:4:{s:4:\"page\";s:10:\"gv_faq.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:8:\"language\";s:2:\"pi\";}s:4:\"post\";a:0:{}}i:12;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:2:{s:5:\"cPath\";s:8:\"15_16_17\";s:8:\"language\";s:2:\"en\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:4:{s:4:\"page\";s:21:\"checkout_shipping.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:8:\"language\";s:2:\"pi\";}s:4:\"post\";a:0:{}}}' where sesskey = 'cded79b9a7aa4b042f692ce08707a8ec'
        )

    [TIME] => Array
        (
            [0] => 0.000427
            [1] => 0.000150
            [2] => 0.000147
            [3] => 0.831021
            [4] => 4.506943
            [5] => 0.000354
            [6] => 0.000323
            [7] => 0.000497
            [8] => 0.000326
            [9] => 0.000174
            [10] => 0.003336
            [11] => 0.000302
            [12] => 0.000191
            [13] => 0.000188
            [14] => 0.000135
            [15] => 0.000136
            [16] => 0.000131
            [17] => 0.000141
            [18] => 0.000222
            [19] => 0.000102
            [20] => 0.000082
            [21] => 0.000141
            [22] => 0.000114
            [23] => 0.000108
            [24] => 0.000104
            [25] => 0.000083
            [26] => 0.000098
            [27] => 0.000062
            [28] => 0.000082
            [29] => 0.000056
            [30] => 0.000053
            [31] => 0.000054
            [32] => 0.000057
            [33] => 0.000062
            [34] => 0.000068
            [35] => 0.000093
            [36] => 0.000057
            [37] => 0.000056
            [38] => 0.000053
            [39] => 0.000053
            [40] => 0.000058
            [41] => 0.000054
            [42] => 0.000050
            [43] => 0.000052
            [44] => 0.000056
            [45] => 0.000080
            [46] => 0.000088
            [47] => 0.000057
            [48] => 0.000056
            [49] => 0.000051
            [50] => 0.000057
            [51] => 0.000051
            [52] => 0.000056
            [53] => 0.000050
            [54] => 0.000054
            [55] => 0.000058
            [56] => 0.000086
            [57] => 0.000067
            [58] => 0.000054
            [59] => 0.000052
            [60] => 0.000053
            [61] => 0.000055
            [62] => 0.000060
            [63] => 0.000061
            [64] => 0.000052
            [65] => 0.000055
            [66] => 0.000049
            [67] => 0.000055
            [68] => 0.000092
            [69] => 0.000057
            [70] => 0.000062
            [71] => 0.000059
            [72] => 0.000054
            [73] => 0.000050
            [74] => 0.000056
            [75] => 0.000063
            [76] => 0.000064
            [77] => 0.000052
            [78] => 0.000052
            [79] => 0.000100
            [80] => 0.000055
            [81] => 0.000054
            [82] => 0.000064
            [83] => 0.000062
            [84] => 0.000055
            [85] => 0.000084
            [86] => 0.000049
            [87] => 0.000051
            [88] => 0.000059
            [89] => 0.000092
            [90] => 0.000080
            [91] => 0.000057
            [92] => 0.000055
            [93] => 0.000044
            [94] => 0.000056
            [95] => 0.000057
            [96] => 0.000054
            [97] => 0.000053
            [98] => 0.000052
            [99] => 0.000057
            [100] => 0.000070
            [101] => 0.000068
            [102] => 0.000064
            [103] => 0.000053
            [104] => 0.000053
            [105] => 0.000055
            [106] => 0.000055
            [107] => 0.000060
            [108] => 0.000059
            [109] => 0.000056
            [110] => 0.000053
            [111] => 0.000051
            [112] => 0.000049
            [113] => 0.000089
            [114] => 0.000066
            [115] => 0.000053
            [116] => 0.000048
            [117] => 0.000062
            [118] => 0.000056
            [119] => 0.000062
            [120] => 0.000058
            [121] => 0.000051
            [122] => 0.000052
            [123] => 0.000054
            [124] => 0.000086
            [125] => 0.000065
            [126] => 0.000059
            [127] => 0.000059
            [128] => 0.000057
            [129] => 0.000056
            [130] => 0.000051
            [131] => 0.000058
            [132] => 0.000061
            [133] => 0.000053
            [134] => 0.000046
            [135] => 0.000092
            [136] => 0.000053
            [137] => 0.000058
            [138] => 0.000065
            [139] => 0.000065
            [140] => 0.000065
            [141] => 0.000055
            [142] => 0.000052
            [143] => 0.000054
            [144] => 0.000050
            [145] => 0.000078
            [146] => 0.000112
            [147] => 0.000053
            [148] => 0.000055
            [149] => 0.000054
            [150] => 0.000050
            [151] => 0.000055
            [152] => 0.000053
            [153] => 0.000053
            [154] => 0.000060
            [155] => 0.000057
            [156] => 0.000054
            [157] => 0.000076
            [158] => 0.000056
            [159] => 0.000055
            [160] => 0.000053
            [161] => 0.000049
            [162] => 0.000054
            [163] => 0.000055
            [164] => 0.000057
            [165] => 0.000056
            [166] => 0.000059
            [167] => 0.000083
            [168] => 0.000096
            [169] => 0.000052
            [170] => 0.000052
            [171] => 0.000053
            [172] => 0.000056
            [173] => 0.000054
            [174] => 0.000056
            [175] => 0.000061
            [176] => 0.000054
            [177] => 0.000057
            [178] => 0.000052
            [179] => 0.000076
            [180] => 0.000057
            [181] => 0.000053
            [182] => 0.000052
            [183] => 0.000052
            [184] => 0.000060
            [185] => 0.000055
            [186] => 0.000053
            [187] => 0.000051
            [188] => 0.000054
            [189] => 0.000051
            [190] => 0.000108
            [191] => 0.000056
            [192] => 0.000055
            [193] => 0.000058
            [194] => 0.000058
            [195] => 0.000051
            [196] => 0.000052
            [197] => 0.000054
            [198] => 0.000056
            [199] => 0.000062
            [200] => 0.000056
            [201] => 0.000082
            [202] => 0.000055
            [203] => 0.000057
            [204] => 0.000053
            [205] => 0.000048
            [206] => 0.000055
            [207] => 0.000054
            [208] => 0.000052
            [209] => 0.000055
            [210] => 0.000058
            [211] => 0.000057
            [212] => 0.000082
            [213] => 0.000054
            [214] => 0.000053
            [215] => 0.000053
            [216] => 0.000061
            [217] => 0.000051
            [218] => 0.000054
            [219] => 0.000055
            [220] => 0.000053
            [221] => 0.000054
            [222] => 0.000095
            [223] => 0.000060
            [224] => 0.000052
            [225] => 0.000055
            [226] => 0.000061
            [227] => 0.000058
            [228] => 0.000058
            [229] => 0.000051
            [230] => 0.000052
            [231] => 0.000063
            [232] => 0.000055
            [233] => 0.000044
            [234] => 0.000121
            [235] => 0.000061
            [236] => 0.000056
            [237] => 0.000055
            [238] => 0.000224
            [239] => 0.000618
            [240] => 0.000167
            [241] => 0.000223
            [242] => 0.000142
            [243] => 0.000140
            [244] => 0.000141
            [245] => 0.000142
            [246] => 0.000065
            [247] => 0.000066
            [248] => 0.000117
            [249] => 0.000076
            [250] => 0.000124
            [251] => 0.000109
            [252] => 0.000059
            [253] => 0.000055
            [254] => 0.000055
            [255] => 0.000141
            [256] => 0.000050
            [257] => 0.000059
            [258] => 0.000052
            [259] => 0.000055
            [260] => 0.000052
            [261] => 0.000058
            [262] => 0.000055
            [263] => 0.000058
            [264] => 0.000056
            [265] => 0.000057
            [266] => 0.000105
            [267] => 0.000055
            [268] => 0.000056
            [269] => 0.000053
            [270] => 0.000057
            [271] => 0.000056
            [272] => 0.000051
            [273] => 0.000052
            [274] => 0.000050
            [275] => 0.000057
            [276] => 0.000067
            [277] => 0.000136
            [278] => 0.000052
            [279] => 0.000053
            [280] => 0.000060
            [281] => 0.000053
            [282] => 0.000049
            [283] => 0.000049
            [284] => 0.000055
            [285] => 0.000051
            [286] => 0.000056
            [287] => 0.000072
            [288] => 0.000123
            [289] => 0.000050
            [290] => 0.000053
            [291] => 0.000056
            [292] => 0.000051
            [293] => 0.000052
            [294] => 0.000050
            [295] => 0.000057
            [296] => 0.000049
            [297] => 0.000057
            [298] => 0.000083
            [299] => 0.000096
            [300] => 0.000051
            [301] => 0.000052
            [302] => 0.000052
            [303] => 0.000051
            [304] => 0.000054
            [305] => 0.000057
            [306] => 0.000052
            [307] => 0.000056
            [308] => 0.000056
            [309] => 0.000099
            [310] => 0.000133
            [311] => 0.000058
            [312] => 0.000060
            [313] => 0.000049
            [314] => 0.000055
            [315] => 0.000055
            [316] => 0.000052
            [317] => 0.000052
            [318] => 0.000052
            [319] => 0.000052
            [320] => 0.000060
            [321] => 0.000107
            [322] => 0.000056
            [323] => 0.000057
            [324] => 0.000054
            [325] => 0.000059
            [326] => 0.000055
            [327] => 0.000052
            [328] => 0.000056
            [329] => 0.000054
            [330] => 0.000051
            [331] => 0.000107
            [332] => 0.000072
            [333] => 0.000059
            [334] => 0.000049
            [335] => 0.000052
            [336] => 0.000058
            [337] => 0.000057
            [338] => 0.000051
            [339] => 0.000059
            [340] => 0.000061
            [341] => 0.000058
            [342] => 0.000091
            [343] => 0.000078
            [344] => 0.000058
            [345] => 0.000056
            [346] => 0.000053
            [347] => 0.000056
            [348] => 0.000053
            [349] => 0.000054
            [350] => 0.000058
            [351] => 0.000058
            [352] => 0.000055
            [353] => 0.000091
            [354] => 0.000066
            [355] => 0.000058
            [356] => 0.000054
            [357] => 0.000055
            [358] => 0.000055
            [359] => 0.000051
            [360] => 0.000056
            [361] => 0.000060
            [362] => 0.000061
            [363] => 0.000057
            [364] => 0.000054
            [365] => 0.000167
            [366] => 0.000054
            [367] => 0.000057
            [368] => 0.000057
            [369] => 0.000059
            [370] => 0.000053
            [371] => 0.000052
            [372] => 0.000053
            [373] => 0.000057
            [374] => 0.000062
            [375] => 0.000059
            [376] => 0.000068
            [377] => 0.000059
            [378] => 0.000058
            [379] => 0.000055
            [380] => 0.000053
            [381] => 0.000064
            [382] => 0.000062
            [383] => 0.000053
            [384] => 0.000051
            [385] => 0.000052
            [386] => 0.000063
            [387] => 0.000052
            [388] => 0.000057
            [389] => 0.000058
            [390] => 0.000055
            [391] => 0.000053
            [392] => 0.000050
            [393] => 0.000051
            [394] => 0.000051
            [395] => 0.000054
            [396] => 0.000055
            [397] => 0.000053
            [398] => 0.000062
            [399] => 0.000050
            [400] => 0.000054
            [401] => 0.000057
            [402] => 0.000058
            [403] => 0.000057
            [404] => 0.000053
            [405] => 0.000056
            [406] => 0.000053
            [407] => 0.000065
            [408] => 0.000062
            [409] => 0.000052
            [410] => 0.000050
            [411] => 0.000058
            [412] => 0.000051
            [413] => 0.000052
            [414] => 0.000052
            [415] => 0.000054
            [416] => 0.000057
            [417] => 0.000064
            [418] => 0.000051
            [419] => 0.000051
            [420] => 0.000053
            [421] => 0.000083
            [422] => 0.000059
            [423] => 0.000057
            [424] => 0.000054
            [425] => 0.000053
            [426] => 0.000043
            [427] => 0.000049
            [428] => 0.000049
            [429] => 0.000053
            [430] => 0.000056
            [431] => 0.000050
            [432] => 0.000048
            [433] => 0.000054
            [434] => 0.000056
            [435] => 0.000065
            [436] => 0.000060
            [437] => 0.000053
            [438] => 0.000052
            [439] => 0.000056
            [440] => 0.000048
            [441] => 0.000062
            [442] => 0.000063
            [443] => 0.000052
            [444] => 0.000089
            [445] => 0.000052
            [446] => 0.000053
            [447] => 0.000049
            [448] => 0.000055
            [449] => 0.000060
            [450] => 0.000055
            [451] => 0.000053
            [452] => 0.000049
            [453] => 0.000051
            [454] => 0.000061
            [455] => 0.000053
            [456] => 0.000056
            [457] => 0.000054
            [458] => 0.000052
            [459] => 0.000056
            [460] => 0.000053
            [461] => 0.000143
            [462] => 0.000126
            [463] => 26.818634
            [464] => 0.000334
            [465] => 0.000233
            [466] => 0.000567
            [467] => 0.000258
            [468] => 0.000387
            [469] => 0.000379
        )

)
SESSION: 
Array
(
    [cart] => shoppingCart Object
        (
            [contents] => Array
                (
                )

            [total] => 0
            [weight] => 0
            [cartID] => 
            [content_type] => 
            [total_virtual] => 0
        )

    [language] => english
    [languages_id] => 1
    [currency] => USD
    [navigation] => navigationHistory Object
        (
            [path] => Array
                (
                    [0] => Array
                        (
                            [page] => rss.php
                            [mode] => NONSSL
                            [get] => Array
                                (
                                )

                            [post] => Array
                                (
                                )

                        )

                    [1] => Array
                        (
                            [page] => cookie_usage.php
                            [mode] => NONSSL
                            [get] => Array
                                (
                                )

                            [post] => Array
                                (
                                )

                        )

                    [2] => Array
                        (
                            [page] => account.php
                            [mode] => NONSSL
                            [get] => Array
                                (
                                    [language] => pi
                                )

                            [post] => Array
                                (
                                )

                        )

                    [3] => Array
                        (
                            [page] => login.php
                            [mode] => NONSSL
                            [get] => Array
                                (
                                    [language] => pi
                                )

                            [post] => Array
                                (
                                )

                        )

                    [4] => Array
                        (
                            [page] => allcategories.php
                            [mode] => NONSSL
                            [get] => Array
                                (
                                    [language] => pi
                                )

                            [post] => Array
                                (
                                )

                        )

                    [5] => Array
                        (
                            [page] => allprods.php
                            [mode] => NONSSL
                            [get] => Array
                                (
                                    [language] => pi
                                )

                            [post] => Array
                                (
                                )

                        )

                    [6] => Array
                        (
                            [page] => catalog_products_with_images.php
                            [mode] => NONSSL
                            [get] => Array
                                (
                                )

                            [post] => Array
                                (
                                )

                        )

                    [7] => Array
                        (
                            [page] => checkout_shipping.php
                            [mode] => NONSSL
                            [get] => Array
                                (
                                    [language] => pi
                                )

                            [post] => Array
                                (
                                )

                        )

                    [8] => Array
                        (
                            [page] => conditions.php
                            [mode] => NONSSL
                            [get] => Array
                                (
                                    [language] => pi
                                )

                            [post] => Array
                                (
                                )

                        )

                    [9] => Array
                        (
                            [page] => contact_us.php
                            [mode] => NONSSL
                            [get] => Array
                                (
                                    [language] => pi
                                )

                            [post] => Array
                                (
                                )

                        )

                    [10] => Array
                        (
                            [page] => create_account.php
                            [mode] => NONSSL
                            [get] => Array
                                (
                                    [language] => pi
                                )

                            [post] => Array
                                (
                                )

                        )

                    [11] => Array
                        (
                            [page] => gv_faq.php
                            [mode] => NONSSL
                            [get] => Array
                                (
                                    [language] => pi
                                )

                            [post] => Array
                                (
                                )

                        )

                    [12] => Array
                        (
                            [page] => index.php
                            [mode] => NONSSL
                            [get] => Array
                                (
                                    [cPath] => 15_16_17
                                    [language] => en
                                )

                            [post] => Array
                                (
                                )

                        )

                )

            [snapshot] => Array
                (
                    [page] => checkout_shipping.php
                    [mode] => NONSSL
                    [get] => Array
                        (
                            [language] => pi
                        )

                    [post] => Array
                        (
                        )

                )

        )

)
COOKIE: 
Array
(
    [osCsid] => cded79b9a7aa4b042f692ce08707a8ec
)
POST: 
Array
(
)
GET: 
Array
(
)