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
1.3532309532166	808	0.5083	0

No Amazon API Requests Made.

App Debug - Total Time 1.3532309532166 seconds

Number	Time From Start	Name	Description
1	0.70053386688232	Initialise	Initialise FSB Function
2	0.70283889770508	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.70539903640747	Start of getCategoryListByGroup Function	Before first category groups query
4	0.70575189590454	After initial query	Before first category groups query
5	0.70575404167175	Get Category List for Group	Before the call to getCategoryList function
6	0.7057569026947	Start of GetCategoryList function	Start of the function
7	0.70576095581055	Before getting categories	Query to get specific category list
8	0.70616602897644	After getting categories	Query to get specific category list
9	0.7061710357666	Before getting category custom	Before call to function getCategoryCustom
10	0.7308030128479	After getting category custom	After call to function getCategoryCustom
11	0.73080587387085	Before getting category custom	Before call to function getCategoryCustom
12	0.75295686721802	After getting category custom	After call to function getCategoryCustom
13	0.75295901298523	Before getting category custom	Before call to function getCategoryCustom
14	0.75640988349915	After getting category custom	After call to function getCategoryCustom
15	0.75641202926636	Before getting category custom	Before call to function getCategoryCustom
16	0.76081800460815	After getting category custom	After call to function getCategoryCustom
17	0.76081991195679	Before getting category custom	Before call to function getCategoryCustom
18	0.76533389091492	After getting category custom	After call to function getCategoryCustom
19	0.76533603668213	Before getting category custom	Before call to function getCategoryCustom
20	0.76866793632507	After getting category custom	After call to function getCategoryCustom
21	0.76866984367371	End of GetCategoryList function	End of the function
22	0.76867389678955	Get Category List for Group	Before the call to getCategoryList function
23	0.76867485046387	Start of GetCategoryList function	Start of the function
24	0.76867699623108	Before getting categories	Query to get specific category list
25	0.76896905899048	End of getCategoryListByGroup Function	Before return()
26	0.77411103248596	App Controller End	End of the App controller (called before the controller of every page)
27	0.80520701408386	Start of GetCategoryList function	Start of the function
28	0.80521202087402	Before getting categories	Query to get specific category list
29	0.80604791641235	After getting categories	Query to get specific category list
30	0.80605506896973	Before getting category custom	Before call to function getCategoryCustom
31	0.81209397315979	After getting category custom	After call to function getCategoryCustom
32	0.81209707260132	Before getting sub category list	Before call to recursive function getCategoryList
33	0.81210088729858	Start of GetCategoryList function	Start of the function
34	0.81210994720459	Before getting categories	Query to get specific category list
35	0.81274485588074	After getting sub category list	After call to recursive function getCategoryList
36	0.81274700164795	Before getting category custom	Before call to function getCategoryCustom
37	0.81533885002136	After getting category custom	After call to function getCategoryCustom
38	0.81534099578857	Before getting sub category list	Before call to recursive function getCategoryList
39	0.81534290313721	Start of GetCategoryList function	Start of the function
40	0.81534504890442	Before getting categories	Query to get specific category list
41	0.81594395637512	After getting sub category list	After call to recursive function getCategoryList
42	0.81594705581665	Before getting category custom	Before call to function getCategoryCustom
43	0.81928992271423	After getting category custom	After call to function getCategoryCustom
44	0.81929302215576	Before getting sub category list	Before call to recursive function getCategoryList
45	0.81929492950439	Start of GetCategoryList function	Start of the function
46	0.81929707527161	Before getting categories	Query to get specific category list
47	0.8198778629303	After getting sub category list	After call to recursive function getCategoryList
48	0.81988096237183	Before getting category custom	Before call to function getCategoryCustom
49	0.82226800918579	After getting category custom	After call to function getCategoryCustom
50	0.82226991653442	Before getting sub category list	Before call to recursive function getCategoryList
51	0.82227301597595	Start of GetCategoryList function	Start of the function
52	0.82227492332458	Before getting categories	Query to get specific category list
53	0.82303404808044	After getting sub category list	After call to recursive function getCategoryList
54	0.82303595542908	Before getting category custom	Before call to function getCategoryCustom
55	0.82555103302002	After getting category custom	After call to function getCategoryCustom
56	0.82555294036865	Before getting sub category list	Before call to recursive function getCategoryList
57	0.82555484771729	Start of GetCategoryList function	Start of the function
58	0.8255569934845	Before getting categories	Query to get specific category list
59	0.82602787017822	After getting sub category list	After call to recursive function getCategoryList
60	0.82603001594543	Before getting category custom	Before call to function getCategoryCustom
61	0.82819604873657	After getting category custom	After call to function getCategoryCustom
62	0.82819795608521	Before getting sub category list	Before call to recursive function getCategoryList
63	0.82820105552673	Start of GetCategoryList function	Start of the function
64	0.82820200920105	Before getting categories	Query to get specific category list
65	0.82866287231445	After getting sub category list	After call to recursive function getCategoryList
66	0.82867097854614	End of GetCategoryList function	End of the function
67	1.2257950305939	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
68	1.2264819145203	Before Get Options	Before the call to getOptions in the tpl class
69	1.2524790763855	After Get Options	After the call to getOptions in the tpl class
70	1.2525119781494	App_after Controller End	End of the App_after controller (called after the controller of every page)
71	1.353208065033	Finalizing debug	Before the debug is output to the page.
72	1.3532290458679	End of App	This is the end of the app logging, final timestamp

Query Debug - 808 Database Queries. Total time 0.5083 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:\"34.232.63.94\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1679434500'
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('34.232.63.94') >= INET_ATON(ip_start) AND INET_ATON('34.232.63.94') <= 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 = '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 = '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 = '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 = '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 = '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 = '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 = 4213
SELECT * FROM products WHERE id = 3881
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 = '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 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 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'