SELECT * FROM os38h_url_alias WHERE keyword = 'shaurma' LIMIT 1
SELECT * FROM os38h_category c LEFT JOIN os38h_category_description cd ON (c.category_id = cd.category_id) WHERE cd.language_id = 1 AND c.status = 1 ORDER BY c.parent_id, c.sort_order, cd.name
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p2c.category_id IN (81) AND p.shop_id = 40908 AND p.active = 1
SELECT p.product_id FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = 1 AND p.status = 1 AND p2c.category_id IN (81) AND p.shop_id = 40908 AND p.active = 1 GROUP BY p.product_id ORDER BY p.sort_available, p.sort_order ASC, LCASE(pd.name) LIMIT 0,24
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_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 os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 239700 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '239700' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
SELECT * FROM os38h_product_prices WHERE product_id = '239700' AND `active` = 1
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_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 os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 239701 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '239701' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
SELECT * FROM os38h_product_prices WHERE product_id = '239701' AND `active` = 1
SELECT * FROM os38h_product_time_available WHERE product_id = 239701
SELECT day_id FROM os38h_product_available WHERE product_id = '239701'
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_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 os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 239702 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '239702' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
SELECT * FROM os38h_product_prices WHERE product_id = '239702' AND `active` = 1
SELECT * FROM os38h_product_time_available WHERE product_id = 239702
SELECT day_id FROM os38h_product_available WHERE product_id = '239702'
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_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 os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 239703 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '239703' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
SELECT * FROM os38h_product_prices WHERE product_id = '239703' AND `active` = 1
SELECT * FROM os38h_product_time_available WHERE product_id = 239703
SELECT day_id FROM os38h_product_available WHERE product_id = '239703'
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_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 os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 239704 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '239704' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
SELECT * FROM os38h_product_prices WHERE product_id = '239704' AND `active` = 1
SELECT * FROM os38h_product_time_available WHERE product_id = 239704
SELECT day_id FROM os38h_product_available WHERE product_id = '239704'
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_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 os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 239705 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '239705' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
SELECT * FROM os38h_product_prices WHERE product_id = '239705' AND `active` = 1
SELECT * FROM os38h_product_time_available WHERE product_id = 239705
SELECT day_id FROM os38h_product_available WHERE product_id = '239705'
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_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 os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 239706 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '239706' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
SELECT * FROM os38h_product_prices WHERE product_id = '239706' AND `active` = 1
SELECT * FROM os38h_product_time_available WHERE product_id = 239706
SELECT day_id FROM os38h_product_available WHERE product_id = '239706'
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_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 os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 239708 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '239708' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
SELECT * FROM os38h_product_prices WHERE product_id = '239708' AND `active` = 1
SELECT * FROM os38h_product_time_available WHERE product_id = 239708
SELECT day_id FROM os38h_product_available WHERE product_id = '239708'
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_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 os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 239709 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '239709' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
SELECT * FROM os38h_product_prices WHERE product_id = '239709' AND `active` = 1
SELECT * FROM os38h_product_time_available WHERE product_id = 239709
SELECT day_id FROM os38h_product_available WHERE product_id = '239709'
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_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 os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 239711 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '239711' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
SELECT * FROM os38h_product_prices WHERE product_id = '239711' AND `active` = 1
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_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 os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 239712 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '239712' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
SELECT * FROM os38h_product_prices WHERE product_id = '239712' AND `active` = 1
SELECT * FROM os38h_product_time_available WHERE product_id = 239712
SELECT day_id FROM os38h_product_available WHERE product_id = '239712'
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_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 os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 239714 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '239714' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
SELECT * FROM os38h_product_prices WHERE product_id = '239714' AND `active` = 1
SELECT * FROM os38h_product_time_available WHERE product_id = 239714
SELECT day_id FROM os38h_product_available WHERE product_id = '239714'
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_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 os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 239715 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '239715' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
SELECT * FROM os38h_product_prices WHERE product_id = '239715' AND `active` = 1
SELECT * FROM os38h_product_time_available WHERE product_id = 239715
SELECT day_id FROM os38h_product_available WHERE product_id = '239715'
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_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 os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 239716 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '239716' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
SELECT * FROM os38h_product_prices WHERE product_id = '239716' AND `active` = 1
SELECT * FROM os38h_product_time_available WHERE product_id = 239716
SELECT day_id FROM os38h_product_available WHERE product_id = '239716'
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_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 os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 239825 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '239825' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
SELECT * FROM os38h_product_prices WHERE product_id = '239825' AND `active` = 1
SELECT * FROM os38h_product_time_available WHERE product_id = 239825
SELECT day_id FROM os38h_product_available WHERE product_id = '239825'
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_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 os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 239718 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '239718' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
SELECT * FROM os38h_product_prices WHERE product_id = '239718' AND `active` = 1
SELECT * FROM os38h_product_time_available WHERE product_id = 239718
SELECT day_id FROM os38h_product_available WHERE product_id = '239718'
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_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 os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 239719 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '239719' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
SELECT * FROM os38h_product_prices WHERE product_id = '239719' AND `active` = 1
SELECT * FROM os38h_product_time_available WHERE product_id = 239719
SELECT day_id FROM os38h_product_available WHERE product_id = '239719'
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_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 os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 239721 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '239721' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
SELECT * FROM os38h_product_prices WHERE product_id = '239721' AND `active` = 1
SELECT * FROM os38h_product_time_available WHERE product_id = 239721
SELECT day_id FROM os38h_product_available WHERE product_id = '239721'
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_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 os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 239722 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '239722' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
SELECT * FROM os38h_product_prices WHERE product_id = '239722' AND `active` = 1
SELECT * FROM os38h_product_time_available WHERE product_id = 239722
SELECT day_id FROM os38h_product_available WHERE product_id = '239722'
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_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 os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 239723 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '239723' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
SELECT * FROM os38h_product_prices WHERE product_id = '239723' AND `active` = 1
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_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 os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 239724 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '239724' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
SELECT * FROM os38h_product_prices WHERE product_id = '239724' AND `active` = 1
SELECT * FROM os38h_product_time_available WHERE product_id = 239724
SELECT day_id FROM os38h_product_available WHERE product_id = '239724'
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_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 os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 239725 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '239725' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
SELECT * FROM os38h_product_prices WHERE product_id = '239725' AND `active` = 1
SELECT * FROM os38h_product_time_available WHERE product_id = 239725
SELECT day_id FROM os38h_product_available WHERE product_id = '239725'
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_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 os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 239726 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '239726' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
SELECT * FROM os38h_product_prices WHERE product_id = '239726' AND `active` = 1
SELECT * FROM os38h_product_time_available WHERE product_id = 239726
SELECT day_id FROM os38h_product_available WHERE product_id = '239726'
SELECT DISTINCT *,
pd.name AS name,
p.image,
(SELECT price FROM os38h_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
(SELECT price FROM os38h_product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
(SELECT points FROM os38h_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward,
(SELECT ss.name FROM os38h_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status,
(SELECT wcd.unit FROM os38h_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 os38h_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class,
(SELECT ptc.category_id FROM os38h_product_to_category ptc WHERE ptc.product_id = 239727 AND ptc.main_category = '1') AS main_category,
p.sort_order
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
WHERE
p.product_id = '239727' AND p.active = '1'AND pd.language_id = '1' AND p.status = '1'
SELECT * FROM os38h_product_prices WHERE product_id = '239727' AND `active` = 1
SELECT * FROM os38h_product_time_available WHERE product_id = 239727
SELECT day_id FROM os38h_product_available WHERE product_id = '239727'
SELECT shop_custom_from, shop_custom_to, shop_day4_from, shop_day4_to, shop_day3_from, shop_day3_to, shop_day5_from, shop_day5_to FROM os38h_shops WHERE shop_id = 40908
SELECT category_id FROM os38h_product_to_category WHERE product_id = '239700' ORDER BY main_category DESC LIMIT 1
SELECT category_id FROM os38h_product_to_category WHERE product_id = '239701' ORDER BY main_category DESC LIMIT 1
SELECT category_id FROM os38h_product_to_category WHERE product_id = '239702' ORDER BY main_category DESC LIMIT 1
SELECT category_id FROM os38h_product_to_category WHERE product_id = '239703' ORDER BY main_category DESC LIMIT 1
SELECT category_id FROM os38h_product_to_category WHERE product_id = '239704' ORDER BY main_category DESC LIMIT 1
SELECT category_id FROM os38h_product_to_category WHERE product_id = '239705' ORDER BY main_category DESC LIMIT 1
SELECT category_id FROM os38h_product_to_category WHERE product_id = '239706' ORDER BY main_category DESC LIMIT 1
SELECT category_id FROM os38h_product_to_category WHERE product_id = '239708' ORDER BY main_category DESC LIMIT 1
SELECT category_id FROM os38h_product_to_category WHERE product_id = '239709' ORDER BY main_category DESC LIMIT 1
SELECT category_id FROM os38h_product_to_category WHERE product_id = '239711' ORDER BY main_category DESC LIMIT 1
SELECT category_id FROM os38h_product_to_category WHERE product_id = '239712' ORDER BY main_category DESC LIMIT 1
SELECT category_id FROM os38h_product_to_category WHERE product_id = '239714' ORDER BY main_category DESC LIMIT 1
SELECT category_id FROM os38h_product_to_category WHERE product_id = '239715' ORDER BY main_category DESC LIMIT 1
SELECT category_id FROM os38h_product_to_category WHERE product_id = '239716' ORDER BY main_category DESC LIMIT 1
SELECT category_id FROM os38h_product_to_category WHERE product_id = '239825' ORDER BY main_category DESC LIMIT 1
SELECT category_id FROM os38h_product_to_category WHERE product_id = '239718' ORDER BY main_category DESC LIMIT 1
SELECT category_id FROM os38h_product_to_category WHERE product_id = '239719' ORDER BY main_category DESC LIMIT 1
SELECT category_id FROM os38h_product_to_category WHERE product_id = '239721' ORDER BY main_category DESC LIMIT 1
SELECT category_id FROM os38h_product_to_category WHERE product_id = '239722' ORDER BY main_category DESC LIMIT 1
SELECT category_id FROM os38h_product_to_category WHERE product_id = '239723' ORDER BY main_category DESC LIMIT 1
SELECT category_id FROM os38h_product_to_category WHERE product_id = '239724' ORDER BY main_category DESC LIMIT 1
SELECT category_id FROM os38h_product_to_category WHERE product_id = '239725' ORDER BY main_category DESC LIMIT 1
SELECT category_id FROM os38h_product_to_category WHERE product_id = '239726' ORDER BY main_category DESC LIMIT 1
SELECT category_id FROM os38h_product_to_category WHERE product_id = '239727' ORDER BY main_category DESC LIMIT 1
SELECT * FROM os38h_category_to_layout WHERE category_id = '81' AND store_id = '0'
SELECT COUNT(DISTINCT p.product_id) AS total, p2c.category_id, cd.name, c.parent_id, IF(c.parent_id IS NOT NULL AND c.parent_id != 0, cp.sort_order, c.sort_order) AS main_sort
FROM os38h_product p
LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN os38h_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN os38h_category c ON (c.category_id = p2c.category_id)
LEFT JOIN os38h_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN os38h_category cp ON c.parent_id = cp.category_id
WHERE pd.language_id = 1 AND p.status = 1 AND p2c.category_id IN (SELECT c.category_id FROM os38h_category c LEFT JOIN os38h_category_description cd ON (c.category_id = cd.category_id) WHERE cd.language_id = 1 AND c.status = 1) AND p.shop_id = 40908 AND p.active = 1 GROUP BY p2c.category_id ORDER BY main_sort, p.sort_order, cd.name
SELECT COUNT(DISTINCT p.product_id) AS total FROM os38h_product p LEFT JOIN os38h_product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.shop_id = 40908 AND p.active = 1 AND p.price_spec = '1'
SELECT * FROM os38h_category_to_layout WHERE category_id = '81' AND store_id = '0'
SELECT * FROM os38h_category_to_layout WHERE category_id = '81' AND store_id = '0'
SELECT * FROM os38h_category_to_layout WHERE category_id = '81' AND store_id = '0'
SELECT *, s.shop_id as shop_id FROM os38h_shops as s LEFT JOIN os38h_shop_sales as ss ON (s.shop_id = ss.shop_id) WHERE s.shop_id = 40908 AND s.shop_active = 1
SELECT city_id FROM os38h_shops_city WHERE shop_id = 40908
SELECT shop_custom_from, shop_custom_to, shop_day4_from, shop_day4_to, shop_day3_from, shop_day3_to, shop_day5_from, shop_day5_to FROM os38h_shops WHERE shop_id = 40908
SELECT c.category_id, cd.name FROM `os38h_category` as c LEFT JOIN `os38h_category_description` as cd ON (c.category_id = cd.category_id) WHERE c.status = 1 AND c.category_type = 2 AND cd.language_id = '1' AND c.category_id IN(232) ORDER BY cd.name ASC
SELECT payment_code FROM os38h_shop_payment WHERE shop_id = 40908
SELECT keyword FROM os38h_url_alias WHERE query = 'cityid=1'
UPDATE os38h_setting SET `value` = '{"229d737b6f21cc50":{"id":"229d737b6f21cc50","last_modified":1518701200,"filename":"catalog\/view\/javascript\/jquery\/229d737b6f21cc50.js"},"4a8301d35850c00a":{"id":"4a8301d35850c00a","last_modified":1647608094,"filename":"catalog\/view\/theme\/original\/js\/4a8301d35850c00a.js"},"3e837028b461cfd9":{"id":"3e837028b461cfd9","last_modified":1551064449,"filename":"catalog\/view\/theme\/original\/js\/3e837028b461cfd9.js"},"c01dc42b7bde92f5":{"id":"c01dc42b7bde92f5","last_modified":1647608094,"filename":"catalog\/view\/theme\/original\/js\/c01dc42b7bde92f5.js"},"a13c397c5f156fa0":{"id":"a13c397c5f156fa0","last_modified":1718058676,"filename":"catalog\/view\/theme\/original\/js\/a13c397c5f156fa0.js"},"bca2be402fa1e47b":{"id":"bca2be402fa1e47b","last_modified":1680255970,"filename":"catalog\/view\/theme\/original\/js\/bca2be402fa1e47b.js"},"c9574d9552316140":{"id":"c9574d9552316140","last_modified":1729670837,"filename":"catalog\/view\/theme\/original\/js\/c9574d9552316140.js"},"499a80be4f15357b":{"id":"499a80be4f15357b","last_modified":1676970718,"filename":"catalog\/view\/theme\/original\/js\/499a80be4f15357b.js"},"88eeab9f8f918c4d":{"id":"88eeab9f8f918c4d","last_modified":1676617663,"filename":"catalog\/view\/javascript\/88eeab9f8f918c4d.js"},"29b14603bde3516a":{"id":"29b14603bde3516a","last_modified":1676617663,"filename":"catalog\/view\/javascript\/29b14603bde3516a.js"},"31de06db6e143674":{"last_modified":16843767059,"id":"31de06db6e143674","filename":"system\/cache\/31de06db6e143674.css"},"a03b54ce5153ea33":{"id":"a03b54ce5153ea33","last_modified":1676970718,"filename":"catalog\/view\/javascript\/jquery\/modal\/a03b54ce5153ea33.js"},"855fa1f1af8df7cd":{"last_modified":16232881545,"id":"855fa1f1af8df7cd","filename":"system\/cache\/855fa1f1af8df7cd.css"},"d570468bded9c3e4":{"last_modified":14610673593,"id":"d570468bded9c3e4","filename":"system\/cache\/d570468bded9c3e4.css"},"5cf4ddb593b186ec":{"id":"5cf4ddb593b186ec","last_modified":1676970718,"filename":"catalog\/view\/theme\/original\/js\/5cf4ddb593b186ec.js"},"b9db8af7c0b2adbb":{"id":"b9db8af7c0b2adbb","last_modified":1689667725,"filename":"catalog\/view\/javascript\/b9db8af7c0b2adbb.js"},"57448b8fc43f1f72":{"id":"57448b8fc43f1f72","last_modified":1711552907,"filename":"catalog\/view\/javascript\/57448b8fc43f1f72.js"},"b67c2d19100079c7":{"id":"b67c2d19100079c7","last_modified":1676970718,"filename":"catalog\/view\/javascript\/jquery\/b67c2d19100079c7.js"},"031d507627cf661b":{"last_modified":18520737777,"id":"031d507627cf661b","filename":"system\/cache\/031d507627cf661b.css"},"fcebc49a4cdb93b6":{"id":"fcebc49a4cdb93b6","last_modified":1676970718,"filename":"catalog\/view\/javascript\/fcebc49a4cdb93b6.js"},"32614fb50ccef28a":{"id":"32614fb50ccef28a","last_modified":1676970718,"filename":"catalog\/view\/theme\/original\/js\/32614fb50ccef28a.js"},"7fdc72f4d8c8389e":{"id":"7fdc72f4d8c8389e","last_modified":1676970718,"filename":"catalog\/view\/javascript\/7fdc72f4d8c8389e.js"},"4ba173e5cedc73ab":{"id":"4ba173e5cedc73ab","last_modified":1676970718,"filename":"catalog\/view\/javascript\/4ba173e5cedc73ab.js"},"4422e6d5aea394bc":{"last_modified":15068859309,"id":"4422e6d5aea394bc","filename":"system\/cache\/4422e6d5aea394bc.css"},"3f7b53ca7c5cea92":{"last_modified":14319830529,"id":"3f7b53ca7c5cea92","filename":"system\/cache\/3f7b53ca7c5cea92.css"},"938dd17435d203e7":{"last_modified":16869080743,"id":"938dd17435d203e7","filename":"system\/cache\/938dd17435d203e7.css"},"47ca1af119948d07":{"last_modified":12194727715,"id":"47ca1af119948d07","filename":"system\/cache\/47ca1af119948d07.css"},"1bcf638d30d977fa":{"id":"1bcf638d30d977fa","last_modified":1551062419,"filename":"catalog\/view\/theme\/original\/js\/1bcf638d30d977fa.js"},"18e3926f517b8f18":{"id":"18e3926f517b8f18","last_modified":1551068103,"filename":"catalog\/view\/theme\/original\/js\/18e3926f517b8f18.js"},"d94c60204f8ac5a1":{"id":"d94c60204f8ac5a1","last_modified":1551064390,"filename":"catalog\/view\/theme\/original\/js\/d94c60204f8ac5a1.js"},"518f7177e23ec789":{"id":"518f7177e23ec789","last_modified":1551064786,"filename":"catalog\/view\/theme\/original\/js\/518f7177e23ec789.js"},"84de7f6dcff2dc54":{"id":"84de7f6dcff2dc54","last_modified":1551064776,"filename":"catalog\/view\/theme\/original\/js\/84de7f6dcff2dc54.js"},"baa999a2539ca07a":{"id":"baa999a2539ca07a","last_modified":1551064772,"filename":"catalog\/view\/theme\/original\/js\/baa999a2539ca07a.js"},"1225c162d3c38bc9":{"id":"1225c162d3c38bc9","last_modified":1551064781,"filename":"catalog\/view\/theme\/original\/js\/1225c162d3c38bc9.js"},"ad39c04c63ed2faa":{"id":"ad39c04c63ed2faa","last_modified":1647608094,"filename":"catalog\/view\/theme\/original\/js\/ad39c04c63ed2faa.js"},"98881ce622b8a03c":{"id":"98881ce622b8a03c","last_modified":1647608094,"filename":"catalog\/view\/theme\/original\/js\/98881ce622b8a03c.js"},"4a5adba547d94097":{"id":"4a5adba547d94097","last_modified":1647608094,"filename":"catalog\/view\/theme\/original\/js\/4a5adba547d94097.js"},"3a706b346bf04711":{"last_modified":18520737777,"id":"3a706b346bf04711","filename":"system\/cache\/3a706b346bf04711.css"},"41fdac0e63f3f256":{"last_modified":1676970718,"id":"41fdac0e63f3f256","filename":"system\/cache\/41fdac0e63f3f256.css"},"ef108adc359c2882":{"id":"ef108adc359c2882","last_modified":1680255970,"filename":"catalog\/view\/theme\/original\/js\/ef108adc359c2882.js"},"59070cb682b92d1b":{"id":"59070cb682b92d1b","last_modified":1656057195,"filename":"catalog\/view\/theme\/original\/js\/59070cb682b92d1b.js"},"0b1b64fd3fb30c1b":{"id":"0b1b64fd3fb30c1b","last_modified":1676970718,"filename":"catalog\/view\/javascript\/0b1b64fd3fb30c1b.js"},"bd145e64d72e5825":{"last_modified":18454135911,"id":"bd145e64d72e5825","filename":"system\/cache\/bd145e64d72e5825.css"},"bbc08b368b1e73e1":{"id":"bbc08b368b1e73e1","last_modified":1676970718,"filename":"catalog\/view\/theme\/original\/js\/bbc08b368b1e73e1.js"},"0c7e6392d7418fa7":{"last_modified":16869080743,"id":"0c7e6392d7418fa7","filename":"system\/cache\/0c7e6392d7418fa7.css"}}' WHERE `os38h_setting`.`key` = 'mcj_cache_list'
Заказывай через мобильное приложение и получай баллы за каждый заказ!