0

Site Map

Products

1101 to 1200 of 1233 products

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
1.8638019561768	1238	1.5418	0

No Amazon API Requests Made.

App Debug - Total Time 1.8638019561768 seconds

Number	Time From Start	Name	Description
1	0.27637195587158	Initialise	Initialise FSB Function
2	0.28028297424316	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.31213593482971	Start of getCategoryListByGroup Function	Before first category groups query
4	0.31352591514587	After initial query	Before first category groups query
5	0.31352686882019	Get Category List for Group	Before the call to getCategoryList function
6	0.31352996826172	Start of GetCategoryList function	Start of the function
7	0.31353187561035	Before getting categories	Query to get specific category list
8	0.31488990783691	After getting categories	Query to get specific category list
9	0.31489086151123	Before getting category custom	Before call to function getCategoryCustom
10	0.33584785461426	After getting category custom	After call to function getCategoryCustom
11	0.33585000038147	Before getting category custom	Before call to function getCategoryCustom
12	0.34571695327759	After getting category custom	After call to function getCategoryCustom
13	0.34571886062622	Before getting category custom	Before call to function getCategoryCustom
14	0.35127091407776	After getting category custom	After call to function getCategoryCustom
15	0.35127305984497	Before getting category custom	Before call to function getCategoryCustom
16	0.354975938797	After getting category custom	After call to function getCategoryCustom
17	0.35497689247131	Before getting category custom	Before call to function getCategoryCustom
18	0.35887098312378	After getting category custom	After call to function getCategoryCustom
19	0.35887289047241	Before getting category custom	Before call to function getCategoryCustom
20	0.36327600479126	After getting category custom	After call to function getCategoryCustom
21	0.36327791213989	End of GetCategoryList function	End of the function
22	0.36328291893005	Get Category List for Group	Before the call to getCategoryList function
23	0.36328387260437	Start of GetCategoryList function	Start of the function
24	0.36328506469727	Before getting categories	Query to get specific category list
25	0.36373805999756	End of getCategoryListByGroup Function	Before return()
26	1.1079108715057	App Controller End	End of the App controller (called before the controller of every page)
27	1.1149289608002	Start of GetCategoryList function	Start of the function
28	1.1149308681488	Before getting categories	Query to get specific category list
29	1.1154499053955	After getting categories	Query to get specific category list
30	1.1154508590698	Before getting category custom	Before call to function getCategoryCustom
31	1.139317035675	After getting category custom	After call to function getCategoryCustom
32	1.1393179893494	Before getting sub category list	Before call to recursive function getCategoryList
33	1.139319896698	Start of GetCategoryList function	Start of the function
34	1.1393208503723	Before getting categories	Query to get specific category list
35	1.1399309635162	After getting sub category list	After call to recursive function getCategoryList
36	1.1399328708649	Before getting category custom	Before call to function getCategoryCustom
37	1.1524469852448	After getting category custom	After call to function getCategoryCustom
38	1.1524469852448	Before getting sub category list	Before call to recursive function getCategoryList
39	1.1524479389191	Start of GetCategoryList function	Start of the function
40	1.1524488925934	Before getting categories	Query to get specific category list
41	1.1528260707855	After getting sub category list	After call to recursive function getCategoryList
42	1.1528270244598	Before getting category custom	Before call to function getCategoryCustom
43	1.1585440635681	After getting category custom	After call to function getCategoryCustom
44	1.1585440635681	Before getting sub category list	Before call to recursive function getCategoryList
45	1.1585450172424	Start of GetCategoryList function	Start of the function
46	1.1585459709167	Before getting categories	Query to get specific category list
47	1.1589639186859	After getting sub category list	After call to recursive function getCategoryList
48	1.1589648723602	Before getting category custom	Before call to function getCategoryCustom
49	1.1630580425262	After getting category custom	After call to function getCategoryCustom
50	1.1630580425262	Before getting sub category list	Before call to recursive function getCategoryList
51	1.1630589962006	Start of GetCategoryList function	Start of the function
52	1.1630589962006	Before getting categories	Query to get specific category list
53	1.1634819507599	After getting sub category list	After call to recursive function getCategoryList
54	1.1634829044342	Before getting category custom	Before call to function getCategoryCustom
55	1.167867898941	After getting category custom	After call to function getCategoryCustom
56	1.1678688526154	Before getting sub category list	Before call to recursive function getCategoryList
57	1.1678688526154	Start of GetCategoryList function	Start of the function
58	1.1678700447083	Before getting categories	Query to get specific category list
59	1.1682820320129	After getting sub category list	After call to recursive function getCategoryList
60	1.1682829856873	Before getting category custom	Before call to function getCategoryCustom
61	1.172905921936	After getting category custom	After call to function getCategoryCustom
62	1.172905921936	Before getting sub category list	Before call to recursive function getCategoryList
63	1.1729068756104	Start of GetCategoryList function	Start of the function
64	1.1729068756104	Before getting categories	Query to get specific category list
65	1.1733720302582	After getting sub category list	After call to recursive function getCategoryList
66	1.1733798980713	End of GetCategoryList function	End of the function
67	1.7512290477753	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
68	1.7536120414734	Before Get Options	Before the call to getOptions in the tpl class
69	1.8269000053406	After Get Options	After the call to getOptions in the tpl class
70	1.8269400596619	App_after Controller End	End of the App_after controller (called after the controller of every page)
71	1.8637928962708	Finalizing debug	Before the debug is output to the page.
72	1.8638010025024	End of App	This is the end of the app logging, final timestamp

