SELECT *
FROM store
WHERE store_id = 0

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

SELECT *
FROM language
WHERE status = '1'

SELECT *
FROM currency

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

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

SELECT *
FROM url_alias
WHERE keyword = 'cabluri'

SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '14' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '14' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '14' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=248'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=261'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=255'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=268'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=516'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=249'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=262'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=259'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=271'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=269'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=487'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=272'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=273'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=256'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=486'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=263'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=434'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=435'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=278'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=446'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=251'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=252'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=250'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=510'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=513'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=462'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=463'

SELECT category_id
FROM category
WHERE parent_id = '14'

SELECT category_id
FROM category
WHERE parent_id = '510'

SELECT category_id
FROM category
WHERE parent_id = '450'

SELECT category_id
FROM category
WHERE parent_id = '451'

SELECT category_id
FROM category
WHERE parent_id = '452'

SELECT category_id
FROM category
WHERE parent_id = '453'

SELECT category_id
FROM category
WHERE parent_id = '455'

SELECT category_id
FROM category
WHERE parent_id = '456'

SELECT category_id
FROM category
WHERE parent_id = '457'

SELECT category_id
FROM category
WHERE parent_id = '458'

SELECT category_id
FROM category
WHERE parent_id = '459'

SELECT category_id
FROM category
WHERE parent_id = '460'

SELECT category_id
FROM category
WHERE parent_id = '461'

SELECT category_id
FROM category
WHERE parent_id = '464'

SELECT category_id
FROM category
WHERE parent_id = '491'

SELECT category_id
FROM category
WHERE parent_id = '248'

SELECT category_id
FROM category
WHERE parent_id = '328'

SELECT category_id
FROM category
WHERE parent_id = '330'

SELECT category_id
FROM category
WHERE parent_id = '331'

SELECT category_id
FROM category
WHERE parent_id = '261'

SELECT category_id
FROM category
WHERE parent_id = '332'

SELECT category_id
FROM category
WHERE parent_id = '333'

SELECT category_id
FROM category
WHERE parent_id = '334'

SELECT category_id
FROM category
WHERE parent_id = '255'

SELECT category_id
FROM category
WHERE parent_id = '335'

SELECT category_id
FROM category
WHERE parent_id = '336'

SELECT category_id
FROM category
WHERE parent_id = '337'

SELECT category_id
FROM category
WHERE parent_id = '268'

SELECT category_id
FROM category
WHERE parent_id = '249'

SELECT category_id
FROM category
WHERE parent_id = '338'

SELECT category_id
FROM category
WHERE parent_id = '339'

SELECT category_id
FROM category
WHERE parent_id = '262'

SELECT category_id
FROM category
WHERE parent_id = '340'

SELECT category_id
FROM category
WHERE parent_id = '341'

SELECT category_id
FROM category
WHERE parent_id = '259'

SELECT category_id
FROM category
WHERE parent_id = '271'

SELECT category_id
FROM category
WHERE parent_id = '269'

SELECT category_id
FROM category
WHERE parent_id = '272'

SELECT category_id
FROM category
WHERE parent_id = '273'

SELECT category_id
FROM category
WHERE parent_id = '256'

SELECT category_id
FROM category
WHERE parent_id = '263'

SELECT category_id
FROM category
WHERE parent_id = '278'

SELECT category_id
FROM category
WHERE parent_id = '251'

SELECT category_id
FROM category
WHERE parent_id = '342'

SELECT category_id
FROM category
WHERE parent_id = '343'

SELECT category_id
FROM category
WHERE parent_id = '344'

SELECT category_id
FROM category
WHERE parent_id = '252'

SELECT category_id
FROM category
WHERE parent_id = '250'

SELECT category_id
FROM category
WHERE parent_id = '516'

SELECT category_id
FROM category
WHERE parent_id = '434'

SELECT category_id
FROM category
WHERE parent_id = '435'

SELECT category_id
FROM category
WHERE parent_id = '446'

SELECT category_id
FROM category
WHERE parent_id = '462'

SELECT category_id
FROM category
WHERE parent_id = '463'

SELECT category_id
FROM category
WHERE parent_id = '486'

SELECT category_id
FROM category
WHERE parent_id = '487'

