• 01 Ocak 1970 Perş.
    -
    Hakem : Saha Koordinatörü : Saha :

KADER ADAMLARI -

    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 ma.takim_id=) xx ON(u.id=xx.uye_id AND xx.takim_id=) ' at line 22
    SELECT u.id AS uye_id, CONCAT(ucfirst(u.ad),' ',ucfirst(soyad)) AS oyuncu_ad, getUserImage(u.resim_id) AS logo, IF(xx.uye_id=t.kaptan,1,0) AS kaptan, IFNULL(ROUND((SUM(xx.rating)/COUNT(DISTINCT mac_id)),1),0) AS rating, IFNULL(ROUND((SUM(xx.teknik)/COUNT(DISTINCT mac_id)),1),0) AS teknik, IFNULL(ROUND((SUM(xx.defans)/COUNT(DISTINCT mac_id)),1),0) AS defans, IFNULL(SUM(xx.kart_sari),0) AS kart_sari, IFNULL(SUM(xx.kart_kirmizi),0) AS kart_kirmizi, IFNULL(SUM(xx.gol_rakibe),0) AS gol FROM (takimlar t,uyeler u) LEFT JOIN ( SELECT CONCAT(ucfirst(u.ad),' ',ucfirst(u.soyad)) AS oyuncu_ad,ma.uye_id,mac_id,u.takim_id, rating,teknik,defans, IF(LENGTH(kart_sari)>0 AND kart_sari!='0',LENGTH(kart_sari)-LENGTH(REPLACE(kart_sari,',',''))+1,0) AS kart_sari, IF(LENGTH(kart_kirmizi)>0 AND kart_kirmizi!='0' ,LENGTH(kart_kirmizi)-LENGTH(REPLACE(kart_kirmizi,',',''))+1,0) AS kart_kirmizi, 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,uyeler u WHERE ma.uye_id=u.id AND u.takim_id=ma.takim_id AND u.takim_id= AND ma.takim_id=) xx ON(u.id=xx.uye_id AND xx.takim_id=) WHERE u.takim_id=t.id AND t.id= GROUP BY u.id ORDER BY kaptan DESC, gol_rakibe DESC,rating DESC,teknik DESC, defans DESC;
  • golcü
    gol
  • yıldız oyuncu
    rating
  • teknik deha
    teknik puan
  • savunmacı
    savunma puan

KADER ADAMLARI -

    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 ma.takim_id=) xx ON(u.id=xx.uye_id AND xx.takim_id=) ' at line 22
    SELECT u.id AS uye_id, CONCAT(ucfirst(u.ad),' ',ucfirst(soyad)) AS oyuncu_ad, getUserImage(u.resim_id) AS logo, IF(xx.uye_id=t.kaptan,1,0) AS kaptan, IFNULL(ROUND((SUM(xx.rating)/COUNT(DISTINCT mac_id)),1),0) AS rating, IFNULL(ROUND((SUM(xx.teknik)/COUNT(DISTINCT mac_id)),1),0) AS teknik, IFNULL(ROUND((SUM(xx.defans)/COUNT(DISTINCT mac_id)),1),0) AS defans, IFNULL(SUM(xx.kart_sari),0) AS kart_sari, IFNULL(SUM(xx.kart_kirmizi),0) AS kart_kirmizi, IFNULL(SUM(xx.gol_rakibe),0) AS gol FROM (takimlar t,uyeler u) LEFT JOIN ( SELECT CONCAT(ucfirst(u.ad),' ',ucfirst(u.soyad)) AS oyuncu_ad,ma.uye_id,mac_id,u.takim_id, rating,teknik,defans, IF(LENGTH(kart_sari)>0 AND kart_sari!='0',LENGTH(kart_sari)-LENGTH(REPLACE(kart_sari,',',''))+1,0) AS kart_sari, IF(LENGTH(kart_kirmizi)>0 AND kart_kirmizi!='0' ,LENGTH(kart_kirmizi)-LENGTH(REPLACE(kart_kirmizi,',',''))+1,0) AS kart_kirmizi, 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,uyeler u WHERE ma.uye_id=u.id AND u.takim_id=ma.takim_id AND u.takim_id= AND ma.takim_id=) xx ON(u.id=xx.uye_id AND xx.takim_id=) WHERE u.takim_id=t.id AND t.id= GROUP BY u.id ORDER BY kaptan DESC, gol_rakibe DESC,rating DESC,teknik DESC, defans DESC;
  • golcü
    gol
  • yıldız oyuncu
    rating
  • teknik deha
    teknik puan
  • savunmacı
    defans puan

