user: ### NOW ANSWER:
Question: Tell me the affiliation for mls team of MetroStars and pick number of 26
Columns: ['Pick #', 'MLS Team', 'Player', 'Position', 'Affiliation']
Types: ['real', 'text', 'text', 'text', 'text']
Sample row: [21.0, 'MetroStars', 'Zach Wells', 'GK', 'UCLA']
SQL:

assistant: SELECT "Affiliation" FROM "Table" WHERE "MLS Team" = 'MetroStars' AND "Pick #" = 26.0;