2SC1678

SQL: SELECT b.PID,b.Bezeichnung,b.Hersteller,b.Datecode,b.Beschreibung,l.Menge,l.VK,l.ID,l.RID FROM bauteile AS b LEFT JOIN lager AS l ON (b.PID = l.PID) WHERE b.Bezeichnung = '2SC1678' GROUP BY l.ID ORDER BY VK DESC,Menge DESC; Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db13501163-ede.b.PID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Ilość	Oznaczenie	Producent	Data produkcji	Opis	Foto	Arkusz Danych