0

Site Map

Shop Categories

Products

1 to 100 of 1233 products

1
2
3
4
Next ›

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
2.0362949371338	808	1.3102	0

No Amazon API Requests Made.

App Debug - Total Time 2.0362949371338 seconds

Number	Time From Start	Name	Description
1	0.62978291511536	Initialise	Initialise FSB Function
2	0.63920593261719	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.68022799491882	Start of getCategoryListByGroup Function	Before first category groups query
4	0.68221497535706	After initial query	Before first category groups query
5	0.68221688270569	Get Category List for Group	Before the call to getCategoryList function
6	0.68222188949585	Start of GetCategoryList function	Start of the function
7	0.68222784996033	Before getting categories	Query to get specific category list
8	0.68453192710876	After getting categories	Query to get specific category list
9	0.68453407287598	Before getting category custom	Before call to function getCategoryCustom
10	0.71084499359131	After getting category custom	After call to function getCategoryCustom
11	0.71084904670715	Before getting category custom	Before call to function getCategoryCustom
12	0.72533202171326	After getting category custom	After call to function getCategoryCustom
13	0.72533488273621	Before getting category custom	Before call to function getCategoryCustom
14	0.73412084579468	After getting category custom	After call to function getCategoryCustom
15	0.73412299156189	Before getting category custom	Before call to function getCategoryCustom
16	0.7406849861145	After getting category custom	After call to function getCategoryCustom
17	0.74068689346313	Before getting category custom	Before call to function getCategoryCustom
18	0.74658799171448	After getting category custom	After call to function getCategoryCustom
19	0.74658989906311	Before getting category custom	Before call to function getCategoryCustom
20	0.75387692451477	After getting category custom	After call to function getCategoryCustom
21	0.7538800239563	End of GetCategoryList function	End of the function
22	0.75388598442078	Get Category List for Group	Before the call to getCategoryList function
23	0.75388789176941	Start of GetCategoryList function	Start of the function
24	0.75389099121094	Before getting categories	Query to get specific category list
25	0.75449585914612	End of getCategoryListByGroup Function	Before return()
26	1.3022079467773	App Controller End	End of the App controller (called before the controller of every page)
27	1.314553976059	Start of GetCategoryList function	Start of the function
28	1.3145580291748	Before getting categories	Query to get specific category list
29	1.3154299259186	After getting categories	Query to get specific category list
30	1.3154320716858	Before getting category custom	Before call to function getCategoryCustom
31	1.3351919651031	After getting category custom	After call to function getCategoryCustom
32	1.3351950645447	Before getting sub category list	Before call to recursive function getCategoryList
33	1.3351979255676	Start of GetCategoryList function	Start of the function
34	1.3352038860321	Before getting categories	Query to get specific category list
35	1.3358910083771	After getting sub category list	After call to recursive function getCategoryList
36	1.3358938694	Before getting category custom	Before call to function getCategoryCustom
37	1.3487110137939	After getting category custom	After call to function getCategoryCustom
38	1.3487129211426	Before getting sub category list	Before call to recursive function getCategoryList
39	1.3487150669098	Start of GetCategoryList function	Start of the function
40	1.3487169742584	Before getting categories	Query to get specific category list
41	1.3493208885193	After getting sub category list	After call to recursive function getCategoryList
42	1.3493230342865	Before getting category custom	Before call to function getCategoryCustom
43	1.3571748733521	After getting category custom	After call to function getCategoryCustom
44	1.3571770191193	Before getting sub category list	Before call to recursive function getCategoryList
45	1.3571779727936	Start of GetCategoryList function	Start of the function
46	1.3571798801422	Before getting categories	Query to get specific category list
47	1.3577609062195	After getting sub category list	After call to recursive function getCategoryList
48	1.3577630519867	Before getting category custom	Before call to function getCategoryCustom
49	1.3634870052338	After getting category custom	After call to function getCategoryCustom
50	1.3634889125824	Before getting sub category list	Before call to recursive function getCategoryList
51	1.3634898662567	Start of GetCategoryList function	Start of the function
52	1.3634920120239	Before getting categories	Query to get specific category list
53	1.3641119003296	After getting sub category list	After call to recursive function getCategoryList
54	1.3641140460968	Before getting category custom	Before call to function getCategoryCustom
55	1.3697860240936	After getting category custom	After call to function getCategoryCustom
56	1.3697879314423	Before getting sub category list	Before call to recursive function getCategoryList
57	1.3697888851166	Start of GetCategoryList function	Start of the function
58	1.3697910308838	Before getting categories	Query to get specific category list
59	1.3704228401184	After getting sub category list	After call to recursive function getCategoryList
60	1.3704249858856	Before getting category custom	Before call to function getCategoryCustom
61	1.375983953476	After getting category custom	After call to function getCategoryCustom
62	1.3759849071503	Before getting sub category list	Before call to recursive function getCategoryList
63	1.3759858608246	Start of GetCategoryList function	Start of the function
64	1.3759880065918	Before getting categories	Query to get specific category list
65	1.3765540122986	After getting sub category list	After call to recursive function getCategoryList
66	1.3765559196472	End of GetCategoryList function	End of the function
67	1.8627638816833	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
68	1.8638989925385	Before Get Options	Before the call to getOptions in the tpl class
69	1.9553570747375	After Get Options	After the call to getOptions in the tpl class
70	1.9553959369659	App_after Controller End	End of the App_after controller (called after the controller of every page)
71	2.0362780094147	Finalizing debug	Before the debug is output to the page.
72	2.0362930297852	End of App	This is the end of the app logging, final timestamp

