CREATE TABLE table_26842217_4 (site VARCHAR2, visiting_team VARCHAR2)

Where's the louisiana-lafayette as a visiting team?
SELECT site FROM table_26842217_4 WHERE visiting_team = "Louisiana-Lafayette"
SELECT "site" FROM "table_26842217_4" WHERE "Louisiana-Lafayette" = "visiting_team"