Query Debug - 1238 Database Queries. Total time 1.5418 seconds


SELECT parameter, value FROM parameters
SELECT * FROM `bad_bots`
SET time_zone = 'Europe/London'
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.137.179.200\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746871115'
SELECT * FROM autorun ORDER BY lastrun ASC
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'site-map' LIMIT 1
SELECT * FROM pages WHERE id = 43
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
SELECT * FROM pages WHERE pagename = 'site-map'
SELECT * FROM categorygroups ORDER BY sortorder ASC
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
SELECT id FROM categories WHERE parent_id = '26'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
SELECT id FROM categories WHERE parent_id = '27'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
SELECT id FROM categories WHERE parent_id = '28'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
SELECT id FROM categories WHERE parent_id = '29'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
SELECT id FROM categories WHERE parent_id = '30'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
SELECT id FROM categories WHERE parent_id = '31'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
SELECT * FROM categorygroups WHERE id = '1'
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
SELECT * FROM ipgeocountries WHERE INET_ATON('3.137.179.200') >= INET_ATON(ip_start) AND INET_ATON('3.137.179.200') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM pages WHERE pagename = 'site-map'
SELECT * FROM categories WHERE parent_id = '0'  AND hidden = 0 ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
SELECT id FROM categories WHERE parent_id = '26'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
SELECT * FROM categorygroups WHERE id = '1'
SELECT * FROM categories WHERE parent_id = '26'  AND hidden = 0 ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
SELECT id FROM categories WHERE parent_id = '27'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
SELECT * FROM categorygroups WHERE id = '1'
SELECT * FROM categories WHERE parent_id = '27'  AND hidden = 0 ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
SELECT id FROM categories WHERE parent_id = '28'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
SELECT * FROM categorygroups WHERE id = '1'
SELECT * FROM categories WHERE parent_id = '28'  AND hidden = 0 ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
SELECT id FROM categories WHERE parent_id = '29'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
SELECT * FROM categorygroups WHERE id = '1'
SELECT * FROM categories WHERE parent_id = '29'  AND hidden = 0 ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
SELECT id FROM categories WHERE parent_id = '30'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
SELECT * FROM categorygroups WHERE id = '1'
SELECT * FROM categories WHERE parent_id = '30'  AND hidden = 0 ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
SELECT id FROM categories WHERE parent_id = '31'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
SELECT * FROM categorygroups WHERE id = '1'
SELECT * FROM categories WHERE parent_id = '31'  AND hidden = 0 ORDER BY sortorder ASC
SELECT * FROM pages WHERE xmlsitemap = 1
SELECT COUNT(*) FROM products WHERE enabled = 1 AND hidden = 0  AND parent_id = 0 
SELECT * FROM products WHERE enabled = 1 AND hidden = 0  AND parent_id = 0 ORDER BY linktitle LIMIT 1059, 100
SELECT * FROM productimages WHERE product_id = '1047' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1047'
SELECT * FROM productcustomimages WHERE product_id = '1047'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1047' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1047' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1047' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1047
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1047'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1047' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1199' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1199'
SELECT * FROM productcustomimages WHERE product_id = '1199'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1199' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1199' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1199' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1199' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1077' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1077'
SELECT * FROM productcustomimages WHERE product_id = '1077'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1077' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1077' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1077' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1077' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1111' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1111'
SELECT * FROM productcustomimages WHERE product_id = '1111'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1111' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1111' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1111' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1111' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1127' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1127'
SELECT * FROM productcustomimages WHERE product_id = '1127'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1127' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1127' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1127' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1127' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1248' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1248'
SELECT * FROM productcustomimages WHERE product_id = '1248'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1248' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1248' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1248' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1248' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '957' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '957'
SELECT * FROM productcustomimages WHERE product_id = '957'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '957' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '957' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '957' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '957' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1121' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1121'
SELECT * FROM productcustomimages WHERE product_id = '1121'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1121' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1121' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1121' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1014' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1014'
SELECT * FROM productcustomimages WHERE product_id = '1014'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1014' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1014' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1014' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1014' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '929' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '929'
SELECT * FROM productcustomimages WHERE product_id = '929'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '929' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '929' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '929' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '929' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1037' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1037'
SELECT * FROM productcustomimages WHERE product_id = '1037'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1037' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1037' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1037' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1037' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4924' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4924'
SELECT * FROM productcustomimages WHERE product_id = '4924'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4924' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4924' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4924' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4924' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4760' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4760' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4760'
SELECT * FROM productcustomimages WHERE product_id = '4760'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4760'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4760'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4760
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4760' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4760' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4760' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4760
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4760'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4760'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4760'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4760
SELECT value FROM productattributes WHERE product_id = '4760' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4760'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM productimages WHERE product_id = '998' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '998'
SELECT * FROM productcustomimages WHERE product_id = '998'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '998' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '998' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '998' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '998' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '3579' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3579' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3579'
SELECT * FROM productcustomimages WHERE product_id = '3579'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3579'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3579'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3579
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3579' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3579' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3579' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3579
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3579'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3579'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3579'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3579
SELECT value FROM productattributes WHERE product_id = '3579' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3579'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM productimages WHERE product_id = '1264' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1264'
SELECT * FROM productcustomimages WHERE product_id = '1264'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1264' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1264' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1264' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1264' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1461' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1461'
SELECT * FROM productcustomimages WHERE product_id = '1461'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1461' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1461' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1461' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1461
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1461'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1461' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1443' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1443'
SELECT * FROM productcustomimages WHERE product_id = '1443'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1443' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1443' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1443' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1443' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '921' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '921'
SELECT * FROM productcustomimages WHERE product_id = '921'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '921' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '921' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '921' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 921
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '921'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '921' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '965' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '965'
SELECT * FROM productcustomimages WHERE product_id = '965'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '965' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '965' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '965' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 965
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '965'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '965' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '967' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '967'
SELECT * FROM productcustomimages WHERE product_id = '967'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '967' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '967' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '967' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 967
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '967'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '967' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1381' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1381'
SELECT * FROM productcustomimages WHERE product_id = '1381'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1381' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1381' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1381' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1381
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1381'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1381' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1435' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1435'
SELECT * FROM productcustomimages WHERE product_id = '1435'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1435' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1435' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1435' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1435' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '938' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '938'
SELECT * FROM productcustomimages WHERE product_id = '938'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '938' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '938' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '938' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '990' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '990'
SELECT * FROM productcustomimages WHERE product_id = '990'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '990' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '990' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '990' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 990
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '990'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '990' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '888' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '888'
SELECT * FROM productcustomimages WHERE product_id = '888'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '888' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '888' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '888' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 888
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '888'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '888' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1008' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1008'
SELECT * FROM productcustomimages WHERE product_id = '1008'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1008' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1008' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1008' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1008
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1008'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1008' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '3646' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3646'
SELECT * FROM productcustomimages WHERE product_id = '3646'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3646' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3646' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3646' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3646
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3646'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3646' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1040' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1040'
SELECT * FROM productcustomimages WHERE product_id = '1040'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1040' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1040' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1040' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1040
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1040'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1040' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '2235' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2235'
SELECT * FROM productcustomimages WHERE product_id = '2235'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2235' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2235' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2235' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2235
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2235'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2235' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '767' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '767' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '767'
SELECT * FROM productcustomimages WHERE product_id = '767'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '767'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '767'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 767
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '767' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '767' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '767' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 767
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '767'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '767'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '767'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 767
SELECT value FROM productattributes WHERE product_id = '767' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '767'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM productimages WHERE product_id = '1466' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1466'
SELECT * FROM productcustomimages WHERE product_id = '1466'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1466' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1466' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1466' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1466
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1466'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1466' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '2687' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2687'
SELECT * FROM productcustomimages WHERE product_id = '2687'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2687' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2687' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2687' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2687
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2687'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2687' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4078' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4078' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4078'
SELECT * FROM productcustomimages WHERE product_id = '4078'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4078'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4078'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4078
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4078' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4078' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4078' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4078
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4078'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4078'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4078'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4078
SELECT * FROM products WHERE parent_id = '4078'
SELECT * FROM productimages WHERE product_id = '4114' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4114'
SELECT * FROM productcustomimages WHERE product_id = '4114'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4114' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4114' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4114' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4114
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4114'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '4114' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1089' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1089'
SELECT * FROM productcustomimages WHERE product_id = '1089'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1089' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1089' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1089' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1089' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4476' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4476' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4476'
SELECT * FROM productcustomimages WHERE product_id = '4476'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4476'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4476'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4476
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4476' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4476' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4476' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4476
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4476'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4476'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4476'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4476
SELECT value FROM productattributes WHERE product_id = '4476' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4476'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'PackageQuantity'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE parent_id = '4476'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '950' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '950' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '950' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 950
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '950'
                AND name = 'ListPriceAmount'