Query Debug - 808 Database Queries. Total time 1.3102 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:12:\"3.12.146.111\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1722055128'
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.12.146.111') >= INET_ATON(ip_start) AND INET_ATON('3.12.146.111') <= 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 0, 59
SELECT * FROM productimages WHERE product_id = '2214' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2214' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '2214'
SELECT * FROM productcustomimages WHERE product_id = '2214'
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 = '2214'
                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     = '2214'
                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 = 2214
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2214' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2214' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2214' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2214
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2214'
                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 = '2214'
                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     = '2214'
                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 = 2214
SELECT value FROM productattributes WHERE product_id = '2214' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '2214'
SELECT * FROM productimages WHERE product_id = '1445' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1445'
SELECT * FROM productcustomimages WHERE product_id = '1445'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1445' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1445' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1445' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1445
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1445'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1445' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1535' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1535'
SELECT * FROM productcustomimages WHERE product_id = '1535'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1535' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1535' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1535' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1535
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1535'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1535' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '2021' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2021'
SELECT * FROM productcustomimages WHERE product_id = '2021'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2021' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2021' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2021' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2021
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2021'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2021' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1458' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1458'
SELECT * FROM productcustomimages WHERE product_id = '1458'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1458' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1458' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1458' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1458' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1221' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1221'
SELECT * FROM productcustomimages WHERE product_id = '1221'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1221' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1221' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1221' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1221
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1221'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1221' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '2954' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2954'
SELECT * FROM productcustomimages WHERE product_id = '2954'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2954' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2954' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2954' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2954
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2954'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2954' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '778' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '778'
SELECT * FROM productcustomimages WHERE product_id = '778'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '778' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '778' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '778' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 778
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '778'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '778' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1854' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1854'
SELECT * FROM productcustomimages WHERE product_id = '1854'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1854' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1854' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1854' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1854
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1854'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1854' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '3897' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3897'
SELECT * FROM productcustomimages WHERE product_id = '3897'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3897' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3897' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3897' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3897
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3897'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3897' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4944' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4944'
SELECT * FROM productcustomimages WHERE product_id = '4944'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4944' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4944' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4944' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4944
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4944'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '4944' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '2439' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2439'
SELECT * FROM productcustomimages WHERE product_id = '2439'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2439' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2439' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2439' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2439
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2439'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2439' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4148' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4148'
SELECT * FROM productcustomimages WHERE product_id = '4148'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4148' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4148' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4148' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4148' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4059' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4059'
SELECT * FROM productcustomimages WHERE product_id = '4059'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4059' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4059' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4059' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4059' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1873' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1873'
SELECT * FROM productcustomimages WHERE product_id = '1873'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1873' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1873' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1873' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1873
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1873'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1873' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '3348' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3348' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3348'
SELECT * FROM productcustomimages WHERE product_id = '3348'
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 = '3348'
                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     = '3348'
                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 = 3348
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3348' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3348' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3348' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3348
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3348'
                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 = '3348'
                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     = '3348'
                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 = 3348
