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 » Lawn & Garden » Lawn Ornaments
Displaying 1 to 20 (of 31 products) Result Pages:  1  2  [Next >>] 
    Item+   [Price][/lb.]    
 (12683) Plant Watering Globe Stakes   (12683) Plant Watering Globe Stakes   $9.95  $4.54  Buy Now 
 Beautiful decorative globes are more than mere ornaments; they’re a worry-free way to water your plants! Just fill and place into soil; the plant absorbs the exact amount as needed. Actual color of each globe may vary from the picture shown. The ideal gift for any avid decorator or gardener! Weight 0.8 lb. Glass. Each is 3 1/8" diameter x 11 3/4" high. Pair 
 (12788) Woodland Squirrel Tree Décor   (12788) Woodland Squirrel Tree Décor   $19.95  $7.65  Buy Now 
 Two-piece decoration creates the illusion of a mischievous squirrel poking out from a tree trunk; a merry accent indeed! Lifelike furry fellow will have visitors guessing and grinning for years. Weight 1 lb. Polyresin. Top: 4"x 4 1/2" x 6" high; bottom: 3 1/4" x 2 3/4" x 10" high. Set 
 (34722) Seasonal Signs With Stakes   (34722) Seasonal Signs With Stakes   $24.95  $9.55  Buy Now 
 Five seasonal wood signs with stake. Welcome, 4th of July, Halloween, Thanksgiving and Christmas. Assembled: 11" x 1 3/4" x 30" high. Sugg. Retail Price: $24.95 
 (35719) Solar Powered Lighthouse   (35719) Solar Powered Lighthouse   $69.95  $26.80  Buy Now 
 This handsome lighthouse is powered by the sun. A garden decoration which shines brightly for up to 8 hours, long after the sun is down. Uses one AAA battery (not included). Alabastrite. 9 1/2" x 8 1/4" x 19" high. Sugg. Retail Price per unit: $69.95 
 (37090) Light Bulb Stepping Stones   (37090) Light Bulb Stepping Stones   $9.99  $3.85  Buy Now 
 Pave a path to your door and welcome everyone to your home for the holidays! A delightful set of three resin stones, in blue, red and green. Stones may also be hung as wall decor. 5 1/2" x 1" x 11 1/4" high. Set of 3 Sugg. Retail Price per unit: $39.95 
 (37092) Happy Holidays' Yard Art   (37092) Happy Holidays' Yard Art   $9.99  $3.85  Buy Now 
 In the holiday spirit? Let everyone know, with this big, bright and festive yard sign! 100% tin. 12" x 1/4" x 37" high. Sugg. Retail Price per unit: $22.95 
 (37201) 'Get Out And Hike' Stepping Stone   (37201) 'Get Out And Hike' Stepping Stone   $6.95  $2.76  Buy Now 
 An apt beginning for your next epic journey! Place this inspiring stepping stone wherever your treasured adventures begin; be it at the mouth of a shaded forest track, or right in your own beloved back yard. Resin. 10" diameter x 1" thick. Sugg. Retail Price per unit: $19.95 
 (37440) Small Ivory Color Glass Lantern   (37440) Small Ivory Color Glass Lantern   $6.95  $2.65  Buy Now 
 When lit from within by candlelight, these old-fashioned lanterns are a true delight! The panels' gracefully curling vine design takes on a magical glow. Perfect for adding special sparkle to your next garden party! Metal and glass. 4" X 4" X 4 3/4"H Sugg. Retail Price per unit: $6.95 
 (37441) Large Ivory Color Glass Lantern   (37441) Large Ivory Color Glass Lantern   $12.95  $4.95  Buy Now 
 When lit from within by candlelight, these old-fashioned lanterns are a true delight! The panels' gracefully curling vine design takes on a magical glow. Perfect for adding special sparkle to your next garden party! Metal and glass. 5 3/4" diameter x 8" h Sugg. Retail Price per unit: $12.95 
 (37619) Crane Garden Stakes   (37619) Crane Garden Stakes   $49.95  $19.44  Buy Now 
 The very essence of serenity and timeless beauty, this pair of slender cranes has a new artistic twist: their graceful curves and slender legs surround a gleaming silver gazing ball. Simply striking! Metal. Outdoor use only. Each crane is 16" x 5 3/4" x 29 1/4" high. Sugg. Retail Price per unit: $49.95 
 (37752) Bloom, Grow, Shine Design Post   (37752) Bloom, Grow, Shine Design Post   $12.47  $5.75  Buy Now 
 Aglow with sunny sentiments and colorful floral adornments, this appealing wall sign turns any corner of your garden into a treasured spot. Polystone. 9" x 3/8" x 18" high. Sugg. Retail Price per unit: $24.95 
 (37761) Garden Totem Tealight Holder   (37761) Garden Totem Tealight Holder   $9.99  $4.03  Buy Now 
 Colorful garden post twinkles so bright on a balmy outdoor night! Add a candle to the beautiful butterfly topper; when lit, golden light glimmers softly through cutouts in the wings, creating an instant party atmosphere. Tealights only (not included). Natural stone and resin. 5 1/8" x 4 1/2" x 12" high. Sugg. Retail Price per unit: $34.95 
 (37839) Family Matters, Numeral 0   (37839) Family Matters, Numeral 0   $3.95  $0.29  Buy Now 
 Metal numerals clip to the Family Matters Garden Stake (sold separately) in an instant to display your address number. Digit: Ŕ". Metal. 1 3/4" x 1/8" x 5" high. Sugg. Retail Price per unit: $3.95 
 (38233) Metal Floor Lantern   (38233) Metal Floor Lantern   $39.95  $18.34  Buy Now 
 Fabulous floor lantern enhances your decor with cottage style romance! Scrollwork stand and bright-copper latticework candle lantern are lovely anywhere; use several sets together to elegantly illuminate a garden pathway or hall. Metal. Candle not included. 12 1/2" diameter x 35 1/2" high. Sugg. Retail Price per unit: $34.95 
 (38465) Mid White Moroccan Lantern   (38465) Mid White Moroccan Lantern   $16.95  $6.50  Buy Now 
 Candlelight shines from the cutout design of this lovely, lacy ivory lantern! It's hexagonal hurricane shape in creamy ivory is stunning against lush garden greenery, casting a gracious golden glow on a twilit summer's night. Metal with glass. 6" x 5" x 12 1/2" high. Candle not included. Sugg. Retail Price per unit: $14.95 
 (38466) Large White Moroccan Lantern   (38466) Large White Moroccan Lantern   $27.95  $10.75  Buy Now 
 Light leaps in lacy patterns from the cutwork roof and vine-patterned panels of this alluring candle lamp. Cast a glamorous aura over an outdoor gathering, or use several together to elegantly illuminate a shadowy garden path! Metal and glass. 7 3/4" x 6 3/4" x 15" high. Candle not included. Sugg. Retail Price per unit: $24.95 
 (38560) Cottage Candle Lantern   (38560) Cottage Candle Lantern   $9.99  $4.03  Buy Now 
 As the birdhouse lamp swings gently from its scrollwork stand, candlelight shines through a multitude of cutouts to broadcast a fascinating halo of shadow and light. Weathered ivory finish and graceful lacework add a look of genteel garden charm. Metal. 100% palm wax tealight included. 10 1/4" x 5 1/4" x 12 1/8" high. Sugg. Retail Price per unit: $17.95 
 (38647) Flower Power Welcome Mat   (38647) Flower Power Welcome Mat   $19.95  $9.14  Buy Now 
 A bevy of blooms puts its perky petals together in a joyful display, bringing to mind the first joyful flowers of spring. A welcoming touch for any doorway, perfectly practical in extra-tough molded rubber. Matte black finish gives this appealling mat the artistic appeal of intricate ironwork. 8mm thickness for extra durability. Rubber. 30" x 3/8" x 18" high. Sugg. Retail Price per unit:... 
 (38688) Bouncy Butterfly Garden Stake   (38688) Bouncy Butterfly Garden Stake   $9.95  $3.92  Buy Now 
 No garden is complete without the joyful fluttering of a beautiful butterfly! This fanciful garden stake is topped with a lifelike butterfly suncatcher in glistening translucent red; its spring-loaded wings bounce in the breeze for the illusion of exuberant movement! Plastic with metal stake. 8" x 7 1/2" x 28 1/2" high. Sugg. Retail Price per unit: $9.95 
 (38813) Frolicking Frogs Hanging Décor   (38813) Frolicking Frogs Hanging Décor   $19.95  $7.65  Buy Now 
 A giggling trio of amphibious acrobats enjoys a merry moment of mirth, playfully tumbling down the length of a free-swinging rope. An utterly irresistible hanging sculpture that brings loads of love and laughter to your garden! Powderstone/polyresin blend. 3 1/4" x 3" x 30 1/4" high. Sugg. Retail Price per unit: $19.95 