SELECT * FROM productimages WHERE product_id = '1993' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1993'
SELECT * FROM productcustomimages WHERE product_id = '1993'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1993' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1993' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1993' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1993
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1993'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1993' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '3687' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3687'
SELECT * FROM productcustomimages WHERE product_id = '3687'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3687' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3687' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3687' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3687' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4479' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4479'
SELECT * FROM productcustomimages WHERE product_id = '4479'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4479' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4479' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4479' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4479
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4479'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '4479' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1917' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1917' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '1917'
SELECT * FROM productcustomimages WHERE product_id = '1917'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '1917'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '1917'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1917
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1917' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1917' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1917' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1917
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1917'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '1917'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '1917'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1917
SELECT * FROM products WHERE parent_id = '1917'
SELECT * FROM productimages WHERE product_id = '1864' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1864'
SELECT * FROM productcustomimages WHERE product_id = '1864'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1864' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1864' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1864' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1864
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1864'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1864' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '997' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '997'
SELECT * FROM productcustomimages WHERE product_id = '997'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '997' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '997' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '997' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 997
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '997'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '997' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '2808' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2808'
SELECT * FROM productcustomimages WHERE product_id = '2808'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2808' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2808' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2808' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '2808' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '3827' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3827'
SELECT * FROM productcustomimages WHERE product_id = '3827'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3827' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3827' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3827' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3827
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3827'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3827' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '3387' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3387' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3387'
SELECT * FROM productcustomimages WHERE product_id = '3387'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3387'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3387'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3387
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3387' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3387' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3387' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3387
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3387'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3387'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3387'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3387
SELECT value FROM productattributes WHERE product_id = '3387' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3387'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM productimages WHERE product_id = '1539' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1539'
SELECT * FROM productcustomimages WHERE product_id = '1539'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1539' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1539' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1539' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1539
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1539'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1539' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '3622' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3622'
SELECT * FROM productcustomimages WHERE product_id = '3622'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3622' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3622' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3622' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3622
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3622'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3622' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '2637' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2637' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '2637'
SELECT * FROM productcustomimages WHERE product_id = '2637'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2637'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2637'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2637
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2637' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2637' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2637' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2637
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2637'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2637'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2637'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2637
SELECT value FROM productattributes WHERE product_id = '2637' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2637'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'PackageQuantity'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE parent_id = '2637'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2638' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2638' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2638' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2638
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2638'
                AND name = 'ListPriceAmount'