SELECT value FROM productattributes WHERE product_id = '3348' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3348'
                  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 = '3775' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3775'
SELECT * FROM productcustomimages WHERE product_id = '3775'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3775' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3775' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3775' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3775
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3775'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3775' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4930' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4930'
SELECT * FROM productcustomimages WHERE product_id = '4930'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4930' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4930' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4930' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4930' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '3693' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3693' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3693'
SELECT * FROM productcustomimages WHERE product_id = '3693'
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 = '3693'
                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     = '3693'
                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 = 3693
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3693' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3693' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3693' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3693
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3693'
                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 = '3693'
                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     = '3693'
                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 = 3693
SELECT value FROM productattributes WHERE product_id = '3693' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3693'
                  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 = '3940' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3940' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3940'
SELECT * FROM productcustomimages WHERE product_id = '3940'
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 = '3940'
                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     = '3940'
                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 = 3940
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3940' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3940' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3940' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3940
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3940'
                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 = '3940'
                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     = '3940'
                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 = 3940
SELECT value FROM productattributes WHERE product_id = '3940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '3940'
SELECT * FROM productimages WHERE product_id = '3728' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3728'
SELECT * FROM productcustomimages WHERE product_id = '3728'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3728' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3728' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3728' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3728
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3728'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3728' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '3234' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3234'
SELECT * FROM productcustomimages WHERE product_id = '3234'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3234' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3234' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3234' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3234
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3234'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3234' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '812' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '812'
SELECT * FROM productcustomimages WHERE product_id = '812'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '812' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '812' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '812' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 812
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '812'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4559' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4559' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4559'
SELECT * FROM productcustomimages WHERE product_id = '4559'
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 = '4559'
                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     = '4559'
                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 = 4559
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4559' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4559' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4559' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4559
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4559'
                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 = '4559'
                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     = '4559'
                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 = 4559
SELECT value FROM productattributes WHERE product_id = '4559' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4559'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM productimages WHERE product_id = '4292' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4292' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4292'
SELECT * FROM productcustomimages WHERE product_id = '4292'
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 = '4292'
                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     = '4292'
                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 = 4292
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4292' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4292' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4292' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4292
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4292'
                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 = '4292'
                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     = '4292'
                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 = 4292
SELECT value FROM productattributes WHERE product_id = '4292' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '4292'
SELECT * FROM productimages WHERE product_id = '4061' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4061' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4061'
SELECT * FROM productcustomimages WHERE product_id = '4061'
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 = '4061'
                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     = '4061'
                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 = 4061
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4061' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4061' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4061' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4061
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4061'
                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 = '4061'
                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     = '4061'
                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 = 4061
SELECT value FROM productattributes WHERE product_id = '4061' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '4061'
SELECT * FROM productimages WHERE product_id = '2564' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2564'
SELECT * FROM productcustomimages WHERE product_id = '2564'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2564' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2564' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2564' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2564
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2564'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2564' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '3129' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3129'
SELECT * FROM productcustomimages WHERE product_id = '3129'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3129' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3129' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3129' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3129
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3129'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3129' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1892' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1892'
SELECT * FROM productcustomimages WHERE product_id = '1892'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1892' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1892' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1892' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1892
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1892'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1892' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1617' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1617'
SELECT * FROM productcustomimages WHERE product_id = '1617'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1617' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1617' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1617' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1617
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1617'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1617' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1323' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1323'
SELECT * FROM productcustomimages WHERE product_id = '1323'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1323' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1323' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1323' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1323
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1323'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1323' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1322' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1322'
SELECT * FROM productcustomimages WHERE product_id = '1322'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1322' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1322' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1322' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1322
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1322'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1322' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '870' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '870'
SELECT * FROM productcustomimages WHERE product_id = '870'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '870' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '870' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '870' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 870
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '870'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '870' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '962' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '962'
SELECT * FROM productcustomimages WHERE product_id = '962'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '962' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '962' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '962' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 962
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '962'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '962' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1318' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1318'
SELECT * FROM productcustomimages WHERE product_id = '1318'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1318' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1318' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1318' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1318
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1318'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1318' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '864' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '864'
SELECT * FROM productcustomimages WHERE product_id = '864'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '864' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '864' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '864' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 864
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '864'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '864' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '854' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '854'
SELECT * FROM productcustomimages WHERE product_id = '854'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '854' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '854' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '854' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 854
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '854'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '854' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1270' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1270'
SELECT * FROM productcustomimages WHERE product_id = '1270'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1270' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1270' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1270' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1270
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1270'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1270' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4201' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4201' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4201'
SELECT * FROM productcustomimages WHERE product_id = '4201'
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 = '4201'
                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     = '4201'
                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 = 4201
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4201' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4201' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4201' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4201
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4201'
                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 = '4201'
                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     = '4201'
                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 = 4201
