1055 - Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vlacek.s.expires_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_fsk18, p.products_id, p.products_price, p.products_price_extra, p.products_price_shop, p.products_extra_charges, p.free_shipping, s.expires_date, s.specials_quantity, p.products_tax_class_id, m.manufacturers_name, p.products_image, pd.products_name, p.products_vpe, p.products_vpe_status, p.products_vpe_value, pd.products_short_description FROM orders_products opa left join specials s on opa.products_id = s.products_id and s.status = '1' AND s.specials_id IN (SELECT s.specials_id FROM specials s LEFT JOIN specials_to_zones sz ON s.specials_id = sz.specials_id WHERE s.products_id = '77852' AND (sz.zone_id IN (4) OR sz.zone_id IS NULL)), orders_products opb, orders o, products_to_categories p2c, products p left outer join manufacturers m on p.manufacturers_id = m.manufacturers_id , products_description pd where opa.products_id = '77852' and opa.orders_id = opb.orders_id and opb.products_id != '77852' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id in (307,8203,8198,8211,8212,8195,8551,5044,5043,7864,8406,8414,8413,5161,5159,5157,5155,5153,5151,5149,5148,5145,5143,5141,5139,5137,8405,5160,5158,5156,5154,5152,5150,5147,5146,5144,5142,5140,5138,5136,5045,5046,5049,5051,5052,5054,5055,5056,5057,5058,8199,8200,8201,8202,5067,8217,8218,8214,8404,5306,6114,7867,7868,6118,7857,7858,7859,7860,7861,7862,7863,6128,7869,7870,7871,7872,7873,7874,7875,7876,7865,7866,6375,6386,6515,6478,6479,6480,6482,6483,6484,6485,6486,6467,6468,6469,6471,6472,6473,6474,6475,6476,6465,7974,7975,7976,8204,8196,8197,8013,8014,8015,8108,8106,8104,8087,8088,8192,8191,8110,8111,8112,8113,8114,8115,8116,8117,8118,8119,8120,8121,8122,8123,8124,8125,8126,8127,8128,8129,8130,8131,8132,8133,8134,8135,8136,8137,8138,8139,8140,8141,8142,8143,8144,8145,8146,8147,8148,8149,8150,8151,8152,8153,8154,8155,8156,8157,8158,8159,8160,8161,8162,8163,8164,8165,8166,8167,8168,8169,8170,8171,8172,8173,8174,8175,8176,8177,8178,8179,8180,8181,8182,8183,8185,8186,8187,8188,8189,8190,8210,8207,8208,8209,8086,8109,7747,7748,7749,7750,7751,7753,7754,7755,8101,7789,8215,8216,8213,7877,7878,7879,7880,8206,7956,8205,8409,8408,8407,8412,8410,8411,8415,8416,8417,8418,8419,8420,8421,8422,8423,8424,8425,8426,8427,8428,8429,8430,8431,8432,8433,8434,8435,8436,8437,8438,8439,8549,8550,8444,8445,8446,8447,8608,8609,8607,8588,8587,8586,8540,8596,8595,8589,8590,8591,8592,8593,8594,8552,8553,8554,8555,8585,8575,8576,8577,8578,8579,8580,8581,8582,8583,8584,8522,8523,8597,8598,8599,8600,8601,8602,8603,8570,8571,8572,8573,8574,8604,8605,8606,8569,8568,8556,8557,8558,8559,8560,8561,8562,8563,8564,8565,8566,8567,8610,8611,8612,8613,8614,8615,8616,8617,8618,8619,8620,8621,8622,8623,8624,8625,8626,8627,8628,8629,8630,8631,8632,8633,8634,8635,8636,8637,8638,8639,8640,8641,8642,8643,8644,8645,8646,8647,8648,8649,8650,8651,8652,8653,9925,9902,9905,9904,9903,9949,9948,9947,9498,9942,9941,9940,9938,9939,9937,9935,9936,9926,9927,9928,9929,9930,9931,9932,9933,9934,9911,9910,9906,9907,9908,9909,9943,9946,9945,9944,9955,9951,9950,9954,9953,9952,9914,9915,9916,9917,9918,9924,9919,9920,9921,9922,9923,8950,9913,9487,9483,9481,9482,9111,9112,9746,9747,9748,9749,9750,9751,9752,9753,9775,9776,9777,9778,9779,9780,9781,9782,9783,9784,9785,9213,9214,9442,9479,9480,9445,9488,9912,9240,9241,9242,9243,9244,9245,9246,9247,9248,9249,9250,9251,9252,9253,9486,9294,9295,9296,9297,9298,9299,9300,9301,9302,9303,9304,9305,9306,9307,9308,9309,9310,9311,9312,9313,9314,9315,9316,9317,9318,9319,9320,9321,9322,9323,9328,9329,9330,9331,9332,9502,9503,9337,9338,9339,9340,9341,9342,9343,9344,9345,9346,9347,9348,9349,9350,9351,9352,9353,9354,9355,9356,9357,9358,9359,9360,9361,9362,9367,9372,9373,9374,9375,9376,9377,9378,9379,9380,9385,9499,9500,9501,9390,9391,9392,9393,9394,9395,9396,9397,9398,9403,9508,9509,9510,9511,9408,9409,9410,9411,9412,9413,9414,9415,9416,9421,9422,9426,9427,9428,9429,9430,9431,9432,9433,9799,9798,9797,9796,9795,9794,9800,9801,9802,9803,9804,9805,9806,9807,9808,9809,9810,9811,9812,9813,9814,9815,9816,9817,9818,9819,9820,9821,9827,9826,9856,9828,9829,9830,9831,9832,9833,9834,9835,9836,9837,9838,9839,9840,9841,9842,9843,9844,9845,9846,9847,9848,9849,9850,9851,9852,9853,9854,9855,9857,9956,9957,9958,9959,9960,9961,9962,9963,9964,9965,9966,9967,9968,9969,9970,9971,9972,9973,9974,9975,9976,9977,9978,9979,9980,9981,9982,9983,9984,9985,9986,9987,9988,9989,9990,9991,9992,9993,9994,9995,9996,9997,9998,9999,10000,10001,10002,10003,10004,10005,10006,10007,10008,10009,10010,10011,10012,10013,10014,10015,10016,10017,10018,10019,10020,10021,10022,10023,10024,10025,10026,10027,10028,10029,10030,10031,10032,10033,10034,10035,10036,10037,10038,10039,10040,10041,10042,10043,10044,10045,10046,10047,10048,10049,10050,10051,10052,10053,10054,10055,10056,10057,10058,10059,10060,10061,10062,10063,10064,10065,10066,10067,10068,10069,10070,10071,10072,10073,10074,10075,10076,10077,10078,10079,10080,10081,10082,10083,10084,10085,10086,10087,10088,10089,10090,10091,10092,10093,10094,10095,10096,10097,10098,10099,10100,10101,10102,10103,10104,10105,10106,10107,10108,10109,10110,10111,10112,10113,10114,10115,10116,10117,10118,10119,10120,10121,10122,10123,10124,10125,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,10153,10154,10155,10156,10157,10158,10159,10160,10161,10162,10163,10164,10165,10166,10167,10168,10169,10170,10171,10172,10173,10174,10175,10176,10177,10178,10179,10180,10181,10182,10194,10195,10196,10197,10198,10199,10200,10201,10202,10203,10204,10205,10206,10207,10208,10209,10210,10211,10212,10213,10214,10215,10216,10217,10218,10219,10220,10221,10222,10223,10224,472) and pd.language_id = '3' and opb.products_id = pd.products_id group by p.products_id order by o.date_purchased desc limit 6

[XT SQL Error]