Ahmet Cem Engin - Mindshare
- Ad Soyad :
- Ahmet Cem Engin
- Takım :
- Mindshare
- Yaş :
- 34
- Güçlu Ayak
- Sağ Ayak
- Mevkii :
- Defans Sol
- Değer :
- 2,001,333
- Boy :
- 168
- Kilo :
- 60
Maç |
Süre |
Gol |
Kurtarış |
Faul |
S.K. |
K.K. |
Rating |
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=295554
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;
Toplam |
0" |
0 |
- |
0 |
0 |
0 |
0 |
- 1 / 1. gösteriliyor
- 1
- Sonraki
- Son