CREATE TABLE table_43670 ("Match" TEXT, "Date" TEXT, "Location" TEXT, "Lineup" TEXT, "Result" TEXT, "Competition" TEXT)

Which Match played in a Location of San Francisco has a Competition of Semifinal?
SELECT "Match" FROM table_43670 WHERE "Competition" = 'semifinal' AND "Location" = 'san francisco'
SELECT "Match" FROM "table_43670" WHERE "Competition" = 'semifinal' AND "Location" = 'san francisco'