QUERY select value from sessions where sesskey = '7ed791e0966a5afcee8014abb2945256' and expiry > '1291520909' RESULT Resource id #16 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #20 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #26 QUERY delete from whos_online where time_last_click < '1291520009' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '7ed791e0966a5afcee8014abb2945256' RESULT Resource id #33 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '7ed791e0966a5afcee8014abb2945256', '91.211.16.126', '1291520909', '1291520909', '/catalog/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #43 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 #46 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #50 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 #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 = '1' RESULT Resource id #68 QUERY select categories_id from categories where parent_id = '1' 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 = '4' RESULT Resource id #74 QUERY select categories_id from categories where parent_id = '4' 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 = '23' RESULT Resource id #80 QUERY select categories_id from categories where parent_id = '23' 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 = '24' RESULT Resource id #86 QUERY select categories_id from categories where parent_id = '24' 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 = '25' RESULT Resource id #92 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #95 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26' RESULT Resource id #98 QUERY select categories_id from categories where parent_id = '26' RESULT Resource id #101 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '8' RESULT Resource id #104 QUERY select categories_id from categories where parent_id = '8' 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 = '62' RESULT Resource id #110 QUERY select categories_id from categories where parent_id = '62' RESULT Resource id #113 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63' RESULT Resource id #116 QUERY select categories_id from categories where parent_id = '63' 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 = '17' RESULT Resource id #122 QUERY select categories_id from categories where parent_id = '17' RESULT Resource id #125 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '64' RESULT Resource id #128 QUERY select categories_id from categories where parent_id = '64' RESULT Resource id #131 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '65' RESULT Resource id #134 QUERY select categories_id from categories where parent_id = '65' RESULT Resource id #137 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '68' RESULT Resource id #140 QUERY select categories_id from categories where parent_id = '68' 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 = '66' RESULT Resource id #146 QUERY select categories_id from categories where parent_id = '66' RESULT Resource id #149 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '67' RESULT Resource id #152 QUERY select categories_id from categories where parent_id = '67' RESULT Resource id #155 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #158 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '1' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #161 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '17' RESULT Resource id #164 QUERY select categories_id from categories where parent_id = '17' RESULT Resource id #167 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '64' RESULT Resource id #170 QUERY select categories_id from categories where parent_id = '64' 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 = '65' RESULT Resource id #176 QUERY select categories_id from categories where parent_id = '65' RESULT Resource id #179 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '68' RESULT Resource id #182 QUERY select categories_id from categories where parent_id = '68' RESULT Resource id #185 QUERY select count(*) as count from categories where parent_id = '17' RESULT Resource id #188 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '17' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name 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 = '64' RESULT Resource id #194 QUERY select categories_id from categories where parent_id = '64' RESULT Resource id #197 QUERY select count(*) as count from categories where parent_id = '64' RESULT Resource id #200 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '65' RESULT Resource id #203 QUERY select categories_id from categories where parent_id = '65' RESULT Resource id #206 QUERY select count(*) as count from categories where parent_id = '65' 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 = '68' RESULT Resource id #212 QUERY select categories_id from categories where parent_id = '68' RESULT Resource id #215 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #218 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '66' RESULT Resource id #221 QUERY select categories_id from categories where parent_id = '66' RESULT Resource id #224 QUERY select count(*) as count from categories where parent_id = '66' 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 = '67' RESULT Resource id #230 QUERY select categories_id from categories where parent_id = '67' RESULT Resource id #233 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #236 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '4' RESULT Resource id #239 QUERY select categories_id from categories where parent_id = '4' RESULT Resource id #242 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23' RESULT Resource id #245 QUERY select categories_id from categories where parent_id = '23' 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 = '24' RESULT Resource id #251 QUERY select categories_id from categories where parent_id = '24' RESULT Resource id #254 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25' RESULT Resource id #257 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #260 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26' RESULT Resource id #263 QUERY select categories_id from categories where parent_id = '26' RESULT Resource id #266 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #269 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '4' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #272 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23' RESULT Resource id #275 QUERY select categories_id from categories where parent_id = '23' RESULT Resource id #278 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #281 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24' RESULT Resource id #284 QUERY select categories_id from categories where parent_id = '24' RESULT Resource id #287 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #290 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25' RESULT Resource id #293 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #296 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #299 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26' RESULT Resource id #302 QUERY select categories_id from categories where parent_id = '26' RESULT Resource id #305 QUERY select count(*) as count from categories where parent_id = '26' RESULT Resource id #308 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '8' RESULT Resource id #311 QUERY select categories_id from categories where parent_id = '8' RESULT Resource id #314 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62' RESULT Resource id #317 QUERY select categories_id from categories where parent_id = '62' RESULT Resource id #320 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63' RESULT Resource id #323 QUERY select categories_id from categories where parent_id = '63' RESULT Resource id #326 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #329 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '8' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #332 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63' RESULT Resource id #335 QUERY select categories_id from categories where parent_id = '63' RESULT Resource id #338 QUERY select count(*) as count from categories where parent_id = '63' RESULT Resource id #341 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62' RESULT Resource id #344 QUERY select categories_id from categories where parent_id = '62' RESULT Resource id #347 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #350 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '2' RESULT Resource id #353 QUERY select categories_id from categories where parent_id = '2' RESULT Resource id #356 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22' RESULT Resource id #359 QUERY select categories_id from categories where parent_id = '22' RESULT Resource id #362 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '19' RESULT Resource id #365 QUERY select categories_id from categories where parent_id = '19' RESULT Resource id #368 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '20' RESULT Resource id #371 QUERY select categories_id from categories where parent_id = '20' RESULT Resource id #374 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #377 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '2' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #380 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22' RESULT Resource id #383 QUERY select categories_id from categories where parent_id = '22' RESULT Resource id #386 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #389 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '20' RESULT Resource id #392 QUERY select categories_id from categories where parent_id = '20' RESULT Resource id #395 QUERY select count(*) as count from categories where parent_id = '20' RESULT Resource id #398 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '19' RESULT Resource id #401 QUERY select categories_id from categories where parent_id = '19' RESULT Resource id #404 QUERY select count(*) as count from categories where parent_id = '19' RESULT Resource id #407 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '21' RESULT Resource id #410 QUERY select categories_id from categories where parent_id = '21' RESULT Resource id #413 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '79' RESULT Resource id #416 QUERY select categories_id from categories where parent_id = '79' RESULT Resource id #419 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31' RESULT Resource id #422 QUERY select categories_id from categories where parent_id = '31' RESULT Resource id #425 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '32' RESULT Resource id #428 QUERY select categories_id from categories where parent_id = '32' RESULT Resource id #431 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '30' RESULT Resource id #434 QUERY select categories_id from categories where parent_id = '30' RESULT Resource id #437 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '76' RESULT Resource id #440 QUERY select categories_id from categories where parent_id = '76' RESULT Resource id #443 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33' RESULT Resource id #446 QUERY select categories_id from categories where parent_id = '33' RESULT Resource id #449 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46' RESULT Resource id #452 QUERY select categories_id from categories where parent_id = '46' RESULT Resource id #455 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '47' RESULT Resource id #458 QUERY select categories_id from categories where parent_id = '47' RESULT Resource id #461 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '48' RESULT Resource id #464 QUERY select categories_id from categories where parent_id = '48' RESULT Resource id #467 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49' RESULT Resource id #470 QUERY select categories_id from categories where parent_id = '49' RESULT Resource id #473 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50' RESULT Resource id #476 QUERY select categories_id from categories where parent_id = '50' RESULT Resource id #479 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51' RESULT Resource id #482 QUERY select categories_id from categories where parent_id = '51' RESULT Resource id #485 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52' RESULT Resource id #488 QUERY select categories_id from categories where parent_id = '52' RESULT Resource id #491 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53' RESULT Resource id #494 QUERY select categories_id from categories where parent_id = '53' RESULT Resource id #497 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54' RESULT Resource id #500 QUERY select categories_id from categories where parent_id = '54' RESULT Resource id #503 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '55' RESULT Resource id #506 QUERY select categories_id from categories where parent_id = '55' RESULT Resource id #509 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '56' RESULT Resource id #512 QUERY select categories_id from categories where parent_id = '56' RESULT Resource id #515 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '77' RESULT Resource id #518 QUERY select categories_id from categories where parent_id = '77' RESULT Resource id #521 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '81' RESULT Resource id #524 QUERY select categories_id from categories where parent_id = '81' RESULT Resource id #527 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34' RESULT Resource id #530 QUERY select categories_id from categories where parent_id = '34' RESULT Resource id #533 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35' RESULT Resource id #536 QUERY select categories_id from categories where parent_id = '35' RESULT Resource id #539 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '36' RESULT Resource id #542 QUERY select categories_id from categories where parent_id = '36' RESULT Resource id #545 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57' RESULT Resource id #548 QUERY select categories_id from categories where parent_id = '57' RESULT Resource id #551 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58' RESULT Resource id #554 QUERY select categories_id from categories where parent_id = '58' RESULT Resource id #557 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59' RESULT Resource id #560 QUERY select categories_id from categories where parent_id = '59' RESULT Resource id #563 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60' RESULT Resource id #566 QUERY select categories_id from categories where parent_id = '60' RESULT Resource id #569 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71' RESULT Resource id #572 QUERY select categories_id from categories where parent_id = '71' RESULT Resource id #575 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37' RESULT Resource id #578 QUERY select categories_id from categories where parent_id = '37' RESULT Resource id #581 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '38' RESULT Resource id #584 QUERY select categories_id from categories where parent_id = '38' RESULT Resource id #587 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '39' RESULT Resource id #590 QUERY select categories_id from categories where parent_id = '39' RESULT Resource id #593 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72' RESULT Resource id #596 QUERY select categories_id from categories where parent_id = '72' RESULT Resource id #599 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73' RESULT Resource id #602 QUERY select categories_id from categories where parent_id = '73' RESULT Resource id #605 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '43' RESULT Resource id #608 QUERY select categories_id from categories where parent_id = '43' RESULT Resource id #611 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '44' RESULT Resource id #614 QUERY select categories_id from categories where parent_id = '44' RESULT Resource id #617 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '45' RESULT Resource id #620 QUERY select categories_id from categories where parent_id = '45' RESULT Resource id #623 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '78' RESULT Resource id #626 QUERY select categories_id from categories where parent_id = '78' RESULT Resource id #629 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '75' RESULT Resource id #632 QUERY select categories_id from categories where parent_id = '75' RESULT Resource id #635 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '80' RESULT Resource id #638 QUERY select categories_id from categories where parent_id = '80' RESULT Resource id #641 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '82' RESULT Resource id #644 QUERY select categories_id from categories where parent_id = '82' RESULT Resource id #647 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '83' RESULT Resource id #650 QUERY select categories_id from categories where parent_id = '83' RESULT Resource id #653 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '84' RESULT Resource id #656 QUERY select categories_id from categories where parent_id = '84' RESULT Resource id #659 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '86' RESULT Resource id #662 QUERY select categories_id from categories where parent_id = '86' RESULT Resource id #665 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #668 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '21' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #671 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '79' RESULT Resource id #674 QUERY select categories_id from categories where parent_id = '79' RESULT Resource id #677 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #680 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '82' RESULT Resource id #683 QUERY select categories_id from categories where parent_id = '82' RESULT Resource id #686 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #689 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '86' RESULT Resource id #692 QUERY select categories_id from categories where parent_id = '86' RESULT Resource id #695 QUERY select count(*) as count from categories where parent_id = '86' RESULT Resource id #698 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '30' RESULT Resource id #701 QUERY select categories_id from categories where parent_id = '30' RESULT Resource id #704 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #707 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34' RESULT Resource id #710 QUERY select categories_id from categories where parent_id = '34' RESULT Resource id #713 QUERY select count(*) as count from categories where parent_id = '34' RESULT Resource id #716 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31' RESULT Resource id #719 QUERY select categories_id from categories where parent_id = '31' RESULT Resource id #722 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #725 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '32' RESULT Resource id #728 QUERY select categories_id from categories where parent_id = '32' RESULT Resource id #731 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #734 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33' RESULT Resource id #737 QUERY select categories_id from categories where parent_id = '33' RESULT Resource id #740 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46' RESULT Resource id #743 QUERY select categories_id from categories where parent_id = '46' RESULT Resource id #746 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '47' RESULT Resource id #749 QUERY select categories_id from categories where parent_id = '47' RESULT Resource id #752 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '48' RESULT Resource id #755 QUERY select categories_id from categories where parent_id = '48' RESULT Resource id #758 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49' RESULT Resource id #761 QUERY select categories_id from categories where parent_id = '49' RESULT Resource id #764 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50' RESULT Resource id #767 QUERY select categories_id from categories where parent_id = '50' RESULT Resource id #770 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51' RESULT Resource id #773 QUERY select categories_id from categories where parent_id = '51' RESULT Resource id #776 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52' RESULT Resource id #779 QUERY select categories_id from categories where parent_id = '52' RESULT Resource id #782 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53' RESULT Resource id #785 QUERY select categories_id from categories where parent_id = '53' RESULT Resource id #788 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54' RESULT Resource id #791 QUERY select categories_id from categories where parent_id = '54' RESULT Resource id #794 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '55' RESULT Resource id #797 QUERY select categories_id from categories where parent_id = '55' RESULT Resource id #800 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '56' RESULT Resource id #803 QUERY select categories_id from categories where parent_id = '56' RESULT Resource id #806 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '77' RESULT Resource id #809 QUERY select categories_id from categories where parent_id = '77' RESULT Resource id #812 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '81' RESULT Resource id #815 QUERY select categories_id from categories where parent_id = '81' RESULT Resource id #818 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #821 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '33' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #824 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46' RESULT Resource id #827 QUERY select categories_id from categories where parent_id = '46' RESULT Resource id #830 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #833 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '47' RESULT Resource id #836 QUERY select categories_id from categories where parent_id = '47' RESULT Resource id #839 QUERY select count(*) as count from categories where parent_id = '47' RESULT Resource id #842 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '81' RESULT Resource id #845 QUERY select categories_id from categories where parent_id = '81' RESULT Resource id #848 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #851 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '48' RESULT Resource id #854 QUERY select categories_id from categories where parent_id = '48' RESULT Resource id #857 QUERY select count(*) as count from categories where parent_id = '48' RESULT Resource id #860 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49' RESULT Resource id #863 QUERY select categories_id from categories where parent_id = '49' RESULT Resource id #866 QUERY select count(*) as count from categories where parent_id = '49' RESULT Resource id #869 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50' RESULT Resource id #872 QUERY select categories_id from categories where parent_id = '50' RESULT Resource id #875 QUERY select count(*) as count from categories where parent_id = '50' RESULT Resource id #878 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51' RESULT Resource id #881 QUERY select categories_id from categories where parent_id = '51' RESULT Resource id #884 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #887 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52' RESULT Resource id #890 QUERY select categories_id from categories where parent_id = '52' RESULT Resource id #893 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #896 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53' RESULT Resource id #899 QUERY select categories_id from categories where parent_id = '53' RESULT Resource id #902 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #905 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54' RESULT Resource id #908 QUERY select categories_id from categories where parent_id = '54' RESULT Resource id #911 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #914 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '77' RESULT Resource id #917 QUERY select categories_id from categories where parent_id = '77' RESULT Resource id #920 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #923 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '55' RESULT Resource id #926 QUERY select categories_id from categories where parent_id = '55' RESULT Resource id #929 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #932 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '56' RESULT Resource id #935 QUERY select categories_id from categories where parent_id = '56' RESULT Resource id #938 QUERY select count(*) as count from categories where parent_id = '56' RESULT Resource id #941 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '84' RESULT Resource id #944 QUERY select categories_id from categories where parent_id = '84' RESULT Resource id #947 QUERY select count(*) as count from categories where parent_id = '84' RESULT Resource id #950 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '83' RESULT Resource id #953 QUERY select categories_id from categories where parent_id = '83' RESULT Resource id #956 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #959 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '38' RESULT Resource id #962 QUERY select categories_id from categories where parent_id = '38' RESULT Resource id #965 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #968 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35' RESULT Resource id #971 QUERY select categories_id from categories where parent_id = '35' RESULT Resource id #974 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #977 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '78' RESULT Resource id #980 QUERY select categories_id from categories where parent_id = '78' RESULT Resource id #983 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #986 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '36' RESULT Resource id #989 QUERY select categories_id from categories where parent_id = '36' RESULT Resource id #992 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57' RESULT Resource id #995 QUERY select categories_id from categories where parent_id = '57' RESULT Resource id #998 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58' RESULT Resource id #1001 QUERY select categories_id from categories where parent_id = '58' RESULT Resource id #1004 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59' RESULT Resource id #1007 QUERY select categories_id from categories where parent_id = '59' RESULT Resource id #1010 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60' RESULT Resource id #1013 QUERY select categories_id from categories where parent_id = '60' RESULT Resource id #1016 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71' RESULT Resource id #1019 QUERY select categories_id from categories where parent_id = '71' RESULT Resource id #1022 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #1025 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '36' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #1028 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57' RESULT Resource id #1031 QUERY select categories_id from categories where parent_id = '57' RESULT Resource id #1034 QUERY select count(*) as count from categories where parent_id = '57' RESULT Resource id #1037 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58' RESULT Resource id #1040 QUERY select categories_id from categories where parent_id = '58' RESULT Resource id #1043 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #1046 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59' RESULT Resource id #1049 QUERY select categories_id from categories where parent_id = '59' RESULT Resource id #1052 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #1055 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60' RESULT Resource id #1058 QUERY select categories_id from categories where parent_id = '60' RESULT Resource id #1061 QUERY select count(*) as count from categories where parent_id = '60' RESULT Resource id #1064 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71' RESULT Resource id #1067 QUERY select categories_id from categories where parent_id = '71' RESULT Resource id #1070 QUERY select count(*) as count from categories where parent_id = '71' RESULT Resource id #1073 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '80' RESULT Resource id #1076 QUERY select categories_id from categories where parent_id = '80' RESULT Resource id #1079 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #1082 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '45' RESULT Resource id #1085 QUERY select categories_id from categories where parent_id = '45' RESULT Resource id #1088 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #1091 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '39' RESULT Resource id #1094 QUERY select categories_id from categories where parent_id = '39' RESULT Resource id #1097 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72' RESULT Resource id #1100 QUERY select categories_id from categories where parent_id = '72' RESULT Resource id #1103 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73' RESULT Resource id #1106 QUERY select categories_id from categories where parent_id = '73' RESULT Resource id #1109 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #1112 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '39' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #1115 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73' RESULT Resource id #1118 QUERY select categories_id from categories where parent_id = '73' RESULT Resource id #1121 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #1124 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72' RESULT Resource id #1127 QUERY select categories_id from categories where parent_id = '72' RESULT Resource id #1130 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #1133 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '76' RESULT Resource id #1136 QUERY select categories_id from categories where parent_id = '76' RESULT Resource id #1139 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #1142 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '44' RESULT Resource id #1145 QUERY select categories_id from categories where parent_id = '44' RESULT Resource id #1148 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #1151 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37' RESULT Resource id #1154 QUERY select categories_id from categories where parent_id = '37' RESULT Resource id #1157 QUERY select count(*) as count from categories where parent_id = '37' RESULT Resource id #1160 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '75' RESULT Resource id #1163 QUERY select categories_id from categories where parent_id = '75' RESULT Resource id #1166 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #1169 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '43' RESULT Resource id #1172 QUERY select categories_id from categories where parent_id = '43' RESULT Resource id #1175 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #1178 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #1191 QUERY select count(*) as total from sessions where sesskey = '7ed791e0966a5afcee8014abb2945256' RESULT Resource id #1195 QUERY insert into sessions values ('7ed791e0966a5afcee8014abb2945256', '1291522350', 'cart|O:12:\"shoppingCart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"GBP\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:7:\"cookies\";s:1:\"1\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}') RESULT 1 05/12/2010 03:48:30 - /catalog/index.php?cookies=1 (0.104s) QUERY select value from sessions where sesskey = 'd838064725550f24a65ca202ab9655e8' and expiry > '1291520912' RESULT Resource id #16 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #20 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #26 QUERY delete from whos_online where time_last_click < '1291520012' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'd838064725550f24a65ca202ab9655e8' RESULT Resource id #33 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', 'd838064725550f24a65ca202ab9655e8', '91.211.16.126', '1291520912', '1291520912', '/catalog/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #43 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 #46 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #50 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 #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 = '1' RESULT Resource id #68 QUERY select categories_id from categories where parent_id = '1' 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 = '4' RESULT Resource id #74 QUERY select categories_id from categories where parent_id = '4' 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 = '23' RESULT Resource id #80 QUERY select categories_id from categories where parent_id = '23' 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 = '24' RESULT Resource id #86 QUERY select categories_id from categories where parent_id = '24' 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 = '25' RESULT Resource id #92 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #95 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26' RESULT Resource id #98 QUERY select categories_id from categories where parent_id = '26' RESULT Resource id #101 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '8' RESULT Resource id #104 QUERY select categories_id from categories where parent_id = '8' 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 = '62' RESULT Resource id #110 QUERY select categories_id from categories where parent_id = '62' RESULT Resource id #113 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63' RESULT Resource id #116 QUERY select categories_id from categories where parent_id = '63' 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 = '17' RESULT Resource id #122 QUERY select categories_id from categories where parent_id = '17' RESULT Resource id #125 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '64' RESULT Resource id #128 QUERY select categories_id from categories where parent_id = '64' RESULT Resource id #131 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '65' RESULT Resource id #134 QUERY select categories_id from categories where parent_id = '65' RESULT Resource id #137 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '68' RESULT Resource id #140 QUERY select categories_id from categories where parent_id = '68' 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 = '66' RESULT Resource id #146 QUERY select categories_id from categories where parent_id = '66' RESULT Resource id #149 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '67' RESULT Resource id #152 QUERY select categories_id from categories where parent_id = '67' RESULT Resource id #155 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #158 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '1' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #161 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '17' RESULT Resource id #164 QUERY select categories_id from categories where parent_id = '17' RESULT Resource id #167 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '64' RESULT Resource id #170 QUERY select categories_id from categories where parent_id = '64' 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 = '65' RESULT Resource id #176 QUERY select categories_id from categories where parent_id = '65' RESULT Resource id #179 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '68' RESULT Resource id #182 QUERY select categories_id from categories where parent_id = '68' RESULT Resource id #185 QUERY select count(*) as count from categories where parent_id = '17' RESULT Resource id #188 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '17' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name 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 = '64' RESULT Resource id #194 QUERY select categories_id from categories where parent_id = '64' RESULT Resource id #197 QUERY select count(*) as count from categories where parent_id = '64' RESULT Resource id #200 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '65' RESULT Resource id #203 QUERY select categories_id from categories where parent_id = '65' RESULT Resource id #206 QUERY select count(*) as count from categories where parent_id = '65' 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 = '68' RESULT Resource id #212 QUERY select categories_id from categories where parent_id = '68' RESULT Resource id #215 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #218 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '66' RESULT Resource id #221 QUERY select categories_id from categories where parent_id = '66' RESULT Resource id #224 QUERY select count(*) as count from categories where parent_id = '66' 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 = '67' RESULT Resource id #230 QUERY select categories_id from categories where parent_id = '67' RESULT Resource id #233 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #236 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '4' RESULT Resource id #239 QUERY select categories_id from categories where parent_id = '4' RESULT Resource id #242 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23' RESULT Resource id #245 QUERY select categories_id from categories where parent_id = '23' 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 = '24' RESULT Resource id #251 QUERY select categories_id from categories where parent_id = '24' RESULT Resource id #254 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25' RESULT Resource id #257 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #260 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26' RESULT Resource id #263 QUERY select categories_id from categories where parent_id = '26' RESULT Resource id #266 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #269 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '4' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #272 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23' RESULT Resource id #275 QUERY select categories_id from categories where parent_id = '23' RESULT Resource id #278 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #281 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24' RESULT Resource id #284 QUERY select categories_id from categories where parent_id = '24' RESULT Resource id #287 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #290 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25' RESULT Resource id #293 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #296 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #299 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26' RESULT Resource id #302 QUERY select categories_id from categories where parent_id = '26' RESULT Resource id #305 QUERY select count(*) as count from categories where parent_id = '26' RESULT Resource id #308 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '8' RESULT Resource id #311 QUERY select categories_id from categories where parent_id = '8' RESULT Resource id #314 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62' RESULT Resource id #317 QUERY select categories_id from categories where parent_id = '62' RESULT Resource id #320 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63' RESULT Resource id #323 QUERY select categories_id from categories where parent_id = '63' RESULT Resource id #326 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #329 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '8' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #332 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63' RESULT Resource id #335 QUERY select categories_id from categories where parent_id = '63' RESULT Resource id #338 QUERY select count(*) as count from categories where parent_id = '63' RESULT Resource id #341 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62' RESULT Resource id #344 QUERY select categories_id from categories where parent_id = '62' RESULT Resource id #347 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #350 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '2' RESULT Resource id #353 QUERY select categories_id from categories where parent_id = '2' RESULT Resource id #356 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22' RESULT Resource id #359 QUERY select categories_id from categories where parent_id = '22' RESULT Resource id #362 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '19' RESULT Resource id #365 QUERY select categories_id from categories where parent_id = '19' RESULT Resource id #368 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '20' RESULT Resource id #371 QUERY select categories_id from categories where parent_id = '20' RESULT Resource id #374 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #377 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '2' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #380 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22' RESULT Resource id #383 QUERY select categories_id from categories where parent_id = '22' RESULT Resource id #386 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #389 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '20' RESULT Resource id #392 QUERY select categories_id from categories where parent_id = '20' RESULT Resource id #395 QUERY select count(*) as count from categories where parent_id = '20' RESULT Resource id #398 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '19' RESULT Resource id #401 QUERY select categories_id from categories where parent_id = '19' RESULT Resource id #404 QUERY select count(*) as count from categories where parent_id = '19' RESULT Resource id #407 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '21' RESULT Resource id #410 QUERY select categories_id from categories where parent_id = '21' RESULT Resource id #413 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '79' RESULT Resource id #416 QUERY select categories_id from categories where parent_id = '79' RESULT Resource id #419 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31' RESULT Resource id #422 QUERY select categories_id from categories where parent_id = '31' RESULT Resource id #425 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '32' RESULT Resource id #428 QUERY select categories_id from categories where parent_id = '32' RESULT Resource id #431 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '30' RESULT Resource id #434 QUERY select categories_id from categories where parent_id = '30' RESULT Resource id #437 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '76' RESULT Resource id #440 QUERY select categories_id from categories where parent_id = '76' RESULT Resource id #443 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33' RESULT Resource id #446 QUERY select categories_id from categories where parent_id = '33' RESULT Resource id #449 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46' RESULT Resource id #452 QUERY select categories_id from categories where parent_id = '46' RESULT Resource id #455 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '47' RESULT Resource id #458 QUERY select categories_id from categories where parent_id = '47' RESULT Resource id #461 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '48' RESULT Resource id #464 QUERY select categories_id from categories where parent_id = '48' RESULT Resource id #467 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49' RESULT Resource id #470 QUERY select categories_id from categories where parent_id = '49' RESULT Resource id #473 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50' RESULT Resource id #476 QUERY select categories_id from categories where parent_id = '50' RESULT Resource id #479 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51' RESULT Resource id #482 QUERY select categories_id from categories where parent_id = '51' RESULT Resource id #485 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52' RESULT Resource id #488 QUERY select categories_id from categories where parent_id = '52' RESULT Resource id #491 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53' RESULT Resource id #494 QUERY select categories_id from categories where parent_id = '53' RESULT Resource id #497 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54' RESULT Resource id #500 QUERY select categories_id from categories where parent_id = '54' RESULT Resource id #503 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '55' RESULT Resource id #506 QUERY select categories_id from categories where parent_id = '55' RESULT Resource id #509 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '56' RESULT Resource id #512 QUERY select categories_id from categories where parent_id = '56' RESULT Resource id #515 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '77' RESULT Resource id #518 QUERY select categories_id from categories where parent_id = '77' RESULT Resource id #521 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '81' RESULT Resource id #524 QUERY select categories_id from categories where parent_id = '81' RESULT Resource id #527 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34' RESULT Resource id #530 QUERY select categories_id from categories where parent_id = '34' RESULT Resource id #533 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35' RESULT Resource id #536 QUERY select categories_id from categories where parent_id = '35' RESULT Resource id #539 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '36' RESULT Resource id #542 QUERY select categories_id from categories where parent_id = '36' RESULT Resource id #545 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57' RESULT Resource id #548 QUERY select categories_id from categories where parent_id = '57' RESULT Resource id #551 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58' RESULT Resource id #554 QUERY select categories_id from categories where parent_id = '58' RESULT Resource id #557 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59' RESULT Resource id #560 QUERY select categories_id from categories where parent_id = '59' RESULT Resource id #563 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60' RESULT Resource id #566 QUERY select categories_id from categories where parent_id = '60' RESULT Resource id #569 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71' RESULT Resource id #572 QUERY select categories_id from categories where parent_id = '71' RESULT Resource id #575 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37' RESULT Resource id #578 QUERY select categories_id from categories where parent_id = '37' RESULT Resource id #581 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '38' RESULT Resource id #584 QUERY select categories_id from categories where parent_id = '38' RESULT Resource id #587 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '39' RESULT Resource id #590 QUERY select categories_id from categories where parent_id = '39' RESULT Resource id #593 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72' RESULT Resource id #596 QUERY select categories_id from categories where parent_id = '72' RESULT Resource id #599 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73' RESULT Resource id #602 QUERY select categories_id from categories where parent_id = '73' RESULT Resource id #605 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '43' RESULT Resource id #608 QUERY select categories_id from categories where parent_id = '43' RESULT Resource id #611 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '44' RESULT Resource id #614 QUERY select categories_id from categories where parent_id = '44' RESULT Resource id #617 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '45' RESULT Resource id #620 QUERY select categories_id from categories where parent_id = '45' RESULT Resource id #623 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '78' RESULT Resource id #626 QUERY select categories_id from categories where parent_id = '78' RESULT Resource id #629 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '75' RESULT Resource id #632 QUERY select categories_id from categories where parent_id = '75' RESULT Resource id #635 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '80' RESULT Resource id #638 QUERY select categories_id from categories where parent_id = '80' RESULT Resource id #641 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '82' RESULT Resource id #644 QUERY select categories_id from categories where parent_id = '82' RESULT Resource id #647 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '83' RESULT Resource id #650 QUERY select categories_id from categories where parent_id = '83' RESULT Resource id #653 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '84' RESULT Resource id #656 QUERY select categories_id from categories where parent_id = '84' RESULT Resource id #659 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '86' RESULT Resource id #662 QUERY select categories_id from categories where parent_id = '86' RESULT Resource id #665 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #668 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '21' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #671 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '79' RESULT Resource id #674 QUERY select categories_id from categories where parent_id = '79' RESULT Resource id #677 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #680 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '82' RESULT Resource id #683 QUERY select categories_id from categories where parent_id = '82' RESULT Resource id #686 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #689 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '86' RESULT Resource id #692 QUERY select categories_id from categories where parent_id = '86' RESULT Resource id #695 QUERY select count(*) as count from categories where parent_id = '86' RESULT Resource id #698 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '30' RESULT Resource id #701 QUERY select categories_id from categories where parent_id = '30' RESULT Resource id #704 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #707 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34' RESULT Resource id #710 QUERY select categories_id from categories where parent_id = '34' RESULT Resource id #713 QUERY select count(*) as count from categories where parent_id = '34' RESULT Resource id #716 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31' RESULT Resource id #719 QUERY select categories_id from categories where parent_id = '31' RESULT Resource id #722 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #725 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '32' RESULT Resource id #728 QUERY select categories_id from categories where parent_id = '32' RESULT Resource id #731 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #734 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33' RESULT Resource id #737 QUERY select categories_id from categories where parent_id = '33' RESULT Resource id #740 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46' RESULT Resource id #743 QUERY select categories_id from categories where parent_id = '46' RESULT Resource id #746 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '47' RESULT Resource id #749 QUERY select categories_id from categories where parent_id = '47' RESULT Resource id #752 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '48' RESULT Resource id #755 QUERY select categories_id from categories where parent_id = '48' RESULT Resource id #758 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49' RESULT Resource id #761 QUERY select categories_id from categories where parent_id = '49' RESULT Resource id #764 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50' RESULT Resource id #767 QUERY select categories_id from categories where parent_id = '50' RESULT Resource id #770 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51' RESULT Resource id #773 QUERY select categories_id from categories where parent_id = '51' RESULT Resource id #776 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52' RESULT Resource id #779 QUERY select categories_id from categories where parent_id = '52' RESULT Resource id #782 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53' RESULT Resource id #785 QUERY select categories_id from categories where parent_id = '53' RESULT Resource id #788 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54' RESULT Resource id #791 QUERY select categories_id from categories where parent_id = '54' RESULT Resource id #794 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '55' RESULT Resource id #797 QUERY select categories_id from categories where parent_id = '55' RESULT Resource id #800 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '56' RESULT Resource id #803 QUERY select categories_id from categories where parent_id = '56' RESULT Resource id #806 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '77' RESULT Resource id #809 QUERY select categories_id from categories where parent_id = '77' RESULT Resource id #812 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '81' RESULT Resource id #815 QUERY select categories_id from categories where parent_id = '81' RESULT Resource id #818 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #821 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '33' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #824 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46' RESULT Resource id #827 QUERY select categories_id from categories where parent_id = '46' RESULT Resource id #830 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #833 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '47' RESULT Resource id #836 QUERY select categories_id from categories where parent_id = '47' RESULT Resource id #839 QUERY select count(*) as count from categories where parent_id = '47' RESULT Resource id #842 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '81' RESULT Resource id #845 QUERY select categories_id from categories where parent_id = '81' RESULT Resource id #848 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #851 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '48' RESULT Resource id #854 QUERY select categories_id from categories where parent_id = '48' RESULT Resource id #857 QUERY select count(*) as count from categories where parent_id = '48' RESULT Resource id #860 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49' RESULT Resource id #863 QUERY select categories_id from categories where parent_id = '49' RESULT Resource id #866 QUERY select count(*) as count from categories where parent_id = '49' RESULT Resource id #869 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50' RESULT Resource id #872 QUERY select categories_id from categories where parent_id = '50' RESULT Resource id #875 QUERY select count(*) as count from categories where parent_id = '50' RESULT Resource id #878 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51' RESULT Resource id #881 QUERY select categories_id from categories where parent_id = '51' RESULT Resource id #884 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #887 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52' RESULT Resource id #890 QUERY select categories_id from categories where parent_id = '52' RESULT Resource id #893 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #896 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53' RESULT Resource id #899 QUERY select categories_id from categories where parent_id = '53' RESULT Resource id #902 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #905 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54' RESULT Resource id #908 QUERY select categories_id from categories where parent_id = '54' RESULT Resource id #911 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #914 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '77' RESULT Resource id #917 QUERY select categories_id from categories where parent_id = '77' RESULT Resource id #920 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #923 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '55' RESULT Resource id #926 QUERY select categories_id from categories where parent_id = '55' RESULT Resource id #929 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #932 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '56' RESULT Resource id #935 QUERY select categories_id from categories where parent_id = '56' RESULT Resource id #938 QUERY select count(*) as count from categories where parent_id = '56' RESULT Resource id #941 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '84' RESULT Resource id #944 QUERY select categories_id from categories where parent_id = '84' RESULT Resource id #947 QUERY select count(*) as count from categories where parent_id = '84' RESULT Resource id #950 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '83' RESULT Resource id #953 QUERY select categories_id from categories where parent_id = '83' RESULT Resource id #956 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #959 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '38' RESULT Resource id #962 QUERY select categories_id from categories where parent_id = '38' RESULT Resource id #965 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #968 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35' RESULT Resource id #971 QUERY select categories_id from categories where parent_id = '35' RESULT Resource id #974 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #977 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '78' RESULT Resource id #980 QUERY select categories_id from categories where parent_id = '78' RESULT Resource id #983 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #986 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '36' RESULT Resource id #989 QUERY select categories_id from categories where parent_id = '36' RESULT Resource id #992 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57' RESULT Resource id #995 QUERY select categories_id from categories where parent_id = '57' RESULT Resource id #998 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58' RESULT Resource id #1001 QUERY select categories_id from categories where parent_id = '58' RESULT Resource id #1004 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59' RESULT Resource id #1007 QUERY select categories_id from categories where parent_id = '59' RESULT Resource id #1010 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60' RESULT Resource id #1013 QUERY select categories_id from categories where parent_id = '60' RESULT Resource id #1016 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71' RESULT Resource id #1019 QUERY select categories_id from categories where parent_id = '71' RESULT Resource id #1022 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #1025 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '36' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #1028 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57' RESULT Resource id #1031 QUERY select categories_id from categories where parent_id = '57' RESULT Resource id #1034 QUERY select count(*) as count from categories where parent_id = '57' RESULT Resource id #1037 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58' RESULT Resource id #1040 QUERY select categories_id from categories where parent_id = '58' RESULT Resource id #1043 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #1046 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59' RESULT Resource id #1049 QUERY select categories_id from categories where parent_id = '59' RESULT Resource id #1052 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #1055 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60' RESULT Resource id #1058 QUERY select categories_id from categories where parent_id = '60' RESULT Resource id #1061 QUERY select count(*) as count from categories where parent_id = '60' RESULT Resource id #1064 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71' RESULT Resource id #1067 QUERY select categories_id from categories where parent_id = '71' RESULT Resource id #1070 QUERY select count(*) as count from categories where parent_id = '71' RESULT Resource id #1073 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '80' RESULT Resource id #1076 QUERY select categories_id from categories where parent_id = '80' RESULT Resource id #1079 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #1082 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '45' RESULT Resource id #1085 QUERY select categories_id from categories where parent_id = '45' RESULT Resource id #1088 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #1091 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '39' RESULT Resource id #1094 QUERY select categories_id from categories where parent_id = '39' RESULT Resource id #1097 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72' RESULT Resource id #1100 QUERY select categories_id from categories where parent_id = '72' RESULT Resource id #1103 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73' RESULT Resource id #1106 QUERY select categories_id from categories where parent_id = '73' RESULT Resource id #1109 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #1112 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '39' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #1115 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73' RESULT Resource id #1118 QUERY select categories_id from categories where parent_id = '73' RESULT Resource id #1121 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #1124 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72' RESULT Resource id #1127 QUERY select categories_id from categories where parent_id = '72' RESULT Resource id #1130 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #1133 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '76' RESULT Resource id #1136 QUERY select categories_id from categories where parent_id = '76' RESULT Resource id #1139 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #1142 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '44' RESULT Resource id #1145 QUERY select categories_id from categories where parent_id = '44' RESULT Resource id #1148 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #1151 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37' RESULT Resource id #1154 QUERY select categories_id from categories where parent_id = '37' RESULT Resource id #1157 QUERY select count(*) as count from categories where parent_id = '37' RESULT Resource id #1160 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '75' RESULT Resource id #1163 QUERY select categories_id from categories where parent_id = '75' RESULT Resource id #1166 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #1169 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '43' RESULT Resource id #1172 QUERY select categories_id from categories where parent_id = '43' RESULT Resource id #1175 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #1178 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #1191 QUERY select count(*) as total from sessions where sesskey = 'd838064725550f24a65ca202ab9655e8' RESULT Resource id #1195 QUERY insert into sessions values ('d838064725550f24a65ca202ab9655e8', '1291522352', 'cart|O:12:\"shoppingCart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"GBP\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:7:\"cookies\";s:1:\"1\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}') RESULT 1 05/12/2010 03:48:32 - /catalog/index.php?cookies=1 (0.212s) QUERY select value from sessions where sesskey = '5e44c67d89ad782dcd064ad72cfb684f' and expiry > '1291520915' RESULT Resource id #16 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #20 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #26 QUERY delete from whos_online where time_last_click < '1291520015' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '5e44c67d89ad782dcd064ad72cfb684f' RESULT Resource id #33 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '5e44c67d89ad782dcd064ad72cfb684f', '91.211.16.126', '1291520915', '1291520915', '/catalog/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #43 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 #46 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #50 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 #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 = '1' RESULT Resource id #68 QUERY select categories_id from categories where parent_id = '1' 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 = '4' RESULT Resource id #74 QUERY select categories_id from categories where parent_id = '4' 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 = '23' RESULT Resource id #80 QUERY select categories_id from categories where parent_id = '23' 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 = '24' RESULT Resource id #86 QUERY select categories_id from categories where parent_id = '24' 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 = '25' RESULT Resource id #92 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #95 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26' RESULT Resource id #98 QUERY select categories_id from categories where parent_id = '26' RESULT Resource id #101 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '8' RESULT Resource id #104 QUERY select categories_id from categories where parent_id = '8' 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 = '62' RESULT Resource id #110 QUERY select categories_id from categories where parent_id = '62' RESULT Resource id #113 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63' RESULT Resource id #116 QUERY select categories_id from categories where parent_id = '63' 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 = '17' RESULT Resource id #122 QUERY select categories_id from categories where parent_id = '17' RESULT Resource id #125 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '64' RESULT Resource id #128 QUERY select categories_id from categories where parent_id = '64' RESULT Resource id #131 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '65' RESULT Resource id #134 QUERY select categories_id from categories where parent_id = '65' RESULT Resource id #137 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '68' RESULT Resource id #140 QUERY select categories_id from categories where parent_id = '68' 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 = '66' RESULT Resource id #146 QUERY select categories_id from categories where parent_id = '66' RESULT Resource id #149 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '67' RESULT Resource id #152 QUERY select categories_id from categories where parent_id = '67' RESULT Resource id #155 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #158 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '1' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #161 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '17' RESULT Resource id #164 QUERY select categories_id from categories where parent_id = '17' RESULT Resource id #167 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '64' RESULT Resource id #170 QUERY select categories_id from categories where parent_id = '64' 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 = '65' RESULT Resource id #176 QUERY select categories_id from categories where parent_id = '65' RESULT Resource id #179 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '68' RESULT Resource id #182 QUERY select categories_id from categories where parent_id = '68' RESULT Resource id #185 QUERY select count(*) as count from categories where parent_id = '17' RESULT Resource id #188 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '17' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name 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 = '64' RESULT Resource id #194 QUERY select categories_id from categories where parent_id = '64' RESULT Resource id #197 QUERY select count(*) as count from categories where parent_id = '64' RESULT Resource id #200 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '65' RESULT Resource id #203 QUERY select categories_id from categories where parent_id = '65' RESULT Resource id #206 QUERY select count(*) as count from categories where parent_id = '65' 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 = '68' RESULT Resource id #212 QUERY select categories_id from categories where parent_id = '68' RESULT Resource id #215 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #218 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '66' RESULT Resource id #221 QUERY select categories_id from categories where parent_id = '66' RESULT Resource id #224 QUERY select count(*) as count from categories where parent_id = '66' 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 = '67' RESULT Resource id #230 QUERY select categories_id from categories where parent_id = '67' RESULT Resource id #233 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #236 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '4' RESULT Resource id #239 QUERY select categories_id from categories where parent_id = '4' RESULT Resource id #242 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23' RESULT Resource id #245 QUERY select categories_id from categories where parent_id = '23' 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 = '24' RESULT Resource id #251 QUERY select categories_id from categories where parent_id = '24' RESULT Resource id #254 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25' RESULT Resource id #257 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #260 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26' RESULT Resource id #263 QUERY select categories_id from categories where parent_id = '26' RESULT Resource id #266 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #269 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '4' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #272 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23' RESULT Resource id #275 QUERY select categories_id from categories where parent_id = '23' RESULT Resource id #278 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #281 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24' RESULT Resource id #284 QUERY select categories_id from categories where parent_id = '24' RESULT Resource id #287 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #290 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25' RESULT Resource id #293 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #296 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #299 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26' RESULT Resource id #302 QUERY select categories_id from categories where parent_id = '26' RESULT Resource id #305 QUERY select count(*) as count from categories where parent_id = '26' RESULT Resource id #308 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '8' RESULT Resource id #311 QUERY select categories_id from categories where parent_id = '8' RESULT Resource id #314 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62' RESULT Resource id #317 QUERY select categories_id from categories where parent_id = '62' RESULT Resource id #320 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63' RESULT Resource id #323 QUERY select categories_id from categories where parent_id = '63' RESULT Resource id #326 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #329 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '8' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #332 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63' RESULT Resource id #335 QUERY select categories_id from categories where parent_id = '63' RESULT Resource id #338 QUERY select count(*) as count from categories where parent_id = '63' RESULT Resource id #341 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62' RESULT Resource id #344 QUERY select categories_id from categories where parent_id = '62' RESULT Resource id #347 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #350 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '2' RESULT Resource id #353 QUERY select categories_id from categories where parent_id = '2' RESULT Resource id #356 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22' RESULT Resource id #359 QUERY select categories_id from categories where parent_id = '22' RESULT Resource id #362 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '19' RESULT Resource id #365 QUERY select categories_id from categories where parent_id = '19' RESULT Resource id #368 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '20' RESULT Resource id #371 QUERY select categories_id from categories where parent_id = '20' RESULT Resource id #374 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #377 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '2' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #380 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22' RESULT Resource id #383 QUERY select categories_id from categories where parent_id = '22' RESULT Resource id #386 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #389 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '20' RESULT Resource id #392 QUERY select categories_id from categories where parent_id = '20' RESULT Resource id #395 QUERY select count(*) as count from categories where parent_id = '20' RESULT Resource id #398 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '19' RESULT Resource id #401 QUERY select categories_id from categories where parent_id = '19' RESULT Resource id #404 QUERY select count(*) as count from categories where parent_id = '19' RESULT Resource id #407 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '21' RESULT Resource id #410 QUERY select categories_id from categories where parent_id = '21' RESULT Resource id #413 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '79' RESULT Resource id #416 QUERY select categories_id from categories where parent_id = '79' RESULT Resource id #419 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31' RESULT Resource id #422 QUERY select categories_id from categories where parent_id = '31' RESULT Resource id #425 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '32' RESULT Resource id #428 QUERY select categories_id from categories where parent_id = '32' RESULT Resource id #431 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '30' RESULT Resource id #434 QUERY select categories_id from categories where parent_id = '30' RESULT Resource id #437 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '76' RESULT Resource id #440 QUERY select categories_id from categories where parent_id = '76' RESULT Resource id #443 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33' RESULT Resource id #446 QUERY select categories_id from categories where parent_id = '33' RESULT Resource id #449 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46' RESULT Resource id #452 QUERY select categories_id from categories where parent_id = '46' RESULT Resource id #455 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '47' RESULT Resource id #458 QUERY select categories_id from categories where parent_id = '47' RESULT Resource id #461 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '48' RESULT Resource id #464 QUERY select categories_id from categories where parent_id = '48' RESULT Resource id #467 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49' RESULT Resource id #470 QUERY select categories_id from categories where parent_id = '49' RESULT Resource id #473 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50' RESULT Resource id #476 QUERY select categories_id from categories where parent_id = '50' RESULT Resource id #479 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51' RESULT Resource id #482 QUERY select categories_id from categories where parent_id = '51' RESULT Resource id #485 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52' RESULT Resource id #488 QUERY select categories_id from categories where parent_id = '52' RESULT Resource id #491 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53' RESULT Resource id #494 QUERY select categories_id from categories where parent_id = '53' RESULT Resource id #497 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54' RESULT Resource id #500 QUERY select categories_id from categories where parent_id = '54' RESULT Resource id #503 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '55' RESULT Resource id #506 QUERY select categories_id from categories where parent_id = '55' RESULT Resource id #509 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '56' RESULT Resource id #512 QUERY select categories_id from categories where parent_id = '56' RESULT Resource id #515 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '77' RESULT Resource id #518 QUERY select categories_id from categories where parent_id = '77' RESULT Resource id #521 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '81' RESULT Resource id #524 QUERY select categories_id from categories where parent_id = '81' RESULT Resource id #527 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34' RESULT Resource id #530 QUERY select categories_id from categories where parent_id = '34' RESULT Resource id #533 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35' RESULT Resource id #536 QUERY select categories_id from categories where parent_id = '35' RESULT Resource id #539 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '36' RESULT Resource id #542 QUERY select categories_id from categories where parent_id = '36' RESULT Resource id #545 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57' RESULT Resource id #548 QUERY select categories_id from categories where parent_id = '57' RESULT Resource id #551 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58' RESULT Resource id #554 QUERY select categories_id from categories where parent_id = '58' RESULT Resource id #557 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59' RESULT Resource id #560 QUERY select categories_id from categories where parent_id = '59' RESULT Resource id #563 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60' RESULT Resource id #566 QUERY select categories_id from categories where parent_id = '60' RESULT Resource id #569 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71' RESULT Resource id #572 QUERY select categories_id from categories where parent_id = '71' RESULT Resource id #575 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37' RESULT Resource id #578 QUERY select categories_id from categories where parent_id = '37' RESULT Resource id #581 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '38' RESULT Resource id #584 QUERY select categories_id from categories where parent_id = '38' RESULT Resource id #587 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '39' RESULT Resource id #590 QUERY select categories_id from categories where parent_id = '39' RESULT Resource id #593 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72' RESULT Resource id #596 QUERY select categories_id from categories where parent_id = '72' RESULT Resource id #599 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73' RESULT Resource id #602 QUERY select categories_id from categories where parent_id = '73' RESULT Resource id #605 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '43' RESULT Resource id #608 QUERY select categories_id from categories where parent_id = '43' RESULT Resource id #611 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '44' RESULT Resource id #614 QUERY select categories_id from categories where parent_id = '44' RESULT Resource id #617 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '45' RESULT Resource id #620 QUERY select categories_id from categories where parent_id = '45' RESULT Resource id #623 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '78' RESULT Resource id #626 QUERY select categories_id from categories where parent_id = '78' RESULT Resource id #629 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '75' RESULT Resource id #632 QUERY select categories_id from categories where parent_id = '75' RESULT Resource id #635 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '80' RESULT Resource id #638 QUERY select categories_id from categories where parent_id = '80' RESULT Resource id #641 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '82' RESULT Resource id #644 QUERY select categories_id from categories where parent_id = '82' RESULT Resource id #647 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '83' RESULT Resource id #650 QUERY select categories_id from categories where parent_id = '83' RESULT Resource id #653 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '84' RESULT Resource id #656 QUERY select categories_id from categories where parent_id = '84' RESULT Resource id #659 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '86' RESULT Resource id #662 QUERY select categories_id from categories where parent_id = '86' RESULT Resource id #665 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #668 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '21' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #671 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '79' RESULT Resource id #674 QUERY select categories_id from categories where parent_id = '79' RESULT Resource id #677 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #680 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '82' RESULT Resource id #683 QUERY select categories_id from categories where parent_id = '82' RESULT Resource id #686 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #689 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '86' RESULT Resource id #692 QUERY select categories_id from categories where parent_id = '86' RESULT Resource id #695 QUERY select count(*) as count from categories where parent_id = '86' RESULT Resource id #698 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '30' RESULT Resource id #701 QUERY select categories_id from categories where parent_id = '30' RESULT Resource id #704 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #707 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34' RESULT Resource id #710 QUERY select categories_id from categories where parent_id = '34' RESULT Resource id #713 QUERY select count(*) as count from categories where parent_id = '34' RESULT Resource id #716 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31' RESULT Resource id #719 QUERY select categories_id from categories where parent_id = '31' RESULT Resource id #722 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #725 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '32' RESULT Resource id #728 QUERY select categories_id from categories where parent_id = '32' RESULT Resource id #731 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #734 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33' RESULT Resource id #737 QUERY select categories_id from categories where parent_id = '33' RESULT Resource id #740 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46' RESULT Resource id #743 QUERY select categories_id from categories where parent_id = '46' RESULT Resource id #746 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '47' RESULT Resource id #749 QUERY select categories_id from categories where parent_id = '47' RESULT Resource id #752 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '48' RESULT Resource id #755 QUERY select categories_id from categories where parent_id = '48' RESULT Resource id #758 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49' RESULT Resource id #761 QUERY select categories_id from categories where parent_id = '49' RESULT Resource id #764 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50' RESULT Resource id #767 QUERY select categories_id from categories where parent_id = '50' RESULT Resource id #770 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51' RESULT Resource id #773 QUERY select categories_id from categories where parent_id = '51' RESULT Resource id #776 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52' RESULT Resource id #779 QUERY select categories_id from categories where parent_id = '52' RESULT Resource id #782 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53' RESULT Resource id #785 QUERY select categories_id from categories where parent_id = '53' RESULT Resource id #788 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54' RESULT Resource id #791 QUERY select categories_id from categories where parent_id = '54' RESULT Resource id #794 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '55' RESULT Resource id #797 QUERY select categories_id from categories where parent_id = '55' RESULT Resource id #800 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '56' RESULT Resource id #803 QUERY select categories_id from categories where parent_id = '56' RESULT Resource id #806 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '77' RESULT Resource id #809 QUERY select categories_id from categories where parent_id = '77' RESULT Resource id #812 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '81' RESULT Resource id #815 QUERY select categories_id from categories where parent_id = '81' RESULT Resource id #818 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #821 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '33' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #824 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46' RESULT Resource id #827 QUERY select categories_id from categories where parent_id = '46' RESULT Resource id #830 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #833 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '47' RESULT Resource id #836 QUERY select categories_id from categories where parent_id = '47' RESULT Resource id #839 QUERY select count(*) as count from categories where parent_id = '47' RESULT Resource id #842 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '81' RESULT Resource id #845 QUERY select categories_id from categories where parent_id = '81' RESULT Resource id #848 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #851 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '48' RESULT Resource id #854 QUERY select categories_id from categories where parent_id = '48' RESULT Resource id #857 QUERY select count(*) as count from categories where parent_id = '48' RESULT Resource id #860 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49' RESULT Resource id #863 QUERY select categories_id from categories where parent_id = '49' RESULT Resource id #866 QUERY select count(*) as count from categories where parent_id = '49' RESULT Resource id #869 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50' RESULT Resource id #872 QUERY select categories_id from categories where parent_id = '50' RESULT Resource id #875 QUERY select count(*) as count from categories where parent_id = '50' RESULT Resource id #878 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51' RESULT Resource id #881 QUERY select categories_id from categories where parent_id = '51' RESULT Resource id #884 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #887 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52' RESULT Resource id #890 QUERY select categories_id from categories where parent_id = '52' RESULT Resource id #893 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #896 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53' RESULT Resource id #899 QUERY select categories_id from categories where parent_id = '53' RESULT Resource id #902 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #905 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54' RESULT Resource id #908 QUERY select categories_id from categories where parent_id = '54' RESULT Resource id #911 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #914 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '77' RESULT Resource id #917 QUERY select categories_id from categories where parent_id = '77' RESULT Resource id #920 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #923 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '55' RESULT Resource id #926 QUERY select categories_id from categories where parent_id = '55' RESULT Resource id #929 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #932 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '56' RESULT Resource id #935 QUERY select categories_id from categories where parent_id = '56' RESULT Resource id #938 QUERY select count(*) as count from categories where parent_id = '56' RESULT Resource id #941 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '84' RESULT Resource id #944 QUERY select categories_id from categories where parent_id = '84' RESULT Resource id #947 QUERY select count(*) as count from categories where parent_id = '84' RESULT Resource id #950 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '83' RESULT Resource id #953 QUERY select categories_id from categories where parent_id = '83' RESULT Resource id #956 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #959 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '38' RESULT Resource id #962 QUERY select categories_id from categories where parent_id = '38' RESULT Resource id #965 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #968 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35' RESULT Resource id #971 QUERY select categories_id from categories where parent_id = '35' RESULT Resource id #974 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #977 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '78' RESULT Resource id #980 QUERY select categories_id from categories where parent_id = '78' RESULT Resource id #983 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #986 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '36' RESULT Resource id #989 QUERY select categories_id from categories where parent_id = '36' RESULT Resource id #992 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57' RESULT Resource id #995 QUERY select categories_id from categories where parent_id = '57' RESULT Resource id #998 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58' RESULT Resource id #1001 QUERY select categories_id from categories where parent_id = '58' RESULT Resource id #1004 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59' RESULT Resource id #1007 QUERY select categories_id from categories where parent_id = '59' RESULT Resource id #1010 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60' RESULT Resource id #1013 QUERY select categories_id from categories where parent_id = '60' RESULT Resource id #1016 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71' RESULT Resource id #1019 QUERY select categories_id from categories where parent_id = '71' RESULT Resource id #1022 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #1025 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '36' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #1028 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57' RESULT Resource id #1031 QUERY select categories_id from categories where parent_id = '57' RESULT Resource id #1034 QUERY select count(*) as count from categories where parent_id = '57' RESULT Resource id #1037 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58' RESULT Resource id #1040 QUERY select categories_id from categories where parent_id = '58' RESULT Resource id #1043 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #1046 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59' RESULT Resource id #1049 QUERY select categories_id from categories where parent_id = '59' RESULT Resource id #1052 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #1055 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60' RESULT Resource id #1058 QUERY select categories_id from categories where parent_id = '60' RESULT Resource id #1061 QUERY select count(*) as count from categories where parent_id = '60' RESULT Resource id #1064 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71' RESULT Resource id #1067 QUERY select categories_id from categories where parent_id = '71' RESULT Resource id #1070 QUERY select count(*) as count from categories where parent_id = '71' RESULT Resource id #1073 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '80' RESULT Resource id #1076 QUERY select categories_id from categories where parent_id = '80' RESULT Resource id #1079 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #1082 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '45' RESULT Resource id #1085 QUERY select categories_id from categories where parent_id = '45' RESULT Resource id #1088 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #1091 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '39' RESULT Resource id #1094 QUERY select categories_id from categories where parent_id = '39' RESULT Resource id #1097 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72' RESULT Resource id #1100 QUERY select categories_id from categories where parent_id = '72' RESULT Resource id #1103 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73' RESULT Resource id #1106 QUERY select categories_id from categories where parent_id = '73' RESULT Resource id #1109 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #1112 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '39' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #1115 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73' RESULT Resource id #1118 QUERY select categories_id from categories where parent_id = '73' RESULT Resource id #1121 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #1124 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72' RESULT Resource id #1127 QUERY select categories_id from categories where parent_id = '72' RESULT Resource id #1130 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #1133 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '76' RESULT Resource id #1136 QUERY select categories_id from categories where parent_id = '76' RESULT Resource id #1139 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #1142 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '44' RESULT Resource id #1145 QUERY select categories_id from categories where parent_id = '44' RESULT Resource id #1148 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #1151 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37' RESULT Resource id #1154 QUERY select categories_id from categories where parent_id = '37' RESULT Resource id #1157 QUERY select count(*) as count from categories where parent_id = '37' RESULT Resource id #1160 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '75' RESULT Resource id #1163 QUERY select categories_id from categories where parent_id = '75' RESULT Resource id #1166 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #1169 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '43' RESULT Resource id #1172 QUERY select categories_id from categories where parent_id = '43' RESULT Resource id #1175 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #1178 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #1191 QUERY select count(*) as total from sessions where sesskey = '5e44c67d89ad782dcd064ad72cfb684f' RESULT Resource id #1195 QUERY insert into sessions values ('5e44c67d89ad782dcd064ad72cfb684f', '1291522355', 'cart|O:12:\"shoppingCart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"GBP\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:7:\"cookies\";s:1:\"1\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}') RESULT 1 05/12/2010 03:48:35 - /catalog/index.php?cookies=1 (0.098s) QUERY select value from sessions where sesskey = 'd87ce259c965c1ef2162f88f1d6ba49b' and expiry > '1291520918' RESULT Resource id #16 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #20 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #26 QUERY delete from whos_online where time_last_click < '1291520018' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'd87ce259c965c1ef2162f88f1d6ba49b' RESULT Resource id #33 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', 'd87ce259c965c1ef2162f88f1d6ba49b', '91.211.16.126', '1291520918', '1291520918', '/catalog/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #43 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 #46 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #50 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 #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 = '1' RESULT Resource id #68 QUERY select categories_id from categories where parent_id = '1' 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 = '4' RESULT Resource id #74 QUERY select categories_id from categories where parent_id = '4' 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 = '23' RESULT Resource id #80 QUERY select categories_id from categories where parent_id = '23' 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 = '24' RESULT Resource id #86 QUERY select categories_id from categories where parent_id = '24' 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 = '25' RESULT Resource id #92 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #95 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26' RESULT Resource id #98 QUERY select categories_id from categories where parent_id = '26' RESULT Resource id #101 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '8' RESULT Resource id #104 QUERY select categories_id from categories where parent_id = '8' 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 = '62' RESULT Resource id #110 QUERY select categories_id from categories where parent_id = '62' RESULT Resource id #113 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63' RESULT Resource id #116 QUERY select categories_id from categories where parent_id = '63' 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 = '17' RESULT Resource id #122 QUERY select categories_id from categories where parent_id = '17' RESULT Resource id #125 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '64' RESULT Resource id #128 QUERY select categories_id from categories where parent_id = '64' RESULT Resource id #131 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '65' RESULT Resource id #134 QUERY select categories_id from categories where parent_id = '65' RESULT Resource id #137 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '68' RESULT Resource id #140 QUERY select categories_id from categories where parent_id = '68' 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 = '66' RESULT Resource id #146 QUERY select categories_id from categories where parent_id = '66' RESULT Resource id #149 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '67' RESULT Resource id #152 QUERY select categories_id from categories where parent_id = '67' RESULT Resource id #155 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #158 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '1' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #161 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '17' RESULT Resource id #164 QUERY select categories_id from categories where parent_id = '17' RESULT Resource id #167 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '64' RESULT Resource id #170 QUERY select categories_id from categories where parent_id = '64' 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 = '65' RESULT Resource id #176 QUERY select categories_id from categories where parent_id = '65' RESULT Resource id #179 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '68' RESULT Resource id #182 QUERY select categories_id from categories where parent_id = '68' RESULT Resource id #185 QUERY select count(*) as count from categories where parent_id = '17' RESULT Resource id #188 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '17' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name 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 = '64' RESULT Resource id #194 QUERY select categories_id from categories where parent_id = '64' RESULT Resource id #197 QUERY select count(*) as count from categories where parent_id = '64' RESULT Resource id #200 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '65' RESULT Resource id #203 QUERY select categories_id from categories where parent_id = '65' RESULT Resource id #206 QUERY select count(*) as count from categories where parent_id = '65' 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 = '68' RESULT Resource id #212 QUERY select categories_id from categories where parent_id = '68' RESULT Resource id #215 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #218 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '66' RESULT Resource id #221 QUERY select categories_id from categories where parent_id = '66' RESULT Resource id #224 QUERY select count(*) as count from categories where parent_id = '66' 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 = '67' RESULT Resource id #230 QUERY select categories_id from categories where parent_id = '67' RESULT Resource id #233 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #236 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '4' RESULT Resource id #239 QUERY select categories_id from categories where parent_id = '4' RESULT Resource id #242 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23' RESULT Resource id #245 QUERY select categories_id from categories where parent_id = '23' 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 = '24' RESULT Resource id #251 QUERY select categories_id from categories where parent_id = '24' RESULT Resource id #254 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25' RESULT Resource id #257 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #260 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26' RESULT Resource id #263 QUERY select categories_id from categories where parent_id = '26' RESULT Resource id #266 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #269 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '4' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #272 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23' RESULT Resource id #275 QUERY select categories_id from categories where parent_id = '23' RESULT Resource id #278 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #281 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24' RESULT Resource id #284 QUERY select categories_id from categories where parent_id = '24' RESULT Resource id #287 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #290 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25' RESULT Resource id #293 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #296 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #299 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26' RESULT Resource id #302 QUERY select categories_id from categories where parent_id = '26' RESULT Resource id #305 QUERY select count(*) as count from categories where parent_id = '26' RESULT Resource id #308 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '8' RESULT Resource id #311 QUERY select categories_id from categories where parent_id = '8' RESULT Resource id #314 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62' RESULT Resource id #317 QUERY select categories_id from categories where parent_id = '62' RESULT Resource id #320 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63' RESULT Resource id #323 QUERY select categories_id from categories where parent_id = '63' RESULT Resource id #326 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #329 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '8' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #332 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63' RESULT Resource id #335 QUERY select categories_id from categories where parent_id = '63' RESULT Resource id #338 QUERY select count(*) as count from categories where parent_id = '63' RESULT Resource id #341 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62' RESULT Resource id #344 QUERY select categories_id from categories where parent_id = '62' RESULT Resource id #347 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #350 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '2' RESULT Resource id #353 QUERY select categories_id from categories where parent_id = '2' RESULT Resource id #356 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22' RESULT Resource id #359 QUERY select categories_id from categories where parent_id = '22' RESULT Resource id #362 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '19' RESULT Resource id #365 QUERY select categories_id from categories where parent_id = '19' RESULT Resource id #368 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '20' RESULT Resource id #371 QUERY select categories_id from categories where parent_id = '20' RESULT Resource id #374 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #377 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '2' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #380 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22' RESULT Resource id #383 QUERY select categories_id from categories where parent_id = '22' RESULT Resource id #386 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #389 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '20' RESULT Resource id #392 QUERY select categories_id from categories where parent_id = '20' RESULT Resource id #395 QUERY select count(*) as count from categories where parent_id = '20' RESULT Resource id #398 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '19' RESULT Resource id #401 QUERY select categories_id from categories where parent_id = '19' RESULT Resource id #404 QUERY select count(*) as count from categories where parent_id = '19' RESULT Resource id #407 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '21' RESULT Resource id #410 QUERY select categories_id from categories where parent_id = '21' RESULT Resource id #413 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '79' RESULT Resource id #416 QUERY select categories_id from categories where parent_id = '79' RESULT Resource id #419 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31' RESULT Resource id #422 QUERY select categories_id from categories where parent_id = '31' RESULT Resource id #425 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '32' RESULT Resource id #428 QUERY select categories_id from categories where parent_id = '32' RESULT Resource id #431 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '30' RESULT Resource id #434 QUERY select categories_id from categories where parent_id = '30' RESULT Resource id #437 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '76' RESULT Resource id #440 QUERY select categories_id from categories where parent_id = '76' RESULT Resource id #443 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33' RESULT Resource id #446 QUERY select categories_id from categories where parent_id = '33' RESULT Resource id #449 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46' RESULT Resource id #452 QUERY select categories_id from categories where parent_id = '46' RESULT Resource id #455 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '47' RESULT Resource id #458 QUERY select categories_id from categories where parent_id = '47' RESULT Resource id #461 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '48' RESULT Resource id #464 QUERY select categories_id from categories where parent_id = '48' RESULT Resource id #467 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49' RESULT Resource id #470 QUERY select categories_id from categories where parent_id = '49' RESULT Resource id #473 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50' RESULT Resource id #476 QUERY select categories_id from categories where parent_id = '50' RESULT Resource id #479 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51' RESULT Resource id #482 QUERY select categories_id from categories where parent_id = '51' RESULT Resource id #485 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52' RESULT Resource id #488 QUERY select categories_id from categories where parent_id = '52' RESULT Resource id #491 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53' RESULT Resource id #494 QUERY select categories_id from categories where parent_id = '53' RESULT Resource id #497 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54' RESULT Resource id #500 QUERY select categories_id from categories where parent_id = '54' RESULT Resource id #503 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '55' RESULT Resource id #506 QUERY select categories_id from categories where parent_id = '55' RESULT Resource id #509 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '56' RESULT Resource id #512 QUERY select categories_id from categories where parent_id = '56' RESULT Resource id #515 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '77' RESULT Resource id #518 QUERY select categories_id from categories where parent_id = '77' RESULT Resource id #521 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '81' RESULT Resource id #524 QUERY select categories_id from categories where parent_id = '81' RESULT Resource id #527 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34' RESULT Resource id #530 QUERY select categories_id from categories where parent_id = '34' RESULT Resource id #533 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35' RESULT Resource id #536 QUERY select categories_id from categories where parent_id = '35' RESULT Resource id #539 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '36' RESULT Resource id #542 QUERY select categories_id from categories where parent_id = '36' RESULT Resource id #545 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57' RESULT Resource id #548 QUERY select categories_id from categories where parent_id = '57' RESULT Resource id #551 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58' RESULT Resource id #554 QUERY select categories_id from categories where parent_id = '58' RESULT Resource id #557 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59' RESULT Resource id #560 QUERY select categories_id from categories where parent_id = '59' RESULT Resource id #563 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60' RESULT Resource id #566 QUERY select categories_id from categories where parent_id = '60' RESULT Resource id #569 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71' RESULT Resource id #572 QUERY select categories_id from categories where parent_id = '71' RESULT Resource id #575 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37' RESULT Resource id #578 QUERY select categories_id from categories where parent_id = '37' RESULT Resource id #581 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '38' RESULT Resource id #584 QUERY select categories_id from categories where parent_id = '38' RESULT Resource id #587 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '39' RESULT Resource id #590 QUERY select categories_id from categories where parent_id = '39' RESULT Resource id #593 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72' RESULT Resource id #596 QUERY select categories_id from categories where parent_id = '72' RESULT Resource id #599 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73' RESULT Resource id #602 QUERY select categories_id from categories where parent_id = '73' RESULT Resource id #605 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '43' RESULT Resource id #608 QUERY select categories_id from categories where parent_id = '43' RESULT Resource id #611 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '44' RESULT Resource id #614 QUERY select categories_id from categories where parent_id = '44' RESULT Resource id #617 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '45' RESULT Resource id #620 QUERY select categories_id from categories where parent_id = '45' RESULT Resource id #623 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '78' RESULT Resource id #626 QUERY select categories_id from categories where parent_id = '78' RESULT Resource id #629 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '75' RESULT Resource id #632 QUERY select categories_id from categories where parent_id = '75' RESULT Resource id #635 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '80' RESULT Resource id #638 QUERY select categories_id from categories where parent_id = '80' RESULT Resource id #641 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '82' RESULT Resource id #644 QUERY select categories_id from categories where parent_id = '82' RESULT Resource id #647 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '83' RESULT Resource id #650 QUERY select categories_id from categories where parent_id = '83' RESULT Resource id #653 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '84' RESULT Resource id #656 QUERY select categories_id from categories where parent_id = '84' RESULT Resource id #659 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '86' RESULT Resource id #662 QUERY select categories_id from categories where parent_id = '86' RESULT Resource id #665 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #668 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '21' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #671 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '79' RESULT Resource id #674 QUERY select categories_id from categories where parent_id = '79' RESULT Resource id #677 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #680 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '82' RESULT Resource id #683 QUERY select categories_id from categories where parent_id = '82' RESULT Resource id #686 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #689 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '86' RESULT Resource id #692 QUERY select categories_id from categories where parent_id = '86' RESULT Resource id #695 QUERY select count(*) as count from categories where parent_id = '86' RESULT Resource id #698 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '30' RESULT Resource id #701 QUERY select categories_id from categories where parent_id = '30' RESULT Resource id #704 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #707 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34' RESULT Resource id #710 QUERY select categories_id from categories where parent_id = '34' RESULT Resource id #713 QUERY select count(*) as count from categories where parent_id = '34' RESULT Resource id #716 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31' RESULT Resource id #719 QUERY select categories_id from categories where parent_id = '31' RESULT Resource id #722 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #725 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '32' RESULT Resource id #728 QUERY select categories_id from categories where parent_id = '32' RESULT Resource id #731 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #734 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33' RESULT Resource id #737 QUERY select categories_id from categories where parent_id = '33' RESULT Resource id #740 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46' RESULT Resource id #743 QUERY select categories_id from categories where parent_id = '46' RESULT Resource id #746 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '47' RESULT Resource id #749 QUERY select categories_id from categories where parent_id = '47' RESULT Resource id #752 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '48' RESULT Resource id #755 QUERY select categories_id from categories where parent_id = '48' RESULT Resource id #758 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49' RESULT Resource id #761 QUERY select categories_id from categories where parent_id = '49' RESULT Resource id #764 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50' RESULT Resource id #767 QUERY select categories_id from categories where parent_id = '50' RESULT Resource id #770 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51' RESULT Resource id #773 QUERY select categories_id from categories where parent_id = '51' RESULT Resource id #776 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52' RESULT Resource id #779 QUERY select categories_id from categories where parent_id = '52' RESULT Resource id #782 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53' RESULT Resource id #785 QUERY select categories_id from categories where parent_id = '53' RESULT Resource id #788 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54' RESULT Resource id #791 QUERY select categories_id from categories where parent_id = '54' RESULT Resource id #794 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '55' RESULT Resource id #797 QUERY select categories_id from categories where parent_id = '55' RESULT Resource id #800 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '56' RESULT Resource id #803 QUERY select categories_id from categories where parent_id = '56' RESULT Resource id #806 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '77' RESULT Resource id #809 QUERY select categories_id from categories where parent_id = '77' RESULT Resource id #812 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '81' RESULT Resource id #815 QUERY select categories_id from categories where parent_id = '81' RESULT Resource id #818 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #821 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '33' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #824 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46' RESULT Resource id #827 QUERY select categories_id from categories where parent_id = '46' RESULT Resource id #830 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #833 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '47' RESULT Resource id #836 QUERY select categories_id from categories where parent_id = '47' RESULT Resource id #839 QUERY select count(*) as count from categories where parent_id = '47' RESULT Resource id #842 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '81' RESULT Resource id #845 QUERY select categories_id from categories where parent_id = '81' RESULT Resource id #848 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #851 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '48' RESULT Resource id #854 QUERY select categories_id from categories where parent_id = '48' RESULT Resource id #857 QUERY select count(*) as count from categories where parent_id = '48' RESULT Resource id #860 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49' RESULT Resource id #863 QUERY select categories_id from categories where parent_id = '49' RESULT Resource id #866 QUERY select count(*) as count from categories where parent_id = '49' RESULT Resource id #869 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50' RESULT Resource id #872 QUERY select categories_id from categories where parent_id = '50' RESULT Resource id #875 QUERY select count(*) as count from categories where parent_id = '50' RESULT Resource id #878 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51' RESULT Resource id #881 QUERY select categories_id from categories where parent_id = '51' RESULT Resource id #884 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #887 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52' RESULT Resource id #890 QUERY select categories_id from categories where parent_id = '52' RESULT Resource id #893 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #896 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53' RESULT Resource id #899 QUERY select categories_id from categories where parent_id = '53' RESULT Resource id #902 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #905 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54' RESULT Resource id #908 QUERY select categories_id from categories where parent_id = '54' RESULT Resource id #911 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #914 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '77' RESULT Resource id #917 QUERY select categories_id from categories where parent_id = '77' RESULT Resource id #920 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #923 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '55' RESULT Resource id #926 QUERY select categories_id from categories where parent_id = '55' RESULT Resource id #929 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #932 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '56' RESULT Resource id #935 QUERY select categories_id from categories where parent_id = '56' RESULT Resource id #938 QUERY select count(*) as count from categories where parent_id = '56' RESULT Resource id #941 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '84' RESULT Resource id #944 QUERY select categories_id from categories where parent_id = '84' RESULT Resource id #947 QUERY select count(*) as count from categories where parent_id = '84' RESULT Resource id #950 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '83' RESULT Resource id #953 QUERY select categories_id from categories where parent_id = '83' RESULT Resource id #956 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #959 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '38' RESULT Resource id #962 QUERY select categories_id from categories where parent_id = '38' RESULT Resource id #965 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #968 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35' RESULT Resource id #971 QUERY select categories_id from categories where parent_id = '35' RESULT Resource id #974 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #977 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '78' RESULT Resource id #980 QUERY select categories_id from categories where parent_id = '78' RESULT Resource id #983 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #986 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '36' RESULT Resource id #989 QUERY select categories_id from categories where parent_id = '36' RESULT Resource id #992 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57' RESULT Resource id #995 QUERY select categories_id from categories where parent_id = '57' RESULT Resource id #998 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58' RESULT Resource id #1001 QUERY select categories_id from categories where parent_id = '58' RESULT Resource id #1004 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59' RESULT Resource id #1007 QUERY select categories_id from categories where parent_id = '59' RESULT Resource id #1010 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60' RESULT Resource id #1013 QUERY select categories_id from categories where parent_id = '60' RESULT Resource id #1016 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71' RESULT Resource id #1019 QUERY select categories_id from categories where parent_id = '71' RESULT Resource id #1022 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #1025 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '36' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #1028 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57' RESULT Resource id #1031 QUERY select categories_id from categories where parent_id = '57' RESULT Resource id #1034 QUERY select count(*) as count from categories where parent_id = '57' RESULT Resource id #1037 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58' RESULT Resource id #1040 QUERY select categories_id from categories where parent_id = '58' RESULT Resource id #1043 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #1046 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59' RESULT Resource id #1049 QUERY select categories_id from categories where parent_id = '59' RESULT Resource id #1052 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #1055 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60' RESULT Resource id #1058 QUERY select categories_id from categories where parent_id = '60' RESULT Resource id #1061 QUERY select count(*) as count from categories where parent_id = '60' RESULT Resource id #1064 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71' RESULT Resource id #1067 QUERY select categories_id from categories where parent_id = '71' RESULT Resource id #1070 QUERY select count(*) as count from categories where parent_id = '71' RESULT Resource id #1073 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '80' RESULT Resource id #1076 QUERY select categories_id from categories where parent_id = '80' RESULT Resource id #1079 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #1082 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '45' RESULT Resource id #1085 QUERY select categories_id from categories where parent_id = '45' RESULT Resource id #1088 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #1091 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '39' RESULT Resource id #1094 QUERY select categories_id from categories where parent_id = '39' RESULT Resource id #1097 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72' RESULT Resource id #1100 QUERY select categories_id from categories where parent_id = '72' RESULT Resource id #1103 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73' RESULT Resource id #1106 QUERY select categories_id from categories where parent_id = '73' RESULT Resource id #1109 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #1112 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '39' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #1115 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73' RESULT Resource id #1118 QUERY select categories_id from categories where parent_id = '73' RESULT Resource id #1121 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #1124 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72' RESULT Resource id #1127 QUERY select categories_id from categories where parent_id = '72' RESULT Resource id #1130 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #1133 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '76' RESULT Resource id #1136 QUERY select categories_id from categories where parent_id = '76' RESULT Resource id #1139 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #1142 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '44' RESULT Resource id #1145 QUERY select categories_id from categories where parent_id = '44' RESULT Resource id #1148 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #1151 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37' RESULT Resource id #1154 QUERY select categories_id from categories where parent_id = '37' RESULT Resource id #1157 QUERY select count(*) as count from categories where parent_id = '37' RESULT Resource id #1160 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '75' RESULT Resource id #1163 QUERY select categories_id from categories where parent_id = '75' RESULT Resource id #1166 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #1169 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '43' RESULT Resource id #1172 QUERY select categories_id from categories where parent_id = '43' RESULT Resource id #1175 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #1178 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #1191 QUERY select count(*) as total from sessions where sesskey = 'd87ce259c965c1ef2162f88f1d6ba49b' RESULT Resource id #1195 QUERY insert into sessions values ('d87ce259c965c1ef2162f88f1d6ba49b', '1291522358', 'cart|O:12:\"shoppingCart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"GBP\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:7:\"cookies\";s:1:\"1\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}') RESULT 1 05/12/2010 03:48:38 - /catalog/index.php?cookies=1 (0.106s) QUERY select value from sessions where sesskey = '532c9675552d0c28f821b9b21152b340' and expiry > '1291520922' RESULT Resource id #16 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #20 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #26 QUERY delete from whos_online where time_last_click < '1291520022' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '532c9675552d0c28f821b9b21152b340' RESULT Resource id #33 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', '532c9675552d0c28f821b9b21152b340', '91.211.16.126', '1291520922', '1291520922', '/catalog/index.php?cookies=1') RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #43 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 #46 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #50 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 #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 = '1' RESULT Resource id #68 QUERY select categories_id from categories where parent_id = '1' 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 = '4' RESULT Resource id #74 QUERY select categories_id from categories where parent_id = '4' 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 = '23' RESULT Resource id #80 QUERY select categories_id from categories where parent_id = '23' 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 = '24' RESULT Resource id #86 QUERY select categories_id from categories where parent_id = '24' 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 = '25' RESULT Resource id #92 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #95 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26' RESULT Resource id #98 QUERY select categories_id from categories where parent_id = '26' RESULT Resource id #101 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '8' RESULT Resource id #104 QUERY select categories_id from categories where parent_id = '8' 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 = '62' RESULT Resource id #110 QUERY select categories_id from categories where parent_id = '62' RESULT Resource id #113 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63' RESULT Resource id #116 QUERY select categories_id from categories where parent_id = '63' 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 = '17' RESULT Resource id #122 QUERY select categories_id from categories where parent_id = '17' RESULT Resource id #125 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '64' RESULT Resource id #128 QUERY select categories_id from categories where parent_id = '64' RESULT Resource id #131 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '65' RESULT Resource id #134 QUERY select categories_id from categories where parent_id = '65' RESULT Resource id #137 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '68' RESULT Resource id #140 QUERY select categories_id from categories where parent_id = '68' 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 = '66' RESULT Resource id #146 QUERY select categories_id from categories where parent_id = '66' RESULT Resource id #149 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '67' RESULT Resource id #152 QUERY select categories_id from categories where parent_id = '67' RESULT Resource id #155 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #158 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '1' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #161 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '17' RESULT Resource id #164 QUERY select categories_id from categories where parent_id = '17' RESULT Resource id #167 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '64' RESULT Resource id #170 QUERY select categories_id from categories where parent_id = '64' 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 = '65' RESULT Resource id #176 QUERY select categories_id from categories where parent_id = '65' RESULT Resource id #179 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '68' RESULT Resource id #182 QUERY select categories_id from categories where parent_id = '68' RESULT Resource id #185 QUERY select count(*) as count from categories where parent_id = '17' RESULT Resource id #188 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '17' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name 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 = '64' RESULT Resource id #194 QUERY select categories_id from categories where parent_id = '64' RESULT Resource id #197 QUERY select count(*) as count from categories where parent_id = '64' RESULT Resource id #200 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '65' RESULT Resource id #203 QUERY select categories_id from categories where parent_id = '65' RESULT Resource id #206 QUERY select count(*) as count from categories where parent_id = '65' 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 = '68' RESULT Resource id #212 QUERY select categories_id from categories where parent_id = '68' RESULT Resource id #215 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #218 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '66' RESULT Resource id #221 QUERY select categories_id from categories where parent_id = '66' RESULT Resource id #224 QUERY select count(*) as count from categories where parent_id = '66' 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 = '67' RESULT Resource id #230 QUERY select categories_id from categories where parent_id = '67' RESULT Resource id #233 QUERY select count(*) as count from categories where parent_id = '67' RESULT Resource id #236 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '4' RESULT Resource id #239 QUERY select categories_id from categories where parent_id = '4' RESULT Resource id #242 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23' RESULT Resource id #245 QUERY select categories_id from categories where parent_id = '23' 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 = '24' RESULT Resource id #251 QUERY select categories_id from categories where parent_id = '24' RESULT Resource id #254 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25' RESULT Resource id #257 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #260 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26' RESULT Resource id #263 QUERY select categories_id from categories where parent_id = '26' RESULT Resource id #266 QUERY select count(*) as count from categories where parent_id = '4' RESULT Resource id #269 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '4' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #272 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23' RESULT Resource id #275 QUERY select categories_id from categories where parent_id = '23' RESULT Resource id #278 QUERY select count(*) as count from categories where parent_id = '23' RESULT Resource id #281 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24' RESULT Resource id #284 QUERY select categories_id from categories where parent_id = '24' RESULT Resource id #287 QUERY select count(*) as count from categories where parent_id = '24' RESULT Resource id #290 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25' RESULT Resource id #293 QUERY select categories_id from categories where parent_id = '25' RESULT Resource id #296 QUERY select count(*) as count from categories where parent_id = '25' RESULT Resource id #299 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26' RESULT Resource id #302 QUERY select categories_id from categories where parent_id = '26' RESULT Resource id #305 QUERY select count(*) as count from categories where parent_id = '26' RESULT Resource id #308 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '8' RESULT Resource id #311 QUERY select categories_id from categories where parent_id = '8' RESULT Resource id #314 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62' RESULT Resource id #317 QUERY select categories_id from categories where parent_id = '62' RESULT Resource id #320 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63' RESULT Resource id #323 QUERY select categories_id from categories where parent_id = '63' RESULT Resource id #326 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #329 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '8' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #332 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63' RESULT Resource id #335 QUERY select categories_id from categories where parent_id = '63' RESULT Resource id #338 QUERY select count(*) as count from categories where parent_id = '63' RESULT Resource id #341 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62' RESULT Resource id #344 QUERY select categories_id from categories where parent_id = '62' RESULT Resource id #347 QUERY select count(*) as count from categories where parent_id = '62' RESULT Resource id #350 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '2' RESULT Resource id #353 QUERY select categories_id from categories where parent_id = '2' RESULT Resource id #356 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22' RESULT Resource id #359 QUERY select categories_id from categories where parent_id = '22' RESULT Resource id #362 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '19' RESULT Resource id #365 QUERY select categories_id from categories where parent_id = '19' RESULT Resource id #368 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '20' RESULT Resource id #371 QUERY select categories_id from categories where parent_id = '20' RESULT Resource id #374 QUERY select count(*) as count from categories where parent_id = '2' RESULT Resource id #377 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '2' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #380 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22' RESULT Resource id #383 QUERY select categories_id from categories where parent_id = '22' RESULT Resource id #386 QUERY select count(*) as count from categories where parent_id = '22' RESULT Resource id #389 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '20' RESULT Resource id #392 QUERY select categories_id from categories where parent_id = '20' RESULT Resource id #395 QUERY select count(*) as count from categories where parent_id = '20' RESULT Resource id #398 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '19' RESULT Resource id #401 QUERY select categories_id from categories where parent_id = '19' RESULT Resource id #404 QUERY select count(*) as count from categories where parent_id = '19' RESULT Resource id #407 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '21' RESULT Resource id #410 QUERY select categories_id from categories where parent_id = '21' RESULT Resource id #413 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '79' RESULT Resource id #416 QUERY select categories_id from categories where parent_id = '79' RESULT Resource id #419 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31' RESULT Resource id #422 QUERY select categories_id from categories where parent_id = '31' RESULT Resource id #425 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '32' RESULT Resource id #428 QUERY select categories_id from categories where parent_id = '32' RESULT Resource id #431 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '30' RESULT Resource id #434 QUERY select categories_id from categories where parent_id = '30' RESULT Resource id #437 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '76' RESULT Resource id #440 QUERY select categories_id from categories where parent_id = '76' RESULT Resource id #443 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33' RESULT Resource id #446 QUERY select categories_id from categories where parent_id = '33' RESULT Resource id #449 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46' RESULT Resource id #452 QUERY select categories_id from categories where parent_id = '46' RESULT Resource id #455 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '47' RESULT Resource id #458 QUERY select categories_id from categories where parent_id = '47' RESULT Resource id #461 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '48' RESULT Resource id #464 QUERY select categories_id from categories where parent_id = '48' RESULT Resource id #467 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49' RESULT Resource id #470 QUERY select categories_id from categories where parent_id = '49' RESULT Resource id #473 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50' RESULT Resource id #476 QUERY select categories_id from categories where parent_id = '50' RESULT Resource id #479 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51' RESULT Resource id #482 QUERY select categories_id from categories where parent_id = '51' RESULT Resource id #485 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52' RESULT Resource id #488 QUERY select categories_id from categories where parent_id = '52' RESULT Resource id #491 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53' RESULT Resource id #494 QUERY select categories_id from categories where parent_id = '53' RESULT Resource id #497 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54' RESULT Resource id #500 QUERY select categories_id from categories where parent_id = '54' RESULT Resource id #503 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '55' RESULT Resource id #506 QUERY select categories_id from categories where parent_id = '55' RESULT Resource id #509 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '56' RESULT Resource id #512 QUERY select categories_id from categories where parent_id = '56' RESULT Resource id #515 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '77' RESULT Resource id #518 QUERY select categories_id from categories where parent_id = '77' RESULT Resource id #521 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '81' RESULT Resource id #524 QUERY select categories_id from categories where parent_id = '81' RESULT Resource id #527 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34' RESULT Resource id #530 QUERY select categories_id from categories where parent_id = '34' RESULT Resource id #533 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35' RESULT Resource id #536 QUERY select categories_id from categories where parent_id = '35' RESULT Resource id #539 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '36' RESULT Resource id #542 QUERY select categories_id from categories where parent_id = '36' RESULT Resource id #545 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57' RESULT Resource id #548 QUERY select categories_id from categories where parent_id = '57' RESULT Resource id #551 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58' RESULT Resource id #554 QUERY select categories_id from categories where parent_id = '58' RESULT Resource id #557 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59' RESULT Resource id #560 QUERY select categories_id from categories where parent_id = '59' RESULT Resource id #563 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60' RESULT Resource id #566 QUERY select categories_id from categories where parent_id = '60' RESULT Resource id #569 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71' RESULT Resource id #572 QUERY select categories_id from categories where parent_id = '71' RESULT Resource id #575 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37' RESULT Resource id #578 QUERY select categories_id from categories where parent_id = '37' RESULT Resource id #581 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '38' RESULT Resource id #584 QUERY select categories_id from categories where parent_id = '38' RESULT Resource id #587 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '39' RESULT Resource id #590 QUERY select categories_id from categories where parent_id = '39' RESULT Resource id #593 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72' RESULT Resource id #596 QUERY select categories_id from categories where parent_id = '72' RESULT Resource id #599 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73' RESULT Resource id #602 QUERY select categories_id from categories where parent_id = '73' RESULT Resource id #605 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '43' RESULT Resource id #608 QUERY select categories_id from categories where parent_id = '43' RESULT Resource id #611 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '44' RESULT Resource id #614 QUERY select categories_id from categories where parent_id = '44' RESULT Resource id #617 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '45' RESULT Resource id #620 QUERY select categories_id from categories where parent_id = '45' RESULT Resource id #623 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '78' RESULT Resource id #626 QUERY select categories_id from categories where parent_id = '78' RESULT Resource id #629 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '75' RESULT Resource id #632 QUERY select categories_id from categories where parent_id = '75' RESULT Resource id #635 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '80' RESULT Resource id #638 QUERY select categories_id from categories where parent_id = '80' RESULT Resource id #641 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '82' RESULT Resource id #644 QUERY select categories_id from categories where parent_id = '82' RESULT Resource id #647 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '83' RESULT Resource id #650 QUERY select categories_id from categories where parent_id = '83' RESULT Resource id #653 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '84' RESULT Resource id #656 QUERY select categories_id from categories where parent_id = '84' RESULT Resource id #659 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '86' RESULT Resource id #662 QUERY select categories_id from categories where parent_id = '86' RESULT Resource id #665 QUERY select count(*) as count from categories where parent_id = '21' RESULT Resource id #668 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '21' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #671 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '79' RESULT Resource id #674 QUERY select categories_id from categories where parent_id = '79' RESULT Resource id #677 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #680 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '82' RESULT Resource id #683 QUERY select categories_id from categories where parent_id = '82' RESULT Resource id #686 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #689 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '86' RESULT Resource id #692 QUERY select categories_id from categories where parent_id = '86' RESULT Resource id #695 QUERY select count(*) as count from categories where parent_id = '86' RESULT Resource id #698 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '30' RESULT Resource id #701 QUERY select categories_id from categories where parent_id = '30' RESULT Resource id #704 QUERY select count(*) as count from categories where parent_id = '30' RESULT Resource id #707 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34' RESULT Resource id #710 QUERY select categories_id from categories where parent_id = '34' RESULT Resource id #713 QUERY select count(*) as count from categories where parent_id = '34' RESULT Resource id #716 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31' RESULT Resource id #719 QUERY select categories_id from categories where parent_id = '31' RESULT Resource id #722 QUERY select count(*) as count from categories where parent_id = '31' RESULT Resource id #725 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '32' RESULT Resource id #728 QUERY select categories_id from categories where parent_id = '32' RESULT Resource id #731 QUERY select count(*) as count from categories where parent_id = '32' RESULT Resource id #734 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33' RESULT Resource id #737 QUERY select categories_id from categories where parent_id = '33' RESULT Resource id #740 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46' RESULT Resource id #743 QUERY select categories_id from categories where parent_id = '46' RESULT Resource id #746 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '47' RESULT Resource id #749 QUERY select categories_id from categories where parent_id = '47' RESULT Resource id #752 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '48' RESULT Resource id #755 QUERY select categories_id from categories where parent_id = '48' RESULT Resource id #758 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49' RESULT Resource id #761 QUERY select categories_id from categories where parent_id = '49' RESULT Resource id #764 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50' RESULT Resource id #767 QUERY select categories_id from categories where parent_id = '50' RESULT Resource id #770 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51' RESULT Resource id #773 QUERY select categories_id from categories where parent_id = '51' RESULT Resource id #776 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52' RESULT Resource id #779 QUERY select categories_id from categories where parent_id = '52' RESULT Resource id #782 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53' RESULT Resource id #785 QUERY select categories_id from categories where parent_id = '53' RESULT Resource id #788 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54' RESULT Resource id #791 QUERY select categories_id from categories where parent_id = '54' RESULT Resource id #794 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '55' RESULT Resource id #797 QUERY select categories_id from categories where parent_id = '55' RESULT Resource id #800 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '56' RESULT Resource id #803 QUERY select categories_id from categories where parent_id = '56' RESULT Resource id #806 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '77' RESULT Resource id #809 QUERY select categories_id from categories where parent_id = '77' RESULT Resource id #812 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '81' RESULT Resource id #815 QUERY select categories_id from categories where parent_id = '81' RESULT Resource id #818 QUERY select count(*) as count from categories where parent_id = '33' RESULT Resource id #821 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '33' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #824 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46' RESULT Resource id #827 QUERY select categories_id from categories where parent_id = '46' RESULT Resource id #830 QUERY select count(*) as count from categories where parent_id = '46' RESULT Resource id #833 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '47' RESULT Resource id #836 QUERY select categories_id from categories where parent_id = '47' RESULT Resource id #839 QUERY select count(*) as count from categories where parent_id = '47' RESULT Resource id #842 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '81' RESULT Resource id #845 QUERY select categories_id from categories where parent_id = '81' RESULT Resource id #848 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #851 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '48' RESULT Resource id #854 QUERY select categories_id from categories where parent_id = '48' RESULT Resource id #857 QUERY select count(*) as count from categories where parent_id = '48' RESULT Resource id #860 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49' RESULT Resource id #863 QUERY select categories_id from categories where parent_id = '49' RESULT Resource id #866 QUERY select count(*) as count from categories where parent_id = '49' RESULT Resource id #869 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50' RESULT Resource id #872 QUERY select categories_id from categories where parent_id = '50' RESULT Resource id #875 QUERY select count(*) as count from categories where parent_id = '50' RESULT Resource id #878 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51' RESULT Resource id #881 QUERY select categories_id from categories where parent_id = '51' RESULT Resource id #884 QUERY select count(*) as count from categories where parent_id = '51' RESULT Resource id #887 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52' RESULT Resource id #890 QUERY select categories_id from categories where parent_id = '52' RESULT Resource id #893 QUERY select count(*) as count from categories where parent_id = '52' RESULT Resource id #896 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53' RESULT Resource id #899 QUERY select categories_id from categories where parent_id = '53' RESULT Resource id #902 QUERY select count(*) as count from categories where parent_id = '53' RESULT Resource id #905 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54' RESULT Resource id #908 QUERY select categories_id from categories where parent_id = '54' RESULT Resource id #911 QUERY select count(*) as count from categories where parent_id = '54' RESULT Resource id #914 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '77' RESULT Resource id #917 QUERY select categories_id from categories where parent_id = '77' RESULT Resource id #920 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #923 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '55' RESULT Resource id #926 QUERY select categories_id from categories where parent_id = '55' RESULT Resource id #929 QUERY select count(*) as count from categories where parent_id = '55' RESULT Resource id #932 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '56' RESULT Resource id #935 QUERY select categories_id from categories where parent_id = '56' RESULT Resource id #938 QUERY select count(*) as count from categories where parent_id = '56' RESULT Resource id #941 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '84' RESULT Resource id #944 QUERY select categories_id from categories where parent_id = '84' RESULT Resource id #947 QUERY select count(*) as count from categories where parent_id = '84' RESULT Resource id #950 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '83' RESULT Resource id #953 QUERY select categories_id from categories where parent_id = '83' RESULT Resource id #956 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #959 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '38' RESULT Resource id #962 QUERY select categories_id from categories where parent_id = '38' RESULT Resource id #965 QUERY select count(*) as count from categories where parent_id = '38' RESULT Resource id #968 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35' RESULT Resource id #971 QUERY select categories_id from categories where parent_id = '35' RESULT Resource id #974 QUERY select count(*) as count from categories where parent_id = '35' RESULT Resource id #977 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '78' RESULT Resource id #980 QUERY select categories_id from categories where parent_id = '78' RESULT Resource id #983 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #986 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '36' RESULT Resource id #989 QUERY select categories_id from categories where parent_id = '36' RESULT Resource id #992 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57' RESULT Resource id #995 QUERY select categories_id from categories where parent_id = '57' RESULT Resource id #998 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58' RESULT Resource id #1001 QUERY select categories_id from categories where parent_id = '58' RESULT Resource id #1004 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59' RESULT Resource id #1007 QUERY select categories_id from categories where parent_id = '59' RESULT Resource id #1010 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60' RESULT Resource id #1013 QUERY select categories_id from categories where parent_id = '60' RESULT Resource id #1016 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71' RESULT Resource id #1019 QUERY select categories_id from categories where parent_id = '71' RESULT Resource id #1022 QUERY select count(*) as count from categories where parent_id = '36' RESULT Resource id #1025 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '36' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #1028 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57' RESULT Resource id #1031 QUERY select categories_id from categories where parent_id = '57' RESULT Resource id #1034 QUERY select count(*) as count from categories where parent_id = '57' RESULT Resource id #1037 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58' RESULT Resource id #1040 QUERY select categories_id from categories where parent_id = '58' RESULT Resource id #1043 QUERY select count(*) as count from categories where parent_id = '58' RESULT Resource id #1046 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59' RESULT Resource id #1049 QUERY select categories_id from categories where parent_id = '59' RESULT Resource id #1052 QUERY select count(*) as count from categories where parent_id = '59' RESULT Resource id #1055 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60' RESULT Resource id #1058 QUERY select categories_id from categories where parent_id = '60' RESULT Resource id #1061 QUERY select count(*) as count from categories where parent_id = '60' RESULT Resource id #1064 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71' RESULT Resource id #1067 QUERY select categories_id from categories where parent_id = '71' RESULT Resource id #1070 QUERY select count(*) as count from categories where parent_id = '71' RESULT Resource id #1073 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '80' RESULT Resource id #1076 QUERY select categories_id from categories where parent_id = '80' RESULT Resource id #1079 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #1082 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '45' RESULT Resource id #1085 QUERY select categories_id from categories where parent_id = '45' RESULT Resource id #1088 QUERY select count(*) as count from categories where parent_id = '45' RESULT Resource id #1091 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '39' RESULT Resource id #1094 QUERY select categories_id from categories where parent_id = '39' RESULT Resource id #1097 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72' RESULT Resource id #1100 QUERY select categories_id from categories where parent_id = '72' RESULT Resource id #1103 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73' RESULT Resource id #1106 QUERY select categories_id from categories where parent_id = '73' RESULT Resource id #1109 QUERY select count(*) as count from categories where parent_id = '39' RESULT Resource id #1112 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '39' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #1115 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73' RESULT Resource id #1118 QUERY select categories_id from categories where parent_id = '73' RESULT Resource id #1121 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #1124 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72' RESULT Resource id #1127 QUERY select categories_id from categories where parent_id = '72' RESULT Resource id #1130 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #1133 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '76' RESULT Resource id #1136 QUERY select categories_id from categories where parent_id = '76' RESULT Resource id #1139 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #1142 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '44' RESULT Resource id #1145 QUERY select categories_id from categories where parent_id = '44' RESULT Resource id #1148 QUERY select count(*) as count from categories where parent_id = '44' RESULT Resource id #1151 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37' RESULT Resource id #1154 QUERY select categories_id from categories where parent_id = '37' RESULT Resource id #1157 QUERY select count(*) as count from categories where parent_id = '37' RESULT Resource id #1160 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '75' RESULT Resource id #1163 QUERY select categories_id from categories where parent_id = '75' RESULT Resource id #1166 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #1169 QUERY select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '43' RESULT Resource id #1172 QUERY select categories_id from categories where parent_id = '43' RESULT Resource id #1175 QUERY select count(*) as count from categories where parent_id = '43' RESULT Resource id #1178 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #1191 QUERY select count(*) as total from sessions where sesskey = '532c9675552d0c28f821b9b21152b340' RESULT Resource id #1195 QUERY insert into sessions values ('532c9675552d0c28f821b9b21152b340', '1291522362', 'cart|O:12:\"shoppingCart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"GBP\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:7:\"cookies\";s:1:\"1\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}') RESULT 1 05/12/2010 03:48:42 - /catalog/index.php?cookies=1 (0.105s)