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 'or m.takim2_id=) AND t1.id=m.takim1_id AND t2.id' at line 16
SELECT * FROM ( SELECT ma.id,ma.rating,m.id as mac_id, ma.takim_id,t1.id AS takim1_id,t2.id AS takim2_id, t1.ad AS takim1_ad,t2.ad AS takim2_ad, IF(u.id IS NULL,oyuncu_ad,CONCAT(u.ad,' ',u.soyad)) AS oyuncu_ad, sut_isabetli, sut_isabetsiz, IF(LENGTH(faul)>0 AND faul!='0' ,LENGTH(faul) -LENGTH(REPLACE(faul, ',',''))+1,0) AS faul, 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_kendikalesine)>0 AND gol_kendikalesine !='0',LENGTH(gol_kendikalesine) -LENGTH(REPLACE(gol_kendikalesine, ',',''))+1,0) AS gol_kendikalesine, IF(LENGTH(gol_rakibe)>0 AND gol_rakibe!='0' ,LENGTH(gol_rakibe) -LENGTH(REPLACE(gol_rakibe, ',',''))+1,0) AS gol_rakibe, korner FROM (mac_aksiyonlari ma,takimlar t1,takimlar t2,maclar m) LEFT JOIN uyeler u ON(u.id=ma.uye_id) WHERE ma.mac_id=m.id AND (m.takim1_id= or m.takim2_id=) AND t1.id=m.takim1_id AND t2.id=m.takim2_id /*and m.sezon_id=''*/ and YEAR(m.mac_tarih)='2020' ORDER BY ma.takim_id) xx ORDER BY mac_id;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 'or m.takim2_id=) AND t1.id=m.takim1_id AND t2.id' at line 16
SELECT * FROM ( SELECT ma.id,ma.rating,m.id as mac_id, ma.takim_id,t1.id AS takim1_id,t2.id AS takim2_id, t1.ad AS takim1_ad,t2.ad AS takim2_ad, IF(u.id IS NULL,oyuncu_ad,CONCAT(u.ad,' ',u.soyad)) AS oyuncu_ad, sut_isabetli, sut_isabetsiz, IF(LENGTH(faul)>0 AND faul!='0' ,LENGTH(faul) -LENGTH(REPLACE(faul, ',',''))+1,0) AS faul, 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_kendikalesine)>0 AND gol_kendikalesine !='0',LENGTH(gol_kendikalesine) -LENGTH(REPLACE(gol_kendikalesine, ',',''))+1,0) AS gol_kendikalesine, IF(LENGTH(gol_rakibe)>0 AND gol_rakibe!='0' ,LENGTH(gol_rakibe) -LENGTH(REPLACE(gol_rakibe, ',',''))+1,0) AS gol_rakibe, korner FROM (mac_aksiyonlari ma,takimlar t1,takimlar t2,maclar m) LEFT JOIN uyeler u ON(u.id=ma.uye_id) WHERE ma.mac_id=m.id AND (m.takim1_id= or m.takim2_id=) AND t1.id=m.takim1_id AND t2.id=m.takim2_id /*and m.sezon_id=''*/ and YEAR(m.mac_tarih)='2020' ORDER BY ma.takim_id) xx ORDER BY mac_id;
Maç Bilgileri
  • 01 Ocak 1970 Perş., 02:00
  • / ...
  • -
  • -