OYUNCULAR

SON MAÇ KADROSU

    SON MAÇ KADROSU

      GENEL LİG PERFORMANSLARI

      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.id='0' OR '0'=0) GROUP BY ma.takim_id' at line 31
      SELECT SUM(rating) AS rating, 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 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=2 AND m.sezon_id=s.id AND s.sezon_turu=1 AND s.lig_id=l.id AND l.listede_goster=1 AND t.il_id=li.il_id AND ma.takim_id= AND (s.id='0' OR '0'=0) GROUP BY ma.takim_idSELECT SUM(rating) AS rating, 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 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=2 AND m.sezon_id=s.id AND s.sezon_turu=1 AND s.lig_id=l.id AND l.listede_goster=1 AND t.il_id=li.il_id AND ma.takim_id= AND (s.id='0' OR '0'=0) GROUP BY ma.takim_idYou 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.id='0' OR '0'=0) GROUP BY ma.takim_id' at line 31
      SELECT SUM(rating) AS rating, 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 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=2 AND m.sezon_id=s.id AND s.sezon_turu=1 AND s.lig_id=l.id AND l.listede_goster=1 AND t.il_id=li.il_id AND ma.takim_id= AND (s.id='0' OR '0'=0) GROUP BY ma.takim_idSELECT SUM(rating) AS rating, 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 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=2 AND m.sezon_id=s.id AND s.sezon_turu=1 AND s.lig_id=l.id AND l.listede_goster=1 AND t.il_id=li.il_id AND ma.takim_id= AND (s.id='0' OR '0'=0) GROUP BY ma.takim_id
      • Maç Sayısı
      • Gol
      • Faul
      • Sarı Kart
      • Kırmızı Kart
      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.id='2213' OR '2213'=0) GROUP BY ma.takim_id' at line 31
      SELECT SUM(rating) AS rating, 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 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=2 AND m.sezon_id=s.id AND s.sezon_turu=1 AND s.lig_id=l.id AND l.listede_goster=1 AND t.il_id=li.il_id AND ma.takim_id= AND (s.id='2213' OR '2213'=0) GROUP BY ma.takim_idSELECT SUM(rating) AS rating, 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 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=2 AND m.sezon_id=s.id AND s.sezon_turu=1 AND s.lig_id=l.id AND l.listede_goster=1 AND t.il_id=li.il_id AND ma.takim_id= AND (s.id='2213' OR '2213'=0) GROUP BY ma.takim_idYou 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.id='2213' OR '2213'=0) GROUP BY ma.takim_id' at line 31
      SELECT SUM(rating) AS rating, 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 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=2 AND m.sezon_id=s.id AND s.sezon_turu=1 AND s.lig_id=l.id AND l.listede_goster=1 AND t.il_id=li.il_id AND ma.takim_id= AND (s.id='2213' OR '2213'=0) GROUP BY ma.takim_idSELECT SUM(rating) AS rating, 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 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=2 AND m.sezon_id=s.id AND s.sezon_turu=1 AND s.lig_id=l.id AND l.listede_goster=1 AND t.il_id=li.il_id AND ma.takim_id= AND (s.id='2213' OR '2213'=0) GROUP BY ma.takim_id

      BU SEZON PERFORMANSLARI

      • Maç Sayısı
      • Gol
      • Faul
      • Sarı Kart
      • Kırmızı Kart