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 s.sene=2024
GROUP BY ma.uye_id
ORDER BY gol_rakibe desc li' at line 33 SELECT SQL_CALC_FOUND_ROWS
ma.takim_id,u.id, getUserImage(u.resim_id) AS logo,
CONCAT(SUBSTR(CONCAT(u.ad,' ',u.soyad),1,IF(LENGTH(CONCAT(u.ad,' ',u.soyad))>20,20,LENGTH(CONCAT(u.ad,' ',u.soyad)))),' (',SUBSTR(t.ad,1,IF(LENGTH(t.ad)>15,15,LENGTH(t.ad))),IF(LENGTH(t.ad)>15,'..',''),') ') AS ad,
/*SUM(sut_isabetli) AS sut_isabetli,
SUM(sut_isabetsiz)+SUM(sut_isabetli) AS sut,*/
SUM(kurtaris) AS kurtaris,
SUM(korner) AS korner,
SUM(teknik) AS teknik,
SUM(guc) AS guc,
SUM(ofans) AS ofans,
SUM(defans) AS defans,
SUM(hiz) AS hiz,
SUM(refleks) AS refleks,
SUM(yan_toplar) AS yan_toplar,
SUM(birebir) AS birebir,
SUM(birebir) AS pozisyon_alma,
COUNT(DISTINCT m.id) AS mac_sayisi,
SUM(IF(LENGTH(faul)>0 AND faul!='0',LENGTH(faul) -LENGTH(REPLACE(faul, ',',''))+1,0)) AS faul,
SUM(IF(LENGTH(kart_sari)>0 AND kart_sari!='0' ,LENGTH(kart_sari) -LENGTH(REPLACE(kart_sari, ',',''))+1,0)) AS kart_sari,
SUM(IF(LENGTH(kart_kirmizi)>0 AND kart_kirmizi!='0' ,LENGTH(kart_kirmizi) -LENGTH(REPLACE(kart_kirmizi, ',',''))+1,0)) AS kart_kirmizi,
SUM(IF(LENGTH(gol_kendikalesine)>0 AND gol_kendikalesine!='0' ,LENGTH(gol_kendikalesine) -LENGTH(REPLACE(gol_kendikalesine, ',',''))+1,0)) AS gol_kendikalesine,
SUM(IF(LENGTH(gol_rakibe)>0 AND gol_rakibe!='0' ,LENGTH(gol_rakibe) -LENGTH(REPLACE(gol_rakibe, ',',''))+1,0)) AS gol_rakibe
FROM mac_aksiyonlari ma,takimlar t,maclar m,sezon s,lig_iller li,ligler l,uyeler u
WHERE li.lig_id=s.lig_id AND ma.mac_id=m.id AND t.id=ma.takim_id
and l.id=li.lig_id and l.uygulama_id=5
AND m.sezon_id=s.id
and ma.uye_id=u.id
and s.durum=1 /*AND s.sezon_turu=1*/ and s.lig_id=l.id
AND l.listede_goster=1
and t.il_id=li.il_id
/*and s.id=*/
AND l.id=
AND s.sene=2024
GROUP BY ma.uye_id
ORDER BY gol_rakibe desc limit 0,10;