SELECT i.id as parent, i.steuersatz, ac.cat_id, i.name_deu AS art_name, i.desc_deu AS artikel_text, i.haendler_id, i.childs, i.pict01, i.pict02, i.pict03, i.pict04, i.pict05, i.pict06, i.pict07, i.pict08, i.pict09, i.pict10, i.pict11, i.pict12, i.pict13, i.pict14, i.pict15, i.pict16, i.pict17, i.lieferfrist, i.show_object, i.fsk_check, i.staffelung, i.versand_preis, i.childs, i.is_foto, i.marke, i.configurator, i.configurator_check, i.config_einheit_check, i.config_menge_check, i.rechner_check, i.mixer_artikel_check, i.timer_check, i.timer_end, i.timer_menge, i.timer_anzeige, i.timer_art_disable, i.sortierung, i.grundeinheit, i.ge_netto_aktiv, i.motiv_uploadp_check, i.motiv_uploadt_check, i.artikelgruppe, i.neu_check, a.id as id, a.netto, a.angebot, a.angebot_active, a.menge, a.ge_netto, a.mpn, a.gtin, (CASE WHEN (a.angebot_active = 'y') THEN a.angebot ELSE a.netto END) AS preis_sort, c.cat_pass, c.name_deu AS cat_name, a.merkmal1 AS mm1_val, a.merkmal2 AS mm2_val, a.wert1 AS w1_val, wert2 AS w2_val, m.merkmal_deu as merkmal1, w.wert_deu as wert1, mm.merkmal_deu as merkmal2, ww.wert_deu as wert2 FROM shop_articles_info as i LEFT JOIN shop_articles as a ON a.parent_id = i.id LEFT JOIN shop_article_to_cats AS ac ON ac.parent_id = a.parent_id LEFT JOIN shop_categories as c ON ac.cat_id = c.id LEFT JOIN shop_merkmale as m ON a.merkmal1 = m.id LEFT JOIN shop_werte as w ON a.wert1 = w.id LEFT JOIN shop_merkmale as mm ON a.merkmal2 = mm.id LEFT JOIN shop_werte as ww ON a.wert2 = ww.id WHERE online = 'y' AND ac.cat_id IN ('1','2','3','4','7','8','9','10','11') GROUP BY parent ORDER BY i.sortierung, i.id DESC , i.id DESC
Error: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db_343390_2.ac.cat_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Aufruf von articles.class.php Zeile 206