SELECT *
FROM omdv_store
WHERE REPLACE(`url`, 'www.', '') = 'http://777dveri.ru/'

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

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

SELECT *
FROM omdv_currency

SELECT *
FROM omdv_weight_class wc
LEFT JOIN omdv_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '1'

SELECT *
FROM omdv_length_class mc
LEFT JOIN omdv_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '1'

SELECT DISTINCT *
FROM omdv_manufacturer m
LEFT JOIN omdv_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id)
LEFT JOIN omdv_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '148' AND md.language_id = '1' AND m2s.store_id = '0'

SELECT DISTINCT SQL_CALC_FOUND_ROWS p.product_id, (SELECT AVG(rating) AS total
FROM omdv_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0' AND p.manufacturer_id = '148' GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,70

SELECT FOUND_ROWS() AS `found_rows`

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12929' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12929'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '13024' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '13024'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12936' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12936'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12937' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12937'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '8950' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '8950'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12941' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12941'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12938' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12938'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12940' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12940'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12942' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12942'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12939' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12939'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '13025' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '13025'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12943' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12943'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '13264' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '13264'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12921' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12921'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12924' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12924'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12923' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12923'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12944' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12944'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12947' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12947'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '13023' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '13023'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6160' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '6160'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12934' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12934'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5867' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '5867'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '13028' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '13028'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12464' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12464'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12931' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12931'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12927' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12927'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12925' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12925'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12930' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12930'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12928' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12928'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12916' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12916'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12932' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12932'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12933' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12933'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '8650' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '8650'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12948' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12948'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '8949' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '8949'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 13:49:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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 < '2025-04-19 13:49:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 13:49:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM omdv_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12463' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0'

SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '12463'
ORDER BY ps.sort_order ASC

SELECT *
FROM omdv_status

SELECT COUNT(DISTINCT p.product_id) AS total
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 13:49:00' AND p2s.store_id = '0' AND p.manufacturer_id = '148'

SELECT *
FROM omdv_product_image
WHERE product_id = '12929'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '13024'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '12936'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '12937'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '8950'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '12941'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '12938'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '12940'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '12942'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '12939'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '13025'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '12943'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '13264'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '12921'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '12924'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '12923'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '12944'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '12947'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '13023'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '6160'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '12934'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '5867'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '13028'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '12464'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '12931'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '12927'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '12925'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '12930'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '12928'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '12916'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '12932'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '12933'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '8650'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '12948'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '8949'
ORDER BY sort_order ASC

SELECT *
FROM omdv_product_image
WHERE product_id = '12463'
ORDER BY sort_order ASC

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM omdv_category c
LEFT JOIN omdv_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN omdv_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '92' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM omdv_category c
LEFT JOIN omdv_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN omdv_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '93' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM omdv_category c
LEFT JOIN omdv_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN omdv_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '99' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM omdv_category c
LEFT JOIN omdv_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN omdv_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '118' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM omdv_category c
LEFT JOIN omdv_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN omdv_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '143' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

SELECT *
FROM omdv_category c
LEFT JOIN omdv_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN omdv_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '162' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)

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