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 = '4444' AND p.price > 0 AND p.quantity >= 0 GROUP BY p.product_id ORDER BY p.viewed DESC, LCASE(pd.name) DESC LIMIT 0,102SELECT 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 = '4444' AND p.price > 0 AND p.quantity >= 0 GROUP BY p.product_id ORDER BY p.viewed DESC, LCASE(pd.name) DESC LIMIT 0,102SELECT 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 = '4444' 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 | ALFAVIT.EU