Shopping Cart 0 Items Sign In / Create new account  |  My Account  |  Checkout

Baby Apparel + Bibs + Blankets Bottles Kidswear + Kit Bags Lunch Bags Pacifier Pouch Pacifiers Pencil Case Rain Ponchos Rainhat & Sunhat Socks Swimwear Tabards Tinkle Potty Training Stickers Totspot Trolley Bag Umbrellas Watches Windbreaker FLATOUT Bears FLATOUT Baby Bears Please SelectBugzz Kids Stuf..FLATOUT BearsGoo-Goo BabyKIDiDNOO DesignsWubbaNub Advanced Search US DollarSingapore DollarEuroHong Kong Dollar About Us Order & Payment Delivery Options Exchange & Refunds Contact Us Cookie Usage Cookie Privacy and Security Cookies must be enabled to purchase online on this store to embrace privacy and security related issues regarding your visit to this site. By enabling cookie support on your browser, the communication between you and this site is strengthened to be certain it is you who are making transactions on your own behalf, and to prevent leakage of your privacy information. We have detected that your browser does not support cookies, or has set cookies to be disabled. To continue shopping online, we encourage you to enable cookies on your browser. For Internet Explorer browsers, please follow these instructions: Click on the Tools menubar, and select Internet Options Select the Security tab, and reset the security level to Medium We have taken this measurement of security for your benefit, and apologize upfront if any inconveniences are caused. Please contact the store owner if you have any questions relating to this requirement, or to continue purchasing products offline.

HOME . NEW ARRIVALS . BEST SELLERS . SPECIAL OFFERS . MAILING LIST . GIFT VOUCHER . FAQ © Copyright 2010 Ben Jr Concept. All Right Reserved.

QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #4 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #7 QUERY delete from whos_online where time_last_click < '1294124509' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '' RESULT Resource id #20 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '', '91.211.16.126', '1294125409', '1294125409', '/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #25 QUERY 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 RESULT Resource id #28 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #31 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #34 QUERY select p.pages_id, p.sort_order, p.status, s.pages_title, s.pages_html_text from pages p LEFT JOIN pages_description s on p.pages_id = s.pages_id where p.status = 1 and s.language_id = '1' and p.page_type = 1 RESULT Resource id #39 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #44 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '137' RESULT Resource id #47 QUERY select categories_id from categories where parent_id = '137' RESULT Resource id #50 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '138' RESULT Resource id #53 QUERY select categories_id from categories where parent_id = '138' RESULT Resource id #56 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '139' RESULT Resource id #59 QUERY select categories_id from categories where parent_id = '139' RESULT Resource id #62 QUERY select count(*) as count from categories where parent_id = '137' RESULT Resource id #66 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '132' RESULT Resource id #69 QUERY select categories_id from categories where parent_id = '132' RESULT Resource id #72 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '140' RESULT Resource id #75 QUERY select categories_id from categories where parent_id = '140' RESULT Resource id #78 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '141' RESULT Resource id #81 QUERY select categories_id from categories where parent_id = '141' RESULT Resource id #84 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '142' RESULT Resource id #87 QUERY select categories_id from categories where parent_id = '142' RESULT Resource id #90 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '143' RESULT Resource id #93 QUERY select categories_id from categories where parent_id = '143' RESULT Resource id #96 QUERY select count(*) as count from categories where parent_id = '132' RESULT Resource id #100 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '130' RESULT Resource id #103 QUERY select categories_id from categories where parent_id = '130' RESULT Resource id #106 QUERY select count(*) as count from categories where parent_id = '130' RESULT Resource id #110 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '134' RESULT Resource id #113 QUERY select categories_id from categories where parent_id = '134' RESULT Resource id #116 QUERY select count(*) as count from categories where parent_id = '134' RESULT Resource id #120 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '124' RESULT Resource id #123 QUERY select categories_id from categories where parent_id = '124' RESULT Resource id #126 QUERY select count(*) as count from categories where parent_id = '124' RESULT Resource id #130 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '131' RESULT Resource id #133 QUERY select categories_id from categories where parent_id = '131' RESULT Resource id #136 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '120' RESULT Resource id #139 QUERY select categories_id from categories where parent_id = '120' RESULT Resource id #142 QUERY select count(*) as count from categories where parent_id = '131' RESULT Resource id #146 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '129' RESULT Resource id #149 QUERY select categories_id from categories where parent_id = '129' RESULT Resource id #152 QUERY select count(*) as count from categories where parent_id = '129' RESULT Resource id #156 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '128' RESULT Resource id #159 QUERY select categories_id from categories where parent_id = '128' RESULT Resource id #162 QUERY select count(*) as count from categories where parent_id = '128' RESULT Resource id #166 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '115' RESULT Resource id #169 QUERY select categories_id from categories where parent_id = '115' RESULT Resource id #172 QUERY select count(*) as count from categories where parent_id = '115' RESULT Resource id #176 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '119' RESULT Resource id #179 QUERY select categories_id from categories where parent_id = '119' RESULT Resource id #182 QUERY select count(*) as count from categories where parent_id = '119' RESULT Resource id #186 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '133' RESULT Resource id #189 QUERY select categories_id from categories where parent_id = '133' RESULT Resource id #192 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '121' RESULT Resource id #195 QUERY select categories_id from categories where parent_id = '121' RESULT Resource id #198 QUERY select count(*) as count from categories where parent_id = '121' RESULT Resource id #202 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '126' RESULT Resource id #205 QUERY select categories_id from categories where parent_id = '126' RESULT Resource id #208 QUERY select count(*) as count from categories where parent_id = '126' RESULT Resource id #212 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '118' RESULT Resource id #215 QUERY select categories_id from categories where parent_id = '118' RESULT Resource id #218 QUERY select count(*) as count from categories where parent_id = '118' RESULT Resource id #222 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '135' RESULT Resource id #225 QUERY select categories_id from categories where parent_id = '135' RESULT Resource id #228 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '145' RESULT Resource id #231 QUERY select categories_id from categories where parent_id = '145' RESULT Resource id #234 QUERY select count(*) as count from categories where parent_id = '145' RESULT Resource id #238 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '144' RESULT Resource id #241 QUERY select categories_id from categories where parent_id = '144' RESULT Resource id #244 QUERY select count(*) as count from categories where parent_id = '144' RESULT Resource id #248 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '123' RESULT Resource id #251 QUERY select categories_id from categories where parent_id = '123' RESULT Resource id #254 QUERY select count(*) as count from categories where parent_id = '123' RESULT Resource id #258 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '122' RESULT Resource id #261 QUERY select categories_id from categories where parent_id = '122' RESULT Resource id #264 QUERY select count(*) as count from categories where parent_id = '122' RESULT Resource id #268 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '117' RESULT Resource id #271 QUERY select categories_id from categories where parent_id = '117' RESULT Resource id #274 QUERY select count(*) as count from categories where parent_id = '117' RESULT Resource id #278 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '125' RESULT Resource id #281 QUERY select categories_id from categories where parent_id = '125' RESULT Resource id #284 QUERY select count(*) as count from categories where parent_id = '125' RESULT Resource id #288 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '91' RESULT Resource id #291 QUERY select categories_id from categories where parent_id = '91' RESULT Resource id #294 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #297 QUERY select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' and TO_DAYS(NOW()) - TO_DAYS(products_date_added) < '900' order by products_date_added desc limit 10 RESULT Resource id #300 QUERY select products_name from products_description where products_id = '476' and language_id = '1' RESULT Resource id #303 QUERY select specials_new_products_price from specials where products_id = '476' and status RESULT Resource id #306 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #309 QUERY select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, orders o, orders_products op, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' and op.orders_id = o.orders_id and op.products_id = p.products_id and TO_DAYS(NOW()) - TO_DAYS(o.date_purchased) < '900' order by p.products_ordered desc, pd.products_name limit 9 RESULT Resource id #315 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #321 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #327 QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added desc limit 10 RESULT Resource id #330 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #334 QUERY select p.pages_id, p.sort_order, p.status, s.pages_title, s.pages_html_text, s.intorext, s.externallink, s.link_target from pages p LEFT JOIN pages_description s on p.pages_id = s.pages_id where p.status = 1 and p.page_type != 1 and s.language_id = '1' order by p.sort_order, s.pages_title RESULT Resource id #337 QUERY select categories_name from categories_description where categories_id = '' limit 1 RESULT Resource id #341 QUERY select p.products_id,p.products_quantity, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand(973031214) DESC limit 6 RESULT Resource id #344 QUERY select products_name from products_description where products_id = '424' and language_id = '1' RESULT Resource id #347 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #353 QUERY select products_name from products_description where products_id = '460' and language_id = '1' RESULT Resource id #358 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #364 QUERY select products_name from products_description where products_id = '476' and language_id = '1' RESULT Resource id #369 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #375 QUERY select counter FROM visitors where browser_ip = '91.211.16.126' AND browser_language = '[Unknown]' AND to_days(date_add(now(), INTERVAL 0 HOUR)) - to_days(date) < 1 RESULT Resource id #380 QUERY insert into visitors (date,counter,browser_ip,browser_language,online,language,referer,uri) values (date_add(now(), INTERVAL 0 HOUR),'1','91.211.16.126','[Unknown]',date_add(now(), INTERVAL 0 HOUR),'english','direct','http://benjrconcept.com.sg/index.php?cookies=1') RESULT 1 QUERY select startdate, counter from counter RESULT Resource id #385 QUERY update counter set counter = '33651' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #390 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '0' order by c.sort_order, cd.categories_name RESULT Resource id #393 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '137' order by c.sort_order, cd.categories_name RESULT Resource id #396 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '138' order by c.sort_order, cd.categories_name RESULT Resource id #399 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '139' order by c.sort_order, cd.categories_name RESULT Resource id #402 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '132' order by c.sort_order, cd.categories_name RESULT Resource id #405 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '140' order by c.sort_order, cd.categories_name RESULT Resource id #408 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '142' order by c.sort_order, cd.categories_name RESULT Resource id #411 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '143' order by c.sort_order, cd.categories_name RESULT Resource id #414 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '141' order by c.sort_order, cd.categories_name RESULT Resource id #417 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '130' order by c.sort_order, cd.categories_name RESULT Resource id #420 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '134' order by c.sort_order, cd.categories_name RESULT Resource id #423 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '124' order by c.sort_order, cd.categories_name RESULT Resource id #426 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '131' order by c.sort_order, cd.categories_name RESULT Resource id #429 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '120' order by c.sort_order, cd.categories_name RESULT Resource id #432 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '129' order by c.sort_order, cd.categories_name RESULT Resource id #435 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '128' order by c.sort_order, cd.categories_name RESULT Resource id #438 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '115' order by c.sort_order, cd.categories_name RESULT Resource id #441 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '119' order by c.sort_order, cd.categories_name RESULT Resource id #444 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '133' order by c.sort_order, cd.categories_name RESULT Resource id #447 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '121' order by c.sort_order, cd.categories_name RESULT Resource id #450 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '126' order by c.sort_order, cd.categories_name RESULT Resource id #453 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '118' order by c.sort_order, cd.categories_name RESULT Resource id #456 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '135' order by c.sort_order, cd.categories_name RESULT Resource id #459 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '145' order by c.sort_order, cd.categories_name RESULT Resource id #462 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '144' order by c.sort_order, cd.categories_name RESULT Resource id #465 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '123' order by c.sort_order, cd.categories_name RESULT Resource id #468 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '122' order by c.sort_order, cd.categories_name RESULT Resource id #471 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '117' order by c.sort_order, cd.categories_name RESULT Resource id #474 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '125' order by c.sort_order, cd.categories_name RESULT Resource id #477 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '91' order by c.sort_order, cd.categories_name RESULT Resource id #480 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #483 04/01/2011 15:16:51 - /index.php?cookies=1 (1.500s) QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #4 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #7 QUERY delete from whos_online where time_last_click < '1294124513' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '' RESULT Resource id #20 QUERY update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '91.211.16.126', time_last_click = '1294125413', last_page_url = '/cookie_usage.php?cookies=1' where session_id = '' RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #25 QUERY 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 RESULT Resource id #28 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #31 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #34 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #43 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '137' RESULT Resource id #46 QUERY select categories_id from categories where parent_id = '137' RESULT Resource id #49 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '138' RESULT Resource id #52 QUERY select categories_id from categories where parent_id = '138' RESULT Resource id #55 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '139' RESULT Resource id #58 QUERY select categories_id from categories where parent_id = '139' RESULT Resource id #61 QUERY select count(*) as count from categories where parent_id = '137' RESULT Resource id #65 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '132' RESULT Resource id #68 QUERY select categories_id from categories where parent_id = '132' RESULT Resource id #71 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '140' RESULT Resource id #74 QUERY select categories_id from categories where parent_id = '140' RESULT Resource id #77 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '141' RESULT Resource id #80 QUERY select categories_id from categories where parent_id = '141' RESULT Resource id #83 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '142' RESULT Resource id #86 QUERY select categories_id from categories where parent_id = '142' RESULT Resource id #89 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '143' RESULT Resource id #92 QUERY select categories_id from categories where parent_id = '143' RESULT Resource id #95 QUERY select count(*) as count from categories where parent_id = '132' RESULT Resource id #99 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '130' RESULT Resource id #102 QUERY select categories_id from categories where parent_id = '130' RESULT Resource id #105 QUERY select count(*) as count from categories where parent_id = '130' RESULT Resource id #109 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '134' RESULT Resource id #112 QUERY select categories_id from categories where parent_id = '134' RESULT Resource id #115 QUERY select count(*) as count from categories where parent_id = '134' RESULT Resource id #119 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '124' RESULT Resource id #122 QUERY select categories_id from categories where parent_id = '124' RESULT Resource id #125 QUERY select count(*) as count from categories where parent_id = '124' RESULT Resource id #129 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '131' RESULT Resource id #132 QUERY select categories_id from categories where parent_id = '131' RESULT Resource id #135 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '120' RESULT Resource id #138 QUERY select categories_id from categories where parent_id = '120' RESULT Resource id #141 QUERY select count(*) as count from categories where parent_id = '131' RESULT Resource id #145 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '129' RESULT Resource id #148 QUERY select categories_id from categories where parent_id = '129' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '129' RESULT Resource id #155 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '128' RESULT Resource id #158 QUERY select categories_id from categories where parent_id = '128' RESULT Resource id #161 QUERY select count(*) as count from categories where parent_id = '128' RESULT Resource id #165 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '115' RESULT Resource id #168 QUERY select categories_id from categories where parent_id = '115' RESULT Resource id #171 QUERY select count(*) as count from categories where parent_id = '115' RESULT Resource id #175 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '119' RESULT Resource id #178 QUERY select categories_id from categories where parent_id = '119' RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '119' RESULT Resource id #185 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '133' RESULT Resource id #188 QUERY select categories_id from categories where parent_id = '133' RESULT Resource id #191 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '121' RESULT Resource id #194 QUERY select categories_id from categories where parent_id = '121' RESULT Resource id #197 QUERY select count(*) as count from categories where parent_id = '121' RESULT Resource id #201 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '126' RESULT Resource id #204 QUERY select categories_id from categories where parent_id = '126' RESULT Resource id #207 QUERY select count(*) as count from categories where parent_id = '126' RESULT Resource id #211 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '118' RESULT Resource id #214 QUERY select categories_id from categories where parent_id = '118' RESULT Resource id #217 QUERY select count(*) as count from categories where parent_id = '118' RESULT Resource id #221 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '135' RESULT Resource id #224 QUERY select categories_id from categories where parent_id = '135' RESULT Resource id #227 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '145' RESULT Resource id #230 QUERY select categories_id from categories where parent_id = '145' RESULT Resource id #233 QUERY select count(*) as count from categories where parent_id = '145' RESULT Resource id #237 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '144' RESULT Resource id #240 QUERY select categories_id from categories where parent_id = '144' RESULT Resource id #243 QUERY select count(*) as count from categories where parent_id = '144' RESULT Resource id #247 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '123' RESULT Resource id #250 QUERY select categories_id from categories where parent_id = '123' RESULT Resource id #253 QUERY select count(*) as count from categories where parent_id = '123' RESULT Resource id #257 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '122' RESULT Resource id #260 QUERY select categories_id from categories where parent_id = '122' RESULT Resource id #263 QUERY select count(*) as count from categories where parent_id = '122' RESULT Resource id #267 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '117' RESULT Resource id #270 QUERY select categories_id from categories where parent_id = '117' RESULT Resource id #273 QUERY select count(*) as count from categories where parent_id = '117' RESULT Resource id #277 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '125' RESULT Resource id #280 QUERY select categories_id from categories where parent_id = '125' RESULT Resource id #283 QUERY select count(*) as count from categories where parent_id = '125' RESULT Resource id #287 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '91' RESULT Resource id #290 QUERY select categories_id from categories where parent_id = '91' RESULT Resource id #293 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #296 QUERY select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' and TO_DAYS(NOW()) - TO_DAYS(products_date_added) < '900' order by products_date_added desc limit 10 RESULT Resource id #299 QUERY select products_name from products_description where products_id = '470' and language_id = '1' RESULT Resource id #302 QUERY select specials_new_products_price from specials where products_id = '470' and status RESULT Resource id #305 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #308 QUERY select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, orders o, orders_products op, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' and op.orders_id = o.orders_id and op.products_id = p.products_id and TO_DAYS(NOW()) - TO_DAYS(o.date_purchased) < '900' order by p.products_ordered desc, pd.products_name limit 9 RESULT Resource id #314 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #320 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #326 QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added desc limit 10 RESULT Resource id #329 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #333 QUERY select p.pages_id, p.sort_order, p.status, s.pages_title, s.pages_html_text, s.intorext, s.externallink, s.link_target from pages p LEFT JOIN pages_description s on p.pages_id = s.pages_id where p.status = 1 and p.page_type != 1 and s.language_id = '1' order by p.sort_order, s.pages_title RESULT Resource id #336 QUERY select counter FROM visitors where browser_ip = '91.211.16.126' AND browser_language = '[Unknown]' AND to_days(date_add(now(), INTERVAL 0 HOUR)) - to_days(date) < 1 RESULT Resource id #341 QUERY update visitors set counter = counter+1, online = date_add(now(), INTERVAL 0 HOUR) where browser_ip = '91.211.16.126' AND browser_language = '[Unknown]' AND to_days(date_add(now(), INTERVAL 0 HOUR)) - to_days(date) < 1 RESULT 1 QUERY select startdate, counter from counter RESULT Resource id #346 QUERY update counter set counter = '33652' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #351 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '0' order by c.sort_order, cd.categories_name RESULT Resource id #354 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '137' order by c.sort_order, cd.categories_name RESULT Resource id #357 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '138' order by c.sort_order, cd.categories_name RESULT Resource id #360 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '139' order by c.sort_order, cd.categories_name RESULT Resource id #363 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '132' order by c.sort_order, cd.categories_name RESULT Resource id #366 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '140' order by c.sort_order, cd.categories_name RESULT Resource id #369 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '142' order by c.sort_order, cd.categories_name RESULT Resource id #372 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '143' order by c.sort_order, cd.categories_name RESULT Resource id #375 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '141' order by c.sort_order, cd.categories_name RESULT Resource id #378 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '130' order by c.sort_order, cd.categories_name RESULT Resource id #381 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '134' order by c.sort_order, cd.categories_name RESULT Resource id #384 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '124' order by c.sort_order, cd.categories_name RESULT Resource id #387 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '131' order by c.sort_order, cd.categories_name RESULT Resource id #390 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '120' order by c.sort_order, cd.categories_name RESULT Resource id #393 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '129' order by c.sort_order, cd.categories_name RESULT Resource id #396 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '128' order by c.sort_order, cd.categories_name RESULT Resource id #399 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '115' order by c.sort_order, cd.categories_name RESULT Resource id #402 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '119' order by c.sort_order, cd.categories_name RESULT Resource id #405 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '133' order by c.sort_order, cd.categories_name RESULT Resource id #408 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '121' order by c.sort_order, cd.categories_name RESULT Resource id #411 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '126' order by c.sort_order, cd.categories_name RESULT Resource id #414 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '118' order by c.sort_order, cd.categories_name RESULT Resource id #417 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '135' order by c.sort_order, cd.categories_name RESULT Resource id #420 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '145' order by c.sort_order, cd.categories_name RESULT Resource id #423 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '144' order by c.sort_order, cd.categories_name RESULT Resource id #426 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '123' order by c.sort_order, cd.categories_name RESULT Resource id #429 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '122' order by c.sort_order, cd.categories_name RESULT Resource id #432 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '117' order by c.sort_order, cd.categories_name RESULT Resource id #435 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '125' order by c.sort_order, cd.categories_name RESULT Resource id #438 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '91' order by c.sort_order, cd.categories_name RESULT Resource id #441 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #444 04/01/2011 15:16:55 - /cookie_usage.php?cookies=1 (1.491s) QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #4 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #7 QUERY delete from whos_online where time_last_click < '1294124517' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '' RESULT Resource id #20 QUERY update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '91.211.16.126', time_last_click = '1294125417', last_page_url = '/index.php?cookies=1' where session_id = '' RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #25 QUERY 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 RESULT Resource id #28 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #31 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #34 QUERY select p.pages_id, p.sort_order, p.status, s.pages_title, s.pages_html_text from pages p LEFT JOIN pages_description s on p.pages_id = s.pages_id where p.status = 1 and s.language_id = '1' and p.page_type = 1 RESULT Resource id #38 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #43 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '137' RESULT Resource id #46 QUERY select categories_id from categories where parent_id = '137' RESULT Resource id #49 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '138' RESULT Resource id #52 QUERY select categories_id from categories where parent_id = '138' RESULT Resource id #55 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '139' RESULT Resource id #58 QUERY select categories_id from categories where parent_id = '139' RESULT Resource id #61 QUERY select count(*) as count from categories where parent_id = '137' RESULT Resource id #65 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '132' RESULT Resource id #68 QUERY select categories_id from categories where parent_id = '132' RESULT Resource id #71 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '140' RESULT Resource id #74 QUERY select categories_id from categories where parent_id = '140' RESULT Resource id #77 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '141' RESULT Resource id #80 QUERY select categories_id from categories where parent_id = '141' RESULT Resource id #83 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '142' RESULT Resource id #86 QUERY select categories_id from categories where parent_id = '142' RESULT Resource id #89 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '143' RESULT Resource id #92 QUERY select categories_id from categories where parent_id = '143' RESULT Resource id #95 QUERY select count(*) as count from categories where parent_id = '132' RESULT Resource id #99 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '130' RESULT Resource id #102 QUERY select categories_id from categories where parent_id = '130' RESULT Resource id #105 QUERY select count(*) as count from categories where parent_id = '130' RESULT Resource id #109 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '134' RESULT Resource id #112 QUERY select categories_id from categories where parent_id = '134' RESULT Resource id #115 QUERY select count(*) as count from categories where parent_id = '134' RESULT Resource id #119 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '124' RESULT Resource id #122 QUERY select categories_id from categories where parent_id = '124' RESULT Resource id #125 QUERY select count(*) as count from categories where parent_id = '124' RESULT Resource id #129 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '131' RESULT Resource id #132 QUERY select categories_id from categories where parent_id = '131' RESULT Resource id #135 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '120' RESULT Resource id #138 QUERY select categories_id from categories where parent_id = '120' RESULT Resource id #141 QUERY select count(*) as count from categories where parent_id = '131' RESULT Resource id #145 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '129' RESULT Resource id #148 QUERY select categories_id from categories where parent_id = '129' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '129' RESULT Resource id #155 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '128' RESULT Resource id #158 QUERY select categories_id from categories where parent_id = '128' RESULT Resource id #161 QUERY select count(*) as count from categories where parent_id = '128' RESULT Resource id #165 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '115' RESULT Resource id #168 QUERY select categories_id from categories where parent_id = '115' RESULT Resource id #171 QUERY select count(*) as count from categories where parent_id = '115' RESULT Resource id #175 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '119' RESULT Resource id #178 QUERY select categories_id from categories where parent_id = '119' RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '119' RESULT Resource id #185 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '133' RESULT Resource id #188 QUERY select categories_id from categories where parent_id = '133' RESULT Resource id #191 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '121' RESULT Resource id #194 QUERY select categories_id from categories where parent_id = '121' RESULT Resource id #197 QUERY select count(*) as count from categories where parent_id = '121' RESULT Resource id #201 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '126' RESULT Resource id #204 QUERY select categories_id from categories where parent_id = '126' RESULT Resource id #207 QUERY select count(*) as count from categories where parent_id = '126' RESULT Resource id #211 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '118' RESULT Resource id #214 QUERY select categories_id from categories where parent_id = '118' RESULT Resource id #217 QUERY select count(*) as count from categories where parent_id = '118' RESULT Resource id #221 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '135' RESULT Resource id #224 QUERY select categories_id from categories where parent_id = '135' RESULT Resource id #227 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '145' RESULT Resource id #230 QUERY select categories_id from categories where parent_id = '145' RESULT Resource id #233 QUERY select count(*) as count from categories where parent_id = '145' RESULT Resource id #237 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '144' RESULT Resource id #240 QUERY select categories_id from categories where parent_id = '144' RESULT Resource id #243 QUERY select count(*) as count from categories where parent_id = '144' RESULT Resource id #247 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '123' RESULT Resource id #250 QUERY select categories_id from categories where parent_id = '123' RESULT Resource id #253 QUERY select count(*) as count from categories where parent_id = '123' RESULT Resource id #257 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '122' RESULT Resource id #260 QUERY select categories_id from categories where parent_id = '122' RESULT Resource id #263 QUERY select count(*) as count from categories where parent_id = '122' RESULT Resource id #267 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '117' RESULT Resource id #270 QUERY select categories_id from categories where parent_id = '117' RESULT Resource id #273 QUERY select count(*) as count from categories where parent_id = '117' RESULT Resource id #277 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '125' RESULT Resource id #280 QUERY select categories_id from categories where parent_id = '125' RESULT Resource id #283 QUERY select count(*) as count from categories where parent_id = '125' RESULT Resource id #287 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '91' RESULT Resource id #290 QUERY select categories_id from categories where parent_id = '91' RESULT Resource id #293 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #296 QUERY select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' and TO_DAYS(NOW()) - TO_DAYS(products_date_added) < '900' order by products_date_added desc limit 10 RESULT Resource id #299 QUERY select products_name from products_description where products_id = '466' and language_id = '1' RESULT Resource id #302 QUERY select specials_new_products_price from specials where products_id = '466' and status RESULT Resource id #305 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #308 QUERY select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, orders o, orders_products op, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' and op.orders_id = o.orders_id and op.products_id = p.products_id and TO_DAYS(NOW()) - TO_DAYS(o.date_purchased) < '900' order by p.products_ordered desc, pd.products_name limit 9 RESULT Resource id #314 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #320 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #326 QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added desc limit 10 RESULT Resource id #329 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #333 QUERY select p.pages_id, p.sort_order, p.status, s.pages_title, s.pages_html_text, s.intorext, s.externallink, s.link_target from pages p LEFT JOIN pages_description s on p.pages_id = s.pages_id where p.status = 1 and p.page_type != 1 and s.language_id = '1' order by p.sort_order, s.pages_title RESULT Resource id #336 QUERY select categories_name from categories_description where categories_id = '' limit 1 RESULT Resource id #339 QUERY select p.products_id,p.products_quantity, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand(593550115) DESC limit 6 RESULT Resource id #342 QUERY select products_name from products_description where products_id = '424' and language_id = '1' RESULT Resource id #345 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #351 QUERY select products_name from products_description where products_id = '460' and language_id = '1' RESULT Resource id #356 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #362 QUERY select products_name from products_description where products_id = '476' and language_id = '1' RESULT Resource id #367 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #373 QUERY select counter FROM visitors where browser_ip = '91.211.16.126' AND browser_language = '[Unknown]' AND to_days(date_add(now(), INTERVAL 0 HOUR)) - to_days(date) < 1 RESULT Resource id #378 QUERY update visitors set counter = counter+1, online = date_add(now(), INTERVAL 0 HOUR) where browser_ip = '91.211.16.126' AND browser_language = '[Unknown]' AND to_days(date_add(now(), INTERVAL 0 HOUR)) - to_days(date) < 1 RESULT 1 QUERY select startdate, counter from counter RESULT Resource id #383 QUERY update counter set counter = '33653' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #388 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '0' order by c.sort_order, cd.categories_name RESULT Resource id #391 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '137' order by c.sort_order, cd.categories_name RESULT Resource id #394 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '138' order by c.sort_order, cd.categories_name RESULT Resource id #397 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '139' order by c.sort_order, cd.categories_name RESULT Resource id #400 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '132' order by c.sort_order, cd.categories_name RESULT Resource id #403 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '140' order by c.sort_order, cd.categories_name RESULT Resource id #406 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '142' order by c.sort_order, cd.categories_name RESULT Resource id #409 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '143' order by c.sort_order, cd.categories_name RESULT Resource id #412 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '141' order by c.sort_order, cd.categories_name RESULT Resource id #415 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '130' order by c.sort_order, cd.categories_name RESULT Resource id #418 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '134' order by c.sort_order, cd.categories_name RESULT Resource id #421 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '124' order by c.sort_order, cd.categories_name RESULT Resource id #424 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '131' order by c.sort_order, cd.categories_name RESULT Resource id #427 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '120' order by c.sort_order, cd.categories_name RESULT Resource id #430 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '129' order by c.sort_order, cd.categories_name RESULT Resource id #433 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '128' order by c.sort_order, cd.categories_name RESULT Resource id #436 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '115' order by c.sort_order, cd.categories_name RESULT Resource id #439 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '119' order by c.sort_order, cd.categories_name RESULT Resource id #442 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '133' order by c.sort_order, cd.categories_name RESULT Resource id #445 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '121' order by c.sort_order, cd.categories_name RESULT Resource id #448 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '126' order by c.sort_order, cd.categories_name RESULT Resource id #451 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '118' order by c.sort_order, cd.categories_name RESULT Resource id #454 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '135' order by c.sort_order, cd.categories_name RESULT Resource id #457 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '145' order by c.sort_order, cd.categories_name RESULT Resource id #460 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '144' order by c.sort_order, cd.categories_name RESULT Resource id #463 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '123' order by c.sort_order, cd.categories_name RESULT Resource id #466 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '122' order by c.sort_order, cd.categories_name RESULT Resource id #469 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '117' order by c.sort_order, cd.categories_name RESULT Resource id #472 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '125' order by c.sort_order, cd.categories_name RESULT Resource id #475 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '91' order by c.sort_order, cd.categories_name RESULT Resource id #478 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #481 04/01/2011 15:16:59 - /index.php?cookies=1 (1.460s) QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #4 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #7 QUERY delete from whos_online where time_last_click < '1294124521' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '' RESULT Resource id #20 QUERY update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '91.211.16.126', time_last_click = '1294125421', last_page_url = '/cookie_usage.php?cookies=1' where session_id = '' RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #25 QUERY 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 RESULT Resource id #28 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #31 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #34 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #41 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '137' RESULT Resource id #44 QUERY select categories_id from categories where parent_id = '137' RESULT Resource id #47 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '138' RESULT Resource id #50 QUERY select categories_id from categories where parent_id = '138' RESULT Resource id #53 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '139' RESULT Resource id #56 QUERY select categories_id from categories where parent_id = '139' RESULT Resource id #59 QUERY select count(*) as count from categories where parent_id = '137' RESULT Resource id #63 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '132' RESULT Resource id #66 QUERY select categories_id from categories where parent_id = '132' RESULT Resource id #69 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '140' RESULT Resource id #72 QUERY select categories_id from categories where parent_id = '140' RESULT Resource id #75 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '141' RESULT Resource id #78 QUERY select categories_id from categories where parent_id = '141' RESULT Resource id #81 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '142' RESULT Resource id #84 QUERY select categories_id from categories where parent_id = '142' RESULT Resource id #87 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '143' RESULT Resource id #90 QUERY select categories_id from categories where parent_id = '143' RESULT Resource id #93 QUERY select count(*) as count from categories where parent_id = '132' RESULT Resource id #97 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '130' RESULT Resource id #100 QUERY select categories_id from categories where parent_id = '130' RESULT Resource id #103 QUERY select count(*) as count from categories where parent_id = '130' RESULT Resource id #107 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '134' RESULT Resource id #110 QUERY select categories_id from categories where parent_id = '134' RESULT Resource id #113 QUERY select count(*) as count from categories where parent_id = '134' RESULT Resource id #117 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '124' RESULT Resource id #120 QUERY select categories_id from categories where parent_id = '124' RESULT Resource id #123 QUERY select count(*) as count from categories where parent_id = '124' RESULT Resource id #127 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '131' RESULT Resource id #130 QUERY select categories_id from categories where parent_id = '131' RESULT Resource id #133 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '120' RESULT Resource id #136 QUERY select categories_id from categories where parent_id = '120' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '131' RESULT Resource id #143 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '129' RESULT Resource id #146 QUERY select categories_id from categories where parent_id = '129' RESULT Resource id #149 QUERY select count(*) as count from categories where parent_id = '129' RESULT Resource id #153 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '128' RESULT Resource id #156 QUERY select categories_id from categories where parent_id = '128' RESULT Resource id #159 QUERY select count(*) as count from categories where parent_id = '128' RESULT Resource id #163 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '115' RESULT Resource id #166 QUERY select categories_id from categories where parent_id = '115' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '115' RESULT Resource id #173 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '119' RESULT Resource id #176 QUERY select categories_id from categories where parent_id = '119' RESULT Resource id #179 QUERY select count(*) as count from categories where parent_id = '119' RESULT Resource id #183 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '133' RESULT Resource id #186 QUERY select categories_id from categories where parent_id = '133' RESULT Resource id #189 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '121' RESULT Resource id #192 QUERY select categories_id from categories where parent_id = '121' RESULT Resource id #195 QUERY select count(*) as count from categories where parent_id = '121' RESULT Resource id #199 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '126' RESULT Resource id #202 QUERY select categories_id from categories where parent_id = '126' RESULT Resource id #205 QUERY select count(*) as count from categories where parent_id = '126' RESULT Resource id #209 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '118' RESULT Resource id #212 QUERY select categories_id from categories where parent_id = '118' RESULT Resource id #215 QUERY select count(*) as count from categories where parent_id = '118' RESULT Resource id #219 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '135' RESULT Resource id #222 QUERY select categories_id from categories where parent_id = '135' RESULT Resource id #225 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '145' RESULT Resource id #228 QUERY select categories_id from categories where parent_id = '145' RESULT Resource id #231 QUERY select count(*) as count from categories where parent_id = '145' RESULT Resource id #235 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '144' RESULT Resource id #238 QUERY select categories_id from categories where parent_id = '144' RESULT Resource id #241 QUERY select count(*) as count from categories where parent_id = '144' RESULT Resource id #245 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '123' RESULT Resource id #248 QUERY select categories_id from categories where parent_id = '123' RESULT Resource id #251 QUERY select count(*) as count from categories where parent_id = '123' RESULT Resource id #255 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '122' RESULT Resource id #258 QUERY select categories_id from categories where parent_id = '122' RESULT Resource id #261 QUERY select count(*) as count from categories where parent_id = '122' RESULT Resource id #265 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '117' RESULT Resource id #268 QUERY select categories_id from categories where parent_id = '117' RESULT Resource id #271 QUERY select count(*) as count from categories where parent_id = '117' RESULT Resource id #275 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '125' RESULT Resource id #278 QUERY select categories_id from categories where parent_id = '125' RESULT Resource id #281 QUERY select count(*) as count from categories where parent_id = '125' RESULT Resource id #285 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '91' RESULT Resource id #288 QUERY select categories_id from categories where parent_id = '91' RESULT Resource id #291 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #294 QUERY select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' and TO_DAYS(NOW()) - TO_DAYS(products_date_added) < '900' order by products_date_added desc limit 10 RESULT Resource id #297 QUERY select products_name from products_description where products_id = '476' and language_id = '1' RESULT Resource id #300 QUERY select specials_new_products_price from specials where products_id = '476' and status RESULT Resource id #303 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #306 QUERY select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, orders o, orders_products op, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' and op.orders_id = o.orders_id and op.products_id = p.products_id and TO_DAYS(NOW()) - TO_DAYS(o.date_purchased) < '900' order by p.products_ordered desc, pd.products_name limit 9 RESULT Resource id #312 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #318 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #324 QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added desc limit 10 RESULT Resource id #327 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #331 QUERY select p.pages_id, p.sort_order, p.status, s.pages_title, s.pages_html_text, s.intorext, s.externallink, s.link_target from pages p LEFT JOIN pages_description s on p.pages_id = s.pages_id where p.status = 1 and p.page_type != 1 and s.language_id = '1' order by p.sort_order, s.pages_title RESULT Resource id #334 QUERY select counter FROM visitors where browser_ip = '91.211.16.126' AND browser_language = '[Unknown]' AND to_days(date_add(now(), INTERVAL 0 HOUR)) - to_days(date) < 1 RESULT Resource id #338 QUERY update visitors set counter = counter+1, online = date_add(now(), INTERVAL 0 HOUR) where browser_ip = '91.211.16.126' AND browser_language = '[Unknown]' AND to_days(date_add(now(), INTERVAL 0 HOUR)) - to_days(date) < 1 RESULT 1 QUERY select startdate, counter from counter RESULT Resource id #343 QUERY update counter set counter = '33654' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #348 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '0' order by c.sort_order, cd.categories_name RESULT Resource id #351 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '137' order by c.sort_order, cd.categories_name RESULT Resource id #354 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '138' order by c.sort_order, cd.categories_name RESULT Resource id #357 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '139' order by c.sort_order, cd.categories_name RESULT Resource id #360 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '132' order by c.sort_order, cd.categories_name RESULT Resource id #363 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '140' order by c.sort_order, cd.categories_name RESULT Resource id #366 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '142' order by c.sort_order, cd.categories_name RESULT Resource id #369 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '143' order by c.sort_order, cd.categories_name RESULT Resource id #372 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '141' order by c.sort_order, cd.categories_name RESULT Resource id #375 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '130' order by c.sort_order, cd.categories_name RESULT Resource id #378 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '134' order by c.sort_order, cd.categories_name RESULT Resource id #381 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '124' order by c.sort_order, cd.categories_name RESULT Resource id #384 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '131' order by c.sort_order, cd.categories_name RESULT Resource id #387 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '120' order by c.sort_order, cd.categories_name RESULT Resource id #390 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '129' order by c.sort_order, cd.categories_name RESULT Resource id #393 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '128' order by c.sort_order, cd.categories_name RESULT Resource id #396 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '115' order by c.sort_order, cd.categories_name RESULT Resource id #399 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '119' order by c.sort_order, cd.categories_name RESULT Resource id #402 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '133' order by c.sort_order, cd.categories_name RESULT Resource id #405 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '121' order by c.sort_order, cd.categories_name RESULT Resource id #408 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '126' order by c.sort_order, cd.categories_name RESULT Resource id #411 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '118' order by c.sort_order, cd.categories_name RESULT Resource id #414 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '135' order by c.sort_order, cd.categories_name RESULT Resource id #417 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '145' order by c.sort_order, cd.categories_name RESULT Resource id #420 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '144' order by c.sort_order, cd.categories_name RESULT Resource id #423 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '123' order by c.sort_order, cd.categories_name RESULT Resource id #426 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '122' order by c.sort_order, cd.categories_name RESULT Resource id #429 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '117' order by c.sort_order, cd.categories_name RESULT Resource id #432 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '125' order by c.sort_order, cd.categories_name RESULT Resource id #435 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '91' order by c.sort_order, cd.categories_name RESULT Resource id #438 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #441 04/01/2011 15:17:03 - /cookie_usage.php?cookies=1 (1.607s) QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #4 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #7 QUERY delete from whos_online where time_last_click < '1294124527' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '' RESULT Resource id #20 QUERY update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '91.211.16.126', time_last_click = '1294125427', last_page_url = '/index.php?cookies=1' where session_id = '' RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #25 QUERY 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 RESULT Resource id #28 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #31 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #34 QUERY select p.pages_id, p.sort_order, p.status, s.pages_title, s.pages_html_text from pages p LEFT JOIN pages_description s on p.pages_id = s.pages_id where p.status = 1 and s.language_id = '1' and p.page_type = 1 RESULT Resource id #38 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #43 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '137' RESULT Resource id #46 QUERY select categories_id from categories where parent_id = '137' RESULT Resource id #49 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '138' RESULT Resource id #52 QUERY select categories_id from categories where parent_id = '138' RESULT Resource id #55 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '139' RESULT Resource id #58 QUERY select categories_id from categories where parent_id = '139' RESULT Resource id #61 QUERY select count(*) as count from categories where parent_id = '137' RESULT Resource id #65 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '132' RESULT Resource id #68 QUERY select categories_id from categories where parent_id = '132' RESULT Resource id #71 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '140' RESULT Resource id #74 QUERY select categories_id from categories where parent_id = '140' RESULT Resource id #77 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '141' RESULT Resource id #80 QUERY select categories_id from categories where parent_id = '141' RESULT Resource id #83 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '142' RESULT Resource id #86 QUERY select categories_id from categories where parent_id = '142' RESULT Resource id #89 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '143' RESULT Resource id #92 QUERY select categories_id from categories where parent_id = '143' RESULT Resource id #95 QUERY select count(*) as count from categories where parent_id = '132' RESULT Resource id #99 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '130' RESULT Resource id #102 QUERY select categories_id from categories where parent_id = '130' RESULT Resource id #105 QUERY select count(*) as count from categories where parent_id = '130' RESULT Resource id #109 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '134' RESULT Resource id #112 QUERY select categories_id from categories where parent_id = '134' RESULT Resource id #115 QUERY select count(*) as count from categories where parent_id = '134' RESULT Resource id #119 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '124' RESULT Resource id #122 QUERY select categories_id from categories where parent_id = '124' RESULT Resource id #125 QUERY select count(*) as count from categories where parent_id = '124' RESULT Resource id #129 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '131' RESULT Resource id #132 QUERY select categories_id from categories where parent_id = '131' RESULT Resource id #135 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '120' RESULT Resource id #138 QUERY select categories_id from categories where parent_id = '120' RESULT Resource id #141 QUERY select count(*) as count from categories where parent_id = '131' RESULT Resource id #145 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '129' RESULT Resource id #148 QUERY select categories_id from categories where parent_id = '129' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '129' RESULT Resource id #155 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '128' RESULT Resource id #158 QUERY select categories_id from categories where parent_id = '128' RESULT Resource id #161 QUERY select count(*) as count from categories where parent_id = '128' RESULT Resource id #165 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '115' RESULT Resource id #168 QUERY select categories_id from categories where parent_id = '115' RESULT Resource id #171 QUERY select count(*) as count from categories where parent_id = '115' RESULT Resource id #175 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '119' RESULT Resource id #178 QUERY select categories_id from categories where parent_id = '119' RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '119' RESULT Resource id #185 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '133' RESULT Resource id #188 QUERY select categories_id from categories where parent_id = '133' RESULT Resource id #191 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '121' RESULT Resource id #194 QUERY select categories_id from categories where parent_id = '121' RESULT Resource id #197 QUERY select count(*) as count from categories where parent_id = '121' RESULT Resource id #201 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '126' RESULT Resource id #204 QUERY select categories_id from categories where parent_id = '126' RESULT Resource id #207 QUERY select count(*) as count from categories where parent_id = '126' RESULT Resource id #211 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '118' RESULT Resource id #214 QUERY select categories_id from categories where parent_id = '118' RESULT Resource id #217 QUERY select count(*) as count from categories where parent_id = '118' RESULT Resource id #221 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '135' RESULT Resource id #224 QUERY select categories_id from categories where parent_id = '135' RESULT Resource id #227 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '145' RESULT Resource id #230 QUERY select categories_id from categories where parent_id = '145' RESULT Resource id #233 QUERY select count(*) as count from categories where parent_id = '145' RESULT Resource id #237 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '144' RESULT Resource id #240 QUERY select categories_id from categories where parent_id = '144' RESULT Resource id #243 QUERY select count(*) as count from categories where parent_id = '144' RESULT Resource id #247 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '123' RESULT Resource id #250 QUERY select categories_id from categories where parent_id = '123' RESULT Resource id #253 QUERY select count(*) as count from categories where parent_id = '123' RESULT Resource id #257 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '122' RESULT Resource id #260 QUERY select categories_id from categories where parent_id = '122' RESULT Resource id #263 QUERY select count(*) as count from categories where parent_id = '122' RESULT Resource id #267 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '117' RESULT Resource id #270 QUERY select categories_id from categories where parent_id = '117' RESULT Resource id #273 QUERY select count(*) as count from categories where parent_id = '117' RESULT Resource id #277 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '125' RESULT Resource id #280 QUERY select categories_id from categories where parent_id = '125' RESULT Resource id #283 QUERY select count(*) as count from categories where parent_id = '125' RESULT Resource id #287 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '91' RESULT Resource id #290 QUERY select categories_id from categories where parent_id = '91' RESULT Resource id #293 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #296 QUERY select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' and TO_DAYS(NOW()) - TO_DAYS(products_date_added) < '900' order by products_date_added desc limit 10 RESULT Resource id #299 QUERY select products_name from products_description where products_id = '468' and language_id = '1' RESULT Resource id #302 QUERY select specials_new_products_price from specials where products_id = '468' and status RESULT Resource id #305 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #308 QUERY select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, orders o, orders_products op, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' and op.orders_id = o.orders_id and op.products_id = p.products_id and TO_DAYS(NOW()) - TO_DAYS(o.date_purchased) < '900' order by p.products_ordered desc, pd.products_name limit 9 RESULT Resource id #314 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #320 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #326 QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added desc limit 10 RESULT Resource id #329 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #333 QUERY select p.pages_id, p.sort_order, p.status, s.pages_title, s.pages_html_text, s.intorext, s.externallink, s.link_target from pages p LEFT JOIN pages_description s on p.pages_id = s.pages_id where p.status = 1 and p.page_type != 1 and s.language_id = '1' order by p.sort_order, s.pages_title RESULT Resource id #336 QUERY select categories_name from categories_description where categories_id = '' limit 1 RESULT Resource id #339 QUERY select p.products_id,p.products_quantity, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand(1420259639) DESC limit 6 RESULT Resource id #342 QUERY select products_name from products_description where products_id = '476' and language_id = '1' RESULT Resource id #345 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #351 QUERY select products_name from products_description where products_id = '460' and language_id = '1' RESULT Resource id #356 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #362 QUERY select products_name from products_description where products_id = '424' and language_id = '1' RESULT Resource id #367 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #373 QUERY select counter FROM visitors where browser_ip = '91.211.16.126' AND browser_language = '[Unknown]' AND to_days(date_add(now(), INTERVAL 0 HOUR)) - to_days(date) < 1 RESULT Resource id #378 QUERY update visitors set counter = counter+1, online = date_add(now(), INTERVAL 0 HOUR) where browser_ip = '91.211.16.126' AND browser_language = '[Unknown]' AND to_days(date_add(now(), INTERVAL 0 HOUR)) - to_days(date) < 1 RESULT 1 QUERY select startdate, counter from counter RESULT Resource id #383 QUERY update counter set counter = '33655' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #388 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '0' order by c.sort_order, cd.categories_name RESULT Resource id #391 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '137' order by c.sort_order, cd.categories_name RESULT Resource id #394 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '138' order by c.sort_order, cd.categories_name RESULT Resource id #397 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '139' order by c.sort_order, cd.categories_name RESULT Resource id #400 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '132' order by c.sort_order, cd.categories_name RESULT Resource id #403 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '140' order by c.sort_order, cd.categories_name RESULT Resource id #406 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '142' order by c.sort_order, cd.categories_name RESULT Resource id #409 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '143' order by c.sort_order, cd.categories_name RESULT Resource id #412 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '141' order by c.sort_order, cd.categories_name RESULT Resource id #415 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '130' order by c.sort_order, cd.categories_name RESULT Resource id #418 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '134' order by c.sort_order, cd.categories_name RESULT Resource id #421 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '124' order by c.sort_order, cd.categories_name RESULT Resource id #424 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '131' order by c.sort_order, cd.categories_name RESULT Resource id #427 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '120' order by c.sort_order, cd.categories_name RESULT Resource id #430 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '129' order by c.sort_order, cd.categories_name RESULT Resource id #433 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '128' order by c.sort_order, cd.categories_name RESULT Resource id #436 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '115' order by c.sort_order, cd.categories_name RESULT Resource id #439 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '119' order by c.sort_order, cd.categories_name RESULT Resource id #442 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '133' order by c.sort_order, cd.categories_name RESULT Resource id #445 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '121' order by c.sort_order, cd.categories_name RESULT Resource id #448 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '126' order by c.sort_order, cd.categories_name RESULT Resource id #451 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '118' order by c.sort_order, cd.categories_name RESULT Resource id #454 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '135' order by c.sort_order, cd.categories_name RESULT Resource id #457 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '145' order by c.sort_order, cd.categories_name RESULT Resource id #460 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '144' order by c.sort_order, cd.categories_name RESULT Resource id #463 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '123' order by c.sort_order, cd.categories_name RESULT Resource id #466 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '122' order by c.sort_order, cd.categories_name RESULT Resource id #469 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '117' order by c.sort_order, cd.categories_name RESULT Resource id #472 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '125' order by c.sort_order, cd.categories_name RESULT Resource id #475 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '91' order by c.sort_order, cd.categories_name RESULT Resource id #478 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #481 04/01/2011 15:17:09 - /index.php?cookies=1 (1.454s) QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #4 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #7 QUERY delete from whos_online where time_last_click < '1294124531' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '' RESULT Resource id #20 QUERY update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '91.211.16.126', time_last_click = '1294125431', last_page_url = '/cookie_usage.php?cookies=1' where session_id = '' RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #25 QUERY 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 RESULT Resource id #28 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #31 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #34 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #41 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '137' RESULT Resource id #44 QUERY select categories_id from categories where parent_id = '137' RESULT Resource id #47 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '138' RESULT Resource id #50 QUERY select categories_id from categories where parent_id = '138' RESULT Resource id #53 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '139' RESULT Resource id #56 QUERY select categories_id from categories where parent_id = '139' RESULT Resource id #59 QUERY select count(*) as count from categories where parent_id = '137' RESULT Resource id #63 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '132' RESULT Resource id #66 QUERY select categories_id from categories where parent_id = '132' RESULT Resource id #69 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '140' RESULT Resource id #72 QUERY select categories_id from categories where parent_id = '140' RESULT Resource id #75 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '141' RESULT Resource id #78 QUERY select categories_id from categories where parent_id = '141' RESULT Resource id #81 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '142' RESULT Resource id #84 QUERY select categories_id from categories where parent_id = '142' RESULT Resource id #87 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '143' RESULT Resource id #90 QUERY select categories_id from categories where parent_id = '143' RESULT Resource id #93 QUERY select count(*) as count from categories where parent_id = '132' RESULT Resource id #97 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '130' RESULT Resource id #100 QUERY select categories_id from categories where parent_id = '130' RESULT Resource id #103 QUERY select count(*) as count from categories where parent_id = '130' RESULT Resource id #107 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '134' RESULT Resource id #110 QUERY select categories_id from categories where parent_id = '134' RESULT Resource id #113 QUERY select count(*) as count from categories where parent_id = '134' RESULT Resource id #117 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '124' RESULT Resource id #120 QUERY select categories_id from categories where parent_id = '124' RESULT Resource id #123 QUERY select count(*) as count from categories where parent_id = '124' RESULT Resource id #127 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '131' RESULT Resource id #130 QUERY select categories_id from categories where parent_id = '131' RESULT Resource id #133 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '120' RESULT Resource id #136 QUERY select categories_id from categories where parent_id = '120' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '131' RESULT Resource id #143 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '129' RESULT Resource id #146 QUERY select categories_id from categories where parent_id = '129' RESULT Resource id #149 QUERY select count(*) as count from categories where parent_id = '129' RESULT Resource id #153 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '128' RESULT Resource id #156 QUERY select categories_id from categories where parent_id = '128' RESULT Resource id #159 QUERY select count(*) as count from categories where parent_id = '128' RESULT Resource id #163 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '115' RESULT Resource id #166 QUERY select categories_id from categories where parent_id = '115' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '115' RESULT Resource id #173 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '119' RESULT Resource id #176 QUERY select categories_id from categories where parent_id = '119' RESULT Resource id #179 QUERY select count(*) as count from categories where parent_id = '119' RESULT Resource id #183 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '133' RESULT Resource id #186 QUERY select categories_id from categories where parent_id = '133' RESULT Resource id #189 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '121' RESULT Resource id #192 QUERY select categories_id from categories where parent_id = '121' RESULT Resource id #195 QUERY select count(*) as count from categories where parent_id = '121' RESULT Resource id #199 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '126' RESULT Resource id #202 QUERY select categories_id from categories where parent_id = '126' RESULT Resource id #205 QUERY select count(*) as count from categories where parent_id = '126' RESULT Resource id #209 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '118' RESULT Resource id #212 QUERY select categories_id from categories where parent_id = '118' RESULT Resource id #215 QUERY select count(*) as count from categories where parent_id = '118' RESULT Resource id #219 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '135' RESULT Resource id #222 QUERY select categories_id from categories where parent_id = '135' RESULT Resource id #225 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '145' RESULT Resource id #228 QUERY select categories_id from categories where parent_id = '145' RESULT Resource id #231 QUERY select count(*) as count from categories where parent_id = '145' RESULT Resource id #235 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '144' RESULT Resource id #238 QUERY select categories_id from categories where parent_id = '144' RESULT Resource id #241 QUERY select count(*) as count from categories where parent_id = '144' RESULT Resource id #245 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '123' RESULT Resource id #248 QUERY select categories_id from categories where parent_id = '123' RESULT Resource id #251 QUERY select count(*) as count from categories where parent_id = '123' RESULT Resource id #255 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '122' RESULT Resource id #258 QUERY select categories_id from categories where parent_id = '122' RESULT Resource id #261 QUERY select count(*) as count from categories where parent_id = '122' RESULT Resource id #265 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '117' RESULT Resource id #268 QUERY select categories_id from categories where parent_id = '117' RESULT Resource id #271 QUERY select count(*) as count from categories where parent_id = '117' RESULT Resource id #275 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '125' RESULT Resource id #278 QUERY select categories_id from categories where parent_id = '125' RESULT Resource id #281 QUERY select count(*) as count from categories where parent_id = '125' RESULT Resource id #285 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '91' RESULT Resource id #288 QUERY select categories_id from categories where parent_id = '91' RESULT Resource id #291 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #294 QUERY select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' and TO_DAYS(NOW()) - TO_DAYS(products_date_added) < '900' order by products_date_added desc limit 10 RESULT Resource id #297 QUERY select products_name from products_description where products_id = '471' and language_id = '1' RESULT Resource id #300 QUERY select specials_new_products_price from specials where products_id = '471' and status RESULT Resource id #303 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #306 QUERY select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, orders o, orders_products op, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' and op.orders_id = o.orders_id and op.products_id = p.products_id and TO_DAYS(NOW()) - TO_DAYS(o.date_purchased) < '900' order by p.products_ordered desc, pd.products_name limit 9 RESULT Resource id #312 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #318 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #324 QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added desc limit 10 RESULT Resource id #327 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #331 QUERY select p.pages_id, p.sort_order, p.status, s.pages_title, s.pages_html_text, s.intorext, s.externallink, s.link_target from pages p LEFT JOIN pages_description s on p.pages_id = s.pages_id where p.status = 1 and p.page_type != 1 and s.language_id = '1' order by p.sort_order, s.pages_title RESULT Resource id #334 QUERY select counter FROM visitors where browser_ip = '91.211.16.126' AND browser_language = '[Unknown]' AND to_days(date_add(now(), INTERVAL 0 HOUR)) - to_days(date) < 1 RESULT Resource id #338 QUERY update visitors set counter = counter+1, online = date_add(now(), INTERVAL 0 HOUR) where browser_ip = '91.211.16.126' AND browser_language = '[Unknown]' AND to_days(date_add(now(), INTERVAL 0 HOUR)) - to_days(date) < 1 RESULT 1 QUERY select startdate, counter from counter RESULT Resource id #343 QUERY update counter set counter = '33656' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #348 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '0' order by c.sort_order, cd.categories_name RESULT Resource id #351 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '137' order by c.sort_order, cd.categories_name RESULT Resource id #354 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '138' order by c.sort_order, cd.categories_name RESULT Resource id #357 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '139' order by c.sort_order, cd.categories_name RESULT Resource id #360 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '132' order by c.sort_order, cd.categories_name RESULT Resource id #363 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '140' order by c.sort_order, cd.categories_name RESULT Resource id #366 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '142' order by c.sort_order, cd.categories_name RESULT Resource id #369 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '143' order by c.sort_order, cd.categories_name RESULT Resource id #372 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '141' order by c.sort_order, cd.categories_name RESULT Resource id #375 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '130' order by c.sort_order, cd.categories_name RESULT Resource id #378 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '134' order by c.sort_order, cd.categories_name RESULT Resource id #381 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '124' order by c.sort_order, cd.categories_name RESULT Resource id #384 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '131' order by c.sort_order, cd.categories_name RESULT Resource id #387 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '120' order by c.sort_order, cd.categories_name RESULT Resource id #390 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '129' order by c.sort_order, cd.categories_name RESULT Resource id #393 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '128' order by c.sort_order, cd.categories_name RESULT Resource id #396 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '115' order by c.sort_order, cd.categories_name RESULT Resource id #399 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '119' order by c.sort_order, cd.categories_name RESULT Resource id #402 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '133' order by c.sort_order, cd.categories_name RESULT Resource id #405 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '121' order by c.sort_order, cd.categories_name RESULT Resource id #408 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '126' order by c.sort_order, cd.categories_name RESULT Resource id #411 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '118' order by c.sort_order, cd.categories_name RESULT Resource id #414 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '135' order by c.sort_order, cd.categories_name RESULT Resource id #417 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '145' order by c.sort_order, cd.categories_name RESULT Resource id #420 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '144' order by c.sort_order, cd.categories_name RESULT Resource id #423 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '123' order by c.sort_order, cd.categories_name RESULT Resource id #426 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '122' order by c.sort_order, cd.categories_name RESULT Resource id #429 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '117' order by c.sort_order, cd.categories_name RESULT Resource id #432 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '125' order by c.sort_order, cd.categories_name RESULT Resource id #435 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '91' order by c.sort_order, cd.categories_name RESULT Resource id #438 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #441 04/01/2011 15:17:13 - /cookie_usage.php?cookies=1 (1.892s) QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #4 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #7 QUERY delete from whos_online where time_last_click < '1294124538' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '' RESULT Resource id #20 QUERY update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '91.211.16.126', time_last_click = '1294125438', last_page_url = '/index.php?cookies=1' where session_id = '' RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #25 QUERY 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 RESULT Resource id #28 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #31 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #34 QUERY select p.pages_id, p.sort_order, p.status, s.pages_title, s.pages_html_text from pages p LEFT JOIN pages_description s on p.pages_id = s.pages_id where p.status = 1 and s.language_id = '1' and p.page_type = 1 RESULT Resource id #38 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #43 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '137' RESULT Resource id #46 QUERY select categories_id from categories where parent_id = '137' RESULT Resource id #49 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '138' RESULT Resource id #52 QUERY select categories_id from categories where parent_id = '138' RESULT Resource id #55 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '139' RESULT Resource id #58 QUERY select categories_id from categories where parent_id = '139' RESULT Resource id #61 QUERY select count(*) as count from categories where parent_id = '137' RESULT Resource id #65 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '132' RESULT Resource id #68 QUERY select categories_id from categories where parent_id = '132' RESULT Resource id #71 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '140' RESULT Resource id #74 QUERY select categories_id from categories where parent_id = '140' RESULT Resource id #77 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '141' RESULT Resource id #80 QUERY select categories_id from categories where parent_id = '141' RESULT Resource id #83 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '142' RESULT Resource id #86 QUERY select categories_id from categories where parent_id = '142' RESULT Resource id #89 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '143' RESULT Resource id #92 QUERY select categories_id from categories where parent_id = '143' RESULT Resource id #95 QUERY select count(*) as count from categories where parent_id = '132' RESULT Resource id #99 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '130' RESULT Resource id #102 QUERY select categories_id from categories where parent_id = '130' RESULT Resource id #105 QUERY select count(*) as count from categories where parent_id = '130' RESULT Resource id #109 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '134' RESULT Resource id #112 QUERY select categories_id from categories where parent_id = '134' RESULT Resource id #115 QUERY select count(*) as count from categories where parent_id = '134' RESULT Resource id #119 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '124' RESULT Resource id #122 QUERY select categories_id from categories where parent_id = '124' RESULT Resource id #125 QUERY select count(*) as count from categories where parent_id = '124' RESULT Resource id #129 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '131' RESULT Resource id #132 QUERY select categories_id from categories where parent_id = '131' RESULT Resource id #135 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '120' RESULT Resource id #138 QUERY select categories_id from categories where parent_id = '120' RESULT Resource id #141 QUERY select count(*) as count from categories where parent_id = '131' RESULT Resource id #145 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '129' RESULT Resource id #148 QUERY select categories_id from categories where parent_id = '129' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '129' RESULT Resource id #155 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '128' RESULT Resource id #158 QUERY select categories_id from categories where parent_id = '128' RESULT Resource id #161 QUERY select count(*) as count from categories where parent_id = '128' RESULT Resource id #165 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '115' RESULT Resource id #168 QUERY select categories_id from categories where parent_id = '115' RESULT Resource id #171 QUERY select count(*) as count from categories where parent_id = '115' RESULT Resource id #175 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '119' RESULT Resource id #178 QUERY select categories_id from categories where parent_id = '119' RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '119' RESULT Resource id #185 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '133' RESULT Resource id #188 QUERY select categories_id from categories where parent_id = '133' RESULT Resource id #191 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '121' RESULT Resource id #194 QUERY select categories_id from categories where parent_id = '121' RESULT Resource id #197 QUERY select count(*) as count from categories where parent_id = '121' RESULT Resource id #201 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '126' RESULT Resource id #204 QUERY select categories_id from categories where parent_id = '126' RESULT Resource id #207 QUERY select count(*) as count from categories where parent_id = '126' RESULT Resource id #211 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '118' RESULT Resource id #214 QUERY select categories_id from categories where parent_id = '118' RESULT Resource id #217 QUERY select count(*) as count from categories where parent_id = '118' RESULT Resource id #221 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '135' RESULT Resource id #224 QUERY select categories_id from categories where parent_id = '135' RESULT Resource id #227 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '145' RESULT Resource id #230 QUERY select categories_id from categories where parent_id = '145' RESULT Resource id #233 QUERY select count(*) as count from categories where parent_id = '145' RESULT Resource id #237 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '144' RESULT Resource id #240 QUERY select categories_id from categories where parent_id = '144' RESULT Resource id #243 QUERY select count(*) as count from categories where parent_id = '144' RESULT Resource id #247 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '123' RESULT Resource id #250 QUERY select categories_id from categories where parent_id = '123' RESULT Resource id #253 QUERY select count(*) as count from categories where parent_id = '123' RESULT Resource id #257 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '122' RESULT Resource id #260 QUERY select categories_id from categories where parent_id = '122' RESULT Resource id #263 QUERY select count(*) as count from categories where parent_id = '122' RESULT Resource id #267 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '117' RESULT Resource id #270 QUERY select categories_id from categories where parent_id = '117' RESULT Resource id #273 QUERY select count(*) as count from categories where parent_id = '117' RESULT Resource id #277 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '125' RESULT Resource id #280 QUERY select categories_id from categories where parent_id = '125' RESULT Resource id #283 QUERY select count(*) as count from categories where parent_id = '125' RESULT Resource id #287 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '91' RESULT Resource id #290 QUERY select categories_id from categories where parent_id = '91' RESULT Resource id #293 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #296 QUERY select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' and TO_DAYS(NOW()) - TO_DAYS(products_date_added) < '900' order by products_date_added desc limit 10 RESULT Resource id #299 QUERY select products_name from products_description where products_id = '468' and language_id = '1' RESULT Resource id #302 QUERY select specials_new_products_price from specials where products_id = '468' and status RESULT Resource id #305 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #308 QUERY select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, orders o, orders_products op, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' and op.orders_id = o.orders_id and op.products_id = p.products_id and TO_DAYS(NOW()) - TO_DAYS(o.date_purchased) < '900' order by p.products_ordered desc, pd.products_name limit 9 RESULT Resource id #314 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #320 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #326 QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added desc limit 10 RESULT Resource id #329 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #333 QUERY select p.pages_id, p.sort_order, p.status, s.pages_title, s.pages_html_text, s.intorext, s.externallink, s.link_target from pages p LEFT JOIN pages_description s on p.pages_id = s.pages_id where p.status = 1 and p.page_type != 1 and s.language_id = '1' order by p.sort_order, s.pages_title RESULT Resource id #336 QUERY select categories_name from categories_description where categories_id = '' limit 1 RESULT Resource id #339 QUERY select p.products_id,p.products_quantity, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand(2099795028) DESC limit 6 RESULT Resource id #342 QUERY select products_name from products_description where products_id = '460' and language_id = '1' RESULT Resource id #345 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #351 QUERY select products_name from products_description where products_id = '424' and language_id = '1' RESULT Resource id #356 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #362 QUERY select products_name from products_description where products_id = '476' and language_id = '1' RESULT Resource id #367 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #373 QUERY select counter FROM visitors where browser_ip = '91.211.16.126' AND browser_language = '[Unknown]' AND to_days(date_add(now(), INTERVAL 0 HOUR)) - to_days(date) < 1 RESULT Resource id #378 QUERY update visitors set counter = counter+1, online = date_add(now(), INTERVAL 0 HOUR) where browser_ip = '91.211.16.126' AND browser_language = '[Unknown]' AND to_days(date_add(now(), INTERVAL 0 HOUR)) - to_days(date) < 1 RESULT 1 QUERY select startdate, counter from counter RESULT Resource id #383 QUERY update counter set counter = '33657' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #388 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '0' order by c.sort_order, cd.categories_name RESULT Resource id #391 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '137' order by c.sort_order, cd.categories_name RESULT Resource id #394 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '138' order by c.sort_order, cd.categories_name RESULT Resource id #397 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '139' order by c.sort_order, cd.categories_name RESULT Resource id #400 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '132' order by c.sort_order, cd.categories_name RESULT Resource id #403 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '140' order by c.sort_order, cd.categories_name RESULT Resource id #406 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '142' order by c.sort_order, cd.categories_name RESULT Resource id #409 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '143' order by c.sort_order, cd.categories_name RESULT Resource id #412 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '141' order by c.sort_order, cd.categories_name RESULT Resource id #415 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '130' order by c.sort_order, cd.categories_name RESULT Resource id #418 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '134' order by c.sort_order, cd.categories_name RESULT Resource id #421 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '124' order by c.sort_order, cd.categories_name RESULT Resource id #424 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '131' order by c.sort_order, cd.categories_name RESULT Resource id #427 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '120' order by c.sort_order, cd.categories_name RESULT Resource id #430 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '129' order by c.sort_order, cd.categories_name RESULT Resource id #433 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '128' order by c.sort_order, cd.categories_name RESULT Resource id #436 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '115' order by c.sort_order, cd.categories_name RESULT Resource id #439 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '119' order by c.sort_order, cd.categories_name RESULT Resource id #442 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '133' order by c.sort_order, cd.categories_name RESULT Resource id #445 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '121' order by c.sort_order, cd.categories_name RESULT Resource id #448 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '126' order by c.sort_order, cd.categories_name RESULT Resource id #451 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '118' order by c.sort_order, cd.categories_name RESULT Resource id #454 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '135' order by c.sort_order, cd.categories_name RESULT Resource id #457 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '145' order by c.sort_order, cd.categories_name RESULT Resource id #460 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '144' order by c.sort_order, cd.categories_name RESULT Resource id #463 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '123' order by c.sort_order, cd.categories_name RESULT Resource id #466 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '122' order by c.sort_order, cd.categories_name RESULT Resource id #469 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '117' order by c.sort_order, cd.categories_name RESULT Resource id #472 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '125' order by c.sort_order, cd.categories_name RESULT Resource id #475 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '91' order by c.sort_order, cd.categories_name RESULT Resource id #478 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #481 04/01/2011 15:17:19 - /index.php?cookies=1 (1.447s) QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #4 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #7 QUERY delete from whos_online where time_last_click < '1294124542' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '' RESULT Resource id #20 QUERY update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '91.211.16.126', time_last_click = '1294125442', last_page_url = '/cookie_usage.php?cookies=1' where session_id = '' RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #25 QUERY 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 RESULT Resource id #28 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #31 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #34 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #41 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '137' RESULT Resource id #44 QUERY select categories_id from categories where parent_id = '137' RESULT Resource id #47 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '138' RESULT Resource id #50 QUERY select categories_id from categories where parent_id = '138' RESULT Resource id #53 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '139' RESULT Resource id #56 QUERY select categories_id from categories where parent_id = '139' RESULT Resource id #59 QUERY select count(*) as count from categories where parent_id = '137' RESULT Resource id #63 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '132' RESULT Resource id #66 QUERY select categories_id from categories where parent_id = '132' RESULT Resource id #69 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '140' RESULT Resource id #72 QUERY select categories_id from categories where parent_id = '140' RESULT Resource id #75 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '141' RESULT Resource id #78 QUERY select categories_id from categories where parent_id = '141' RESULT Resource id #81 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '142' RESULT Resource id #84 QUERY select categories_id from categories where parent_id = '142' RESULT Resource id #87 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '143' RESULT Resource id #90 QUERY select categories_id from categories where parent_id = '143' RESULT Resource id #93 QUERY select count(*) as count from categories where parent_id = '132' RESULT Resource id #97 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '130' RESULT Resource id #100 QUERY select categories_id from categories where parent_id = '130' RESULT Resource id #103 QUERY select count(*) as count from categories where parent_id = '130' RESULT Resource id #107 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '134' RESULT Resource id #110 QUERY select categories_id from categories where parent_id = '134' RESULT Resource id #113 QUERY select count(*) as count from categories where parent_id = '134' RESULT Resource id #117 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '124' RESULT Resource id #120 QUERY select categories_id from categories where parent_id = '124' RESULT Resource id #123 QUERY select count(*) as count from categories where parent_id = '124' RESULT Resource id #127 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '131' RESULT Resource id #130 QUERY select categories_id from categories where parent_id = '131' RESULT Resource id #133 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '120' RESULT Resource id #136 QUERY select categories_id from categories where parent_id = '120' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '131' RESULT Resource id #143 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '129' RESULT Resource id #146 QUERY select categories_id from categories where parent_id = '129' RESULT Resource id #149 QUERY select count(*) as count from categories where parent_id = '129' RESULT Resource id #153 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '128' RESULT Resource id #156 QUERY select categories_id from categories where parent_id = '128' RESULT Resource id #159 QUERY select count(*) as count from categories where parent_id = '128' RESULT Resource id #163 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '115' RESULT Resource id #166 QUERY select categories_id from categories where parent_id = '115' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '115' RESULT Resource id #173 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '119' RESULT Resource id #176 QUERY select categories_id from categories where parent_id = '119' RESULT Resource id #179 QUERY select count(*) as count from categories where parent_id = '119' RESULT Resource id #183 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '133' RESULT Resource id #186 QUERY select categories_id from categories where parent_id = '133' RESULT Resource id #189 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '121' RESULT Resource id #192 QUERY select categories_id from categories where parent_id = '121' RESULT Resource id #195 QUERY select count(*) as count from categories where parent_id = '121' RESULT Resource id #199 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '126' RESULT Resource id #202 QUERY select categories_id from categories where parent_id = '126' RESULT Resource id #205 QUERY select count(*) as count from categories where parent_id = '126' RESULT Resource id #209 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '118' RESULT Resource id #212 QUERY select categories_id from categories where parent_id = '118' RESULT Resource id #215 QUERY select count(*) as count from categories where parent_id = '118' RESULT Resource id #219 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '135' RESULT Resource id #222 QUERY select categories_id from categories where parent_id = '135' RESULT Resource id #225 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '145' RESULT Resource id #228 QUERY select categories_id from categories where parent_id = '145' RESULT Resource id #231 QUERY select count(*) as count from categories where parent_id = '145' RESULT Resource id #235 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '144' RESULT Resource id #238 QUERY select categories_id from categories where parent_id = '144' RESULT Resource id #241 QUERY select count(*) as count from categories where parent_id = '144' RESULT Resource id #245 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '123' RESULT Resource id #248 QUERY select categories_id from categories where parent_id = '123' RESULT Resource id #251 QUERY select count(*) as count from categories where parent_id = '123' RESULT Resource id #255 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '122' RESULT Resource id #258 QUERY select categories_id from categories where parent_id = '122' RESULT Resource id #261 QUERY select count(*) as count from categories where parent_id = '122' RESULT Resource id #265 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '117' RESULT Resource id #268 QUERY select categories_id from categories where parent_id = '117' RESULT Resource id #271 QUERY select count(*) as count from categories where parent_id = '117' RESULT Resource id #275 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '125' RESULT Resource id #278 QUERY select categories_id from categories where parent_id = '125' RESULT Resource id #281 QUERY select count(*) as count from categories where parent_id = '125' RESULT Resource id #285 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '91' RESULT Resource id #288 QUERY select categories_id from categories where parent_id = '91' RESULT Resource id #291 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #294 QUERY select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' and TO_DAYS(NOW()) - TO_DAYS(products_date_added) < '900' order by products_date_added desc limit 10 RESULT Resource id #297 QUERY select products_name from products_description where products_id = '472' and language_id = '1' RESULT Resource id #300 QUERY select specials_new_products_price from specials where products_id = '472' and status RESULT Resource id #303 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #306 QUERY select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, orders o, orders_products op, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' and op.orders_id = o.orders_id and op.products_id = p.products_id and TO_DAYS(NOW()) - TO_DAYS(o.date_purchased) < '900' order by p.products_ordered desc, pd.products_name limit 9 RESULT Resource id #312 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #318 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #324 QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added desc limit 10 RESULT Resource id #327 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #331 QUERY select p.pages_id, p.sort_order, p.status, s.pages_title, s.pages_html_text, s.intorext, s.externallink, s.link_target from pages p LEFT JOIN pages_description s on p.pages_id = s.pages_id where p.status = 1 and p.page_type != 1 and s.language_id = '1' order by p.sort_order, s.pages_title RESULT Resource id #334 QUERY select counter FROM visitors where browser_ip = '91.211.16.126' AND browser_language = '[Unknown]' AND to_days(date_add(now(), INTERVAL 0 HOUR)) - to_days(date) < 1 RESULT Resource id #338 QUERY update visitors set counter = counter+1, online = date_add(now(), INTERVAL 0 HOUR) where browser_ip = '91.211.16.126' AND browser_language = '[Unknown]' AND to_days(date_add(now(), INTERVAL 0 HOUR)) - to_days(date) < 1 RESULT 1 QUERY select startdate, counter from counter RESULT Resource id #343 QUERY update counter set counter = '33658' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #348 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '0' order by c.sort_order, cd.categories_name RESULT Resource id #351 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '137' order by c.sort_order, cd.categories_name RESULT Resource id #354 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '138' order by c.sort_order, cd.categories_name RESULT Resource id #357 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '139' order by c.sort_order, cd.categories_name RESULT Resource id #360 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '132' order by c.sort_order, cd.categories_name RESULT Resource id #363 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '140' order by c.sort_order, cd.categories_name RESULT Resource id #366 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '142' order by c.sort_order, cd.categories_name RESULT Resource id #369 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '143' order by c.sort_order, cd.categories_name RESULT Resource id #372 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '141' order by c.sort_order, cd.categories_name RESULT Resource id #375 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '130' order by c.sort_order, cd.categories_name RESULT Resource id #378 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '134' order by c.sort_order, cd.categories_name RESULT Resource id #381 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '124' order by c.sort_order, cd.categories_name RESULT Resource id #384 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '131' order by c.sort_order, cd.categories_name RESULT Resource id #387 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '120' order by c.sort_order, cd.categories_name RESULT Resource id #390 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '129' order by c.sort_order, cd.categories_name RESULT Resource id #393 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '128' order by c.sort_order, cd.categories_name RESULT Resource id #396 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '115' order by c.sort_order, cd.categories_name RESULT Resource id #399 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '119' order by c.sort_order, cd.categories_name RESULT Resource id #402 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '133' order by c.sort_order, cd.categories_name RESULT Resource id #405 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '121' order by c.sort_order, cd.categories_name RESULT Resource id #408 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '126' order by c.sort_order, cd.categories_name RESULT Resource id #411 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '118' order by c.sort_order, cd.categories_name RESULT Resource id #414 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '135' order by c.sort_order, cd.categories_name RESULT Resource id #417 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '145' order by c.sort_order, cd.categories_name RESULT Resource id #420 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '144' order by c.sort_order, cd.categories_name RESULT Resource id #423 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '123' order by c.sort_order, cd.categories_name RESULT Resource id #426 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '122' order by c.sort_order, cd.categories_name RESULT Resource id #429 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '117' order by c.sort_order, cd.categories_name RESULT Resource id #432 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '125' order by c.sort_order, cd.categories_name RESULT Resource id #435 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '91' order by c.sort_order, cd.categories_name RESULT Resource id #438 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #441 04/01/2011 15:17:23 - /cookie_usage.php?cookies=1 (1.458s) QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #4 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #7 QUERY delete from whos_online where time_last_click < '1294124550' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '' RESULT Resource id #20 QUERY update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '91.211.16.126', time_last_click = '1294125450', last_page_url = '/index.php?cookies=1' where session_id = '' RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #25 QUERY 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 RESULT Resource id #28 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #31 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #34 QUERY select p.pages_id, p.sort_order, p.status, s.pages_title, s.pages_html_text from pages p LEFT JOIN pages_description s on p.pages_id = s.pages_id where p.status = 1 and s.language_id = '1' and p.page_type = 1 RESULT Resource id #38 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #43 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '137' RESULT Resource id #46 QUERY select categories_id from categories where parent_id = '137' RESULT Resource id #49 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '138' RESULT Resource id #52 QUERY select categories_id from categories where parent_id = '138' RESULT Resource id #55 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '139' RESULT Resource id #58 QUERY select categories_id from categories where parent_id = '139' RESULT Resource id #61 QUERY select count(*) as count from categories where parent_id = '137' RESULT Resource id #65 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '132' RESULT Resource id #68 QUERY select categories_id from categories where parent_id = '132' RESULT Resource id #71 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '140' RESULT Resource id #74 QUERY select categories_id from categories where parent_id = '140' RESULT Resource id #77 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '141' RESULT Resource id #80 QUERY select categories_id from categories where parent_id = '141' RESULT Resource id #83 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '142' RESULT Resource id #86 QUERY select categories_id from categories where parent_id = '142' RESULT Resource id #89 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '143' RESULT Resource id #92 QUERY select categories_id from categories where parent_id = '143' RESULT Resource id #95 QUERY select count(*) as count from categories where parent_id = '132' RESULT Resource id #99 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '130' RESULT Resource id #102 QUERY select categories_id from categories where parent_id = '130' RESULT Resource id #105 QUERY select count(*) as count from categories where parent_id = '130' RESULT Resource id #109 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '134' RESULT Resource id #112 QUERY select categories_id from categories where parent_id = '134' RESULT Resource id #115 QUERY select count(*) as count from categories where parent_id = '134' RESULT Resource id #119 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '124' RESULT Resource id #122 QUERY select categories_id from categories where parent_id = '124' RESULT Resource id #125 QUERY select count(*) as count from categories where parent_id = '124' RESULT Resource id #129 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '131' RESULT Resource id #132 QUERY select categories_id from categories where parent_id = '131' RESULT Resource id #135 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '120' RESULT Resource id #138 QUERY select categories_id from categories where parent_id = '120' RESULT Resource id #141 QUERY select count(*) as count from categories where parent_id = '131' RESULT Resource id #145 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '129' RESULT Resource id #148 QUERY select categories_id from categories where parent_id = '129' RESULT Resource id #151 QUERY select count(*) as count from categories where parent_id = '129' RESULT Resource id #155 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '128' RESULT Resource id #158 QUERY select categories_id from categories where parent_id = '128' RESULT Resource id #161 QUERY select count(*) as count from categories where parent_id = '128' RESULT Resource id #165 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '115' RESULT Resource id #168 QUERY select categories_id from categories where parent_id = '115' RESULT Resource id #171 QUERY select count(*) as count from categories where parent_id = '115' RESULT Resource id #175 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '119' RESULT Resource id #178 QUERY select categories_id from categories where parent_id = '119' RESULT Resource id #181 QUERY select count(*) as count from categories where parent_id = '119' RESULT Resource id #185 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '133' RESULT Resource id #188 QUERY select categories_id from categories where parent_id = '133' RESULT Resource id #191 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '121' RESULT Resource id #194 QUERY select categories_id from categories where parent_id = '121' RESULT Resource id #197 QUERY select count(*) as count from categories where parent_id = '121' RESULT Resource id #201 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '126' RESULT Resource id #204 QUERY select categories_id from categories where parent_id = '126' RESULT Resource id #207 QUERY select count(*) as count from categories where parent_id = '126' RESULT Resource id #211 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '118' RESULT Resource id #214 QUERY select categories_id from categories where parent_id = '118' RESULT Resource id #217 QUERY select count(*) as count from categories where parent_id = '118' RESULT Resource id #221 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '135' RESULT Resource id #224 QUERY select categories_id from categories where parent_id = '135' RESULT Resource id #227 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '145' RESULT Resource id #230 QUERY select categories_id from categories where parent_id = '145' RESULT Resource id #233 QUERY select count(*) as count from categories where parent_id = '145' RESULT Resource id #237 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '144' RESULT Resource id #240 QUERY select categories_id from categories where parent_id = '144' RESULT Resource id #243 QUERY select count(*) as count from categories where parent_id = '144' RESULT Resource id #247 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '123' RESULT Resource id #250 QUERY select categories_id from categories where parent_id = '123' RESULT Resource id #253 QUERY select count(*) as count from categories where parent_id = '123' RESULT Resource id #257 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '122' RESULT Resource id #260 QUERY select categories_id from categories where parent_id = '122' RESULT Resource id #263 QUERY select count(*) as count from categories where parent_id = '122' RESULT Resource id #267 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '117' RESULT Resource id #270 QUERY select categories_id from categories where parent_id = '117' RESULT Resource id #273 QUERY select count(*) as count from categories where parent_id = '117' RESULT Resource id #277 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '125' RESULT Resource id #280 QUERY select categories_id from categories where parent_id = '125' RESULT Resource id #283 QUERY select count(*) as count from categories where parent_id = '125' RESULT Resource id #287 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '91' RESULT Resource id #290 QUERY select categories_id from categories where parent_id = '91' RESULT Resource id #293 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #296 QUERY select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' and TO_DAYS(NOW()) - TO_DAYS(products_date_added) < '900' order by products_date_added desc limit 10 RESULT Resource id #299 QUERY select products_name from products_description where products_id = '475' and language_id = '1' RESULT Resource id #302 QUERY select specials_new_products_price from specials where products_id = '475' and status RESULT Resource id #305 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #308 QUERY select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, orders o, orders_products op, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' and op.orders_id = o.orders_id and op.products_id = p.products_id and TO_DAYS(NOW()) - TO_DAYS(o.date_purchased) < '900' order by p.products_ordered desc, pd.products_name limit 9 RESULT Resource id #314 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #320 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #326 QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added desc limit 10 RESULT Resource id #329 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #333 QUERY select p.pages_id, p.sort_order, p.status, s.pages_title, s.pages_html_text, s.intorext, s.externallink, s.link_target from pages p LEFT JOIN pages_description s on p.pages_id = s.pages_id where p.status = 1 and p.page_type != 1 and s.language_id = '1' order by p.sort_order, s.pages_title RESULT Resource id #336 QUERY select categories_name from categories_description where categories_id = '' limit 1 RESULT Resource id #339 QUERY select p.products_id,p.products_quantity, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand(1528689042) DESC limit 6 RESULT Resource id #342 QUERY select products_name from products_description where products_id = '460' and language_id = '1' RESULT Resource id #345 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #351 QUERY select products_name from products_description where products_id = '424' and language_id = '1' RESULT Resource id #356 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #362 QUERY select products_name from products_description where products_id = '476' and language_id = '1' RESULT Resource id #367 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #373 QUERY select counter FROM visitors where browser_ip = '91.211.16.126' AND browser_language = '[Unknown]' AND to_days(date_add(now(), INTERVAL 0 HOUR)) - to_days(date) < 1 RESULT Resource id #378 QUERY update visitors set counter = counter+1, online = date_add(now(), INTERVAL 0 HOUR) where browser_ip = '91.211.16.126' AND browser_language = '[Unknown]' AND to_days(date_add(now(), INTERVAL 0 HOUR)) - to_days(date) < 1 RESULT 1 QUERY select startdate, counter from counter RESULT Resource id #383 QUERY update counter set counter = '33659' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #388 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '0' order by c.sort_order, cd.categories_name RESULT Resource id #391 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '137' order by c.sort_order, cd.categories_name RESULT Resource id #394 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '138' order by c.sort_order, cd.categories_name RESULT Resource id #397 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '139' order by c.sort_order, cd.categories_name RESULT Resource id #400 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '132' order by c.sort_order, cd.categories_name RESULT Resource id #403 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '140' order by c.sort_order, cd.categories_name RESULT Resource id #406 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '142' order by c.sort_order, cd.categories_name RESULT Resource id #409 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '143' order by c.sort_order, cd.categories_name RESULT Resource id #412 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '141' order by c.sort_order, cd.categories_name RESULT Resource id #415 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '130' order by c.sort_order, cd.categories_name RESULT Resource id #418 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '134' order by c.sort_order, cd.categories_name RESULT Resource id #421 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '124' order by c.sort_order, cd.categories_name RESULT Resource id #424 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '131' order by c.sort_order, cd.categories_name RESULT Resource id #427 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '120' order by c.sort_order, cd.categories_name RESULT Resource id #430 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '129' order by c.sort_order, cd.categories_name RESULT Resource id #433 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '128' order by c.sort_order, cd.categories_name RESULT Resource id #436 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '115' order by c.sort_order, cd.categories_name RESULT Resource id #439 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '119' order by c.sort_order, cd.categories_name RESULT Resource id #442 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '133' order by c.sort_order, cd.categories_name RESULT Resource id #445 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '121' order by c.sort_order, cd.categories_name RESULT Resource id #448 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '126' order by c.sort_order, cd.categories_name RESULT Resource id #451 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '118' order by c.sort_order, cd.categories_name RESULT Resource id #454 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '135' order by c.sort_order, cd.categories_name RESULT Resource id #457 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '145' order by c.sort_order, cd.categories_name RESULT Resource id #460 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '144' order by c.sort_order, cd.categories_name RESULT Resource id #463 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '123' order by c.sort_order, cd.categories_name RESULT Resource id #466 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '122' order by c.sort_order, cd.categories_name RESULT Resource id #469 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '117' order by c.sort_order, cd.categories_name RESULT Resource id #472 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '125' order by c.sort_order, cd.categories_name RESULT Resource id #475 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '91' order by c.sort_order, cd.categories_name RESULT Resource id #478 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #481 04/01/2011 15:17:31 - /index.php?cookies=1 (1.441s) QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #4 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #7 QUERY delete from whos_online where time_last_click < '1294124554' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '' RESULT Resource id #20 QUERY update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '91.211.16.126', time_last_click = '1294125454', last_page_url = '/cookie_usage.php?cookies=1' where session_id = '' RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #25 QUERY 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 RESULT Resource id #28 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #31 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #34 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #41 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '137' RESULT Resource id #44 QUERY select categories_id from categories where parent_id = '137' RESULT Resource id #47 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '138' RESULT Resource id #50 QUERY select categories_id from categories where parent_id = '138' RESULT Resource id #53 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '139' RESULT Resource id #56 QUERY select categories_id from categories where parent_id = '139' RESULT Resource id #59 QUERY select count(*) as count from categories where parent_id = '137' RESULT Resource id #63 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '132' RESULT Resource id #66 QUERY select categories_id from categories where parent_id = '132' RESULT Resource id #69 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '140' RESULT Resource id #72 QUERY select categories_id from categories where parent_id = '140' RESULT Resource id #75 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '141' RESULT Resource id #78 QUERY select categories_id from categories where parent_id = '141' RESULT Resource id #81 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '142' RESULT Resource id #84 QUERY select categories_id from categories where parent_id = '142' RESULT Resource id #87 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '143' RESULT Resource id #90 QUERY select categories_id from categories where parent_id = '143' RESULT Resource id #93 QUERY select count(*) as count from categories where parent_id = '132' RESULT Resource id #97 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '130' RESULT Resource id #100 QUERY select categories_id from categories where parent_id = '130' RESULT Resource id #103 QUERY select count(*) as count from categories where parent_id = '130' RESULT Resource id #107 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '134' RESULT Resource id #110 QUERY select categories_id from categories where parent_id = '134' RESULT Resource id #113 QUERY select count(*) as count from categories where parent_id = '134' RESULT Resource id #117 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '124' RESULT Resource id #120 QUERY select categories_id from categories where parent_id = '124' RESULT Resource id #123 QUERY select count(*) as count from categories where parent_id = '124' RESULT Resource id #127 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '131' RESULT Resource id #130 QUERY select categories_id from categories where parent_id = '131' RESULT Resource id #133 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '120' RESULT Resource id #136 QUERY select categories_id from categories where parent_id = '120' RESULT Resource id #139 QUERY select count(*) as count from categories where parent_id = '131' RESULT Resource id #143 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '129' RESULT Resource id #146 QUERY select categories_id from categories where parent_id = '129' RESULT Resource id #149 QUERY select count(*) as count from categories where parent_id = '129' RESULT Resource id #153 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '128' RESULT Resource id #156 QUERY select categories_id from categories where parent_id = '128' RESULT Resource id #159 QUERY select count(*) as count from categories where parent_id = '128' RESULT Resource id #163 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '115' RESULT Resource id #166 QUERY select categories_id from categories where parent_id = '115' RESULT Resource id #169 QUERY select count(*) as count from categories where parent_id = '115' RESULT Resource id #173 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '119' RESULT Resource id #176 QUERY select categories_id from categories where parent_id = '119' RESULT Resource id #179 QUERY select count(*) as count from categories where parent_id = '119' RESULT Resource id #183 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '133' RESULT Resource id #186 QUERY select categories_id from categories where parent_id = '133' RESULT Resource id #189 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '121' RESULT Resource id #192 QUERY select categories_id from categories where parent_id = '121' RESULT Resource id #195 QUERY select count(*) as count from categories where parent_id = '121' RESULT Resource id #199 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '126' RESULT Resource id #202 QUERY select categories_id from categories where parent_id = '126' RESULT Resource id #205 QUERY select count(*) as count from categories where parent_id = '126' RESULT Resource id #209 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '118' RESULT Resource id #212 QUERY select categories_id from categories where parent_id = '118' RESULT Resource id #215 QUERY select count(*) as count from categories where parent_id = '118' RESULT Resource id #219 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '135' RESULT Resource id #222 QUERY select categories_id from categories where parent_id = '135' RESULT Resource id #225 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '145' RESULT Resource id #228 QUERY select categories_id from categories where parent_id = '145' RESULT Resource id #231 QUERY select count(*) as count from categories where parent_id = '145' RESULT Resource id #235 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '144' RESULT Resource id #238 QUERY select categories_id from categories where parent_id = '144' RESULT Resource id #241 QUERY select count(*) as count from categories where parent_id = '144' RESULT Resource id #245 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '123' RESULT Resource id #248 QUERY select categories_id from categories where parent_id = '123' RESULT Resource id #251 QUERY select count(*) as count from categories where parent_id = '123' RESULT Resource id #255 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '122' RESULT Resource id #258 QUERY select categories_id from categories where parent_id = '122' RESULT Resource id #261 QUERY select count(*) as count from categories where parent_id = '122' RESULT Resource id #265 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '117' RESULT Resource id #268 QUERY select categories_id from categories where parent_id = '117' RESULT Resource id #271 QUERY select count(*) as count from categories where parent_id = '117' RESULT Resource id #275 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '125' RESULT Resource id #278 QUERY select categories_id from categories where parent_id = '125' RESULT Resource id #281 QUERY select count(*) as count from categories where parent_id = '125' RESULT Resource id #285 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '91' RESULT Resource id #288 QUERY select categories_id from categories where parent_id = '91' RESULT Resource id #291 QUERY select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name RESULT Resource id #294 QUERY select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' and TO_DAYS(NOW()) - TO_DAYS(products_date_added) < '900' order by products_date_added desc limit 10 RESULT Resource id #297 QUERY select products_name from products_description where products_id = '476' and language_id = '1' RESULT Resource id #300 QUERY select specials_new_products_price from specials where products_id = '476' and status RESULT Resource id #303 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #306 QUERY select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, orders o, orders_products op, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' and op.orders_id = o.orders_id and op.products_id = p.products_id and TO_DAYS(NOW()) - TO_DAYS(o.date_purchased) < '900' order by p.products_ordered desc, pd.products_name limit 9 RESULT Resource id #312 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #318 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '188') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '0') and tr.tax_class_id = '0' group by tr.tax_priority RESULT Resource id #324 QUERY select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added desc limit 10 RESULT Resource id #327 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #331 QUERY select p.pages_id, p.sort_order, p.status, s.pages_title, s.pages_html_text, s.intorext, s.externallink, s.link_target from pages p LEFT JOIN pages_description s on p.pages_id = s.pages_id where p.status = 1 and p.page_type != 1 and s.language_id = '1' order by p.sort_order, s.pages_title RESULT Resource id #334 QUERY select counter FROM visitors where browser_ip = '91.211.16.126' AND browser_language = '[Unknown]' AND to_days(date_add(now(), INTERVAL 0 HOUR)) - to_days(date) < 1 RESULT Resource id #338 QUERY update visitors set counter = counter+1, online = date_add(now(), INTERVAL 0 HOUR) where browser_ip = '91.211.16.126' AND browser_language = '[Unknown]' AND to_days(date_add(now(), INTERVAL 0 HOUR)) - to_days(date) < 1 RESULT 1 QUERY select startdate, counter from counter RESULT Resource id #343 QUERY update counter set counter = '33660' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #348 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '0' order by c.sort_order, cd.categories_name RESULT Resource id #351 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '137' order by c.sort_order, cd.categories_name RESULT Resource id #354 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '138' order by c.sort_order, cd.categories_name RESULT Resource id #357 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '139' order by c.sort_order, cd.categories_name RESULT Resource id #360 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '132' order by c.sort_order, cd.categories_name RESULT Resource id #363 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '140' order by c.sort_order, cd.categories_name RESULT Resource id #366 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '142' order by c.sort_order, cd.categories_name RESULT Resource id #369 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '143' order by c.sort_order, cd.categories_name RESULT Resource id #372 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '141' order by c.sort_order, cd.categories_name RESULT Resource id #375 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '130' order by c.sort_order, cd.categories_name RESULT Resource id #378 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '134' order by c.sort_order, cd.categories_name RESULT Resource id #381 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '124' order by c.sort_order, cd.categories_name RESULT Resource id #384 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '131' order by c.sort_order, cd.categories_name RESULT Resource id #387 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '120' order by c.sort_order, cd.categories_name RESULT Resource id #390 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '129' order by c.sort_order, cd.categories_name RESULT Resource id #393 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '128' order by c.sort_order, cd.categories_name RESULT Resource id #396 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '115' order by c.sort_order, cd.categories_name RESULT Resource id #399 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '119' order by c.sort_order, cd.categories_name RESULT Resource id #402 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '133' order by c.sort_order, cd.categories_name RESULT Resource id #405 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '121' order by c.sort_order, cd.categories_name RESULT Resource id #408 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '126' order by c.sort_order, cd.categories_name RESULT Resource id #411 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '118' order by c.sort_order, cd.categories_name RESULT Resource id #414 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '135' order by c.sort_order, cd.categories_name RESULT Resource id #417 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '145' order by c.sort_order, cd.categories_name RESULT Resource id #420 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '144' order by c.sort_order, cd.categories_name RESULT Resource id #423 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '123' order by c.sort_order, cd.categories_name RESULT Resource id #426 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '122' order by c.sort_order, cd.categories_name RESULT Resource id #429 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '117' order by c.sort_order, cd.categories_name RESULT Resource id #432 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '125' order by c.sort_order, cd.categories_name RESULT Resource id #435 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '1' and c.parent_id = '91' order by c.sort_order, cd.categories_name RESULT Resource id #438 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #441 04/01/2011 15:17:35 - /cookie_usage.php?cookies=1 (1.441s)