SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'

SHOW TABLES LIKE 'bad_bots'

SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'

SELECT * FROM `bad_bots`

SELECT parameter, value FROM parameters

SET time_zone = 'Europe/London'

SELECT * FROM autorun ORDER BY lastrun ASC

SELECT * FROM version ORDER BY installed DESC LIMIT 1

SELECT id FROM pages WHERE pagename = 'mardingtop-5060656510l-mochila-tactica-militar-molle-mochila-de-asalto-acampada-senderismo-deporte' LIMIT 1

SELECT id FROM products WHERE pagename = 'mardingtop-5060656510l-mochila-tactica-militar-molle-mochila-de-asalto-acampada-senderismo-deporte' AND hidden = 0 LIMIT 1

SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'

SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'es'

SELECT * FROM pages WHERE pagename = 'mardingtop-5060656510l-mochila-tactica-militar-molle-mochila-de-asalto-acampada-senderismo-deporte'

SELECT * FROM categorygroups ORDER BY sortorder ASC

SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  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 = 70

SELECT id FROM categories WHERE parent_id = '70'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (70)
				  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 (70)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (70)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '70'

SELECT * FROM categorygroups WHERE id = '2'

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 = 66

SELECT id FROM categories WHERE parent_id = '66'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (66)
				  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 (66)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'

SELECT * FROM categorygroups WHERE id = '2'

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 = 67

SELECT id FROM categories WHERE parent_id = '67'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (67)
				  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 (67)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (67)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '67'

SELECT * FROM categorygroups WHERE id = '2'

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 = 56

SELECT id FROM categories WHERE parent_id = '56'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (56)
				  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 (56)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (56)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '56'

SELECT * FROM categorygroups WHERE id = '2'

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 = 59

SELECT id FROM categories WHERE parent_id = '59'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (59)
				  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 (59)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (59)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '59'

SELECT * FROM categorygroups WHERE id = '2'

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 = 61

SELECT id FROM categories WHERE parent_id = '61'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (61)
				  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 (61)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (61)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'

SELECT * FROM categorygroups WHERE id = '2'

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 = 62

SELECT id FROM categories WHERE parent_id = '62'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (62)
				  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 (62)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (62)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '62'

SELECT * FROM categorygroups WHERE id = '2'

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 = 68

SELECT id FROM categories WHERE parent_id = '68'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (68)
				  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 (68)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (68)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'

SELECT * FROM categorygroups WHERE id = '2'

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 = 69

SELECT id FROM categories WHERE parent_id = '69'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (69)
				  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 (69)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (69)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'

SELECT * FROM categorygroups WHERE id = '2'

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 = 29

SELECT id FROM categories WHERE parent_id = '29'

SELECT id FROM categories WHERE parent_id = '30'

SELECT id FROM categories WHERE parent_id = '31'

SELECT id FROM categories WHERE parent_id = '32'

SELECT id FROM categories WHERE parent_id = '33'

SELECT id FROM categories WHERE parent_id = '34'

SELECT id FROM categories WHERE parent_id = '35'

SELECT id FROM categories WHERE parent_id = '39'

SELECT id FROM categories WHERE parent_id = '41'

SELECT id FROM categories WHERE parent_id = '36'

SELECT id FROM categories WHERE parent_id = '37'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30,31,32,33,34,35,39,41,36,37,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 (30,31,32,33,34,35,39,41,36,37,29)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (30,31,32,33,34,35,39,41,36,37,29)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 

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 = 52

SELECT id FROM categories WHERE parent_id = '52'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (52)
				  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 (52)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (52)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '52'

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 = 51

