CREATE TABLE table_47214 ("Date" CLOB, "Opponent" CLOB, "Venue" CLOB, "Result" CLOB, "Attendance" FLOAT)

Where was the venue that Linfield was the opponent?
SELECT "Venue" FROM table_47214 WHERE "Opponent" = 'linfield'
SELECT "Venue" FROM "table_47214" WHERE "Opponent" = 'linfield'