string(2610) "SELECT p.product_id, pd.name AS name, p.image, p.model, p.sku, p.upc, p.ean,
p.jan, p.isbn, p.mpn, p.location, p.quantity, p.price, p.stock_status_id,
p.manufacturer_id, p.tax_class_id, p.date_available, p.weight, p.weight_class_id,
p.length, p.width, p.height, p.length_class_id, p.subtract, p.minimum,
p.sort_order, p.status, p.date_added, p.date_modified, p.viewed, p.points,
pd.description, pd.meta_title, pd.meta_description, pd.meta_keyword, pd.tag,
m.name AS manufacturer,
ss.name AS stock_status,
wcd.unit AS weight_class,
lcd.unit AS length_class,
r.rating,
r.reviews,
d.discount,
s.special,
pr.reward FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id AND pd.language_id = '1')
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id AND p2s.store_id = '0')
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN oc_stock_status ss ON (p.stock_status_id = ss.stock_status_id AND ss.language_id = '1')
LEFT JOIN oc_weight_class_description wcd ON (p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1')
LEFT JOIN oc_length_class_description lcd ON (p.length_class_id = lcd.length_class_id AND lcd.language_id = '1')
LEFT JOIN (
SELECT product_id, AVG(rating) AS rating, COUNT(*) AS reviews
FROM oc_review
WHERE status = '1'
GROUP BY product_id
) r ON (r.product_id = p.product_id)
LEFT JOIN (
SELECT product_id, MIN(price) AS discount
FROM oc_product_discount
WHERE customer_group_id = '1'
AND quantity = '1'
AND (date_start = '0000-00-00' OR date_start < NOW())
AND (date_end = '0000-00-00' OR date_end > NOW())
GROUP BY product_id
) d ON (d.product_id = p.product_id)
LEFT JOIN (
SELECT product_id, MIN(price) AS special
FROM oc_product_special
WHERE customer_group_id = '1'
AND (date_start = '0000-00-00' OR date_start < NOW())
AND (date_end = '0000-00-00' OR date_end > NOW())
GROUP BY product_id
) s ON (s.product_id = p.product_id)
LEFT JOIN (
SELECT product_id, MAX(points) AS reward
FROM oc_product_reward
WHERE customer_group_id = '1'
GROUP BY product_id
) pr ON (pr.product_id = p.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2c.category_id = '5568' GROUP BY p.product_id ORDER BY p.sort_order ASC, (pd.name) ASC LIMIT 0,20"
Гравировка птиц ПТ009 на памятник, Москва
