J P Assistants
Categories
box
Bookkeeping

Consultant Stores->

Payroll

Printing

View All Products ->

All Products sorted by Categories ->

All Products sorted by Manufacturers ->
box
Best Sellers
box
01.Mineralicious Makeup Catalogs
02.Shipping Labels
03.Sensual Magick 2009 Mild Winter Sampler
04.Sensual Magick 2009 Wild Winter Sampler
05.Inspirations From The Heart Business Cards
06.Inspirations From The Heart Scratch Off Cards
07.Design/Set Up Fee
08.The Scented Tub Scratch Off Cards
09.The Scented Tub Business Cards
10.The Scented Tub Catalogs
box
Reviews more
box
Business Cards
my name is Luella and I have ordered here for a while now an ..
5 of 5 Stars!
box
Cookie Usage Cookie Usage
Cookies must be enabled to purchase online on this store to embrace privacy and security related issues regarding your visit to this site.

By enabling cookie support on your browser, the communication between you and this site is strengthened to be certain it is you who are making transactions on your own behalf, and to prevent leakage of your privacy information.
We have detected that your browser does not support cookies, or has set cookies to be disabled.

To continue shopping online, we encourage you to enable cookies on your browser.

For Internet Explorer browsers, please follow these instructions:
  1. Click on the Tools menubar, and select Internet Options
  2. Select the Security tab, and reset the security level to Medium
We have taken this measurement of security for your benefit, and apologize upfront if any inconveniences are caused.

Please contact the store owner if you have any questions relating to this requirement, or to continue purchasing products offline.
Continue
Shopping Cart more
box
0 items
box
Your Account
box
Your Email Address
Your Password
box
Languages
box
English
box
Currencies
box
box
Information
box
Terms and Conditions
Shipping and returns
Privacy
Testimonials
Design Portfolio
Gift Voucher FAQ
Links
Contact Us
box
Quick Find
box
 
Use keywords to find the product you are looking for.
Advanced Search
box
Cards We Accept
box
BOX_INFORMATION_CARD
BOX_INFORMATION_CARD
BOX_INFORMATION_CARDBOX_INFORMATION_CARD
box
Who's Online
box
There currently is 1 guest online.
box

