MAÇ SONU | -
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 'GROUP BY ma.id ORDER BY m.siralama,ad' at line 12
SELECT IF(u.id=t.kaptan,1,0) AS kaptan, u.id, IF(ma.uye_id=0,ucfirst(ma.oyuncu_ad),CONCAT(ucfirst(u.ad),' ',ucfirst(u.soyad))) AS ad, getUserImage(u.resim_id) AS uimage, ma.mevki,ud.mevcut_sezon_degeri FROM (takimlar t,mac_aksiyonlari ma) LEFT JOIN uyeler u ON (u.id=ma.uye_id ) LEFT JOIN uye_degerleri ud ON (ud.uye_id=ma.uye_id ) LEFT JOIN mevkiler m ON(m.kod=ma.mevki) WHERE t.id=ma.`takim_id` AND ma.mac_id=57827 AND ma.takim_id= GROUP BY ma.id ORDER BY m.siralama,adYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY ma.id ORDER BY m.siralama,ad' at line 12
SELECT IF(u.id=t.kaptan,1,0) AS kaptan, u.id, IF(ma.uye_id=0,ucfirst(ma.oyuncu_ad),CONCAT(ucfirst(u.ad),' ',ucfirst(u.soyad))) AS ad, getUserImage(u.resim_id) AS uimage, ma.mevki,ud.mevcut_sezon_degeri FROM (takimlar t,mac_aksiyonlari ma) LEFT JOIN uyeler u ON (u.id=ma.uye_id ) LEFT JOIN uye_degerleri ud ON (ud.uye_id=ma.uye_id ) LEFT JOIN mevkiler m ON(m.kod=ma.mevki) WHERE t.id=ma.`takim_id` AND ma.mac_id=57827 AND ma.takim_id= GROUP BY ma.id ORDER BY m.siralama,adYou 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 u.id=ta.`uye_id` AND ta.`uye_id` NOT IN (SE' at line 6
SELECT u.`id`,CONCAT(ucfirst(u.ad),' ',ucfirst(u.soyad)) AS ad, getUserImage(u.resim_id) AS uimage,m.kod AS mevki FROM (takim_oyuncular ta,uyeler u) LEFT JOIN mevkiler m ON(m.id=u.mevki_id) WHERE ta.`takim_id`= AND u.id=ta.`uye_id` AND ta.`uye_id` NOT IN (SELECT uye_id FROM mac_aksiyonlari WHERE mac_id=57827 AND takim_id=) ORDER BY m.siralama,u.ad;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 u.id=ta.`uye_id` AND ta.`uye_id` NOT IN (SE' at line 6
SELECT u.`id`,CONCAT(ucfirst(u.ad),' ',ucfirst(u.soyad)) AS ad, getUserImage(u.resim_id) AS uimage,m.kod AS mevki FROM (takim_oyuncular ta,uyeler u) LEFT JOIN mevkiler m ON(m.id=u.mevki_id) WHERE ta.`takim_id`= AND u.id=ta.`uye_id` AND ta.`uye_id` NOT IN (SELECT uye_id FROM mac_aksiyonlari WHERE mac_id=57827 AND takim_id=) ORDER BY m.siralama,u.ad;
      Yedekler
      • TOPLAM DEĞER 0 RB$
      • TOPLAM DEĞER 0 RB$
      Hakem  Saha Koordınatörü  
      Maç Bilgileri
      • 01 Ocak 1970 Perş., 02:00
      • / ...
      • -
      • -
      Maçın Özet Görüntüleri
      Nesine.com Maç İstatistikleri
      Konya Kocaeli
      Gol
      24
      Faul
      5 3
      Korner
      0 0
      Sarı Kart
      0 0
      Kırmızı Kart
      0 0
      Rating
      5.0 5.0
      geri ileri
      rakipBUL