CREATE TABLE table_39309 ("Team #1" CLOB, "Agg." CLOB, "Team #2" CLOB, "1st leg" CLOB, "2nd leg" CLOB)

Which 1st leg that has hemofarm?
SELECT "1st leg" FROM table_39309 WHERE "Team #1" = 'hemofarm'
SELECT "1st leg" FROM "table_39309" WHERE "Team #1" = 'hemofarm'