SELECT parameter, value FROM parameters

SELECT * FROM `bad_bots`

SET time_zone = 'Europe/London'

SELECT version FROM version ORDER BY `installed` DESC LIMIT 1

INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"216.73.216.66\";}'

INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1751621240'

SELECT * FROM autorun ORDER BY lastrun ASC

SELECT * FROM version ORDER BY installed DESC LIMIT 1

SELECT id FROM pages WHERE pagename = 'search' LIMIT 1

SELECT * FROM pages WHERE id = 52

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 = 'search'

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('216.73.216.66') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.66') <= INET_ATON(ip_end)

SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'

SELECT * FROM countryredirects WHERE countrycode = 'US'

SELECT * FROM pages WHERE pagename = 'search'

SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 

SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name

SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC

SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 

SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name

SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC

INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT 'palais des thes the vert genmaicha yama bote metal 130g', NOW(), '216.73.216.66'

SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1

SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1

SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE 'palais') OR (keyfeatures LIKE 'palais') OR (title LIKE 'palais') OR (description LIKE 'des') OR (keyfeatures LIKE 'des') OR (title LIKE 'des') OR (description LIKE 'thes') OR (keyfeatures LIKE 'thes') OR (title LIKE 'thes') OR (description LIKE 'the') OR (keyfeatures LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (keyfeatures LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'genmaicha') OR (keyfeatures LIKE 'genmaicha') OR (title LIKE 'genmaicha') OR (description LIKE 'yama') OR (keyfeatures LIKE 'yama') OR (title LIKE 'yama') OR (description LIKE 'bote') OR (keyfeatures LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'metal') OR (keyfeatures LIKE 'metal') OR (title LIKE 'metal') OR (description LIKE '130g') OR (keyfeatures LIKE '130g') OR (title LIKE '130g'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1

SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE 'palais') OR (title LIKE 'palais') OR (description LIKE 'des') OR (title LIKE 'des') OR (description LIKE 'thes') OR (title LIKE 'thes') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'genmaicha') OR (title LIKE 'genmaicha') OR (description LIKE 'yama') OR (title LIKE 'yama') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'metal') OR (title LIKE 'metal') OR (description LIKE '130g') OR (title LIKE '130g'))
		AND hide = 0

SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE 'palais') OR (title LIKE 'palais') OR (description LIKE 'des') OR (title LIKE 'des') OR (description LIKE 'thes') OR (title LIKE 'thes') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'genmaicha') OR (title LIKE 'genmaicha') OR (description LIKE 'yama') OR (title LIKE 'yama') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'metal') OR (title LIKE 'metal') OR (description LIKE '130g') OR (title LIKE '130g'))
		AND hide = 0

SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1

SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%palais%') OR (keyfeatures LIKE '%palais%') OR (title LIKE '%palais%') OR (description LIKE '%des%') OR (keyfeatures LIKE '%des%') OR (title LIKE '%des%') OR (description LIKE '%thes%') OR (keyfeatures LIKE '%thes%') OR (title LIKE '%thes%') OR (description LIKE '%the%') OR (keyfeatures LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (keyfeatures LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%genmaicha%') OR (keyfeatures LIKE '%genmaicha%') OR (title LIKE '%genmaicha%') OR (description LIKE '%yama%') OR (keyfeatures LIKE '%yama%') OR (title LIKE '%yama%') OR (description LIKE '%bote%') OR (keyfeatures LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%metal%') OR (keyfeatures LIKE '%metal%') OR (title LIKE '%metal%') OR (description LIKE '%130g%') OR (keyfeatures LIKE '%130g%') OR (title LIKE '%130g%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1

SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%palais%') OR (title LIKE '%palais%') OR (description LIKE '%des%') OR (title LIKE '%des%') OR (description LIKE '%thes%') OR (title LIKE '%thes%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%genmaicha%') OR (title LIKE '%genmaicha%') OR (description LIKE '%yama%') OR (title LIKE '%yama%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%metal%') OR (title LIKE '%metal%') OR (description LIKE '%130g%') OR (title LIKE '%130g%'))
		AND hide = 0

SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%palais%') OR (title LIKE '%palais%') OR (description LIKE '%des%') OR (title LIKE '%des%') OR (description LIKE '%thes%') OR (title LIKE '%thes%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%genmaicha%') OR (title LIKE '%genmaicha%') OR (description LIKE '%yama%') OR (title LIKE '%yama%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%metal%') OR (title LIKE '%metal%') OR (description LIKE '%130g%') OR (title LIKE '%130g%'))
		AND hide = 0

SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC

SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC

SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE 'palais') OR (keyfeatures LIKE 'palais') OR (title LIKE 'palais') OR (description LIKE 'des') OR (keyfeatures LIKE 'des') OR (title LIKE 'des') OR (description LIKE 'thes') OR (keyfeatures LIKE 'thes') OR (title LIKE 'thes') OR (description LIKE 'the') OR (keyfeatures LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (keyfeatures LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'genmaicha') OR (keyfeatures LIKE 'genmaicha') OR (title LIKE 'genmaicha') OR (description LIKE 'yama') OR (keyfeatures LIKE 'yama') OR (title LIKE 'yama') OR (description LIKE 'bote') OR (keyfeatures LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'metal') OR (keyfeatures LIKE 'metal') OR (title LIKE 'metal') OR (description LIKE '130g') OR (keyfeatures LIKE '130g') OR (title LIKE '130g'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC

SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE 'palais') OR (title LIKE 'palais') OR (description LIKE 'des') OR (title LIKE 'des') OR (description LIKE 'thes') OR (title LIKE 'thes') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'genmaicha') OR (title LIKE 'genmaicha') OR (description LIKE 'yama') OR (title LIKE 'yama') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'metal') OR (title LIKE 'metal') OR (description LIKE '130g') OR (title LIKE '130g'))
		AND hide = 0

SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE 'palais') OR (title LIKE 'palais') OR (description LIKE 'des') OR (title LIKE 'des') OR (description LIKE 'thes') OR (title LIKE 'thes') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'genmaicha') OR (title LIKE 'genmaicha') OR (description LIKE 'yama') OR (title LIKE 'yama') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'metal') OR (title LIKE 'metal') OR (description LIKE '130g') OR (title LIKE '130g'))
		AND hide = 0

SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+pala} +d} +th} +the +vert +genmaicha +yama +bote +metal +130g' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC

SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%palais%') OR (keyfeatures LIKE '%palais%') OR (title LIKE '%palais%') OR (description LIKE '%des%') OR (keyfeatures LIKE '%des%') OR (title LIKE '%des%') OR (description LIKE '%thes%') OR (keyfeatures LIKE '%thes%') OR (title LIKE '%thes%') OR (description LIKE '%the%') OR (keyfeatures LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (keyfeatures LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%genmaicha%') OR (keyfeatures LIKE '%genmaicha%') OR (title LIKE '%genmaicha%') OR (description LIKE '%yama%') OR (keyfeatures LIKE '%yama%') OR (title LIKE '%yama%') OR (description LIKE '%bote%') OR (keyfeatures LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%metal%') OR (keyfeatures LIKE '%metal%') OR (title LIKE '%metal%') OR (description LIKE '%130g%') OR (keyfeatures LIKE '%130g%') OR (title LIKE '%130g%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC

SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%palais%') OR (title LIKE '%palais%') OR (description LIKE '%des%') OR (title LIKE '%des%') OR (description LIKE '%thes%') OR (title LIKE '%thes%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%genmaicha%') OR (title LIKE '%genmaicha%') OR (description LIKE '%yama%') OR (title LIKE '%yama%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%metal%') OR (title LIKE '%metal%') OR (description LIKE '%130g%') OR (title LIKE '%130g%'))
		AND hide = 0

SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%palais%') OR (title LIKE '%palais%') OR (description LIKE '%des%') OR (title LIKE '%des%') OR (description LIKE '%thes%') OR (title LIKE '%thes%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%genmaicha%') OR (title LIKE '%genmaicha%') OR (description LIKE '%yama%') OR (title LIKE '%yama%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%metal%') OR (title LIKE '%metal%') OR (description LIKE '%130g%') OR (title LIKE '%130g%'))
		AND hide = 0

SELECT * FROM products WHERE id = '1462'

SELECT * FROM productimages WHERE product_id = '1462' ORDER BY sortorder ASC

SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1462' AND p.id = pi.product_id ORDER BY pi.sortorder

SELECT * FROM product_image_select WHERE product_id = '1462'

SELECT * FROM productcustomimages WHERE product_id = '1462'

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 = '1462'
                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     = '1462'
                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 = 1462

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1462' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '1462' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '1462' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 1462
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '1462'
                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 = '1462'
                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     = '1462'
                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 = 1462

SELECT * FROM products WHERE parent_id = '1462'

SELECT * FROM products WHERE id = '846'

SELECT * FROM productimages WHERE product_id = '846' ORDER BY sortorder ASC

SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '846' AND p.id = pi.product_id ORDER BY pi.sortorder

SELECT * FROM product_image_select WHERE product_id = '846'

SELECT * FROM productcustomimages WHERE product_id = '846'

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 = '846'
                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     = '846'
                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 = 846

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '846' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '846' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '846' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 846
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '846'
                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 = '846'
                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     = '846'
                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 = 846

SELECT value FROM productattributes WHERE product_id = '846' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '846'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC

SELECT * FROM products WHERE id = '1669'

SELECT * FROM productimages WHERE product_id = '1669' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '1669'

SELECT * FROM productcustomimages WHERE product_id = '1669'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1669' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '1669' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '1669' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 1669
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '1669'
                AND name = 'ListPriceAmount'

SELECT value FROM productattributes WHERE product_id = '1669' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '2633'

SELECT * FROM productimages WHERE product_id = '2633' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '2633'

SELECT * FROM productcustomimages WHERE product_id = '2633'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2633' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '2633' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '2633' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes WHERE product_id = '2633' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '1286'

SELECT * FROM productimages WHERE product_id = '1286' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '1286'

SELECT * FROM productcustomimages WHERE product_id = '1286'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1286' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '1286' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '1286' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes WHERE product_id = '1286' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '1629'

SELECT * FROM productimages WHERE product_id = '1629' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '1629'

SELECT * FROM productcustomimages WHERE product_id = '1629'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1629' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '1629' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '1629' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 1629
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '1629'
                AND name = 'ListPriceAmount'

SELECT value FROM productattributes WHERE product_id = '1629' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '1562'

SELECT * FROM productimages WHERE product_id = '1562' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '1562'

SELECT * FROM productcustomimages WHERE product_id = '1562'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1562' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '1562' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '1562' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 1562
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '1562'
                AND name = 'ListPriceAmount'

SELECT value FROM productattributes WHERE product_id = '1562' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '2602'

SELECT * FROM productimages WHERE product_id = '2602' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '2602'

SELECT * FROM productcustomimages WHERE product_id = '2602'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2602' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '2602' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '2602' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 2602
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '2602'
                AND name = 'ListPriceAmount'

SELECT value FROM productattributes WHERE product_id = '2602' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '1849'

SELECT * FROM productimages WHERE product_id = '1849' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '1849'

SELECT * FROM productcustomimages WHERE product_id = '1849'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1849' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '1849' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '1849' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes WHERE product_id = '1849' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '1302'

SELECT * FROM productimages WHERE product_id = '1302' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '1302'

SELECT * FROM productcustomimages WHERE product_id = '1302'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1302' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '1302' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '1302' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes WHERE product_id = '1302' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '3077'

SELECT * FROM productimages WHERE product_id = '3077' ORDER BY sortorder ASC

SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3077' AND p.id = pi.product_id ORDER BY pi.sortorder

SELECT * FROM product_image_select WHERE product_id = '3077'

SELECT * FROM productcustomimages WHERE product_id = '3077'

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 = '3077'
                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     = '3077'
                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 = 3077

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3077' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '3077' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '3077' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 3077
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '3077'
                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 = '3077'
                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     = '3077'
                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 = 3077

SELECT value FROM productattributes WHERE product_id = '3077' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3077'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC

SELECT * FROM products WHERE id = '1620'

SELECT * FROM productimages WHERE product_id = '1620' ORDER BY sortorder ASC

SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1620' AND p.id = pi.product_id ORDER BY pi.sortorder

SELECT * FROM product_image_select WHERE product_id = '1620'

SELECT * FROM productcustomimages WHERE product_id = '1620'

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 = '1620'
                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     = '1620'
                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 = 1620

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1620' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '1620' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '1620' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 1620
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '1620'
                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 = '1620'
                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     = '1620'
                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 = 1620

SELECT value FROM productattributes WHERE product_id = '1620' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1620'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC

SELECT * FROM products WHERE id = '3954'

SELECT * FROM productimages WHERE product_id = '3954' ORDER BY sortorder ASC

SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3954' AND p.id = pi.product_id ORDER BY pi.sortorder

SELECT * FROM product_image_select WHERE product_id = '3954'

SELECT * FROM productcustomimages WHERE product_id = '3954'

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 = '3954'
                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     = '3954'
                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 = 3954

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3954' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '3954' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '3954' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 3954
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '3954'
                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 = '3954'
                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     = '3954'
                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 = 3954

SELECT value FROM productattributes WHERE product_id = '3954' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE parent_id = '3954'

SELECT * FROM products WHERE id = '3531'

SELECT * FROM productimages WHERE product_id = '3531' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '3531'

SELECT * FROM productcustomimages WHERE product_id = '3531'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3531' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '3531' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '3531' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 3531
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '3531'
                AND name = 'ListPriceAmount'

SELECT value FROM productattributes WHERE product_id = '3531' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '2808'

SELECT * FROM productimages WHERE product_id = '2808' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '2808'

SELECT * FROM productcustomimages WHERE product_id = '2808'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2808' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '2808' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '2808' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes WHERE product_id = '2808' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '4766'

SELECT * FROM productimages WHERE product_id = '4766' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '4766'

SELECT * FROM productcustomimages WHERE product_id = '4766'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4766' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '4766' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '4766' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 4766
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '4766'
                AND name = 'ListPriceAmount'

SELECT value FROM productattributes WHERE product_id = '4766' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '3554'

SELECT * FROM productimages WHERE product_id = '3554' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '3554'

SELECT * FROM productcustomimages WHERE product_id = '3554'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3554' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '3554' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '3554' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 3554
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '3554'
                AND name = 'ListPriceAmount'

SELECT value FROM productattributes WHERE product_id = '3554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '767'

SELECT * FROM productimages WHERE product_id = '767' ORDER BY sortorder ASC

SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '767' AND p.id = pi.product_id ORDER BY pi.sortorder

SELECT * FROM product_image_select WHERE product_id = '767'

SELECT * FROM productcustomimages WHERE product_id = '767'

SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '767'
                GROUP BY o.product_id

SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '767'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC

SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 767

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '767' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '767' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '767' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT * FROM productoffers
                WHERE product_id = 767
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes
                WHERE product_id = '767'
                AND name = 'ListPriceAmount'

SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '767'
                GROUP BY o.product_id

SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '767'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC

SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 767

SELECT value FROM productattributes WHERE product_id = '767' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '767'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1462' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '846' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1669' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2633' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1286' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1629' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1562' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2602' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1849' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1302' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3077' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1620' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3954' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3531' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2808' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4766' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3554' ORDER BY timestamp DESC

SELECT * FROM customerreviews WHERE approved = 1 AND productid = '767' ORDER BY timestamp DESC

SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'

SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'

SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'

SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6

SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6

SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6

SELECT * FROM products WHERE id = 1626

SELECT * FROM products WHERE id = 4041

SELECT * FROM products WHERE id = 4312

SELECT * FROM products WHERE id = 777

SELECT * FROM products WHERE id = 3881

SELECT * FROM products WHERE id = 4213

SELECT * FROM products WHERE id = '1626'

SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '1626'

SELECT * FROM productcustomimages WHERE product_id = '1626'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '4041'

SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '4041'

SELECT * FROM productcustomimages WHERE product_id = '4041'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '4312'

SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '4312'

SELECT * FROM productcustomimages WHERE product_id = '4312'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '777'

SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '777'

SELECT * FROM productcustomimages WHERE product_id = '777'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '3881'

SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '3881'

SELECT * FROM productcustomimages WHERE product_id = '3881'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM products WHERE id = '4213'

SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '4213'

SELECT * FROM productcustomimages WHERE product_id = '4213'

SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname

SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'

SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1

SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1

SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC

SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC

SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''

SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'

SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'

SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'

SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'