TestArray
(
[0] => mazda
[1] => guminis-bagazines-kilimelis-mazda-6-iii-2013-sedanas
[2] => modeliniai-guminiai-kilimeliai-mazda-mx-30-2020-su-borteliais
)
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 (395,396,397,398,399,400,401,402,403,404,405,406,407,408,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1817,1818,1819,1820,1821,1822,1823,1824,1825,1826,1827,1828,1829,1830,1831,1832,1833,1834,1835,1836,1837,1838,1839,1840,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,3129,3130,3131,3132,3133,3450,3451,3452,3453,3454,3481,3560,3561,3562,3802,4278,4279,4280,4281,4282,4283,4284,4285,4286,4287,4288,4289,4290,4291,4292,4293,4294,4295,4296,4297,4298,4299,4300,4301,4302,4303,4304,4305,4988,4989,4990,4991,4992,4993,4994,4995,4996,4997,4998,4999,5000,5001,5002,5003,5004,5005,5006,5007,5008,5009,5010,5011,5012,5013,5014,5015,6284,6285,6286,6287,6288,6289,6290,6291,6292,6293,6294,6295,6296,6297,6298,6299,6300,6301,6302,6303,6304,6305,6306,6307,6308,6309,6310,6311,6312,6313,6314,6315,6316,6317,6318,6319,6320,6321,6322,6323,6324,6325,6326,6327,6328,6329,6330,6331,6332,6333,6334,6335,6336,6337,6338,6339,6340,6341,6342,6343,6344,6345,6346,6347,7721,7722,7723,7724,7725,7726,7727,7728,7729,7730,7731,7732,7733,7734,8402,8403,8404,8405,8406,8407,8408,8409,8410,8411,8412,8413,8414,8415,8416,8417,8418,8419,8420,8421,8422,8423,8424,8425,8426,8427,8428,8429,9111,9112,9113,9114,9115,9116,9117,9118,9119,9120,9121,9122,9123,9124,9125,9126,9127,9128,9129,9130,9131,9132,9133,9134,9135,9136,9137,9138,9636,9637,9638,9639,9640,9641,9642,9643,10126,10127,10128,10129,10130,10131,10132,10133,10134,10135,10136,10137,10138,10139,10140,10141,10142,10143,10144,10145,10146,10147,10148,10149,10150,10151,10152,10909,10910,10911,10912,10913,10914,10915,10916,10917,10918,10919,10920,10921,10922,10923,10924,10925,10926,10927,10928,10929,10930,10931,11698,11699,11700,11701,11702,11703,11704,11705,11706,11707,11708,11709,11710,11711,12328,12329,12330,12331,12332,12333,12334,12335,12336,12337,12338,12339,12340,12341,12342,12343,12344,12345,12346,12347,12348,12349,13601,13655,13667,13718,13730,13806,13869,13872,14346,14347,14348,14349,14496,14497,14498,14499,14500,14501,14564,14565,14566,14567,14664,14665,14666,14667,14668,14669,14670,14671,14672,14763,14823,14824,14949,14950,14951,14990,15471,15472,15473,15474,15475,15476,15477,15478,15479,15480,15481,15482,15483,15484,15485,15486,15487,15488,15489,15490,15491,15492,15493,16147,16148,16149,16150,16151,16152,16153,16154,16155,16156,16157,16158,16159,16160,16508,16979,16980,16981,16982,16983,16984,17544,17545,17546,17547,17548,17549,17550,17551,17552,17553,17554,17555,17556,17557,17558,17559,17560,17561,17562,17563,17564,17565,17566,17567,24046,24047,24048,24049,24050,24051,24052,24053,24054,24055,24056,24057,24058,24059,24605,24606,24607,24608,24609,24610,24611,24612,24613,24614,24615,24616,24617,24618,25286,25287,25288,25289,25478,25821,25822,25823,25824,25825,25826,25827,25828,25829,25830,25831,25832,25833,25834,26457,26458,26459,26460,26461,26462,26463,26464,26465,26466,26467,26468,26469,26470,26787,27010,27153,27154,27155,27156,27157,27329,27330,27331,12823,12827,12828,12869,13273,13349,13358,13361,13388,13482,13485,13486,13490,13491,13500,13511,13513,13516,13541,13550,13553,13555,13558,13569,13574,13581,13583,13585,13587,13594,13273,13349,13358,13361,13388,13482,13485,13486,13490,13491,13500,13511,13513,13516,13541,13550,13553,13555,13558,13569,13574,13581,13583,13585,13587,13594) 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
Mazda automobiliniai kilimėliai internetu pigiau | autorolis.lt