Emre Gökdemir - Titrifikir
Ad Soyad :
Emre Gökdemir
Takım :
Titrifikir
Yaş :
44
Güçlu Ayak
Sağ Ayak
Mevkii :
Forvet
Değer :
4,326,500
Boy :
189
Kilo :
70
BIGINT UNSIGNED value is out of range in '(cast(`fairplay`.`ma`.`oyun_cikis` as unsigned) - cast(`fairplay`.`ma`.`oyun_giris` as unsigned))'
SELECT SQL_CALC_FOUND_ROWS m.id as mac_id,ma.id,ma.rating,t1.ad takim1_ad,m.gol1,m.gol2,t2.ad AS takim2_ad, IF(CAST(ma.oyun_cikis AS UNSIGNED)>0, IF(CAST(ma.oyun_giris AS UNSIGNED)>0,CAST(ma.oyun_cikis AS UNSIGNED)-CAST(ma.oyun_giris AS UNSIGNED),CAST(ma.oyun_cikis AS UNSIGNED)), getConfigValue('match_total_time',5)-CAST(ma.oyun_giris AS UNSIGNED)) AS sure, 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, kurtaris FROM (mac_aksiyonlari ma, maclar m, takimlar t1, takimlar t2) WHERE ma.mac_id=m.id AND ma.uye_id=258458 AND m.mac_durum=0 AND t1.id=m.takim1_id AND t2.id=m.takim2_id GROUP BY m.id ORDER BY m.mac_tarih DESC limit 0,10;
Maç Süre Gol Kurtarış Faul S.K. K.K. Rating
Toplam 0" 0 - 0 0 0 0
Final Yolu