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

What's the 1st leg result in the round where team #1 is Iraklis?
SELECT "1st leg" FROM table_22823 WHERE "Team #1" = 'Iraklis'
SELECT "1st leg" FROM "table_22823" WHERE "Team #1" = 'Iraklis'