Abfrage war ung├╝ltig!
SELECT Grammatur, Shop_Marke.Name as MName, Hersteller, Orderid, R, G, B, HerstellerPid, Shop_Marke_Farben.bezeichnung as cbez, Shop_Groessen.Bezeichnung as gbez, Shop_Artikel.Name, Warenkorb_Textil.id, session, Warenkorb_Textil.artikelid, Warenkorb_Textil.farbenid, Warenkorb_Textil.groessenid, Warenkorb_Textil.anzahl, ek FROM Shop_Marke, Warenkorb_Textil, Shop_Farbe_Groesse, Shop_Artikel, Shop_Marke_Farben, Shop_Groessen WHERE Warenkorb_Textil.artikelid = Shop_Farbe_Groesse.Artikelid AND Warenkorb_Textil.farbenid = Shop_Farbe_Groesse.Farbenid AND Warenkorb_Textil.groessenid = Shop_Farbe_Groesse.Groessenid AND Warenkorb_Textil.artikelid = Shop_Artikel.Artikelid AND Warenkorb_Textil.farbenid = Shop_Marke_Farben.id AND Shop_Groessen.id = Warenkorb_Textil.groessenid AND Shop_Marke.id = Shop_Artikel.Hersteller AND session = '2pdgvaqceqk2kbk8nmmu535ba5' GROUP BY artikelid, farbenid ORDER BY Name, cbez, Orderid DESC
Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'devil_haupt.Shop_Groessen.Orderid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by