Select kamp.kid, kamp.rating, lag.navn, lag.lid, lag.alderstrinn, lag.logo, kamp.dato, kamp.alvor, kamp.plass, klubb.klid, klubb.arenanavn, kamp.malmsil, kamp.malmot, kamp.sted, (kamp.malmsil-kamp.malmot) as malfork, sum(malmsil) as malmsilfor, sum(malmot) as malmotmot, sum(cast(kamp.malmsil AS UNSIGNED) > cast(kamp.malmot AS UNSIGNED)) as seire, sum(cast(kamp.malmsil AS UNSIGNED) < cast(kamp.malmot AS UNSIGNED)) as tap, sum(malmsil = malmot) uavgjort, count(kamp.kid) as totkamper FROM kamp INNER JOIN lag ON lag.lid = kamp.lag_lid INNER JOIN sesong ON kamp.sesid = sesong.sesid LEFT JOIN klubb ON lag.lid = klubb.klid WHERE lag.alderstrinn = 0 AND kamp.lag_lid = AND kamp.malmsil NOT LIKE 'x' GRoup by lag.lid order by lag.navn;You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND kamp.malmsil NOT LIKE 'x' GRoup by lag.lid order by lag.navn' at line 28