TestTSELECT p.product_id, p.price AS sprice, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, pd.url 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) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2c.category_id = '232' AND p.product_id IN (21910,21911,21912,21913,21914,21915,21916,21917,21918,21919,21920,21921,21922,21924,21925,21926,21927,21928,21929,21930,21957,22026,22063,22066,22077,22190,22191,22198,22200,22205,22288,22320,22322,22323,22330,22331,22332,22335,22339,22341,22345,22348,22354,22358,22364,22370,22373,22379,22383,22384,22390,22393,22396,22397,22398,23110,23111,23134,21923,30377,30378,30379,30380,30381,30382,30383,30384,30385,30386,30387,30388,30389,30390,30391,30392,30393,30394,30395,30396,30397,30398,30399,30400,30401,30402,30403,30404,30405,30406,30407,30408,30409,30411,30412,30414,30415,30416,30417,30418,30419,30420,30421,30422,30424,30425,30426,30427,30428,30429,30430,30431,30432,30433,30434,30435,30436,30437,30438,30439,30440,30441,30442,30443,30444,30445,30446,30447,30448,30449,30450,30655,30657,30673,30674,30683,30684,30687,30691,30870,30871,30877,30878,30886,30892,30893,30910,30951,31008,31010,31014,31064,31065,31099,31100,31102,31103,31104,31105,31106,31107,31108,31109,31113,31114,31115,31116,31118,31120,31121,31122,31123,31125,31126,31127,31129,31130,31131,31132,31133,31135,31136,31137,31138,31139,31140,31141,31142,31143,31144,31145,31146,31147,31148,31151) AND p.quantity > 0 GROUP BY p.product_id ORDER BY CASE WHEN p.quantity <= 0 THEN 1 ELSE 0 END, p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,10000
Naujos padangos internetu pigiau | Autorolis.lt