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 = '233' AND p.product_id IN (19189,19190,19191,19192,19194,19195,19202,19203,19204,19205,19206,19207,19208,19209,19210,19211,19212,19213,19214,19215,19216,19217,19218,19219,19220,19221,19222,19223,19224,19225,19226,19227,19228,19229,19230,19231,19232,19233,19234,19235,19236,19237,19238,19239,19240,19241,19242,19243,19244,19245,19246,19247,19248,19249,19250,19251,19252,19253,19254,19255,19256,19257,19258,19259,19260,19261,19262,19263,19264,19265,19266,19267,19268,19269,19270,19271,19272,19273,19274,19275,19276,19277,19278,19279,19280,21825,21826,21828,21829,21830,21831,21838,21839,21865,21866,21868,21870,21872,23021,23022,23023,23024,23025,23026,23027,23028,23029,23030,23031,23032,23033,23034,23035) 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,10000TestTSELECT 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 = '233' AND p.product_id IN (18432,18439,18440,18441,18443,18444,18448,18450,18452,18454,18455,18457,18458,18462,18463,18466,18467,18471,18473,18475,18476,18477,18479,18486,18488,18490,18496,18533,18569,18693,18694,18696,18697,18700,18701,18702,18703,18704,18706,18707,18710,18711,18713,18714,18715,18718,18719,18720,18721,18723,18724,18725,18727,18729,18730,18731,18733,18734,18735,18736,18737,18738,18743,18744,18745,18746,18747,18748,18749,18750,18757,19169,19172,19177,19182,19185,19187,19189,19190,19191,19192,19194,19195,19202,19203,19204,19205,19206,19207,19208,19209,19210,19211,19212,19213,19214,19215,19216,19217,19218,19219,19220,19221,19222,19223,19224,19225,19226,19227,19228,19229,19230,19231,19232,19233,19234,19235,19236,19237,19238,19239,19240,19241,19242,19243,19244,19245,19246,19247,19248,19249,19250,19251,19252,19253,19254,19255,19256,19257,19258,19259,19260,19261,19262,19263,19264,19265,19266,19267,19268,19269,19270,19271,19272,19273,19274,19275,19276,19277,19278,19279,19280,19281,19283,19284,19295,19298,19381,19390,19529,19562,19563,19565,19568,19572,19573,19575,19577,19579,19580,19581,19582,19583,19584,19587,19697,19707,19708,19711,19712,19713,19715,19716,19753,19785,19808,19866,19867,19870,19873,19878,21825,21826,21828,21829,21830,21831,21838,21839,21865,21866,21868,21870,21872,22742,23021,23022,23023,23024,23025,23026,23027,23028,23029,23030,23031,23032,23033,23034,23035,23436,23437,23438,23439,23440,23441,23442,23443,23444,23445,23446,23447,23448,23449,23450,23451,23452,23453,23454,23455,23456,23457,23458,23459,23460,23492,23493,23494,23502,23503,23504,23523,23524,23525,23546,23547,23548,23549,23550,23551,23767,24893,24894,24895,24896,24897,24898,24900,24901,24902,24903,24904,24905,24906,24907,24908,24917,24918,24986,28084,28085,28086,28087,28088,28089,28090,28091,28092,28093,28094,28095,28096,28307,28416,28417,28418,28419,28935,28936,28938,29230,29231,29233,29234,29235,29236,29237,29238,29239,29240,29242,29243,29244,29245,29246,29247,29248,29250,29803,29806,29807,29818,29840,30152,30153,30154,30156,30160,30161,30162,30164,30232,30233,30234,30235,30236,30237,30238,30239,30241,30242,30243,30244,30248,30249,30250,30251,30252,30560,30568,30571,30574,30628,30630,30636,30640,30841,31259,31260,31261,31262,32000,32001,32002,32003,32004,32049,32050,32051,32052,32053,32054,32055,32059,32062,32063,32064,32065,32069,32070,32073,32074,32075,32081,32252,32253,32254,32255,32256,32257,32258,32259,32260,32261,32262,32263,32264,32265,32266,32267,32268,32269,32270,32271,32272,32274,32405,32406,32407,32408,32409,32410,32411,32412,32413,32414,32415) 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 vasarinės padangos internetu pigiau | Autorolis.lt