TestArray
(
[0] => chevrolet
[1] => modeliniai-guminiai-kilimeliai-chevrolet-malibu-2011-2015
[2] => modeliniai-eva-polimeriniai-salono-kilimeliai-chevrolet-corvette-c5-1997-2004-priekiniai
)
TSELECT 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 = '59' AND p.product_id IN (198,199,200,201,202,203,204,205,1482,1483,1484,1485,1486,1487,1488,1489,1490,1491,1492,1493,1494,1495,1496,2475,2476,2477,2478,2479,2480,2481,2482,3070,3071,3531,3532,4014,4015,4016,4017,4018,4019,4020,4021,4022,4023,4024,4025,4026,4724,4725,4726,4727,4728,4729,4730,4731,4732,4733,4734,4735,4736,5624,5625,5626,5627,5628,5629,5630,5631,5632,5633,5634,5635,5636,5637,5638,5639,5640,5641,5642,5643,5644,5645,5646,5647,5648,5649,5650,5651,5652,5653,5654,5655,5656,5657,5658,5659,5660,5661,5662,5663,5664,5665,5666,5667,5668,5669,5670,5671,5672,5673,5674,5675,7529,7530,7531,7532,7533,7534,7535,7536,8138,8139,8140,8141,8142,8143,8144,8145,8146,8147,8148,8149,8150,8847,8848,8849,8850,8851,8852,8853,8854,8855,8856,8857,8858,8859,9607,9894,9895,9896,10669,10670,10671,10672,10673,10674,10675,10676,10677,10678,10679,10680,11537,11538,11539,11540,11541,11542,11543,11544,12087,12088,12089,12090,12091,12092,12093,12094,12095,12096,12097,12098,12099,14272,14273,14323,14387,14467,14549,14621,14622,14746,14873,14874,14938,15218,15219,15220,15221,15222,15223,15224,15225,15226,15227,15228,16005,16238,16889,16890,17313,17314,17315,17316,17317,17318,17319,17320,17321,17322,17323,17324,23820,23821,23822,23823,23824,23825,23826,23827,23828,23829,23830,23831,23832,23833,23834,23835,23836,23837,23838,24379,24380,24381,24382,24383,24384,24385,24386,24387,24388,24389,24390,24391,24392,24393,24394,24395,24396,24397,25162,25632,25633,25634,25635,25636,25637,25638,25639,26231,26232,26233,26234,26235,26236,26237,26238,26239,26240,26241,26242,26243,26244,26245,26246,26247,26248,26249,27076,27077,27078,27079,27080,27354,12835,13334,13338,13349,13368,13379,13404,13405,13413,13415,13416,13420,13421,13422,13424,13426,13428,13430,13484,13550,14246,13334,13349,13368,13379,13404,13405,13413,13415,13416,13420,13421,13422,13424,13426,13428,13484,13550,14246) 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
Chevrolet automobiliniai kilimėliai internetu pigiau | autorolis.lt