SELECT category_id
FROM category
WHERE parent_id = '513'

SELECT COUNT(DISTINCT p2c.product_id) AS total
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (14, 342, 343, 344, 340, 341, 338, 339, 335, 336, 337, 332, 333, 334, 328, 330, 331, 450, 451, 452, 453, 455, 456, 457, 458, 459, 460, 461, 464, 491, 510, 248, 261, 255, 268, 249, 262, 259, 271, 269, 272, 273, 256, 263, 278, 251, 252, 250, 516, 434, 435, 446, 462, 463, 486, 487, 513)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT category_id
FROM category
WHERE parent_id = '14'

SELECT category_id
FROM category
WHERE parent_id = '510'

SELECT category_id
FROM category
WHERE parent_id = '450'

SELECT category_id
FROM category
WHERE parent_id = '451'

SELECT category_id
FROM category
WHERE parent_id = '452'

SELECT category_id
FROM category
WHERE parent_id = '453'

SELECT category_id
FROM category
WHERE parent_id = '455'

SELECT category_id
FROM category
WHERE parent_id = '456'

SELECT category_id
FROM category
WHERE parent_id = '457'

SELECT category_id
FROM category
WHERE parent_id = '458'

SELECT category_id
FROM category
WHERE parent_id = '459'

SELECT category_id
FROM category
WHERE parent_id = '460'

SELECT category_id
FROM category
WHERE parent_id = '461'

SELECT category_id
FROM category
WHERE parent_id = '464'

SELECT category_id
FROM category
WHERE parent_id = '491'

SELECT category_id
FROM category
WHERE parent_id = '248'

SELECT category_id
FROM category
WHERE parent_id = '328'

SELECT category_id
FROM category
WHERE parent_id = '330'

SELECT category_id
FROM category
WHERE parent_id = '331'

SELECT category_id
FROM category
WHERE parent_id = '261'

SELECT category_id
FROM category
WHERE parent_id = '332'

SELECT category_id
FROM category
WHERE parent_id = '333'

SELECT category_id
FROM category
WHERE parent_id = '334'

SELECT category_id
FROM category
WHERE parent_id = '255'

SELECT category_id
FROM category
WHERE parent_id = '335'

SELECT category_id
FROM category
WHERE parent_id = '336'

SELECT category_id
FROM category
WHERE parent_id = '337'

SELECT category_id
FROM category
WHERE parent_id = '268'

SELECT category_id
FROM category
WHERE parent_id = '249'

SELECT category_id
FROM category
WHERE parent_id = '338'

SELECT category_id
FROM category
WHERE parent_id = '339'

SELECT category_id
FROM category
WHERE parent_id = '262'

SELECT category_id
FROM category
WHERE parent_id = '340'

SELECT category_id
FROM category
WHERE parent_id = '341'

SELECT category_id
FROM category
WHERE parent_id = '259'

SELECT category_id
FROM category
WHERE parent_id = '271'

SELECT category_id
FROM category
WHERE parent_id = '269'

SELECT category_id
FROM category
WHERE parent_id = '272'

SELECT category_id
FROM category
WHERE parent_id = '273'

SELECT category_id
FROM category
WHERE parent_id = '256'

SELECT category_id
FROM category
WHERE parent_id = '263'

SELECT category_id
FROM category
WHERE parent_id = '278'

SELECT category_id
FROM category
WHERE parent_id = '251'

SELECT category_id
FROM category
WHERE parent_id = '342'

SELECT category_id
FROM category
WHERE parent_id = '343'

SELECT category_id
FROM category
WHERE parent_id = '344'

SELECT category_id
FROM category
WHERE parent_id = '252'

SELECT category_id
FROM category
WHERE parent_id = '250'

SELECT category_id
FROM category
WHERE parent_id = '516'

SELECT category_id
FROM category
WHERE parent_id = '434'

SELECT category_id
FROM category
WHERE parent_id = '435'

SELECT category_id
FROM category
WHERE parent_id = '446'

SELECT category_id
FROM category
WHERE parent_id = '462'

SELECT category_id
FROM category
WHERE parent_id = '463'

SELECT category_id
FROM category
WHERE parent_id = '486'

SELECT category_id
FROM category
WHERE parent_id = '487'

