Table schema:
CREATE TABLE table_name_47 (games VARCHAR, club VARCHAR)

Question: What games have colomiers as the club?
SQL: SELECT games FROM table_name_47 WHERE club = "colomiers"