SELECT id FROM categories WHERE parent_id = '51'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (51)
				  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 (51)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (51)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'

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 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(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 

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 = 43

SELECT id FROM categories WHERE parent_id = '43'

SELECT id FROM categories WHERE parent_id = '44'

SELECT id FROM categories WHERE parent_id = '45'

SELECT id FROM categories WHERE parent_id = '46'

SELECT id FROM categories WHERE parent_id = '47'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (44,45,46,47,43)
				  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 (44,45,46,47,43)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (44,45,46,47,43)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '43'

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 = 50

SELECT id FROM categories WHERE parent_id = '50'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (50)
				  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 (50)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (50)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'

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 = 54

SELECT id FROM categories WHERE parent_id = '54'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (54)
				  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 (54)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (54)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '54'

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 = 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(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 

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 = 38

SELECT id FROM categories WHERE parent_id = '38'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (38)
				  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 (38)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (38)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'

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 = 48

SELECT id FROM categories WHERE parent_id = '48'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (48)
				  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 (48)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (48)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '48'

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 = 49

SELECT id FROM categories WHERE parent_id = '49'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (49)
				  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 (49)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (49)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'

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 = 55

SELECT id FROM categories WHERE parent_id = '55'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (55)
				  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 (55)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (55)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '55'

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 id FROM categories WHERE parent_id = '27'

SELECT id FROM categories WHERE parent_id = '65'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (65,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 (65,27)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65,27)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'

SELECT * FROM categorygroups WHERE id = '1'

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-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC

SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 

SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 

SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 

SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 

SELECT * FROM pages WHERE core = 1 ORDER BY pagekey

SELECT * FROM products WHERE pagename = 'mardingtop-5060656510l-mochila-tactica-militar-molle-mochila-de-asalto-acampada-senderismo-deporte'

SELECT * FROM manufacturers WHERE id = '2189'

SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '2189'

SELECT filename FROM manufacturerimages WHERE manufacturer_id = '2189' LIMIT 1

SELECT pagename, id FROM products p WHERE manufacturer_id = '2189' ORDER BY RAND() LIMIT 1

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

SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '2189'

SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '2189'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 

SELECT * FROM manufacturerimages WHERE manufacturer_id = '2189'

SELECT category_id FROM products_categories WHERE product_id = '27049'

SELECT * FROM categories WHERE id = '67'

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 = 67

SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 67

SELECT id FROM categories WHERE parent_id = '67'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (67)
				  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 (67)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (67)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '67'

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

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

SELECT * FROM product_image_select WHERE product_id = '27049'

SELECT * FROM productcustomimages WHERE product_id = '27049'

SELECT * FROM productfeeds WHERE product_id = '27049' ORDER BY item_date DESC

SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '27049' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0

SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '27049' AND t.hidden = 0 AND display_product = 1

SELECT * FROM tags WHERE id = '17906'

SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '17906'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0

SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '17906'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 

SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '17906' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1

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

SELECT * FROM productamazoncontent WHERE product_id = '27049'

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

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

SELECT * FROM productoffers WHERE product_id = '27049' AND merchantid = ''

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

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

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

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

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

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

SELECT *, MATCH (description, keyfeatures, title) AGAINST ('mochila' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('mochila' IN BOOLEAN MODE) AND 27049 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6

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

SELECT * FROM product_image_select WHERE product_id = '6069'

SELECT * FROM productcustomimages WHERE product_id = '6069'

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

SELECT * FROM productoffers WHERE product_id = '6069' AND merchantid = ''

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

UPDATE products SET price = '3900' WHERE id = '6069'

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

SELECT * FROM product_image_select WHERE product_id = '10920'

SELECT * FROM productcustomimages WHERE product_id = '10920'

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

SELECT * FROM productoffers WHERE product_id = '10920' AND merchantid = ''

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

UPDATE products SET price = '2134' WHERE id = '10920'

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

SELECT * FROM product_image_select WHERE product_id = '12646'

SELECT * FROM productcustomimages WHERE product_id = '12646'

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

SELECT * FROM productoffers WHERE product_id = '12646' AND merchantid = ''

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

UPDATE products SET price = '5995' WHERE id = '12646'

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

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

SELECT * FROM product_image_select WHERE product_id = '8358'

SELECT * FROM productcustomimages WHERE product_id = '8358'

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

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

SELECT * FROM productoffers WHERE product_id = '8358' AND merchantid = ''

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

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

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

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

UPDATE products SET price = '3299' WHERE id = '8358'

SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '8358'
                  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 = '11296' ORDER BY sortorder ASC

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

SELECT * FROM product_image_select WHERE product_id = '11296'

SELECT * FROM productcustomimages WHERE product_id = '11296'

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

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

SELECT * FROM productoffers WHERE product_id = '11296' AND merchantid = ''

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

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

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

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

UPDATE products SET price = '8199' WHERE id = '11296'

SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '11296'
                  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 = '8924' ORDER BY sortorder ASC

SELECT * FROM product_image_select WHERE product_id = '8924'

SELECT * FROM productcustomimages WHERE product_id = '8924'

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

SELECT * FROM productoffers WHERE product_id = '8924' AND merchantid = ''

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

UPDATE products SET price = '1890' WHERE id = '8924'

SELECT value FROM parameters WHERE parameter = 'EBAY_CACHE_TIME' 

SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 

SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 

SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 

SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 

SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 

SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 

SELECT * FROM ebay_products_cache WHERE cachekey = '58e175e4918e0595d435a09f14ebf28f' 

SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 

SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 

SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 

SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 

SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 

SELECT * FROM ebay_products_cache WHERE cachekey = '58e175e4918e0595d435a09f14ebf28f' 

SELECT id,asin FROM products WHERE parent_id = 27049

SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27306

SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27306

SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27308

SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27308

SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27310

SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27310

SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27311

SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27311

SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27312

SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27312

SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27313

SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27313

SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27314

SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27314

SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27315

SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27315

SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27316

SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27316

SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 27317

SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 27317

SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 28519

SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 28519

SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 29022

SELECT name,value FROM productoptions WHERE name="Color" AND product_id = 29022

SELECT category_id FROM products_categories WHERE product_id = '27049'

SELECT * FROM categories WHERE id = '67'

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 = 67

SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 67

SELECT id FROM categories WHERE parent_id = '67'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (67)
				  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 (67)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (67)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '67'

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

SELECT * FROM productoffers WHERE product_id = '27049' AND merchantid = ''

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

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

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

SELECT * FROM products WHERE id = '27049'

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

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

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

SELECT * FROM productoffers WHERE product_id = '27049' AND merchantid = ''

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

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

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

SELECT DISTINCT (name) FROM productoptions

SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 27049))

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

SELECT * FROM translationsfilter

SELECT category_id FROM products_categories WHERE product_id = '27049'

SELECT parent_id FROM categories WHERE id = '67'

SELECT * FROM categories WHERE id = '67'

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 = 67

SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 67

SELECT id FROM categories WHERE parent_id = '67'

SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (67)
				  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 (67)
				  AND p.disabled = 0 

SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (67)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 

SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '67'

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

SELECT * FROM pages WHERE id = 52

SELECT * FROM pages WHERE id = 53

SELECT * FROM pages WHERE id = 54

SELECT * FROM pages WHERE id = 51

SELECT * FROM pages WHERE id = 52

SELECT * FROM pages WHERE id = 53

SELECT * FROM pages WHERE id = 54

SELECT * FROM pages WHERE id = 51

SELECT p.id,p.parent_id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (p.price >= 1000 AND p.price <= 50000) 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 o.percentagesaved DESC LIMIT 4

UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"4\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:2:\"10\";s:8:\"maxprice\";s:3:\"500\";s:9:\"minimages\";s:1:\"1\";s:10:\"updatetime\";s:5:\"21600\";s:13:\"selectiontype\";s:13:\"specialoffers\";s:11:\"lastupdated\";i:1560652312;s:8:\"products\";a:4:{i:0;s:3:\"955\";i:1;s:4:\"1934\";i:2;s:3:\"758\";i:3;s:4:\"1322\";}}' WHERE id = '207'

SELECT * FROM products WHERE id IN (955,1934,758,1322) ORDER BY FIELD(id, 955,1934,758,1322 )

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

SELECT * FROM product_image_select WHERE product_id = '955'

SELECT * FROM productcustomimages WHERE product_id = '955'

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

SELECT * FROM productoffers WHERE product_id = '955' AND merchantid = ''

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

UPDATE products SET price = '7426' WHERE id = '955'

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

SELECT * FROM product_image_select WHERE product_id = '1934'

SELECT * FROM productcustomimages WHERE product_id = '1934'

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

SELECT * FROM productoffers WHERE product_id = '1934' AND merchantid = ''

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

UPDATE products SET price = '15048' WHERE id = '1934'

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

SELECT * FROM product_image_select WHERE product_id = '758'

SELECT * FROM productcustomimages WHERE product_id = '758'

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

SELECT * FROM productoffers WHERE product_id = '758' AND merchantid = ''

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

UPDATE products SET price = '3921' WHERE id = '758'

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

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

UPDATE products SET price = '10808' WHERE id = '1322'

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND textuid = '' AND language = 'en'

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