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

give the 1st leg score against ilisiakos
SELECT "1st leg" FROM table_24345 WHERE "Team #2" = 'Ilisiakos'
SELECT "1st leg" FROM "table_24345" WHERE "Team #2" = 'Ilisiakos'