CREATE TABLE table_29626583_3 (mls_team VARCHAR, position VARCHAR, player VARCHAR)

Which team has a midfielder of konrad warzycha?
SELECT mls_team FROM table_29626583_3 WHERE position = "Midfielder" AND player = "Konrad Warzycha"
SELECT "mls_team" FROM "table_29626583_3" WHERE "Konrad Warzycha" = "player" AND "Midfielder" = "position"