Displaying 1 to 20 (of 31 products) Result Pages:  1  2  [Next >>] 
  Friday 18 May, 2012     17996845 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: 26.372 s with 466 queries
QUERY DEBUG: 
Array
(
    [QUERIES] => Array
        (
            [0] => select value from sessions where sesskey = 'cded79b9a7aa4b042f692ce08707a8ec' and expiry > '1337343490'
            [1] => select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies
            [2] => delete from whos_online where time_last_click < '1337342590'
            [3] => select count(*) as count from whos_online where session_id = 'cded79b9a7aa4b042f692ce08707a8ec'
            [4] => update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '38.107.179.222', time_last_click = '1337343490', last_page_url = '/index.php/cPath/41_148/sort/2a/page' where session_id = 'cded79b9a7aa4b042f692ce08707a8ec'
            [5] => select banners_id, date_scheduled from banners where date_scheduled != ''
            [6] => 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
            [7] => select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0
            [8] => select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0
            [9] => select categories_name from categories_description where categories_id = '41' and language_id = '1'
            [10] => select categories_name from categories_description where categories_id = '148' and language_id = '1'
            [11] => select count(*) as total from products_to_categories where categories_id = '148'
            [12] => select title, keywords, description from meta_tags where categories_id = '148'
            [13] => 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
            [14] => 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
            [15] => 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
            [16] => 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
            [17] => 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
            [18] => 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
            [19] => 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
            [20] => 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
            [21] => 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
            [22] => 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
            [23] => 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
            [24] => 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
            [25] => 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
            [26] => 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
            [27] => 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
            [28] => 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
            [29] => 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
            [30] => 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
            [31] => 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
            [32] => 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
            [33] => 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
            [34] => 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
            [35] => 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
            [36] => 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
            [37] => 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
            [38] => 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
            [39] => 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
            [40] => 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
            [41] => 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
            [42] => 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
            [43] => 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
            [44] => 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
            [45] => 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
            [46] => 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
            [47] => 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
            [48] => 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
            [49] => 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
            [50] => 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
            [51] => 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
            [52] => 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
            [53] => 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
            [54] => 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
            [55] => 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
            [56] => 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
            [57] => 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
            [58] => 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
            [59] => 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
            [60] => 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
            [61] => 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
            [62] => 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
            [63] => 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
            [64] => 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
            [65] => 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
            [66] => 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
            [67] => 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
            [68] => 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
            [69] => 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
            [70] => 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
            [71] => 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
            [72] => 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
            [73] => 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
            [74] => 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
            [75] => 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
            [76] => 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
            [77] => 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
            [78] => 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
            [79] => 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
            [80] => 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
            [81] => 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
            [82] => 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
            [83] => 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
            [84] => 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
            [85] => 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
            [86] => 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
            [87] => 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
            [88] => 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
            [89] => 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
            [90] => 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
            [91] => 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
            [92] => 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
            [93] => 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
            [94] => 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
            [95] => 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
            [96] => 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
            [97] => 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
            [98] => 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
            [99] => 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
            [100] => 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
            [101] => 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
            [102] => 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
            [103] => 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
            [104] => 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
            [105] => 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
            [106] => 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
            [107] => 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
            [108] => 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
            [109] => 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
            [110] => 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
            [111] => 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
            [112] => 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
            [113] => 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
            [114] => 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
            [115] => 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
            [116] => 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
            [117] => 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
            [118] => 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
            [119] => 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
            [120] => 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
            [121] => 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
            [122] => 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
            [123] => 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
            [124] => 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
            [125] => 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
            [126] => 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
            [127] => 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
            [128] => 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
            [129] => 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
            [130] => 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
            [131] => 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
            [132] => 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
            [133] => 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
            [134] => 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
            [135] => 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
            [136] => 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
            [137] => 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
            [138] => 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
            [139] => 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
            [140] => 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
            [141] => 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
            [142] => 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
            [143] => 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
            [144] => 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
            [145] => 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
            [146] => 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
            [147] => 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
            [148] => 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
            [149] => 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
            [150] => 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
            [151] => 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
            [152] => 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
            [153] => 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
            [154] => 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
            [155] => 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
            [156] => 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
            [157] => 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
            [158] => 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
            [159] => 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
            [160] => 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
            [161] => 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
            [162] => 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
            [163] => 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
            [164] => 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
            [165] => 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
            [166] => 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
            [167] => 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
            [168] => 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
            [169] => 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
            [170] => 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
            [171] => 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
            [172] => 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
            [173] => 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
            [174] => 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
            [175] => 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
            [176] => 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
            [177] => 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
            [178] => 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
            [179] => 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
            [180] => 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
            [181] => 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
            [182] => 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
            [183] => 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
            [184] => 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
            [185] => 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
            [186] => 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
            [187] => 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
            [188] => 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
            [189] => 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
            [190] => 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
            [191] => 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
            [192] => 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
            [193] => 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
            [194] => 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
            [195] => 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
            [196] => 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
            [197] => 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
            [198] => 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
            [199] => 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
            [200] => 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
            [201] => 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
            [202] => 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
            [203] => 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
            [204] => 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
            [205] => 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
            [206] => 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
            [207] => 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
            [208] => 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
            [209] => 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
            [210] => 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
            [211] => 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
            [212] => 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
            [213] => 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
            [214] => 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
            [215] => 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
            [216] => 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
            [217] => 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
            [218] => 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
            [219] => 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
            [220] => 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
            [221] => 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
            [222] => 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
            [223] => 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
            [224] => 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
            [225] => 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
            [226] => 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
            [227] => 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
            [228] => 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
            [229] => 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
            [230] => 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
            [231] => 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
            [232] => 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
            [233] => 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
            [234] => 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 '148' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit 25
            [235] => 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
            [236] => 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
            [237] => 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
            [238] => 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
            [239] => 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
            [240] => 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
            [241] => 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
            [242] => 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
            [243] => 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
            [244] => 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
            [245] => 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
            [246] => 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
            [247] => 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
            [248] => 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
            [249] => 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
            [250] => 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
            [251] => 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
            [252] => 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
            [253] => 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
            [254] => 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
            [255] => 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
            [256] => 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
            [257] => 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
            [258] => 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
            [259] => 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
            [260] => 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
            [261] => 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
            [262] => 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
            [263] => 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
            [264] => 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
            [265] => 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
            [266] => 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
            [267] => 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
            [268] => 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
            [269] => 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
            [270] => 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
            [271] => 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
            [272] => 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
            [273] => 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
            [274] => 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
            [275] => 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
            [276] => 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
            [277] => 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
            [278] => 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
            [279] => 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
            [280] => 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
            [281] => 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
            [282] => 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
            [283] => 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
            [284] => 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
            [285] => 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
            [286] => 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
            [287] => 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
            [288] => 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
            [289] => 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
            [290] => 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
            [291] => 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
            [292] => 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
            [293] => 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
            [294] => 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
            [295] => 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
            [296] => 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
            [297] => 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
            [298] => 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
            [299] => 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
            [300] => 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
            [301] => 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
            [302] => 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
            [303] => 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
            [304] => 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
            [305] => 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
            [306] => 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
            [307] => 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
            [308] => 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
            [309] => 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
            [310] => 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
            [311] => 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
            [312] => 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
            [313] => 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
            [314] => 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
            [315] => 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
            [316] => 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
            [317] => 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
            [318] => 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
            [319] => 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
            [320] => 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
            [321] => 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
            [322] => 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
            [323] => 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
            [324] => 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
            [325] => 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
            [326] => 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
            [327] => 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
            [328] => 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
            [329] => 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
            [330] => 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
            [331] => 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
            [332] => 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
            [333] => 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
            [334] => 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
            [335] => 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
            [336] => 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
            [337] => 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
            [338] => 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
            [339] => 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
            [340] => 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
            [341] => 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
            [342] => 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
            [343] => 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
            [344] => 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
            [345] => 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
            [346] => 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
            [347] => 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
            [348] => 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
            [349] => 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
            [350] => 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
            [351] => 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
            [352] => 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
            [353] => 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
            [354] => 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
            [355] => 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
            [356] => 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
            [357] => 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
            [358] => 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
            [359] => 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
            [360] => 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
            [361] => 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
            [362] => 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
            [363] => 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
            [364] => 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
            [365] => 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
            [366] => 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
            [367] => 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
            [368] => 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
            [369] => 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
            [370] => 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
            [371] => 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
            [372] => 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
            [373] => 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
            [374] => 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
            [375] => 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
            [376] => 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
            [377] => 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
            [378] => 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
            [379] => 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
            [380] => 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
            [381] => 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
            [382] => 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
            [383] => 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
            [384] => 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
            [385] => 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
            [386] => 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
            [387] => 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
            [388] => 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
            [389] => 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
            [390] => 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
            [391] => 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
            [392] => 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
            [393] => 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
            [394] => 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
            [395] => 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
            [396] => 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
            [397] => 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
            [398] => 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
            [399] => 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
            [400] => 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
            [401] => 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
            [402] => 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
            [403] => 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
            [404] => 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
            [405] => 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
            [406] => 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
            [407] => 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
            [408] => 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
            [409] => 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
            [410] => 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
            [411] => 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
            [412] => 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
            [413] => 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
            [414] => 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
            [415] => 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
            [416] => 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
            [417] => 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
            [418] => 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
            [419] => 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
            [420] => 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
            [421] => 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
            [422] => 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
            [423] => 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
            [424] => 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
            [425] => 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
            [426] => 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
            [427] => 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
            [428] => 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
            [429] => 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
            [430] => 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
            [431] => 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
            [432] => 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
            [433] => 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
            [434] => 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
            [435] => 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
            [436] => 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
            [437] => 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
            [438] => 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
            [439] => 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
            [440] => 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
            [441] => 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
            [442] => 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
            [443] => 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
            [444] => 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
            [445] => 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
            [446] => 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
            [447] => 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
            [448] => 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
            [449] => 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
            [450] => 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
            [451] => 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
            [452] => 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
            [453] => 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
            [454] => 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
            [455] => 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
            [456] => 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
            [457] => select cd.categories_name, cd.categories_heading_title, cd.categories_description, c.categories_image from categories c, categories_description cd where c.categories_id = '148' and cd.categories_id = '148' and cd.language_id = '1'
            [458] => select categories_image from categories where categories_id = '148'
            [459] => 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 = '148'
            [460] => 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 = '148' order by pd.products_name  limit 0, 20
            [461] => select products_id, specials_new_products_price from specials where (products_id = '20719' or products_id = '20509' or products_id = '3740' or products_id = '4252' or products_id = '4863' or products_id = '4865' or products_id = '4972' or products_id = '5201' or products_id = '5202' or products_id = '5369' or products_id = '5494' or products_id = '5503' or products_id = '5577' or products_id = '5947' or products_id = '18472' or products_id = '18473' or products_id = '18564' or products_id = '18649' or products_id = '18690' or products_id = '18810' ) and status = '1' and customers_group_id =  '0'
            [462] => select startdate, counter from counter
            [463] => update counter set counter = '17996845'
            [464] => select count(*) as total from sessions where sesskey = 'cded79b9a7aa4b042f692ce08707a8ec'
            [465] => update sessions set expiry = '1337344956', 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:3:{s:5:\"cPath\";s:6:\"41_148\";s:4:\"sort\";s:2:\"2a\";s:4:\"page\";N;}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.000440
            [1] => 0.000104
            [2] => 0.000210
            [3] => 0.000567
            [4] => 0.000393
            [5] => 0.000229
            [6] => 0.000311
            [7] => 0.003392
            [8] => 0.000209
            [9] => 0.000139
            [10] => 0.000380
            [11] => 0.000122
            [12] => 0.000125
            [13] => 0.000130
            [14] => 0.000118
            [15] => 0.000124
            [16] => 0.000218
            [17] => 0.000132
            [18] => 0.000091
            [19] => 0.000088
            [20] => 0.000084
            [21] => 0.000056
            [22] => 0.000056
            [23] => 0.000057
            [24] => 0.000057
            [25] => 0.000107
            [26] => 0.000049
            [27] => 0.000050
            [28] => 0.000045
            [29] => 0.000050
            [30] => 0.000055
            [31] => 0.000051
            [32] => 0.000047
            [33] => 0.000050
            [34] => 0.000045
            [35] => 0.000046
            [36] => 0.000110
            [37] => 0.000056
            [38] => 0.000056
            [39] => 0.000045
            [40] => 0.000048
            [41] => 0.000059
            [42] => 0.000046
            [43] => 0.000054
            [44] => 0.000056
            [45] => 0.000048
            [46] => 0.000050
            [47] => 0.000112
            [48] => 0.000055
            [49] => 0.000050
            [50] => 0.000053
            [51] => 0.000054
            [52] => 0.000052
            [53] => 0.000053
            [54] => 0.000042
            [55] => 0.000038
            [56] => 0.000049
            [57] => 0.000052
            [58] => 0.000048
            [59] => 0.000089
            [60] => 0.000053
            [61] => 0.000046
            [62] => 0.000047
            [63] => 0.000041
            [64] => 0.000049
            [65] => 0.000056
            [66] => 0.000055
            [67] => 0.000049
            [68] => 0.000045
            [69] => 0.000050
            [70] => 0.000050
            [71] => 0.000089
            [72] => 0.000049
            [73] => 0.000054
            [74] => 0.000052
            [75] => 0.000052
            [76] => 0.000051
            [77] => 0.000050
            [78] => 0.000053
            [79] => 0.000046
            [80] => 0.000054
            [81] => 0.000046
            [82] => 0.000040
            [83] => 0.000081
            [84] => 0.000048
            [85] => 0.000049
            [86] => 0.000044
            [87] => 0.000055
            [88] => 0.000055
            [89] => 0.000046
            [90] => 0.000048
            [91] => 0.000048
            [92] => 0.000049
            [93] => 0.000055
            [94] => 0.000048
            [95] => 0.000085
            [96] => 0.000055
            [97] => 0.000051
            [98] => 0.000050
            [99] => 0.000046
            [100] => 0.000050
            [101] => 0.000056
            [102] => 0.000043
            [103] => 0.000047
            [104] => 0.000049
            [105] => 0.000051
            [106] => 0.000049
            [107] => 0.000083
            [108] => 0.000040
            [109] => 0.000049
            [110] => 0.000055
            [111] => 0.000056
            [112] => 0.000049
            [113] => 0.000060
            [114] => 0.000056
            [115] => 0.000048
            [116] => 0.000056
            [117] => 0.000058
            [118] => 0.000037
            [119] => 0.000087
            [120] => 0.000041
            [121] => 0.000050
            [122] => 0.000047
            [123] => 0.000046
            [124] => 0.000056
            [125] => 0.000055
            [126] => 0.000048
            [127] => 0.000049
            [128] => 0.000048
            [129] => 0.000048
            [130] => 0.000111
            [131] => 0.000055
            [132] => 0.000056
            [133] => 0.000045
            [134] => 0.000058
            [135] => 0.000052
            [136] => 0.000048
            [137] => 0.000052
            [138] => 0.000054
            [139] => 0.000049
            [140] => 0.000047
            [141] => 0.000113
            [142] => 0.000054
            [143] => 0.000048
            [144] => 0.000056
            [145] => 0.000055
            [146] => 0.000046
            [147] => 0.000047
            [148] => 0.000044
            [149] => 0.000049
            [150] => 0.000056
            [151] => 0.000052
            [152] => 0.000103
            [153] => 0.000051
            [154] => 0.000048
            [155] => 0.000055
            [156] => 0.000042
            [157] => 0.000054
            [158] => 0.000052
            [159] => 0.000049
            [160] => 0.000052
            [161] => 0.000051
            [162] => 0.000049
            [163] => 0.000047
            [164] => 0.000086
            [165] => 0.000054
            [166] => 0.000055
            [167] => 0.000051
            [168] => 0.000054
            [169] => 0.000057
            [170] => 0.000050
            [171] => 0.000056
            [172] => 0.000054
            [173] => 0.000052
            [174] => 0.000048
            [175] => 0.000108
            [176] => 0.000067
            [177] => 0.000047
            [178] => 0.000050
            [179] => 0.000057
            [180] => 0.000058
            [181] => 0.000051
            [182] => 0.000048
            [183] => 0.000052
            [184] => 0.000050
            [185] => 0.000076
            [186] => 0.000093
            [187] => 0.000049
            [188] => 0.000048
            [189] => 0.000051
            [190] => 0.000051
            [191] => 0.000049
            [192] => 0.000057
            [193] => 0.000054
            [194] => 0.000050
            [195] => 0.000055
            [196] => 0.000071
            [197] => 0.000098
            [198] => 0.000046
            [199] => 0.000054
            [200] => 0.000055
            [201] => 0.000052
            [202] => 0.000049
            [203] => 0.000048
            [204] => 0.000045
            [205] => 0.000054
            [206] => 0.000055
            [207] => 0.000055
            [208] => 0.000098
            [209] => 0.000052
            [210] => 0.000045
            [211] => 0.000051
            [212] => 0.000050
            [213] => 0.000055
            [214] => 0.000054
            [215] => 0.000051
            [216] => 0.000045
            [217] => 0.000052
            [218] => 0.000091
            [219] => 0.000089
            [220] => 0.000045
            [221] => 0.000050
            [222] => 0.000051
            [223] => 0.000049
            [224] => 0.000048
            [225] => 0.000051
            [226] => 0.000053
            [227] => 0.000052
            [228] => 0.000051
            [229] => 0.000086
            [230] => 0.000071
            [231] => 0.000044
            [232] => 0.000051
            [233] => 0.000051
            [234] => 0.000100
            [235] => 0.000460
            [236] => 0.000071
            [237] => 0.000051
            [238] => 0.000048
            [239] => 0.000127
            [240] => 0.000053
            [241] => 0.000056
            [242] => 0.000048
            [243] => 0.000048
            [244] => 0.000052
            [245] => 0.000046
            [246] => 0.000047
            [247] => 0.000052
            [248] => 0.000049
            [249] => 0.000047
            [250] => 0.000046
            [251] => 0.000041
            [252] => 0.000122
            [253] => 0.000051
            [254] => 0.000048
            [255] => 0.000043
            [256] => 0.000043
            [257] => 0.000213
            [258] => 0.000048
            [259] => 0.000049
            [260] => 0.000052
            [261] => 0.000045
            [262] => 0.000114
            [263] => 0.000047
            [264] => 0.000047
            [265] => 0.000047
            [266] => 0.000049
            [267] => 0.000046
            [268] => 0.000044
            [269] => 0.000045
            [270] => 0.000040
            [271] => 0.000052
            [272] => 0.000051
            [273] => 0.000045
            [274] => 0.000051
            [275] => 0.000054
            [276] => 0.000047
            [277] => 0.000050
            [278] => 0.000047
            [279] => 0.000043
            [280] => 0.000041
            [281] => 0.000043
            [282] => 0.000042
            [283] => 0.000048
            [284] => 0.000051
            [285] => 0.000043
            [286] => 0.000045
            [287] => 0.000152
            [288] => 0.000052
            [289] => 0.000052
            [290] => 0.000048
            [291] => 0.000041
            [292] => 0.000044
            [293] => 0.000043
            [294] => 0.000049
            [295] => 0.000050
            [296] => 0.000051
            [297] => 0.000047
            [298] => 0.000044
            [299] => 0.000045
            [300] => 0.000046
            [301] => 0.000052
            [302] => 0.000048
            [303] => 0.000043
            [304] => 0.000044
            [305] => 0.000042
            [306] => 0.000043
            [307] => 0.000047
            [308] => 0.000050
            [309] => 0.000043
            [310] => 0.000046
            [311] => 0.000044
            [312] => 0.000181
            [313] => 0.000048
            [314] => 0.000048
            [315] => 0.000044
            [316] => 0.000043
            [317] => 0.000042
            [318] => 0.000043
            [319] => 0.000048
            [320] => 0.000049
            [321] => 0.000043
            [322] => 0.000041
            [323] => 0.000045
            [324] => 0.000165
            [325] => 0.000050
            [326] => 0.000048
            [327] => 0.000045
            [328] => 0.000046
            [329] => 0.000043
            [330] => 0.000039
            [331] => 0.000045
            [332] => 0.000049
            [333] => 0.000043
            [334] => 0.000044
            [335] => 0.000043
            [336] => 0.000046
            [337] => 0.000052
            [338] => 0.000048
            [339] => 0.000044
            [340] => 0.000044
            [341] => 0.000043
            [342] => 0.000044
            [343] => 0.000045
            [344] => 0.000049
            [345] => 0.000042
            [346] => 0.000044
            [347] => 0.000044
            [348] => 0.000043
            [349] => 0.000050
            [350] => 0.000050
            [351] => 0.000044
            [352] => 0.000042
            [353] => 0.000042
            [354] => 0.000044
            [355] => 0.000048
            [356] => 0.000045
            [357] => 0.000051
            [358] => 0.000042
            [359] => 0.000046
            [360] => 0.000052
            [361] => 0.000219
            [362] => 0.000178
            [363] => 0.000174
            [364] => 0.000056
            [365] => 0.000276
            [366] => 0.000162
            [367] => 0.000175
            [368] => 0.000170
            [369] => 0.000172
            [370] => 0.000201
            [371] => 0.000052
            [372] => 0.000045
            [373] => 0.000047
            [374] => 0.000043
            [375] => 0.000050
            [376] => 0.000049
            [377] => 0.000044
            [378] => 0.000046
            [379] => 0.000043
            [380] => 0.000042
            [381] => 0.000046
            [382] => 0.000168
            [383] => 0.000205
            [384] => 0.000168
            [385] => 0.000272
            [386] => 0.000205
            [387] => 0.000051
            [388] => 0.000046
            [389] => 0.000043
            [390] => 0.000041
            [391] => 0.000043
            [392] => 0.000052
            [393] => 0.000045
            [394] => 0.000044
            [395] => 0.000046
            [396] => 0.000052
            [397] => 0.000048
            [398] => 0.000052
            [399] => 0.000058
            [400] => 0.000050
            [401] => 0.000041
            [402] => 0.000044
            [403] => 0.000047
            [404] => 0.000049
            [405] => 0.000040
            [406] => 0.000044
            [407] => 0.000044
            [408] => 0.000043
            [409] => 0.000043
            [410] => 0.000045
            [411] => 0.000113
            [412] => 0.000047
            [413] => 0.000047
            [414] => 0.000042
            [415] => 0.000044
            [416] => 0.000044
            [417] => 0.000041
            [418] => 0.000050
            [419] => 0.000044
            [420] => 0.000041
            [421] => 0.000042
            [422] => 0.000045
            [423] => 0.000042
            [424] => 0.000044
            [425] => 0.000044
            [426] => 0.000045
            [427] => 0.000041
            [428] => 0.000043
            [429] => 0.000044
            [430] => 0.000048
            [431] => 0.000048
            [432] => 0.000049
            [433] => 0.000040
            [434] => 0.000046
            [435] => 0.000045
            [436] => 0.000044
            [437] => 0.000119
            [438] => 0.000051
            [439] => 0.000041
            [440] => 0.000043
            [441] => 0.000043
            [442] => 0.000042
            [443] => 0.000040
            [444] => 0.000040
            [445] => 0.000046
            [446] => 0.000048
            [447] => 0.000043
            [448] => 0.000041
            [449] => 0.000040
            [450] => 0.000118
            [451] => 0.000046
            [452] => 0.000047
            [453] => 0.000045
            [454] => 0.000048
            [455] => 0.000046
            [456] => 0.000044
            [457] => 0.000084
            [458] => 0.000066
            [459] => 0.000075
            [460] => 26.046687
            [461] => 0.000171
            [462] => 0.000324
            [463] => 0.000231
            [464] => 0.000284
            [465] => 0.000365
        )

)
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] => 41_148
                                    [sort] => 2a
                                    [page] => 
                                )

                            [post] => Array
                                (
                                )

                        )

                )

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

                    [post] => Array
                        (
                        )

                )

        )

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