Пазлы (1500-1999 элементов)
13.96 €
13.35 €
13.35 €
24.78 €
13.35 €
13.35 €
43.72 €
13.35 €
64.86 €
22.97 €
64.86 €
35.87 €
22.97 €
21.45 €
22.97 €
45.80 €
15.34 €
57.08 €
13.35 €
15.34 €
14.45 €
21.45 €
13.35 €
91.32 €
80.51 €
- 1
- 2
SELECT p.product_id FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) 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) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) JOIN oc_product_to_cat ptc ON (ptc.product_id = p.product_id) JOIN oc_cat_description cd ON (cd.cat_id = ptc.cat_id) JOIN oc_product_to_serial pts ON (pts.product_id = p.product_id) JOIN oc_serial_description sd ON (sd.serial_id = pts.serial_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status > 0 AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '1809' AND p.price > 0 AND p.quantity >= 0 GROUP BY p.product_id ORDER BY p.viewed DESC, LCASE(pd.name) DESC LIMIT 0,102
SELECT p.product_id FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) 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) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) JOIN oc_product_to_cat ptc ON (ptc.product_id = p.product_id) JOIN oc_cat_description cd ON (cd.cat_id = ptc.cat_id) JOIN oc_product_to_serial pts ON (pts.product_id = p.product_id) JOIN oc_serial_description sd ON (sd.serial_id = pts.serial_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status > 0 AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '1809' AND p.price > 0 AND p.quantity >= 0 GROUP BY p.product_id ORDER BY p.viewed DESC, LCASE(pd.name) DESC LIMIT 0,102
SELECT p.product_id FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) 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) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) JOIN oc_product_to_cat ptc ON (ptc.product_id = p.product_id) JOIN oc_cat_description cd ON (cd.cat_id = ptc.cat_id) JOIN oc_product_to_serial pts ON (pts.product_id = p.product_id) JOIN oc_serial_description sd ON (sd.serial_id = pts.serial_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '3' AND p.status > 0 AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '1809' AND p.price > 0 AND p.quantity >= 0 GROUP BY p.product_id ORDER BY p.viewed DESC, LCASE(pd.name) DESC LIMIT 0,102
13.96 €
13.35 €
13.35 €
24.78 €
13.35 €
13.35 €
43.72 €
13.35 €
64.86 €
22.97 €
64.86 €
35.87 €
22.97 €
21.45 €
22.97 €
45.80 €
15.34 €
57.08 €
13.35 €
15.34 €
14.45 €
21.45 €
13.35 €
91.32 €
80.51 €