SELECT * FROM productimages WHERE product_id = '2690' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2690'
SELECT * FROM productcustomimages WHERE product_id = '2690'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2690' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2690' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2690' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2690
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2690'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2690' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '2794' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2794'
SELECT * FROM productcustomimages WHERE product_id = '2794'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2794' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2794' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2794' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2794
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2794'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2794' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '2916' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2916'
SELECT * FROM productcustomimages WHERE product_id = '2916'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2916' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2916' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2916' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2916
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2916'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2916' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '3067' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3067'
SELECT * FROM productcustomimages WHERE product_id = '3067'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3067' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3067' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3067' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3067
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3067'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3067' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '2776' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2776'
SELECT * FROM productcustomimages WHERE product_id = '2776'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2776' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2776' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2776' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2776
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2776'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '2711' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2711'
SELECT * FROM productcustomimages WHERE product_id = '2711'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2711' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2711' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2711' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2711
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2711'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2711' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '2714' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2714'
SELECT * FROM productcustomimages WHERE product_id = '2714'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2714' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2714' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2714' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2714
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2714'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2714' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4904' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4904'
SELECT * FROM productcustomimages WHERE product_id = '4904'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4904' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4904' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4904' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4904' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4943' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4943'
SELECT * FROM productcustomimages WHERE product_id = '4943'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4943' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4943' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4943' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4943
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4943'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '4943' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '2285' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2285'
SELECT * FROM productcustomimages WHERE product_id = '2285'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2285' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2285' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2285' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2285
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2285'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2285' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1502' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1502'
SELECT * FROM productcustomimages WHERE product_id = '1502'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1502' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1502' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1502' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1502
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1502'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1502' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1587' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1587'
SELECT * FROM productcustomimages WHERE product_id = '1587'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1587' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1587' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1587' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1587
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1587'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1587' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1508' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1508'
SELECT * FROM productcustomimages WHERE product_id = '1508'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1508' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1508' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1508' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1508
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1508'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1508' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '2132' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2132'
SELECT * FROM productcustomimages WHERE product_id = '2132'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2132' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2132' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2132' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2132
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2132'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2132' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4483' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4483' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4483'
SELECT * FROM productcustomimages WHERE product_id = '4483'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4483'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4483'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4483
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4483' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4483' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4483' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4483
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4483'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4483'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4483'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4483
SELECT value FROM productattributes WHERE product_id = '4483' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4483'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4483'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM productimages WHERE product_id = '4496' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4496' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4496'
SELECT * FROM productcustomimages WHERE product_id = '4496'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4496'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4496'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4496
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4496' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4496' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4496' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4496
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4496'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4496'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4496'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4496
SELECT value FROM productattributes WHERE product_id = '4496' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4496'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4496'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE parent_id = '4496'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4497' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4497' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4497' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4497
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4497'
                AND name = 'ListPriceAmount'
