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

SELECT p.products_model, p.products_ean, p.rating, pd.products_name, p.products_id, p.products_price, m.manufacturers_name, p.products_quantity, p.availability_threshold, p.products_image, p.products_weight, p.manufacturers_id, p.products_vpe, p.products_vpe_status, p.products_vpe_value, p.products_discount_allowed, p.products_tax_class_id, p.products_not_available, p.products_shipping_days, p.variante_von, p.variantenvorlage, p.products_inline_thumbnail, s.specials_categories_id, s.stop as specials_to_time, s.specials_new_products_price as special_price, s.happyhour, s.start as special_start_time, s.stop as special_stop_time, s.status as is_special, pd.products_seo_name FROM products AS p LEFT JOIN products_description AS pd ON pd.products_id=p.products_id LEFT JOIN manufacturers AS m ON p.manufacturers_id=m.manufacturers_id LEFT JOIN products_to_categories AS p2c ON p2c.products_id=p.products_id LEFT JOIN categories AS c ON c.categories_id=p2c.categories_id LEFT JOIN specials s ON p.products_id = s.products_id AND s.specials_categories_id!=365 LEFT JOIN reviews AS r ON r.products_id=p.products_id WHERE p.products_status = '1' AND p.variante_von='0' AND pd.language_id='2' AND m.manufacturers_id='300' AND m.active='1' AND c.categories_status='1' AND ((FIND_IN_SET("6",p.alergens)!=0)) AND p.rating>='0' GROUP BY p.products_id ORDER BY c.sort_order ASC, p.products_sort ASC

[XT SQL Error]