QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #16 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #22 QUERY delete from whos_online where time_last_click < '1290938366' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '' RESULT Resource id #37 QUERY update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '91.211.16.126', time_last_click = '1290939266', last_page_url = '/index.php?cookies=1' where session_id = '' RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #47 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 #50 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #54 QUERY select image_id as total,DATE_FORMAT(startDate,'%Y%m%d') as startDate, DATE_FORMAT(expirationDate,'%Y%m%d') as expirationDate from main_page_images where image_id > 1 and expirationDate > 20101128 and startDate <= 20101128 RESULT Resource id #61 QUERY select image_id, image_type, image_name, image_link, image_name_secondary, image_link_secondary, DATE_FORMAT(startDate,'%Y%m%d') as startDate, DATE_FORMAT(expirationDate,'%Y%m%d') as expirationDate from main_page_images where image_id > 1 and expirationDate > 20101128 and startDate <= 20101128 order by RAND() LIMIT 1 RESULT Resource id #64 QUERY select information from info_page where page_id = 13 LIMIT 1 RESULT Resource id #67 QUERY select information from info_page where page_id = 14 LIMIT 1 RESULT Resource id #70 QUERY select information from info_page where page_id = 16 LIMIT 1 RESULT Resource id #73 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #16 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #22 QUERY delete from whos_online where time_last_click < '1290938368' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '' RESULT Resource id #37 QUERY update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '91.211.16.126', time_last_click = '1290939268', last_page_url = '/index.php?cookies=1' where session_id = '' RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #47 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 #50 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #54 QUERY select image_id as total,DATE_FORMAT(startDate,'%Y%m%d') as startDate, DATE_FORMAT(expirationDate,'%Y%m%d') as expirationDate from main_page_images where image_id > 1 and expirationDate > 20101128 and startDate <= 20101128 RESULT Resource id #61 QUERY select image_id, image_type, image_name, image_link, image_name_secondary, image_link_secondary, DATE_FORMAT(startDate,'%Y%m%d') as startDate, DATE_FORMAT(expirationDate,'%Y%m%d') as expirationDate from main_page_images where image_id > 1 and expirationDate > 20101128 and startDate <= 20101128 order by RAND() LIMIT 1 RESULT Resource id #64 QUERY select information from info_page where page_id = 13 LIMIT 1 RESULT Resource id #67 QUERY select information from info_page where page_id = 14 LIMIT 1 RESULT Resource id #70 QUERY select information from info_page where page_id = 16 LIMIT 1 RESULT Resource id #73 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #16 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #22 QUERY delete from whos_online where time_last_click < '1290938369' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '' RESULT Resource id #37 QUERY update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '91.211.16.126', time_last_click = '1290939269', last_page_url = '/index.php?cookies=1' where session_id = '' RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #47 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 #50 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #54 QUERY select image_id as total,DATE_FORMAT(startDate,'%Y%m%d') as startDate, DATE_FORMAT(expirationDate,'%Y%m%d') as expirationDate from main_page_images where image_id > 1 and expirationDate > 20101128 and startDate <= 20101128 RESULT Resource id #61 QUERY select image_id, image_type, image_name, image_link, image_name_secondary, image_link_secondary, DATE_FORMAT(startDate,'%Y%m%d') as startDate, DATE_FORMAT(expirationDate,'%Y%m%d') as expirationDate from main_page_images where image_id > 1 and expirationDate > 20101128 and startDate <= 20101128 order by RAND() LIMIT 1 RESULT Resource id #64 QUERY select information from info_page where page_id = 13 LIMIT 1 RESULT Resource id #67 QUERY select information from info_page where page_id = 14 LIMIT 1 RESULT Resource id #70 QUERY select information from info_page where page_id = 16 LIMIT 1 RESULT Resource id #73 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #16 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #22 QUERY delete from whos_online where time_last_click < '1290938370' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '' RESULT Resource id #37 QUERY update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '91.211.16.126', time_last_click = '1290939270', last_page_url = '/index.php?cookies=1' where session_id = '' RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #47 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 #50 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #54 QUERY select image_id as total,DATE_FORMAT(startDate,'%Y%m%d') as startDate, DATE_FORMAT(expirationDate,'%Y%m%d') as expirationDate from main_page_images where image_id > 1 and expirationDate > 20101128 and startDate <= 20101128 RESULT Resource id #61 QUERY select image_id, image_type, image_name, image_link, image_name_secondary, image_link_secondary, DATE_FORMAT(startDate,'%Y%m%d') as startDate, DATE_FORMAT(expirationDate,'%Y%m%d') as expirationDate from main_page_images where image_id > 1 and expirationDate > 20101128 and startDate <= 20101128 order by RAND() LIMIT 1 RESULT Resource id #64 QUERY select information from info_page where page_id = 13 LIMIT 1 RESULT Resource id #67 QUERY select information from info_page where page_id = 14 LIMIT 1 RESULT Resource id #70 QUERY select information from info_page where page_id = 16 LIMIT 1 RESULT Resource id #73 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #16 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #22 QUERY delete from whos_online where time_last_click < '1290938372' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '' RESULT Resource id #37 QUERY update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '91.211.16.126', time_last_click = '1290939272', last_page_url = '/index.php?cookies=1' where session_id = '' RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #47 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 #50 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #54 QUERY select image_id as total,DATE_FORMAT(startDate,'%Y%m%d') as startDate, DATE_FORMAT(expirationDate,'%Y%m%d') as expirationDate from main_page_images where image_id > 1 and expirationDate > 20101128 and startDate <= 20101128 RESULT Resource id #61 QUERY select image_id, image_type, image_name, image_link, image_name_secondary, image_link_secondary, DATE_FORMAT(startDate,'%Y%m%d') as startDate, DATE_FORMAT(expirationDate,'%Y%m%d') as expirationDate from main_page_images where image_id > 1 and expirationDate > 20101128 and startDate <= 20101128 order by RAND() LIMIT 1 RESULT Resource id #64 QUERY select information from info_page where page_id = 13 LIMIT 1 RESULT Resource id #67 QUERY select information from info_page where page_id = 14 LIMIT 1 RESULT Resource id #70 QUERY select information from info_page where page_id = 16 LIMIT 1 RESULT Resource id #73 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #16 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #22 QUERY delete from whos_online where time_last_click < '1291025082' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '' RESULT Resource id #37 QUERY update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '91.211.16.126', time_last_click = '1291025982', last_page_url = '/index.php?cookies=1' where session_id = '' RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #47 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 #50 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #54 QUERY select image_id as total,DATE_FORMAT(startDate,'%Y%m%d') as startDate, DATE_FORMAT(expirationDate,'%Y%m%d') as expirationDate from main_page_images where image_id > 1 and expirationDate > 20101129 and startDate <= 20101129 RESULT Resource id #61 QUERY select image_id, image_type, image_name, image_link, image_name_secondary, image_link_secondary, DATE_FORMAT(startDate,'%Y%m%d') as startDate, DATE_FORMAT(expirationDate,'%Y%m%d') as expirationDate from main_page_images where image_id > 1 and expirationDate > 20101129 and startDate <= 20101129 order by RAND() LIMIT 1 RESULT Resource id #64 QUERY select information from info_page where page_id = 13 LIMIT 1 RESULT Resource id #67 QUERY select information from info_page where page_id = 14 LIMIT 1 RESULT Resource id #70 QUERY select information from info_page where page_id = 16 LIMIT 1 RESULT Resource id #73 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #16 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #22 QUERY delete from whos_online where time_last_click < '1291025084' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '' RESULT Resource id #37 QUERY update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '91.211.16.126', time_last_click = '1291025984', last_page_url = '/index.php?cookies=1' where session_id = '' RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #47 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 #50 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #54 QUERY select image_id as total,DATE_FORMAT(startDate,'%Y%m%d') as startDate, DATE_FORMAT(expirationDate,'%Y%m%d') as expirationDate from main_page_images where image_id > 1 and expirationDate > 20101129 and startDate <= 20101129 RESULT Resource id #61 QUERY select image_id, image_type, image_name, image_link, image_name_secondary, image_link_secondary, DATE_FORMAT(startDate,'%Y%m%d') as startDate, DATE_FORMAT(expirationDate,'%Y%m%d') as expirationDate from main_page_images where image_id > 1 and expirationDate > 20101129 and startDate <= 20101129 order by RAND() LIMIT 1 RESULT Resource id #64 QUERY select information from info_page where page_id = 13 LIMIT 1 RESULT Resource id #67 QUERY select information from info_page where page_id = 14 LIMIT 1 RESULT Resource id #70 QUERY select information from info_page where page_id = 16 LIMIT 1 RESULT Resource id #73 QUERY select value from sessions where sesskey = '095bdf0779a68740feea855c32f23da0' and expiry > '1291025985' RESULT Resource id #15 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #19 QUERY delete from whos_online where time_last_click < '1291025085' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '095bdf0779a68740feea855c32f23da0' RESULT Resource id #36 QUERY update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '173.192.97.134', time_last_click = '1291025985', last_page_url = '/d430sc-jewel-empire-bubble-p-353.html?cPath=73' where session_id = '095bdf0779a68740feea855c32f23da0' RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #46 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 #49 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #53 QUERY select categories_name from categories_description where categories_id = '73' and language_id = '1' RESULT Resource id #57 QUERY select products_name from products_description where products_id = '353' RESULT Resource id #60 QUERY select categories_name from categories_description where categories_id = '73' and language_id = '1' RESULT Resource id #64 QUERY select products_name from products_description where products_id = '353' RESULT Resource id #67 QUERY select m.manufacturers_name from manufacturers m, products p where m.manufacturers_id = p.manufacturers_id and p.products_id = 353 RESULT Resource id #70 QUERY select categories_name from categories_description where categories_id = '73' and language_id = '1' RESULT Resource id #73 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where sort_order<10000 and 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 #80 QUERY select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '73' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name RESULT Resource id #83 QUERY select count(*) as count from categories where parent_id = '66' RESULT Resource id #88 QUERY select count(*) as count from categories where parent_id = '68' RESULT Resource id #93 QUERY select count(*) as count from categories where parent_id = '69' RESULT Resource id #98 QUERY select count(*) as count from categories where parent_id = '72' RESULT Resource id #103 QUERY select count(*) as count from categories where parent_id = '73' RESULT Resource id #108 QUERY select count(*) as count from categories where parent_id = '74' RESULT Resource id #113 QUERY select count(*) as count from categories where parent_id = '75' RESULT Resource id #118 QUERY select count(*) as count from categories where parent_id = '76' RESULT Resource id #123 QUERY select count(*) as count from categories where parent_id = '78' RESULT Resource id #128 QUERY select count(*) as count from categories where parent_id = '79' RESULT Resource id #133 QUERY select count(*) as count from categories where parent_id = '80' RESULT Resource id #138 QUERY select count(*) as count from categories where parent_id = '81' RESULT Resource id #143 QUERY select count(*) as count from categories where parent_id = '82' RESULT Resource id #148 QUERY select count(*) as count from categories where parent_id = '83' RESULT Resource id #153 QUERY select count(*) as count from categories where parent_id = '84' RESULT Resource id #158 QUERY select count(*) as count from categories where parent_id = '85' RESULT Resource id #163 QUERY select count(*) as count from categories where parent_id = '86' RESULT Resource id #168 QUERY select count(*) as count from categories where parent_id = '77' RESULT Resource id #173 QUERY select count(*) as count from categories where parent_id = '87' RESULT Resource id #178 QUERY select count(*) as count from categories where parent_id = '88' RESULT Resource id #183 QUERY select count(*) as total from products p, products_description pd where p.products_status = '1' and p.products_id = '353' and pd.products_id = p.products_id RESULT Resource id #187 QUERY select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(ws.status, ws.specials_new_products_price, NULL) as ws_specials_new_products_price, IF(s.status, ws.specials_new_products_price, p.products_price) as ws_final_price from products p left join specials s on p.products_id = s.products_id left join wholesaler_specials ws on p.products_id = ws.products_id, products_description pd where p.products_status = '1' and p.products_id = '353' and pd.products_id = p.products_id and pd.language_id = '1' RESULT Resource id #190 QUERY select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '223') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '43') and tr.tax_class_id = '1' group by tr.tax_priority RESULT Resource id #193 QUERY select count(*) as total from products_options popt, products_attributes patrib where patrib.products_id='353' and patrib.options_id = popt.products_options_id and popt.language_id = '1' RESULT Resource id #196 QUERY select distinct popt.products_options_id, popt.products_options_name from products_options popt, products_attributes patrib where patrib.products_id='353' and patrib.options_id = popt.products_options_id and popt.language_id = '1' order by popt.products_options_name RESULT Resource id #199 QUERY select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix ,pa.products_attributes_id, pa.att_image_small,pa.att_image_hi_res, pa.att_image_extra_small1, pa.att_image_extra_hi_res1, pa.att_image_extra_small2, pa.att_image_extra_hi_res2, pa.size_XS, pa.size_S, pa.size_M, pa.size_L from products_attributes pa, products_options_values pov where pa.products_id = '353' and pa.options_id = '1' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '1' order by pa.attribute_sort RESULT Resource id #202 QUERY select count(*) as total from sessions where sesskey = '095bdf0779a68740feea855c32f23da0' RESULT Resource id #206 QUERY update sessions set expiry = '1291027425', value = 'cart|O:12:\"shoppingCart\":5:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:6:\"cartID\";N;s:12:\"content_type\";b:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:3:{i:0;a:4:{s:4:\"page\";s:14:\"shop_front.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:4:\"page\";s:1:\"1\";}s:4:\"post\";a:0:{}}i:1;a:4:{s:4:\"page\";s:16:\"product_info.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:11:\"products_id\";s:3:\"456\";}s:4:\"post\";a:0:{}}i:2;a:4:{s:4:\"page\";s:16:\"product_info.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:2:{s:11:\"products_id\";s:3:\"355\";s:5:\"cPath\";s:2:\"73\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:4:{s:4:\"page\";s:21:\"checkout_shipping.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}}' where sesskey = '095bdf0779a68740feea855c32f23da0' RESULT 1 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #16 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #22 QUERY delete from whos_online where time_last_click < '1291025086' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '' RESULT Resource id #37 QUERY update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '91.211.16.126', time_last_click = '1291025986', last_page_url = '/index.php?cookies=1' where session_id = '' RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #47 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 #50 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #54 QUERY select image_id as total,DATE_FORMAT(startDate,'%Y%m%d') as startDate, DATE_FORMAT(expirationDate,'%Y%m%d') as expirationDate from main_page_images where image_id > 1 and expirationDate > 20101129 and startDate <= 20101129 RESULT Resource id #61 QUERY select image_id, image_type, image_name, image_link, image_name_secondary, image_link_secondary, DATE_FORMAT(startDate,'%Y%m%d') as startDate, DATE_FORMAT(expirationDate,'%Y%m%d') as expirationDate from main_page_images where image_id > 1 and expirationDate > 20101129 and startDate <= 20101129 order by RAND() LIMIT 1 RESULT Resource id #64 QUERY select information from info_page where page_id = 13 LIMIT 1 RESULT Resource id #67 QUERY select information from info_page where page_id = 14 LIMIT 1 RESULT Resource id #70 QUERY select information from info_page where page_id = 16 LIMIT 1 RESULT Resource id #73 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #16 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #22 QUERY delete from whos_online where time_last_click < '1291025088' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '' RESULT Resource id #37 QUERY update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '91.211.16.126', time_last_click = '1291025988', last_page_url = '/index.php?cookies=1' where session_id = '' RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #47 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 #50 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #54 QUERY select image_id as total,DATE_FORMAT(startDate,'%Y%m%d') as startDate, DATE_FORMAT(expirationDate,'%Y%m%d') as expirationDate from main_page_images where image_id > 1 and expirationDate > 20101129 and startDate <= 20101129 RESULT Resource id #61 QUERY select image_id, image_type, image_name, image_link, image_name_secondary, image_link_secondary, DATE_FORMAT(startDate,'%Y%m%d') as startDate, DATE_FORMAT(expirationDate,'%Y%m%d') as expirationDate from main_page_images where image_id > 1 and expirationDate > 20101129 and startDate <= 20101129 order by RAND() LIMIT 1 RESULT Resource id #64 QUERY select information from info_page where page_id = 13 LIMIT 1 RESULT Resource id #67 QUERY select information from info_page where page_id = 14 LIMIT 1 RESULT Resource id #70 QUERY select information from info_page where page_id = 16 LIMIT 1 RESULT Resource id #73 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #16 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #22 QUERY delete from whos_online where time_last_click < '1291025090' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '' RESULT Resource id #37 QUERY update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '91.211.16.126', time_last_click = '1291025990', last_page_url = '/index.php?cookies=1' where session_id = '' RESULT 1 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #47 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 #50 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #54 QUERY select image_id as total,DATE_FORMAT(startDate,'%Y%m%d') as startDate, DATE_FORMAT(expirationDate,'%Y%m%d') as expirationDate from main_page_images where image_id > 1 and expirationDate > 20101129 and startDate <= 20101129 RESULT Resource id #61 QUERY select image_id, image_type, image_name, image_link, image_name_secondary, image_link_secondary, DATE_FORMAT(startDate,'%Y%m%d') as startDate, DATE_FORMAT(expirationDate,'%Y%m%d') as expirationDate from main_page_images where image_id > 1 and expirationDate > 20101129 and startDate <= 20101129 order by RAND() LIMIT 1 RESULT Resource id #64 QUERY select information from info_page where page_id = 13 LIMIT 1 RESULT Resource id #67 QUERY select information from info_page where page_id = 14 LIMIT 1 RESULT Resource id #70 QUERY select information from info_page where page_id = 16 LIMIT 1 RESULT Resource id #73