SELECT value FROM productattributes WHERE product_id = '4201' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '4201'
SELECT * FROM productimages WHERE product_id = '3588' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3588'
SELECT * FROM productcustomimages WHERE product_id = '3588'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3588' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3588' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3588' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '3524' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3524'
SELECT * FROM productcustomimages WHERE product_id = '3524'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3524' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3524' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3524' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3524' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4202' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4202'
SELECT * FROM productcustomimages WHERE product_id = '4202'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4202' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4202' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4202' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4202' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '3578' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3578' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3578'
SELECT * FROM productcustomimages WHERE product_id = '3578'
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 = '3578'
                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     = '3578'
                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 = 3578
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3578' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3578' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3578' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3578
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3578'
                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 = '3578'
                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     = '3578'
                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 = 3578
SELECT value FROM productattributes WHERE product_id = '3578' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '3578'
SELECT * FROM productimages WHERE product_id = '3587' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3587'
SELECT * FROM productcustomimages WHERE product_id = '3587'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3587' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3587' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3587' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3587' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '3525' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3525'
SELECT * FROM productcustomimages WHERE product_id = '3525'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3525' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3525' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3525' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3525' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '867' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '867'
SELECT * FROM productcustomimages WHERE product_id = '867'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '867' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '867' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '867' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 867
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '867'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '867' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4570' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4570' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4570'
SELECT * FROM productcustomimages WHERE product_id = '4570'
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 = '4570'
                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     = '4570'
                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 = 4570
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4570' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4570' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4570' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4570
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4570'
                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 = '4570'
                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     = '4570'
                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 = 4570
SELECT value FROM productattributes WHERE product_id = '4570' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4570'
                  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 = '4570'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4645' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4645' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4645' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4645
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4645'
                AND name = 'ListPriceAmount'
SELECT * FROM productimages WHERE product_id = '1108' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1108'
SELECT * FROM productcustomimages WHERE product_id = '1108'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1108' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1108' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1108' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1108
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1108'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1108' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1215' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1215'
SELECT * FROM productcustomimages WHERE product_id = '1215'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1215' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1215' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1215' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1215' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1140' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1140'
SELECT * FROM productcustomimages WHERE product_id = '1140'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1140' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1140' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1140' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1140' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4006' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4006'
SELECT * FROM productcustomimages WHERE product_id = '4006'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4006' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4006' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4006' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4006
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4006'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '4006' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '762' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '762'
SELECT * FROM productcustomimages WHERE product_id = '762'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '762' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '762' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '762' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 762
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '762'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '762' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4921' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4921'
SELECT * FROM productcustomimages WHERE product_id = '4921'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4921' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4921' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4921' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4921' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '2234' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2234'
SELECT * FROM productcustomimages WHERE product_id = '2234'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2234' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2234' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2234' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2234
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2234'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2234' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4769' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4769' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4769'
SELECT * FROM productcustomimages WHERE product_id = '4769'
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 = '4769'
                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     = '4769'
                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 = 4769
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4769' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4769' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4769' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4769
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4769'
                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 = '4769'
                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     = '4769'
                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 = 4769
SELECT value FROM productattributes WHERE product_id = '4769' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '4769'
SELECT * FROM productimages WHERE product_id = '1319' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1319'
SELECT * FROM productcustomimages WHERE product_id = '1319'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1319' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1319' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1319' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1319' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1476' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1476'
SELECT * FROM productcustomimages WHERE product_id = '1476'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1476' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1476' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1476' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1476
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1476'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1476' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1349' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1349'
SELECT * FROM productcustomimages WHERE product_id = '1349'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1349' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1349' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1349' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1349' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '2109' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2109'
SELECT * FROM productcustomimages WHERE product_id = '2109'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2109' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2109' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2109' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2109
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2109'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2109' 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'