NAJI GOCHE - regionalny magazyn społeczno-kulturalny

BŁĄD - Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'najigoche.c.nazwa' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT art.id,art.tytul, aut.nazwisko,aut.imie,aut.miejscowosc, c.nazwa, n.data,n.rok,n.numer, CASE WHEN art.cyklID=0 THEN 1000 WHEN art.cyklID>0 THEN 10 ELSE NULL END AS cyklord FROM artykul AS art, autor AS aut, ng AS n, cykl AS c WHERE aut.id=art.autorID AND n.id=art.ngID AND (art.cyklID=0 OR c.id=art.cyklID) GROUP BY art.id ORDER BY art.tytul ASC,n.numer ASC


NAJI GOCHE | e-mail: