Предсказания. Пророки. Ченнелинг. Спиритизм
9.41 €
45.74 €
8.39 €
25.12 €
15.99 €
19.66 €
49.00 €
11.81 €
3.42 €
35.29 €
5.93 €
11.54 €
10.47 €
8.66 €
6.82 €
14.72 €
10.22 €
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 = '680' 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 = '680' 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 = '680' 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
9.41 €
45.74 €
8.39 €
25.12 €
15.99 €
19.66 €
49.00 €
11.81 €
3.42 €
35.29 €
5.93 €
11.54 €
10.47 €
8.66 €
6.82 €
14.72 €
10.22 €