YENER KAYI - İPEKYOL
- Ad Soyad :
- YENER KAYI
- Takım :
- İPEKYOL
- Yaş :
- 34
- Güçlu Ayak
- Çift Ayak
- Mevkii :
- Orta Saha Sol
- Değer :
- 1,631,000
- Boy :
- 2
- Kilo :
- 82
| Maç |
Süre |
Gol |
Kurtarış |
Faul |
S.K. |
K.K. |
Rating |
Illegal mix of collations (latin5_turkish_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
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',1)-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=318502
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