SELECT category_id
FROM category
WHERE parent_id = '513'

SELECT p.product_id, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, m.name as manufacturername
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (14, 342, 343, 344, 340, 341, 338, 339, 335, 336, 337, 332, 333, 334, 328, 330, 331, 450, 451, 452, 453, 455, 456, 457, 458, 459, 460, 461, 464, 491, 510, 248, 261, 255, 268, 249, 262, 259, 271, 269, 272, 273, 256, 263, 278, 251, 252, 250, 516, 434, 435, 446, 462, 463, 486, 487, 513) GROUP BY p.product_id
ORDER BY p.price ASC, LCASE(pd.name) ASC LIMIT 1716,12

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15759' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '8827' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11051' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '9244' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15084' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15686' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14661' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '9004' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6287' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12964' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14132' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty, (SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14069' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT IFNULL(COUNT(*),0) AS total
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE r.show_bottom=1 and p.product_id = '15759' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'product_id=15759'

SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN 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 = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC

SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN 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 = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC

SELECT IFNULL(COUNT(*),0) AS total
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE r.show_bottom=1 and p.product_id = '8827' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'product_id=8827'

SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN 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 = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC

SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN 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 = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC

SELECT IFNULL(COUNT(*),0) AS total
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE r.show_bottom=1 and p.product_id = '11051' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'product_id=11051'

SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN 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 = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC

SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN 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 = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC

SELECT IFNULL(COUNT(*),0) AS total
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE r.show_bottom=1 and p.product_id = '9244' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'product_id=9244'

SELECT IFNULL(COUNT(*),0) AS total
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE r.show_bottom=1 and p.product_id = '15084' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'product_id=15084'

SELECT IFNULL(COUNT(*),0) AS total
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE r.show_bottom=1 and p.product_id = '15686' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'product_id=15686'

SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN 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 = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC

SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN 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 = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC

SELECT IFNULL(COUNT(*),0) AS total
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE r.show_bottom=1 and p.product_id = '14661' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'product_id=14661'

SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN 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 = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC

SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN 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 = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC

SELECT IFNULL(COUNT(*),0) AS total
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE r.show_bottom=1 and p.product_id = '9004' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'product_id=9004'

SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN 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 = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC

SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN 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 = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC

SELECT IFNULL(COUNT(*),0) AS total
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE r.show_bottom=1 and p.product_id = '6287' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'product_id=6287'

SELECT IFNULL(COUNT(*),0) AS total
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE r.show_bottom=1 and p.product_id = '12964' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'product_id=12964'

SELECT IFNULL(COUNT(*),0) AS total
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE r.show_bottom=1 and p.product_id = '14132' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'product_id=14132'

SELECT IFNULL(COUNT(*),0) AS total
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE r.show_bottom=1 and p.product_id = '14069' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'product_id=14069'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM category_to_layout
WHERE category_id = '14' AND store_id = '0'

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

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

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

SELECT *
FROM banner_image bi
LEFT JOIN banner_image_description bid ON (bi.banner_image_id = bid.banner_image_id)
WHERE bi.banner_id = '6' AND bid.language_id = '2'
ORDER BY bi.sort_order ASC, bid.title ASC

CREATE TABLE IF NOT EXISTS subscribe ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `email_id` varchar(225) NOT NULL, `name` varchar(225) NOT NULL, `option1` varchar(225) NOT NULL, `option2` varchar(225) NOT NULL, `option3` varchar(225) NOT NULL, `option4` varchar(225) NOT NULL, `option5` varchar(225) NOT NULL, `option6` varchar(225) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `Index_2` (`email_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

SELECT *
FROM category_to_layout
WHERE category_id = '14' AND store_id = '0'

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

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

SELECT *
FROM category_to_layout
WHERE category_id = '14' AND store_id = '0'

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

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

SELECT category_id
FROM category
WHERE category_id = 14 or parent_id = 14

SELECT distinct(M.manufacturer_id), M.name, M.image
from product P join product_to_category PTC on PTC.product_id=P.product_id join manufacturer M on M.manufacturer_id = P.manufacturer_id
where (category_id IN( SELECT category_id
FROM category
WHERE category_id = 14 or parent_id = 14) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 14 or parent_id = 14) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 510 or parent_id = 510) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 248 or parent_id = 248) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 261 or parent_id = 261) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 255 or parent_id = 255) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 268 or parent_id = 268) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 249 or parent_id = 249) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 262 or parent_id = 262) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 259 or parent_id = 259) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 271 or parent_id = 271) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 269 or parent_id = 269) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 272 or parent_id = 272) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 273 or parent_id = 273) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 256 or parent_id = 256) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 263 or parent_id = 263) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 278 or parent_id = 278) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 251 or parent_id = 251) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 252 or parent_id = 252) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 250 or parent_id = 250) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 516 or parent_id = 516) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 434 or parent_id = 434) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 435 or parent_id = 435) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 446 or parent_id = 446) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 462 or parent_id = 462) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 463 or parent_id = 463) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 486 or parent_id = 486) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 487 or parent_id = 487) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 513 or parent_id = 513)) AND P.status = 1 AND M.status = 1
ORDER BY M.name ASC

SELECT PO.option_id, OD.name as parent_option, OVD.option_value_id as child_id, OVD.name as child_name
FROM product_option PO join option_description OD on PO.option_id = OD.option_id join option_value_description OVD on OVD.option_id = PO.option_id join product_to_category PTC on PTC.product_id = PO.product_id join product P on P.product_id = PO.product_id AND P.status = 1
where PTC.category_id IN( SELECT category_id
FROM category
WHERE category_id = 14 or parent_id = 14) group by OD.name,OVD.name

SELECT *
FROM category_to_layout
WHERE category_id = '14' AND store_id = '0'

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

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

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

SELECT *
FROM banner_image bi
LEFT JOIN banner_image_description bid ON ( bi.banner_image_id = bid.banner_image_id )
LEFT JOIN ( SELECT `manufacturer_id` , CONCAT( 'index.php?route=product/manufacturer/info&manufacturer_id=', manufacturer.manufacturer_id ) AS manlink, CONCAT( 'manufacturer_id=', manufacturer.manufacturer_id ) AS manquery
FROM `manufacturer` ) AS tmpman ON ( tmpman.manlink = bi.link )
LEFT JOIN url_alias ua ON ( tmpman.manquery = ua.query )
WHERE bi.banner_id = '8' AND bid.language_id = '2'
ORDER BY bi.sort_order ASC , bid.title ASC

SELECT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN 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 CAST(i.sort_order AS CHAR), LCASE(id.title) ASC

SELECT *
FROM url_alias
WHERE `query` = 'information_id=23'

SELECT *
FROM url_alias
WHERE `query` = 'information_id=5'

SELECT *
FROM url_alias
WHERE `query` = 'information_id=4'

SELECT *
FROM url_alias
WHERE `query` = 'information_id=25'

SELECT *
FROM url_alias
WHERE `query` = 'information_id=6'

SELECT *
FROM url_alias
WHERE `query` = 'information_id=3'

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

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

SELECT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN 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 CAST(i.sort_order AS CHAR), LCASE(id.title) ASC

SELECT *
from url_alias
where query='information_id=23' limit 1;

SELECT *
FROM url_alias
WHERE `query` = 'information_id=23'

SELECT *
from url_alias
where query='information_id=5' limit 1;

SELECT *
FROM url_alias
WHERE `query` = 'information_id=5'

SELECT *
from url_alias
where query='information_id=4' limit 1;

SELECT *
FROM url_alias
WHERE `query` = 'information_id=4'

SELECT *
from url_alias
where query='information_id=25' limit 1;

SELECT *
FROM url_alias
WHERE `query` = 'information_id=25'

SELECT *
from url_alias
where query='information_id=6' limit 1;

SELECT *
FROM url_alias
WHERE `query` = 'information_id=6'

SELECT *
from url_alias
where query='information_id=3' limit 1;

SELECT *
FROM url_alias
WHERE `query` = 'information_id=3'

SELECT *
from url_alias
where query='information_id=7' limit 1;

SELECT *
FROM url_alias
WHERE `query` = 'information_id=7'

SELECT *
from url_alias
where query='information_id=24' limit 1;

SELECT *
FROM url_alias
WHERE `query` = 'information_id=24'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'

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

SELECT SUM(amount) AS total
FROM customer_transaction
WHERE customer_id = '0'