İstatistikler
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,20;
  •     Ad Sayı Maç Sayısı Ortalama