Table: cardiff_records
Columns: date
competition
opponents
venue
score

Question: Who was the opponent at the Football League Trophy competition?
SQL: SELECT "opponents" FROM cardiff_records WHERE "competition" = 'football league trophy'

Question: What was the opponent at the League Play Offs at home?
SQL: SELECT "opponents" FROM cardiff_records WHERE "venue" = 'home' AND "competition" = 'league play offs'

Question: What venue held that game against the Queens Park Rangers?
SQL: SELECT "venue" FROM cardiff_records WHERE "opponents" = 'queens park rangers'

Question: Who was the opponent at the away game with a score of 5-4?
SQL: SELECT "opponents" FROM cardiff_records WHERE "venue" = 'away' AND "score" = '5-4'

Question: Who was the opponent at the League Cup competition with a score of 3-1?
SQL: SELECT "opponents" FROM cardiff_records WHERE "competition" = 'league cup' AND "score" = '3-1'