Match Espérance ST-EBS Béni Khiar
Le 16/09/2017 - S.ZOUAOUI

36 - 23
Espérance ST-EBS Béni Khiar
samedi 16 septembre 2017 - 17h00


select * from can2015_player p inner join stat_match_hand m on p.id = m.player_id and m.match_id = 1515 where p.club_team = 1539 and p.discipline_id = 9 and m.val1 != 0 and p.playing_position != 'Gardien de but' order by m.val1 desc