CREATE TABLE table_49582 ("Nat." CLOB, "Name" CLOB, "Moving to" CLOB, "Type" CLOB, "Transfer window" CLOB, "Transfer fee" CLOB, "Source" CLOB)

What's the name that had a moving to Anorthosis Famagusta and a transfer window of winter?
SELECT "Name" FROM table_49582 WHERE "Transfer window" = 'winter' AND "Moving to" = 'anorthosis famagusta'
SELECT "Name" FROM "table_49582" WHERE "Moving to" = 'anorthosis famagusta' AND "Transfer window" = 'winter'