Copyright © 2003 Oscommerce and CRE Loaded Team
Powered by Oscommerce Supercharged by CRE Loaded Team
Using Version CRE Loaded v6.2 B2B
QUERY select value from sessions where sesskey = 'e1237f53f62b8333f0c5dd1022b31065' and expiry > '1293633043' RESULT Resource id #22 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #27 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #36 QUERY delete from whos_online where time_last_click < '1293632143' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'e1237f53f62b8333f0c5dd1022b31065' RESULT Resource id #54 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', 'e1237f53f62b8333f0c5dd1022b31065', '91.211.16.126', '1293633043', '1293633043', '/shop/index.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #63 QUERY select * from template where template_name = 'Helius' RESULT Resource id #69 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #74 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 #77 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #81 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #85 QUERY select categories_name, categories_head_title_tag, categories_head_desc_tag, categories_head_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #106 QUERY SELECT infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration WHERE template_id = 3 and infobox_display = "yes" and display_in_column = "left" ORDER BY location RESULT Resource id #111 QUERY select box_heading from infobox_heading where infobox_id = '81' and languages_id = '1' RESULT Resource id #114 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 #121 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #124 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #127 QUERY select count(*) as count from categories where parent_id = '9' RESULT Resource id #130 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #133 QUERY select box_heading from infobox_heading where infobox_id = '83' and languages_id = '1' RESULT Resource id #138 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #145 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '1' and languages_id = '1' RESULT Resource id #148 QUERY select box_heading from infobox_heading where infobox_id = '82' and languages_id = '1' RESULT Resource id #155 QUERY select box_heading from infobox_heading where infobox_id = '84' and languages_id = '1' RESULT Resource id #159 QUERY select distinct p.products_id, pd.products_name, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' order by rand(), s.specials_date_added desc limit 10 RESULT Resource id #163 QUERY select box_heading from infobox_heading where infobox_id = '92' and languages_id = '1' RESULT Resource id #166 QUERY select box_heading from infobox_heading where infobox_id = '93' and languages_id = '1' RESULT Resource id #170 QUERY select box_heading from infobox_heading where infobox_id = '114' and languages_id = '1' RESULT Resource id #174 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'box-ad' RESULT Resource id #178 QUERY select count(*) as count from banners_history where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #181 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select box_heading from infobox_heading where infobox_id = '95' and languages_id = '1' RESULT Resource id #191 QUERY select box_heading from infobox_heading where infobox_id = '96' and languages_id = '1' RESULT Resource id #195 QUERY select featured_id from featured where status = '1' order by featured_date_added DESC limit 10 RESULT Resource id #199 QUERY select box_heading from infobox_heading where infobox_id = '100' and languages_id = '1' RESULT Resource id #202 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'googlebox' RESULT Resource id #206 QUERY select distinct p.products_image, p.products_id, pd.products_name, p.products_image from products p, products_description pd, featured f where p.products_status = '1' and f.status = '1' and p.products_id = f.products_id and pd.products_id = f.products_id and pd.language_id = '1' order by rand(),p.products_date_added DESC, pd.products_name limit 6 RESULT Resource id #214 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 3 and infobox_display = "yes" and display_in_column = "right" order by location RESULT Resource id #218 QUERY select box_heading from infobox_heading where infobox_id = '101' and languages_id = '1' RESULT Resource id #221 QUERY select box_heading from infobox_heading where infobox_id = '103' and languages_id = '1' RESULT Resource id #230 QUERY select box_heading from infobox_heading where infobox_id = '104' and languages_id = '1' RESULT Resource id #240 QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 10 RESULT Resource id #244 QUERY select box_heading from infobox_heading where infobox_id = '105' and languages_id = '1' RESULT Resource id #252 QUERY select box_heading from infobox_heading where infobox_id = '106' and languages_id = '1' RESULT Resource id #256 QUERY select box_heading from infobox_heading where infobox_id = '107' and languages_id = '1' RESULT Resource id #266 QUERY select box_heading from infobox_heading where infobox_id = '108' and languages_id = '1' RESULT Resource id #275 QUERY SELECT information_id, languages_id, info_title FROM information WHERE visible= '1' and languages_id ='1' ORDER BY v_order RESULT Resource id #283 QUERY select box_heading from infobox_heading where infobox_id = '89' and languages_id = '1' RESULT Resource id #288 QUERY select box_heading from infobox_heading where infobox_id = '111' and languages_id = '1' RESULT Resource id #297 QUERY select box_heading from infobox_heading where infobox_id = '113' and languages_id = '1' RESULT Resource id #310 QUERY select box_heading from infobox_heading where infobox_id = '99' and languages_id = '1' RESULT Resource id #314 QUERY delete from whos_online where time_last_click < '1293632143' RESULT 1 QUERY select customer_id from whos_online RESULT Resource id #321 QUERY select startdate, counter from counter RESULT Resource id #330 QUERY update counter set counter = '62234' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'googlefoot' RESULT Resource id #335 QUERY select count(*) as count from banners where status = '1' and banners_group = 'googlefoot' RESULT Resource id #338 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'googlefoot' RESULT Resource id #341 QUERY select count(*) as count from banners_history where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #344 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #349 QUERY select count(*) as total from sessions where sesskey = 'e1237f53f62b8333f0c5dd1022b31065' RESULT Resource id #353 QUERY insert into sessions values ('e1237f53f62b8333f0c5dd1022b31065', '1293634483', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:6:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}s:10:\"headertags\";a:0:{}s:10:\"columnleft\";a:0:{}s:6:\"global\";a:0:{}s:12:\"indexdefault\";a:0:{}}}cre_RCO_data|a:1:{s:7:\"folders\";a:0:{}}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";') RESULT 1 - /shop/index.php?cookies=1 (0.247s) QUERY select value from sessions where sesskey = 'd343db461b1a80d269a08ea8c6d73a1f' and expiry > '1293633044' RESULT Resource id #22 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #27 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #36 QUERY delete from whos_online where time_last_click < '1293632144' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'd343db461b1a80d269a08ea8c6d73a1f' RESULT Resource id #54 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', 'd343db461b1a80d269a08ea8c6d73a1f', '91.211.16.126', '1293633044', '1293633044', '/shop/cookie_usage.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #63 QUERY select * from template where template_name = 'Helius' RESULT Resource id #69 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #74 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 #77 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #81 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #85 QUERY SELECT infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration WHERE template_id = 3 and infobox_display = "yes" and display_in_column = "left" ORDER BY location RESULT Resource id #104 QUERY select box_heading from infobox_heading where infobox_id = '81' and languages_id = '1' RESULT Resource id #107 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 #114 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #117 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #120 QUERY select count(*) as count from categories where parent_id = '9' RESULT Resource id #123 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #126 QUERY select box_heading from infobox_heading where infobox_id = '83' and languages_id = '1' RESULT Resource id #131 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #138 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '1' and languages_id = '1' RESULT Resource id #141 QUERY select box_heading from infobox_heading where infobox_id = '82' and languages_id = '1' RESULT Resource id #148 QUERY select box_heading from infobox_heading where infobox_id = '84' and languages_id = '1' RESULT Resource id #152 QUERY select distinct p.products_id, pd.products_name, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' order by rand(), s.specials_date_added desc limit 10 RESULT Resource id #156 QUERY select box_heading from infobox_heading where infobox_id = '92' and languages_id = '1' RESULT Resource id #159 QUERY select box_heading from infobox_heading where infobox_id = '93' and languages_id = '1' RESULT Resource id #163 QUERY select box_heading from infobox_heading where infobox_id = '114' and languages_id = '1' RESULT Resource id #167 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'box-ad' RESULT Resource id #171 QUERY select count(*) as count from banners_history where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #174 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select box_heading from infobox_heading where infobox_id = '95' and languages_id = '1' RESULT Resource id #184 QUERY select box_heading from infobox_heading where infobox_id = '96' and languages_id = '1' RESULT Resource id #188 QUERY select featured_id from featured where status = '1' order by featured_date_added DESC limit 10 RESULT Resource id #192 QUERY select box_heading from infobox_heading where infobox_id = '100' and languages_id = '1' RESULT Resource id #195 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'googlebox' RESULT Resource id #199 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 3 and infobox_display = "yes" and display_in_column = "right" order by location RESULT Resource id #206 QUERY select box_heading from infobox_heading where infobox_id = '101' and languages_id = '1' RESULT Resource id #209 QUERY select box_heading from infobox_heading where infobox_id = '103' and languages_id = '1' RESULT Resource id #218 QUERY select box_heading from infobox_heading where infobox_id = '104' and languages_id = '1' RESULT Resource id #228 QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 10 RESULT Resource id #232 QUERY select box_heading from infobox_heading where infobox_id = '105' and languages_id = '1' RESULT Resource id #240 QUERY select box_heading from infobox_heading where infobox_id = '106' and languages_id = '1' RESULT Resource id #244 QUERY select box_heading from infobox_heading where infobox_id = '107' and languages_id = '1' RESULT Resource id #254 QUERY select box_heading from infobox_heading where infobox_id = '108' and languages_id = '1' RESULT Resource id #263 QUERY SELECT information_id, languages_id, info_title FROM information WHERE visible= '1' and languages_id ='1' ORDER BY v_order RESULT Resource id #271 QUERY select box_heading from infobox_heading where infobox_id = '89' and languages_id = '1' RESULT Resource id #276 QUERY select box_heading from infobox_heading where infobox_id = '111' and languages_id = '1' RESULT Resource id #285 QUERY select box_heading from infobox_heading where infobox_id = '113' and languages_id = '1' RESULT Resource id #298 QUERY select box_heading from infobox_heading where infobox_id = '99' and languages_id = '1' RESULT Resource id #302 QUERY delete from whos_online where time_last_click < '1293632144' RESULT 1 QUERY select customer_id from whos_online RESULT Resource id #309 QUERY select startdate, counter from counter RESULT Resource id #318 QUERY update counter set counter = '62235' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'googlefoot' RESULT Resource id #323 QUERY select count(*) as count from banners where status = '1' and banners_group = 'googlefoot' RESULT Resource id #326 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'googlefoot' RESULT Resource id #329 QUERY select count(*) as count from banners_history where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #332 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #337 QUERY select count(*) as total from sessions where sesskey = 'd343db461b1a80d269a08ea8c6d73a1f' RESULT Resource id #341 QUERY insert into sessions values ('d343db461b1a80d269a08ea8c6d73a1f', '1293634484', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:6:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}s:10:\"headertags\";a:0:{}s:10:\"columnleft\";a:0:{}s:6:\"global\";a:0:{}s:11:\"cookieusage\";a:0:{}}}cre_RCO_data|a:1:{s:7:\"folders\";a:0:{}}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:16:\"cookie_usage.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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";') RESULT 1 - /shop/cookie_usage.php?cookies=1 (0.109s) QUERY select value from sessions where sesskey = 'f5a183784f6538f3bd48132bad3a0983' and expiry > '1293635599' RESULT Resource id #22 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #27 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #36 QUERY delete from whos_online where time_last_click < '1293634699' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'f5a183784f6538f3bd48132bad3a0983' RESULT Resource id #54 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', 'f5a183784f6538f3bd48132bad3a0983', '91.211.16.126', '1293635599', '1293635599', '/shop/index.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #63 QUERY select * from template where template_name = 'Helius' RESULT Resource id #69 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #74 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 #77 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #81 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #85 QUERY select categories_name, categories_head_title_tag, categories_head_desc_tag, categories_head_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #106 QUERY SELECT infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration WHERE template_id = 3 and infobox_display = "yes" and display_in_column = "left" ORDER BY location RESULT Resource id #111 QUERY select box_heading from infobox_heading where infobox_id = '81' and languages_id = '1' RESULT Resource id #114 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 #121 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #124 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #127 QUERY select count(*) as count from categories where parent_id = '9' RESULT Resource id #130 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #133 QUERY select box_heading from infobox_heading where infobox_id = '83' and languages_id = '1' RESULT Resource id #138 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #145 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '1' and languages_id = '1' RESULT Resource id #148 QUERY select box_heading from infobox_heading where infobox_id = '82' and languages_id = '1' RESULT Resource id #155 QUERY select box_heading from infobox_heading where infobox_id = '84' and languages_id = '1' RESULT Resource id #159 QUERY select distinct p.products_id, pd.products_name, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' order by rand(), s.specials_date_added desc limit 10 RESULT Resource id #163 QUERY select box_heading from infobox_heading where infobox_id = '92' and languages_id = '1' RESULT Resource id #166 QUERY select box_heading from infobox_heading where infobox_id = '93' and languages_id = '1' RESULT Resource id #170 QUERY select box_heading from infobox_heading where infobox_id = '114' and languages_id = '1' RESULT Resource id #174 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'box-ad' RESULT Resource id #178 QUERY select count(*) as count from banners_history where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #181 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select box_heading from infobox_heading where infobox_id = '95' and languages_id = '1' RESULT Resource id #191 QUERY select box_heading from infobox_heading where infobox_id = '96' and languages_id = '1' RESULT Resource id #195 QUERY select featured_id from featured where status = '1' order by featured_date_added DESC limit 10 RESULT Resource id #199 QUERY select box_heading from infobox_heading where infobox_id = '100' and languages_id = '1' RESULT Resource id #202 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'googlebox' RESULT Resource id #206 QUERY select distinct p.products_image, p.products_id, pd.products_name, p.products_image from products p, products_description pd, featured f where p.products_status = '1' and f.status = '1' and p.products_id = f.products_id and pd.products_id = f.products_id and pd.language_id = '1' order by rand(),p.products_date_added DESC, pd.products_name limit 6 RESULT Resource id #214 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 3 and infobox_display = "yes" and display_in_column = "right" order by location RESULT Resource id #218 QUERY select box_heading from infobox_heading where infobox_id = '101' and languages_id = '1' RESULT Resource id #221 QUERY select box_heading from infobox_heading where infobox_id = '103' and languages_id = '1' RESULT Resource id #230 QUERY select box_heading from infobox_heading where infobox_id = '104' and languages_id = '1' RESULT Resource id #240 QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 10 RESULT Resource id #244 QUERY select box_heading from infobox_heading where infobox_id = '105' and languages_id = '1' RESULT Resource id #252 QUERY select box_heading from infobox_heading where infobox_id = '106' and languages_id = '1' RESULT Resource id #256 QUERY select box_heading from infobox_heading where infobox_id = '107' and languages_id = '1' RESULT Resource id #266 QUERY select box_heading from infobox_heading where infobox_id = '108' and languages_id = '1' RESULT Resource id #275 QUERY SELECT information_id, languages_id, info_title FROM information WHERE visible= '1' and languages_id ='1' ORDER BY v_order RESULT Resource id #283 QUERY select box_heading from infobox_heading where infobox_id = '89' and languages_id = '1' RESULT Resource id #288 QUERY select box_heading from infobox_heading where infobox_id = '111' and languages_id = '1' RESULT Resource id #297 QUERY select box_heading from infobox_heading where infobox_id = '113' and languages_id = '1' RESULT Resource id #310 QUERY select box_heading from infobox_heading where infobox_id = '99' and languages_id = '1' RESULT Resource id #314 QUERY delete from whos_online where time_last_click < '1293634699' RESULT 1 QUERY select customer_id from whos_online RESULT Resource id #321 QUERY select startdate, counter from counter RESULT Resource id #330 QUERY update counter set counter = '62248' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'googlefoot' RESULT Resource id #335 QUERY select count(*) as count from banners where status = '1' and banners_group = 'googlefoot' RESULT Resource id #338 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'googlefoot' RESULT Resource id #341 QUERY select count(*) as count from banners_history where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #344 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #349 QUERY select count(*) as total from sessions where sesskey = 'f5a183784f6538f3bd48132bad3a0983' RESULT Resource id #353 QUERY insert into sessions values ('f5a183784f6538f3bd48132bad3a0983', '1293637039', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:6:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}s:10:\"headertags\";a:0:{}s:10:\"columnleft\";a:0:{}s:6:\"global\";a:0:{}s:12:\"indexdefault\";a:0:{}}}cre_RCO_data|a:1:{s:7:\"folders\";a:0:{}}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";') RESULT 1 - /shop/index.php?cookies=1 (0.083s) QUERY select value from sessions where sesskey = '4a00017eab8234adc976c133e5f2b0db' and expiry > '1293635600' RESULT Resource id #22 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #27 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #36 QUERY delete from whos_online where time_last_click < '1293634700' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '4a00017eab8234adc976c133e5f2b0db' RESULT Resource id #54 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', '4a00017eab8234adc976c133e5f2b0db', '91.211.16.126', '1293635600', '1293635600', '/shop/cookie_usage.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #63 QUERY select * from template where template_name = 'Helius' RESULT Resource id #69 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #74 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 #77 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #81 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #85 QUERY select count(*) as total from sessions where sesskey = '4a00017eab8234adc976c133e5f2b0db' RESULT Resource id #99 QUERY insert into sessions values ('4a00017eab8234adc976c133e5f2b0db', '1293637040', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:2:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}}}cre_RCO_data|a:1:{s:7:\"folders\";a:0:{}}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:16:\"cookie_usage.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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";') RESULT 1 QUERY select value from sessions where sesskey = '109638c403c9e141230f3a19b85bc446' and expiry > '1293635601' RESULT Resource id #22 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #27 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #36 QUERY delete from whos_online where time_last_click < '1293634701' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '109638c403c9e141230f3a19b85bc446' RESULT Resource id #54 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', '109638c403c9e141230f3a19b85bc446', '91.211.16.126', '1293635601', '1293635601', '/shop/index.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #63 QUERY select * from template where template_name = 'Helius' RESULT Resource id #69 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #74 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 #77 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #81 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #85 QUERY select categories_name, categories_head_title_tag, categories_head_desc_tag, categories_head_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #106 QUERY SELECT infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration WHERE template_id = 3 and infobox_display = "yes" and display_in_column = "left" ORDER BY location RESULT Resource id #111 QUERY select box_heading from infobox_heading where infobox_id = '81' and languages_id = '1' RESULT Resource id #114 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 #121 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #124 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #127 QUERY select count(*) as count from categories where parent_id = '9' RESULT Resource id #130 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #133 QUERY select box_heading from infobox_heading where infobox_id = '83' and languages_id = '1' RESULT Resource id #138 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #145 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '1' and languages_id = '1' RESULT Resource id #148 QUERY select box_heading from infobox_heading where infobox_id = '82' and languages_id = '1' RESULT Resource id #155 QUERY select box_heading from infobox_heading where infobox_id = '84' and languages_id = '1' RESULT Resource id #159 QUERY select distinct p.products_id, pd.products_name, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' order by rand(), s.specials_date_added desc limit 10 RESULT Resource id #163 QUERY select box_heading from infobox_heading where infobox_id = '92' and languages_id = '1' RESULT Resource id #166 QUERY select box_heading from infobox_heading where infobox_id = '93' and languages_id = '1' RESULT Resource id #170 QUERY select box_heading from infobox_heading where infobox_id = '114' and languages_id = '1' RESULT Resource id #174 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'box-ad' RESULT Resource id #178 QUERY select count(*) as count from banners_history where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #181 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select box_heading from infobox_heading where infobox_id = '95' and languages_id = '1' RESULT Resource id #191 QUERY select box_heading from infobox_heading where infobox_id = '96' and languages_id = '1' RESULT Resource id #195 QUERY select featured_id from featured where status = '1' order by featured_date_added DESC limit 10 RESULT Resource id #199 QUERY select box_heading from infobox_heading where infobox_id = '100' and languages_id = '1' RESULT Resource id #202 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'googlebox' RESULT Resource id #206 QUERY select distinct p.products_image, p.products_id, pd.products_name, p.products_image from products p, products_description pd, featured f where p.products_status = '1' and f.status = '1' and p.products_id = f.products_id and pd.products_id = f.products_id and pd.language_id = '1' order by rand(),p.products_date_added DESC, pd.products_name limit 6 RESULT Resource id #214 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 3 and infobox_display = "yes" and display_in_column = "right" order by location RESULT Resource id #218 QUERY select box_heading from infobox_heading where infobox_id = '101' and languages_id = '1' RESULT Resource id #221 QUERY select box_heading from infobox_heading where infobox_id = '103' and languages_id = '1' RESULT Resource id #230 QUERY select box_heading from infobox_heading where infobox_id = '104' and languages_id = '1' RESULT Resource id #240 QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 10 RESULT Resource id #244 QUERY select box_heading from infobox_heading where infobox_id = '105' and languages_id = '1' RESULT Resource id #252 QUERY select box_heading from infobox_heading where infobox_id = '106' and languages_id = '1' RESULT Resource id #256 QUERY select box_heading from infobox_heading where infobox_id = '107' and languages_id = '1' RESULT Resource id #266 QUERY select box_heading from infobox_heading where infobox_id = '108' and languages_id = '1' RESULT Resource id #275 QUERY SELECT information_id, languages_id, info_title FROM information WHERE visible= '1' and languages_id ='1' ORDER BY v_order RESULT Resource id #283 QUERY select box_heading from infobox_heading where infobox_id = '89' and languages_id = '1' RESULT Resource id #288 QUERY select box_heading from infobox_heading where infobox_id = '111' and languages_id = '1' RESULT Resource id #297 QUERY select box_heading from infobox_heading where infobox_id = '113' and languages_id = '1' RESULT Resource id #310 QUERY select box_heading from infobox_heading where infobox_id = '99' and languages_id = '1' RESULT Resource id #314 QUERY delete from whos_online where time_last_click < '1293634701' RESULT 1 QUERY select customer_id from whos_online RESULT Resource id #321 QUERY select startdate, counter from counter RESULT Resource id #330 QUERY update counter set counter = '62249' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'googlefoot' RESULT Resource id #335 QUERY select count(*) as count from banners where status = '1' and banners_group = 'googlefoot' RESULT Resource id #338 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'googlefoot' RESULT Resource id #341 QUERY select count(*) as count from banners_history where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #344 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #349 QUERY select count(*) as total from sessions where sesskey = '109638c403c9e141230f3a19b85bc446' RESULT Resource id #353 QUERY insert into sessions values ('109638c403c9e141230f3a19b85bc446', '1293637041', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:6:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}s:10:\"headertags\";a:0:{}s:10:\"columnleft\";a:0:{}s:6:\"global\";a:0:{}s:12:\"indexdefault\";a:0:{}}}cre_RCO_data|a:1:{s:7:\"folders\";a:0:{}}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";') RESULT 1 - /shop/index.php?cookies=1 (0.058s) QUERY select value from sessions where sesskey = '64601ebc9275cdb34e50835f1d24662f' and expiry > '1293635602' RESULT Resource id #22 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #27 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #36 QUERY delete from whos_online where time_last_click < '1293634702' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '64601ebc9275cdb34e50835f1d24662f' RESULT Resource id #54 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', '64601ebc9275cdb34e50835f1d24662f', '91.211.16.126', '1293635602', '1293635602', '/shop/cookie_usage.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #63 QUERY select * from template where template_name = 'Helius' RESULT Resource id #69 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #74 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 #77 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #81 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #85 QUERY select count(*) as total from sessions where sesskey = '64601ebc9275cdb34e50835f1d24662f' RESULT Resource id #99 QUERY insert into sessions values ('64601ebc9275cdb34e50835f1d24662f', '1293637042', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:2:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}}}cre_RCO_data|a:1:{s:7:\"folders\";a:0:{}}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:16:\"cookie_usage.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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";') RESULT 1 QUERY select value from sessions where sesskey = '06e226f1e4d5ac58f6c72c3696e03c52' and expiry > '1293635603' RESULT Resource id #22 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #27 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #36 QUERY delete from whos_online where time_last_click < '1293634703' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '06e226f1e4d5ac58f6c72c3696e03c52' RESULT Resource id #54 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', '06e226f1e4d5ac58f6c72c3696e03c52', '91.211.16.126', '1293635603', '1293635603', '/shop/index.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #63 QUERY select * from template where template_name = 'Helius' RESULT Resource id #69 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #74 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 #77 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #81 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #85 QUERY select categories_name, categories_head_title_tag, categories_head_desc_tag, categories_head_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #106 QUERY SELECT infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration WHERE template_id = 3 and infobox_display = "yes" and display_in_column = "left" ORDER BY location RESULT Resource id #111 QUERY select box_heading from infobox_heading where infobox_id = '81' and languages_id = '1' RESULT Resource id #114 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 #121 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #124 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #127 QUERY select count(*) as count from categories where parent_id = '9' RESULT Resource id #130 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #133 QUERY select box_heading from infobox_heading where infobox_id = '83' and languages_id = '1' RESULT Resource id #138 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #145 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '1' and languages_id = '1' RESULT Resource id #148 QUERY select box_heading from infobox_heading where infobox_id = '82' and languages_id = '1' RESULT Resource id #155 QUERY select box_heading from infobox_heading where infobox_id = '84' and languages_id = '1' RESULT Resource id #159 QUERY select distinct p.products_id, pd.products_name, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' order by rand(), s.specials_date_added desc limit 10 RESULT Resource id #163 QUERY select box_heading from infobox_heading where infobox_id = '92' and languages_id = '1' RESULT Resource id #166 QUERY select box_heading from infobox_heading where infobox_id = '93' and languages_id = '1' RESULT Resource id #170 QUERY select box_heading from infobox_heading where infobox_id = '114' and languages_id = '1' RESULT Resource id #174 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'box-ad' RESULT Resource id #178 QUERY select count(*) as count from banners_history where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #181 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select box_heading from infobox_heading where infobox_id = '95' and languages_id = '1' RESULT Resource id #191 QUERY select box_heading from infobox_heading where infobox_id = '96' and languages_id = '1' RESULT Resource id #195 QUERY select featured_id from featured where status = '1' order by featured_date_added DESC limit 10 RESULT Resource id #199 QUERY select box_heading from infobox_heading where infobox_id = '100' and languages_id = '1' RESULT Resource id #202 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'googlebox' RESULT Resource id #206 QUERY select distinct p.products_image, p.products_id, pd.products_name, p.products_image from products p, products_description pd, featured f where p.products_status = '1' and f.status = '1' and p.products_id = f.products_id and pd.products_id = f.products_id and pd.language_id = '1' order by rand(),p.products_date_added DESC, pd.products_name limit 6 RESULT Resource id #214 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 3 and infobox_display = "yes" and display_in_column = "right" order by location RESULT Resource id #218 QUERY select box_heading from infobox_heading where infobox_id = '101' and languages_id = '1' RESULT Resource id #221 QUERY select box_heading from infobox_heading where infobox_id = '103' and languages_id = '1' RESULT Resource id #230 QUERY select box_heading from infobox_heading where infobox_id = '104' and languages_id = '1' RESULT Resource id #240 QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 10 RESULT Resource id #244 QUERY select box_heading from infobox_heading where infobox_id = '105' and languages_id = '1' RESULT Resource id #252 QUERY select box_heading from infobox_heading where infobox_id = '106' and languages_id = '1' RESULT Resource id #256 QUERY select box_heading from infobox_heading where infobox_id = '107' and languages_id = '1' RESULT Resource id #266 QUERY select box_heading from infobox_heading where infobox_id = '108' and languages_id = '1' RESULT Resource id #275 QUERY SELECT information_id, languages_id, info_title FROM information WHERE visible= '1' and languages_id ='1' ORDER BY v_order RESULT Resource id #283 QUERY select box_heading from infobox_heading where infobox_id = '89' and languages_id = '1' RESULT Resource id #288 QUERY select box_heading from infobox_heading where infobox_id = '111' and languages_id = '1' RESULT Resource id #297 QUERY select box_heading from infobox_heading where infobox_id = '113' and languages_id = '1' RESULT Resource id #310 QUERY select box_heading from infobox_heading where infobox_id = '99' and languages_id = '1' RESULT Resource id #314 QUERY delete from whos_online where time_last_click < '1293634703' RESULT 1 QUERY select customer_id from whos_online RESULT Resource id #321 QUERY select startdate, counter from counter RESULT Resource id #330 QUERY update counter set counter = '62250' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'googlefoot' RESULT Resource id #335 QUERY select count(*) as count from banners where status = '1' and banners_group = 'googlefoot' RESULT Resource id #338 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'googlefoot' RESULT Resource id #341 QUERY select count(*) as count from banners_history where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #344 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #349 QUERY select count(*) as total from sessions where sesskey = '06e226f1e4d5ac58f6c72c3696e03c52' RESULT Resource id #353 QUERY insert into sessions values ('06e226f1e4d5ac58f6c72c3696e03c52', '1293637043', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:6:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}s:10:\"headertags\";a:0:{}s:10:\"columnleft\";a:0:{}s:6:\"global\";a:0:{}s:12:\"indexdefault\";a:0:{}}}cre_RCO_data|a:1:{s:7:\"folders\";a:0:{}}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";') RESULT 1 - /shop/index.php?cookies=1 (0.058s) QUERY select value from sessions where sesskey = '93fac74ba98b8b60a3784d5667566f9f' and expiry > '1293635605' RESULT Resource id #22 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #27 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #36 QUERY delete from whos_online where time_last_click < '1293634705' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '93fac74ba98b8b60a3784d5667566f9f' RESULT Resource id #54 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', '93fac74ba98b8b60a3784d5667566f9f', '91.211.16.126', '1293635605', '1293635605', '/shop/cookie_usage.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #63 QUERY select * from template where template_name = 'Helius' RESULT Resource id #69 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #74 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 #77 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #81 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #85 QUERY select count(*) as total from sessions where sesskey = '93fac74ba98b8b60a3784d5667566f9f' RESULT Resource id #99 QUERY insert into sessions values ('93fac74ba98b8b60a3784d5667566f9f', '1293637045', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:2:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}}}cre_RCO_data|a:1:{s:7:\"folders\";a:0:{}}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:16:\"cookie_usage.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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";') RESULT 1 QUERY select value from sessions where sesskey = 'c6484fccafef6ab994d131ab74bb7ad1' and expiry > '1293635607' RESULT Resource id #22 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #27 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #36 QUERY delete from whos_online where time_last_click < '1293634707' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'c6484fccafef6ab994d131ab74bb7ad1' RESULT Resource id #54 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', 'c6484fccafef6ab994d131ab74bb7ad1', '91.211.16.126', '1293635607', '1293635607', '/shop/index.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #63 QUERY select * from template where template_name = 'Helius' RESULT Resource id #69 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #74 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 #77 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #81 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #85 QUERY select categories_name, categories_head_title_tag, categories_head_desc_tag, categories_head_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #106 QUERY SELECT infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration WHERE template_id = 3 and infobox_display = "yes" and display_in_column = "left" ORDER BY location RESULT Resource id #111 QUERY select box_heading from infobox_heading where infobox_id = '81' and languages_id = '1' RESULT Resource id #114 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 #121 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #124 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #127 QUERY select count(*) as count from categories where parent_id = '9' RESULT Resource id #130 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #133 QUERY select box_heading from infobox_heading where infobox_id = '83' and languages_id = '1' RESULT Resource id #138 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #145 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '1' and languages_id = '1' RESULT Resource id #148 QUERY select box_heading from infobox_heading where infobox_id = '82' and languages_id = '1' RESULT Resource id #155 QUERY select box_heading from infobox_heading where infobox_id = '84' and languages_id = '1' RESULT Resource id #159 QUERY select distinct p.products_id, pd.products_name, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' order by rand(), s.specials_date_added desc limit 10 RESULT Resource id #163 QUERY select box_heading from infobox_heading where infobox_id = '92' and languages_id = '1' RESULT Resource id #166 QUERY select box_heading from infobox_heading where infobox_id = '93' and languages_id = '1' RESULT Resource id #170 QUERY select box_heading from infobox_heading where infobox_id = '114' and languages_id = '1' RESULT Resource id #174 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'box-ad' RESULT Resource id #178 QUERY select count(*) as count from banners_history where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #181 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select box_heading from infobox_heading where infobox_id = '95' and languages_id = '1' RESULT Resource id #191 QUERY select box_heading from infobox_heading where infobox_id = '96' and languages_id = '1' RESULT Resource id #195 QUERY select featured_id from featured where status = '1' order by featured_date_added DESC limit 10 RESULT Resource id #199 QUERY select box_heading from infobox_heading where infobox_id = '100' and languages_id = '1' RESULT Resource id #202 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'googlebox' RESULT Resource id #206 QUERY select distinct p.products_image, p.products_id, pd.products_name, p.products_image from products p, products_description pd, featured f where p.products_status = '1' and f.status = '1' and p.products_id = f.products_id and pd.products_id = f.products_id and pd.language_id = '1' order by rand(),p.products_date_added DESC, pd.products_name limit 6 RESULT Resource id #214 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 3 and infobox_display = "yes" and display_in_column = "right" order by location RESULT Resource id #218 QUERY select box_heading from infobox_heading where infobox_id = '101' and languages_id = '1' RESULT Resource id #221 QUERY select box_heading from infobox_heading where infobox_id = '103' and languages_id = '1' RESULT Resource id #230 QUERY select box_heading from infobox_heading where infobox_id = '104' and languages_id = '1' RESULT Resource id #240 QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 10 RESULT Resource id #244 QUERY select box_heading from infobox_heading where infobox_id = '105' and languages_id = '1' RESULT Resource id #252 QUERY select box_heading from infobox_heading where infobox_id = '106' and languages_id = '1' RESULT Resource id #256 QUERY select box_heading from infobox_heading where infobox_id = '107' and languages_id = '1' RESULT Resource id #266 QUERY select box_heading from infobox_heading where infobox_id = '108' and languages_id = '1' RESULT Resource id #275 QUERY SELECT information_id, languages_id, info_title FROM information WHERE visible= '1' and languages_id ='1' ORDER BY v_order RESULT Resource id #283 QUERY select box_heading from infobox_heading where infobox_id = '89' and languages_id = '1' RESULT Resource id #288 QUERY select box_heading from infobox_heading where infobox_id = '111' and languages_id = '1' RESULT Resource id #297 QUERY select box_heading from infobox_heading where infobox_id = '113' and languages_id = '1' RESULT Resource id #310 QUERY select box_heading from infobox_heading where infobox_id = '99' and languages_id = '1' RESULT Resource id #314 QUERY delete from whos_online where time_last_click < '1293634707' RESULT 1 QUERY select customer_id from whos_online RESULT Resource id #321 QUERY select startdate, counter from counter RESULT Resource id #330 QUERY update counter set counter = '62251' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'googlefoot' RESULT Resource id #335 QUERY select count(*) as count from banners where status = '1' and banners_group = 'googlefoot' RESULT Resource id #338 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'googlefoot' RESULT Resource id #341 QUERY select count(*) as count from banners_history where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #344 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #349 QUERY select count(*) as total from sessions where sesskey = 'c6484fccafef6ab994d131ab74bb7ad1' RESULT Resource id #353 QUERY insert into sessions values ('c6484fccafef6ab994d131ab74bb7ad1', '1293637047', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:6:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}s:10:\"headertags\";a:0:{}s:10:\"columnleft\";a:0:{}s:6:\"global\";a:0:{}s:12:\"indexdefault\";a:0:{}}}cre_RCO_data|a:1:{s:7:\"folders\";a:0:{}}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";') RESULT 1 - /shop/index.php?cookies=1 (0.061s) QUERY select value from sessions where sesskey = 'e36b9513792a2e27f3591a1e9c0f3d34' and expiry > '1293635608' RESULT Resource id #22 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #27 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #36 QUERY delete from whos_online where time_last_click < '1293634708' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'e36b9513792a2e27f3591a1e9c0f3d34' RESULT Resource id #54 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', 'e36b9513792a2e27f3591a1e9c0f3d34', '91.211.16.126', '1293635608', '1293635608', '/shop/cookie_usage.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #63 QUERY select * from template where template_name = 'Helius' RESULT Resource id #69 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #74 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 #77 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #81 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #85 QUERY select count(*) as total from sessions where sesskey = 'e36b9513792a2e27f3591a1e9c0f3d34' RESULT Resource id #99 QUERY insert into sessions values ('e36b9513792a2e27f3591a1e9c0f3d34', '1293637048', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:2:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}}}cre_RCO_data|a:1:{s:7:\"folders\";a:0:{}}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:16:\"cookie_usage.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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";') RESULT 1 QUERY select value from sessions where sesskey = 'ecf078789a55600f3467c33cf8e8c44c' and expiry > '1293635609' RESULT Resource id #22 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #27 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #36 QUERY delete from whos_online where time_last_click < '1293634709' RESULT 1 QUERY select count(*) as count from whos_online where session_id = 'ecf078789a55600f3467c33cf8e8c44c' RESULT Resource id #54 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', 'ecf078789a55600f3467c33cf8e8c44c', '91.211.16.126', '1293635609', '1293635609', '/shop/index.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #63 QUERY select * from template where template_name = 'Helius' RESULT Resource id #69 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #74 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 #77 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #81 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #85 QUERY select categories_name, categories_head_title_tag, categories_head_desc_tag, categories_head_keywords_tag from categories_description where categories_id = '0' and language_id = '1' RESULT Resource id #106 QUERY SELECT infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration WHERE template_id = 3 and infobox_display = "yes" and display_in_column = "left" ORDER BY location RESULT Resource id #111 QUERY select box_heading from infobox_heading where infobox_id = '81' and languages_id = '1' RESULT Resource id #114 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 #121 QUERY select count(*) as count from categories where parent_id = '8' RESULT Resource id #124 QUERY select count(*) as count from categories where parent_id = '1' RESULT Resource id #127 QUERY select count(*) as count from categories where parent_id = '9' RESULT Resource id #130 QUERY select count(*) as count from categories where parent_id = '10' RESULT Resource id #133 QUERY select box_heading from infobox_heading where infobox_id = '83' and languages_id = '1' RESULT Resource id #138 QUERY select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10 RESULT Resource id #145 QUERY select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '1' and languages_id = '1' RESULT Resource id #148 QUERY select box_heading from infobox_heading where infobox_id = '82' and languages_id = '1' RESULT Resource id #155 QUERY select box_heading from infobox_heading where infobox_id = '84' and languages_id = '1' RESULT Resource id #159 QUERY select distinct p.products_id, pd.products_name, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' order by rand(), s.specials_date_added desc limit 10 RESULT Resource id #163 QUERY select box_heading from infobox_heading where infobox_id = '92' and languages_id = '1' RESULT Resource id #166 QUERY select box_heading from infobox_heading where infobox_id = '93' and languages_id = '1' RESULT Resource id #170 QUERY select box_heading from infobox_heading where infobox_id = '114' and languages_id = '1' RESULT Resource id #174 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'box-ad' RESULT Resource id #178 QUERY select count(*) as count from banners_history where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #181 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select box_heading from infobox_heading where infobox_id = '95' and languages_id = '1' RESULT Resource id #191 QUERY select box_heading from infobox_heading where infobox_id = '96' and languages_id = '1' RESULT Resource id #195 QUERY select featured_id from featured where status = '1' order by featured_date_added DESC limit 10 RESULT Resource id #199 QUERY select box_heading from infobox_heading where infobox_id = '100' and languages_id = '1' RESULT Resource id #202 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'googlebox' RESULT Resource id #206 QUERY select distinct p.products_image, p.products_id, pd.products_name, p.products_image from products p, products_description pd, featured f where p.products_status = '1' and f.status = '1' and p.products_id = f.products_id and pd.products_id = f.products_id and pd.language_id = '1' order by rand(),p.products_date_added DESC, pd.products_name limit 6 RESULT Resource id #214 QUERY select infobox_id, display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_template, box_heading_font_color from infobox_configuration where template_id = 3 and infobox_display = "yes" and display_in_column = "right" order by location RESULT Resource id #218 QUERY select box_heading from infobox_heading where infobox_id = '101' and languages_id = '1' RESULT Resource id #221 QUERY select box_heading from infobox_heading where infobox_id = '103' and languages_id = '1' RESULT Resource id #230 QUERY select box_heading from infobox_heading where infobox_id = '104' and languages_id = '1' RESULT Resource id #240 QUERY select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 10 RESULT Resource id #244 QUERY select box_heading from infobox_heading where infobox_id = '105' and languages_id = '1' RESULT Resource id #252 QUERY select box_heading from infobox_heading where infobox_id = '106' and languages_id = '1' RESULT Resource id #256 QUERY select box_heading from infobox_heading where infobox_id = '107' and languages_id = '1' RESULT Resource id #266 QUERY select box_heading from infobox_heading where infobox_id = '108' and languages_id = '1' RESULT Resource id #275 QUERY SELECT information_id, languages_id, info_title FROM information WHERE visible= '1' and languages_id ='1' ORDER BY v_order RESULT Resource id #283 QUERY select box_heading from infobox_heading where infobox_id = '89' and languages_id = '1' RESULT Resource id #288 QUERY select box_heading from infobox_heading where infobox_id = '111' and languages_id = '1' RESULT Resource id #297 QUERY select box_heading from infobox_heading where infobox_id = '113' and languages_id = '1' RESULT Resource id #310 QUERY select box_heading from infobox_heading where infobox_id = '99' and languages_id = '1' RESULT Resource id #314 QUERY delete from whos_online where time_last_click < '1293634709' RESULT 1 QUERY select customer_id from whos_online RESULT Resource id #321 QUERY select startdate, counter from counter RESULT Resource id #330 QUERY update counter set counter = '62252' RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'googlefoot' RESULT Resource id #335 QUERY select count(*) as count from banners where status = '1' and banners_group = 'googlefoot' RESULT Resource id #338 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = 'googlefoot' RESULT Resource id #341 QUERY select count(*) as count from banners_history where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT Resource id #344 QUERY update banners_history set banners_shown = banners_shown + 1 where banners_id = '1' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') RESULT 1 QUERY select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50' RESULT Resource id #349 QUERY select count(*) as total from sessions where sesskey = 'ecf078789a55600f3467c33cf8e8c44c' RESULT Resource id #353 QUERY insert into sessions values ('ecf078789a55600f3467c33cf8e8c44c', '1293637049', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:6:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}s:10:\"headertags\";a:0:{}s:10:\"columnleft\";a:0:{}s:6:\"global\";a:0:{}s:12:\"indexdefault\";a:0:{}}}cre_RCO_data|a:1:{s:7:\"folders\";a:0:{}}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";') RESULT 1 - /shop/index.php?cookies=1 (0.061s) QUERY select value from sessions where sesskey = '50959e352ae1792de527795ccae88ac2' and expiry > '1293635610' RESULT Resource id #22 QUERY select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies RESULT Resource id #27 QUERY select languages_id, name, code, image, directory from languages order by sort_order RESULT Resource id #36 QUERY delete from whos_online where time_last_click < '1293634710' RESULT 1 QUERY select count(*) as count from whos_online where session_id = '50959e352ae1792de527795ccae88ac2' RESULT Resource id #54 QUERY insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('0', 'Guest', '50959e352ae1792de527795ccae88ac2', '91.211.16.126', '1293635610', '1293635610', '/shop/cookie_usage.php?cookies=1', '') RESULT 1 QUERY select customers_selected_template as template_selected from customers where customers_id = '' RESULT Resource id #63 QUERY select * from template where template_name = 'Helius' RESULT Resource id #69 QUERY select banners_id, date_scheduled from banners where date_scheduled != '' RESULT Resource id #74 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 #77 QUERY select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #81 QUERY select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0 RESULT Resource id #85 QUERY select count(*) as total from sessions where sesskey = '50959e352ae1792de527795ccae88ac2' RESULT Resource id #99 QUERY insert into sessions values ('50959e352ae1792de527795ccae88ac2', '1293637050', '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;}cre_RCI_data|a:1:{s:7:\"folders\";a:2:{s:7:\"english\";a:1:{s:4:\"lang\";a:1:{i:0;s:26:\"paypalwpp_english_lang.php\";}}s:14:\"applicationtop\";a:2:{s:6:\"bottom\";a:2:{i:0;s:33:\"buysafe_applicationtop_bottom.php\";i:1;s:35:\"paypalwpp_applicationtop_bottom.php\";}s:13:\"updateproduct\";a:1:{i:0;s:40:\"buysafe_applicationtop_updateproduct.php\";}}}}cre_RCO_data|a:1:{s:7:\"folders\";a:0:{}}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:16:\"cookie_usage.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:{}}sppc_customer_group_show_tax|s:1:\"1\";sppc_customer_group_tax_exempt|s:1:\"0\";') RESULT 1