Славянские украшения

SELECT *
FROM pr_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://yavinav.ru/'

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

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

SELECT *
FROM pr_currency

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

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

SELECT *
FROM pr_url_alias
WHERE keyword = 'slavjanskie-ukrashenija'

select curdate() as today, timestampadd(day,1,curdate()) as tommorow

SELECT *
FROM pr_url_alias
WHERE `query` = 'common/home'

SELECT DISTINCT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '24' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/compare'

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

SELECT COUNT(DISTINCT p.product_id) AS total
FROM pr_product_to_category p2c
LEFT JOIN pr_product p ON (p2c.product_id = p.product_id)
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0' AND p2c.category_id = '24'

SELECT p.product_id, (SELECT AVG(rating) AS total
FROM pr_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special
FROM pr_product_to_category p2c
LEFT JOIN pr_product p ON (p2c.product_id = p.product_id)
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0' AND p2c.category_id = '24' GROUP BY p.product_id
ORDER BY LCASE(pd.name) ASC, LCASE(pd.name) ASC LIMIT 0,50

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '301' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '981' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '564' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '3956' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '3104' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '3710' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4129' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4130' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4141' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4142' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4136' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4137' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1647' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1786' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1706' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '941' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1333' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '601' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1274' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '815' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '598' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1267' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '264' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '167' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1280' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '265' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '159' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1650' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4138' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4139' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1017' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '813' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '614' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '3983' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4073' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4074' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '897' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '650' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '609' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1644' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '556' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '187' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '569' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4140' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1780' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1781' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1782' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '962' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '77' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-04-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-04-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-04-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_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 pr_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 pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '101' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-04-20' AND p2s.store_id = '0'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=301'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=981'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=564'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3956'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3104'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3710'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=4129'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=4130'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=4141'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=4142'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=4136'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=4137'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1647'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1786'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1706'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=941'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1333'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=601'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1274'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=815'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=598'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1267'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=264'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=167'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1280'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=265'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=159'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1650'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=4138'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=4139'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1017'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=813'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=614'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3983'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=4073'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=4074'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=897'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=650'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=609'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1644'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=556'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=187'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=569'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=4140'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1780'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1781'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1782'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=962'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=77'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=101'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'

SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'

SELECT *
FROM pr_url_alias
WHERE `query` = 'common/home'