Table schema:
CREATE TABLE table_name_49 (player VARCHAR, club_province VARCHAR)

Question: Who is the player from Aurillac?
SQL: SELECT player FROM table_name_49 WHERE club_province = "aurillac"