Cookies on the Taraji Website We use cookies to improve your browsing experience and help us improve our websites. For more information, please click here. By continuing to use our website, you agree to our use of such cookies.
select * from can2015_player p inner join stat_match_hand m on p.id = m.player_id and m.match_id = 2420 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