Samet Usta - Şeker Sigorta
Name :
Samet Usta
Team :
Şeker Sigorta
Value :
1,436,000
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',27)-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=324809 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;
Match Time Goal Save Foul Y.C. R.C. Rating
Total 0" 0 - 0 0 0 0
  • 1 / 1. showing
  • 1
  • Next
  • Last
Road to the Final