Familiecadeautjes

SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://mini-love.nl/'

SELECT *
FROM oc_setting
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC

SELECT *
FROM `oc_language`
WHERE status = '1'

SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/dutch.php'

SELECT *
FROM oc_currency

SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'

SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'

SELECT *
FROM oc_setting
WHERE `store_id` = 0 AND `key` = 'tsb_theme' AND `group` = 'tsb_theme'

SELECT *
FROM oc_language
ORDER BY sort_order, name

SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/tsb_theme/theme.lang.php'

SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/tsb_theme/theme.lang.php'

SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/tsb_theme/global.lang.php'

SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/tsb_theme/global.lang.php'

SELECT *
FROM oc_setting
WHERE `store_id` = 0 AND `key` = 'extensions' AND `group` = 'tsb_theme'

SELECT *
FROM oc_url_alias
WHERE keyword = 'mama-amp-papa' AND language_id = 2

SELECT *
FROM oc_category_to_layout
WHERE category_id = '95' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_category AS c
LEFT JOIN oc_category_description AS cd ON (c.category_id = cd.category_id)
WHERE c.category_id = 95 AND cd.language_id = 2

SELECT c.*, cd.*, COUNT(p2c.category_id) AS products_count
FROM oc_category c
INNER JOIN oc_category_description cd ON (c.category_id = cd.category_id)
INNER JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN oc_product_to_store AS p2s ON p2s.store_id = c2s.store_id
LEFT JOIN oc_product_to_category AS p2c ON c.category_id = p2c.category_id AND p2c.product_id = p2s.product_id
LEFT JOIN oc_product p ON p.product_id = p2s.product_id
WHERE c.parent_id = 95 AND cd.language_id = 2 AND c2s.store_id = 0 AND c.status = 1 AND c.sort_order <> -1 AND p.status=1 GROUP BY c.category_id
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=125' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=121' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=115' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=117' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=105' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=103' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=110' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=118' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=119' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=107' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=112' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=131' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=129' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=78' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=78' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=168' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=78' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=169' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=78' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=171' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=122' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=133' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=133' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=141' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=133' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=142' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=133' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=143' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=97' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=97' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=153' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=150' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=150' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=154' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=150' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=155' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=150' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=191' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=150' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=190' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=150' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=150' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=192' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=150' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=188' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=135' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=136' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=126' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=148' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=147' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=138' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=199' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=201' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=137' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=144' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=198' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=130' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=196' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=195' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=193' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=197' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=194' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=104' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=104' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=200' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=124' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=123' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=134' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128' AND language_id = '2'

SELECT *
FROM oc_extension
WHERE `type` = 'module'

SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/common/footer.php'

SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0' AND p2c.category_id IN (106,125,121,115,117,105,103,110,118,119,107,112,131,111,129,100)
ORDER BY m.sort_order, LCASE(m.name) ASC

SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0' AND p2c.category_id IN (168,169,171,78)
ORDER BY m.sort_order, LCASE(m.name) ASC

SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0' AND p2c.category_id IN (122)
ORDER BY m.sort_order, LCASE(m.name) ASC

SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0' AND p2c.category_id IN (141,142,143,133)
ORDER BY m.sort_order, LCASE(m.name) ASC

SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0' AND p2c.category_id IN (153,97)
ORDER BY m.sort_order, LCASE(m.name) ASC

SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0' AND p2c.category_id IN (154,155,191,190,189,192,188,150)
ORDER BY m.sort_order, LCASE(m.name) ASC

SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0' AND p2c.category_id IN (135,136,126,151,148,147,138,199,201,137,144,198,79)
ORDER BY m.sort_order, LCASE(m.name) ASC

SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0' AND p2c.category_id IN (130)
ORDER BY m.sort_order, LCASE(m.name) ASC

SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0' AND p2c.category_id IN (196,195,193,197,194,95)
ORDER BY m.sort_order, LCASE(m.name) ASC

SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0' AND p2c.category_id IN (98)
ORDER BY m.sort_order, LCASE(m.name) ASC

SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0' AND p2c.category_id IN (200,104)
ORDER BY m.sort_order, LCASE(m.name) ASC

SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0' AND p2c.category_id IN (124)
ORDER BY m.sort_order, LCASE(m.name) ASC

SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0' AND p2c.category_id IN (123)
ORDER BY m.sort_order, LCASE(m.name) ASC

SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0' AND p2c.category_id IN (134)
ORDER BY m.sort_order, LCASE(m.name) ASC

SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0' AND p2c.category_id IN (128)
ORDER BY m.sort_order, LCASE(m.name) ASC

SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC

SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=8' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=4' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=9' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=6' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=5' AND language_id = '2'

SELECT *
FROM oc_setting
WHERE `store_id` = 0 AND `key` = 'custom_stylesheet' AND `group` = 'tsb_theme'

SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/product/category.php'

SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '95' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '95' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '95' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=196' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=195' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=193' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=197' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=194' AND language_id = '2'

SELECT p.product_id
FROM oc_product_to_category p2c
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND (SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1) IS NULL AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '95'

SELECT filter_id
FROM oc_product_filter
WHERE product_id IN ( 14809,14810,14848,14849,14974,14975,14999,15003,15004,15005,15006,15007,15008,15010,15011,15012,15069,15233,15251,15252,15288,15301,15309,15310,15311,15356,15555,15556,15557,15558,15570,15573,15597,15598,15599,15609,15610,15611,15612,15698,15728,15747,15748,15749,15758,15759,15760,15761,15944 )

SELECT p.product_id,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special
FROM oc_product_to_category p2c
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND (SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1) IS NULL AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '95' GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,20

SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2') AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15761' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'

SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2') AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15556' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'

SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2') AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15555' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'

SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2') AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15759' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'

SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2') AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15748' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'

SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2') AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15749' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'

SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2') AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15944' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'

SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2') AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15747' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'

SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2') AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15573' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'

SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2') AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15558' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'

SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2') AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15557' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'

SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2') AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15760' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'

SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2') AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15758' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'

SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2') AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14810' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'

SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2') AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15012' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'

SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2') AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14809' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'

SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2') AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15011' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'

SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2') AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15008' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'

SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2') AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14849' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'

SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2') AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14848' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15761' AND language_id = '2'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15556' AND language_id = '2'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15555' AND language_id = '2'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15759' AND language_id = '2'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15748' AND language_id = '2'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15749' AND language_id = '2'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15944' AND language_id = '2'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15747' AND language_id = '2'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15573' AND language_id = '2'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15558' AND language_id = '2'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15557' AND language_id = '2'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15760' AND language_id = '2'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15758' AND language_id = '2'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=14810' AND language_id = '2'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15012' AND language_id = '2'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=14809' AND language_id = '2'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15011' AND language_id = '2'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15008' AND language_id = '2'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=14849' AND language_id = '2'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'

SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '150' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2332')
ORDER BY tr1.priority ASC

SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '150' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2332')
ORDER BY tr1.priority ASC

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=14848' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT pf.filter_id
FROM oc_product_filter pf join oc_product_to_category ptc on pf.product_id = ptc.product_id
WHERE ptc.category_id = '95'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '95' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_extension
WHERE `type` = 'module'

SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '95' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/module/filter.php'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT pf.filter_id
FROM oc_product_filter pf join oc_product_to_category ptc on pf.product_id = ptc.product_id
WHERE ptc.category_id = '95'

SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/module/information.php'

SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC

SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=8' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=4' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=9' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=6' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=5' AND language_id = '2'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '95' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_extension
WHERE `type` = 'module'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '95' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_extension
WHERE `type` = 'module'

SELECT *
FROM oc_category_to_layout
WHERE category_id = '95' AND store_id = '0'

SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT *
FROM oc_extension
WHERE `type` = 'module'

SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/common/footer.php'

SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC

SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=8' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=4' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=9' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=6' AND language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=5' AND language_id = '2'

DELETE
FROM `oc_customer_online`
WHERE (UNIX_TIMESTAMP(`date_added`) + 3600) < UNIX_TIMESTAMP(NOW())

REPLACE INTO `oc_customer_online` SET `ip` = '34.204.180.1', `customer_id` = '0', `url` = 'http://mini-love.nl/mama-amp-papa', `referer` = '', `date_added` = NOW()

SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/module/language.php'

SELECT *
FROM oc_language
WHERE language_id = '2'

SELECT *
FROM oc_language
WHERE language_id = '2'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/module/currency.php'

SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95' AND language_id = '2'

SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/module/cart.php'

SHOW TABLES
FROM `minilove_adva1` LIKE 'oc_product_to_product'

SELECT *
FROM oc_extension
WHERE `type` = 'total'

SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/total/sub_total.php'