CREATE TABLE table_name_49 (player VARCHAR(255), club_province VARCHAR(255))
Who is the player from Aurillac?
    
SQL: SELECT player FROM table_name_49 WHERE club_province = "aurillac"