string(1786) "SELECT DISTINCT SQL_CALC_FOUND_ROWS p.product_id
, (
SELECT AVG(rating) AS total
FROM mebel_review r1
WHERE r1.product_id = p.product_id
AND r1.status = '1'
GROUP BY r1.product_id
) AS rating
, (
SELECT price
FROM mebel_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 < '2018-04-24 05:43:00')
AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2018-04-24 05:43:00'))
ORDER BY pd2.priority ASC
, pd2.price ASC
LIMIT 1
) AS discount
, (
SELECT price
FROM mebel_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 < '2018-04-24 05:43:00')
AND (ps.date_end = '0000-00-00' OR ps.date_end > '2018-04-24 05:43:00'))
ORDER BY ps.priority ASC
, ps.price ASC
LIMIT 1
) AS special
FROM mebel_product_to_category p2c
LEFT JOIN mebel_product p
ON (p2c.product_id = p.product_id)
LEFT JOIN mebel_product_description pd
ON (p.product_id = pd.product_id)
LEFT JOIN mebel_product_to_store p2s
ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1'
AND p.status = '1'
AND p.date_available <= '2018-04-24 05:43:00'
AND p2s.store_id = '0'
AND p2c.category_id = '721' GROUP BY p.product_id ORDER BY (CASE WHEN special IS NOT NULL THEN special WHEN discount IS NOT NULL THEN discount ELSE p.price END) ASC, LCASE(pd.name) ASC LIMIT 0,60"
Детские кровати трансформеры для новорожденных по доступным ценам