SELECT * FROM productimages WHERE product_id = '4245' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4245'
SELECT * FROM productcustomimages WHERE product_id = '4245'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4245' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4245' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4245' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4245' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4247' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4247' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4247'
SELECT * FROM productcustomimages WHERE product_id = '4247'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4247'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4247'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4247
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4247' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4247' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4247' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4247
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4247'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4247'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4247'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4247
SELECT value FROM productattributes WHERE product_id = '4247' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4247'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4247'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM productimages WHERE product_id = '4614' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4614' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4614'
SELECT * FROM productcustomimages WHERE product_id = '4614'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4614'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4614'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4614
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4614' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4614' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4614' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4614
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4614'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4614'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4614'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4614
SELECT value FROM productattributes WHERE product_id = '4614' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4614'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4614'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM productimages WHERE product_id = '4581' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4581' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4581'
SELECT * FROM productcustomimages WHERE product_id = '4581'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4581'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4581'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4581
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4581' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4581' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4581' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4581
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4581'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4581'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4581'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4581
SELECT value FROM productattributes WHERE product_id = '4581' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4581'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4581'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM productimages WHERE product_id = '4612' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4612'
SELECT * FROM productcustomimages WHERE product_id = '4612'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4612' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4612' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4612' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4612
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4612'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '4612' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4246' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4246'
SELECT * FROM productcustomimages WHERE product_id = '4246'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4246' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4246' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4246' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4258' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4258'
SELECT * FROM productcustomimages WHERE product_id = '4258'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4258' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4258' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4258' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4258' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4257' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4257'
SELECT * FROM productcustomimages WHERE product_id = '4257'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4257' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4257' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4257' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4257' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4260' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4260'
SELECT * FROM productcustomimages WHERE product_id = '4260'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4260' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4260' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4260' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4260' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4261' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4261'
SELECT * FROM productcustomimages WHERE product_id = '4261'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4261' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4261' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4261' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4261' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4322' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4322' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4322'
SELECT * FROM productcustomimages WHERE product_id = '4322'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4322'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4322'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4322
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4322' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4322' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4322' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4322
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4322'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4322'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4322'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4322
SELECT value FROM productattributes WHERE product_id = '4322' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4322'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4322'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM productimages WHERE product_id = '4554' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4554' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4554'
SELECT * FROM productcustomimages WHERE product_id = '4554'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4554'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4554'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4554
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4554' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4554' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4554' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4554
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4554'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4554'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4554'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4554
SELECT value FROM productattributes WHERE product_id = '4554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4554'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4554'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM productimages WHERE product_id = '4256' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4256'
SELECT * FROM productcustomimages WHERE product_id = '4256'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4256' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4256' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4256' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4256' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4259' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4259'
SELECT * FROM productcustomimages WHERE product_id = '4259'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4259' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4259' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4259' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4259
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4259'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '4259' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4262' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4262' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4262'
SELECT * FROM productcustomimages WHERE product_id = '4262'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4262'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4262'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4262
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4262' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4262' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4262' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4262
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4262'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4262'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4262'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4262
SELECT value FROM productattributes WHERE product_id = '4262' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4262'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4262'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE parent_id = '4262'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4265' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4265' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4265' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productimages WHERE product_id = '4556' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4556' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4556'
SELECT * FROM productcustomimages WHERE product_id = '4556'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4556'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4556'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4556
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4556' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4556' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4556' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4556
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4556'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4556'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4556'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4556
SELECT value FROM productattributes WHERE product_id = '4556' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4556'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4556'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM productimages WHERE product_id = '3243' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3243'
SELECT * FROM productcustomimages WHERE product_id = '3243'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3243' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3243' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3243' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3243
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3243'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3243' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '3529' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3529'
SELECT * FROM productcustomimages WHERE product_id = '3529'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3529' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3529' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3529' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3529
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3529'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3529' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '2633' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2633'
SELECT * FROM productcustomimages WHERE product_id = '2633'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2633' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2633' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2633' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '2633' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '3916' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3916' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3916'
SELECT * FROM productcustomimages WHERE product_id = '3916'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3916'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3916'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3916
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3916' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3916' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3916' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3916
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3916'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3916'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3916'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3916
SELECT value FROM productattributes WHERE product_id = '3916' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3916'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM productimages WHERE product_id = '4164' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4164' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4164'
SELECT * FROM productcustomimages WHERE product_id = '4164'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4164'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4164'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4164
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4164' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4164' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4164' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4164
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4164'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4164'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4164'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4164
SELECT value FROM productattributes WHERE product_id = '4164' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4164'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM productimages WHERE product_id = '2019' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2019'
SELECT * FROM productcustomimages WHERE product_id = '2019'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2019' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2019' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2019' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '2019' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1948' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1948' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '1948'
SELECT * FROM productcustomimages WHERE product_id = '1948'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '1948'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '1948'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1948
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1948' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1948' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1948' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1948
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1948'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '1948'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '1948'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1948
SELECT value FROM productattributes WHERE product_id = '1948' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1948'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM productimages WHERE product_id = '4947' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4947'
SELECT * FROM productcustomimages WHERE product_id = '4947'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4947' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4947' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4947' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4947' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '3012' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3012'
SELECT * FROM productcustomimages WHERE product_id = '3012'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3012' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3012' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3012' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3012
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3012'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3012' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4145' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4145'
SELECT * FROM productcustomimages WHERE product_id = '4145'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4145' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4145' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4145' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4145
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4145'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '4145' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '3901' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3901'
SELECT * FROM productcustomimages WHERE product_id = '3901'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3901' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3901' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3901' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3901
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3901'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3901' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '3602' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3602'
SELECT * FROM productcustomimages WHERE product_id = '3602'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3602' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3602' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3602' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3602
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3602'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3602' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '3781' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3781'
SELECT * FROM productcustomimages WHERE product_id = '3781'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3781' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3781' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3781' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3781
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3781'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3781' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '995' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '995'
SELECT * FROM productcustomimages WHERE product_id = '995'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '995' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '995' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '995' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '995' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1347' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1347'
SELECT * FROM productcustomimages WHERE product_id = '1347'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1347' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1347' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1347' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1347
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1347'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1347' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1331' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1331'
SELECT * FROM productcustomimages WHERE product_id = '1331'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1331' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1331' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1331' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1331
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1331'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1331' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1489' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1489'
SELECT * FROM productcustomimages WHERE product_id = '1489'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1489' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1489' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1489' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1489
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1489'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1489' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '2157' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2157'
SELECT * FROM productcustomimages WHERE product_id = '2157'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2157' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2157' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2157' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2157
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2157'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2157' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '2265' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2265'
SELECT * FROM productcustomimages WHERE product_id = '2265'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2265' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2265' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2265' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2265
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2265'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2265' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
SELECT * FROM products WHERE id = 1626
SELECT * FROM products WHERE id = 4041
SELECT * FROM products WHERE id = 4312
SELECT * FROM products WHERE id = 777
SELECT * FROM products WHERE id = 3881
SELECT * FROM products WHERE id = 4213
SELECT * FROM products WHERE id = '1626'
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1626'
SELECT * FROM productcustomimages WHERE product_id = '1626'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4041'
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4041'
SELECT * FROM productcustomimages WHERE product_id = '4041'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4312'
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4312'
SELECT * FROM productcustomimages WHERE product_id = '4312'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '777'
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '777'
SELECT * FROM productcustomimages WHERE product_id = '777'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3881'
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3881'
SELECT * FROM productcustomimages WHERE product_id = '3881'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4213'
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4213'
SELECT * FROM productcustomimages WHERE product_id = '4213'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'