Новогодняя гирлянда декор Triumph Колорадо 270x30 см зеленая

SELECT *
FROM store
WHERE REPLACE(`url`, 'www.', '') = 'http://novelki.ru/'

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

SELECT *
FROM length_class mc

SELECT *
FROM url_alias
WHERE keyword IN ('novogodniy_dekor', 'girljanda-dekor-triumph-kolorado-270-30-sm-zelenaja')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=73388')

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

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '934'

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (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 = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) 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_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 (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '73388' AND p.date_available <= '2023-09-22' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=73388')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=73388')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=73388')

SELECT *
FROM manufacturer_sertif
WHERE manufacturer_id = '769'
ORDER BY sort_order

SELECT COUNT(*) AS total
FROM review r
LEFT JOIN product p ON (r.product_id = p.product_id)
WHERE p.product_id = '73388' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1'

SELECT *
FROM url_alias
WHERE `query` IN ('manufacturer_id=769')

SELECT *
FROM product_image
WHERE product_id = '73388'
ORDER BY sort_order ASC

SELECT *
FROM product_video
WHERE product_id = '73388'
ORDER BY sort_order ASC

SELECT *
FROM product_discount
WHERE product_id = '73388' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY quantity ASC, priority ASC, price ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '73388'
ORDER BY o.sort_order

SELECT ag.attribute_group_id, ag.name, a.attribute_type
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
WHERE pa.product_id = '73388' and pa.store_id='0' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, ag.name

SELECT ag.attribute_group_id, ag.name, a.attribute_type
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
WHERE pa.product_id = '73388' and pa.store_id='0' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, ag.name

SELECT *
FROM product_related pr
LEFT JOIN product p ON (pr.related_id = p.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pr.product_id = '73388' AND p.status = '1' AND p.date_available <= NOW() AND p2s.status = '1' AND p2s.store_id = '0'

SELECT *
FROM product_tag
WHERE product_id = '73388'

SELECT DISTINCT *
FROM information i
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '6' AND i2s.store_id = '0' AND i.status = '1'

UPDATE product SET viewed = (viewed + 1)
WHERE product_id = '73388'

SELECT *
FROM product_to_layout
WHERE product_id = '73388' AND store_id = '0'

SELECT *
FROM layout_route
WHERE 'product/product' 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_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c2s.store_id = '0' AND c.status = '1' AND c.top='1'
ORDER BY c.parent_id, c.sort_order, c.name

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '922'

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '923'

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '924'

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '925'

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '926'

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '927'

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '928'

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '929'

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path
FROM category t0
LEFT JOIN category t1 ON (t1.category_id = t0.parent_id)
LEFT JOIN category t2 ON (t2.category_id = t1.parent_id)
LEFT JOIN category t3 ON (t3.category_id = t2.parent_id)
LEFT JOIN category t4 ON (t4.category_id = t3.parent_id)
LEFT JOIN category t5 ON (t5.category_id = t4.parent_id)
LEFT JOIN category t6 ON (t6.category_id = t5.parent_id)
LEFT JOIN category t7 ON (t7.category_id = t6.parent_id)
LEFT JOIN category t8 ON (t8.category_id = t7.parent_id)
LEFT JOIN category t9 ON (t9.category_id = t8.parent_id)
WHERE t0.category_id = '932'

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM product_to_layout
WHERE product_id = '73388' AND store_id = '0'

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

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

SELECT *
FROM product_to_layout
WHERE product_id = '73388' AND store_id = '0'

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

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

SELECT *
FROM product_to_layout
WHERE product_id = '73388' AND store_id = '0'

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

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

SELECT *
FROM product_to_layout
WHERE product_id = '73388' AND store_id = '0'

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

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

SELECT *
FROM product_to_layout
WHERE product_id = '73388' AND store_id = '0'

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

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

SELECT DISTINCT *, p.name AS name, p2s.seo_h1 AS p_seo_h1, p2s.description AS p_description, p2s.seo_title as p_seo_title, p2s.meta_description as p_meta_description, p2s.meta_keyword as p_meta_keyword, p.image, m.name AS manufacturer, c.name as country, p2c.category_id, (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 = '1') AS stock_status, (SELECT wc.unit
FROM weight_class wc
WHERE p.weight_class_id = wc.weight_class_id ) AS weight_class, (SELECT lc.unit
FROM length_class lc
WHERE p.length_class_id = lc.length_class_id ) 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_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 (p2c.product_id = p.product_id)
LEFT JOIN country c ON (c.country_id = m.country_id)
WHERE p.product_id = '73388' AND p.date_available <= '2023-09-22' AND p2c.main_category='1' AND p.status = '1' AND p2s.store_id = '0' AND p2s.status='1' AND p2c.store_id = '0'

SELECT *
FROM ( SELECT DISTINCT p.product_id, p.complect, p.price, p.tax_class_id, p.sku, p.top_100, p.recommend, p.present, p2s.description, p.name AS name, p.image, (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 = '1') AS stock_status, (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, p.sort_order
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE p.product_id <> '73388' AND p.status = '1' AND p2c.category_id = '934' AND p2c.main_category = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2s.status = '1' ) p1
WHERE IF(p1.special>0, p1.special>='-13410' AND p1.special<='16390' , p1.price>='-13410' AND p1.price<='16390') LIMIT 0,15

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '3906'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=3906')

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '3908'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=3908')

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '3926'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=3926')

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23549'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23549')

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23552'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23552')

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23556'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23556')

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23575'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23575')

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '3927'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=3927')

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23557'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23557')

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23577'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23577')

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '73400'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=73400')

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23553'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23553')

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23572'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23572')

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23554'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23554')

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '23555'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=23555')

SELECT *
FROM information i
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i2s.store_id = '0' AND i.status = '1' AND i.sort_order <> '-1'
ORDER BY i.sort_order, LCASE(i.title) ASC

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=37')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=35')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=106')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=13')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=8')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=9')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM information i
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i2s.store_id = '0' AND i.top = '1' AND i.status = '1' AND i.sort_order <> '-1'
ORDER BY i.sort_order, LCASE(i.title) ASC

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=37')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=35')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=8')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=9')

SELECT *
FROM language
ORDER BY sort_order, name

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=73388')

SELECT *
FROM currency
ORDER BY title ASC

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=73388')

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

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

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM information i
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i2s.store_id = '0' AND i.top = '1' AND i.status = '1' AND i.sort_order <> '-1'
ORDER BY i.sort_order, LCASE(i.title) ASC

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=37')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=35')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=8')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=9')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=73388')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934', 'product_id=73388')

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

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