Conversation so far:
What is Villarreal?
Villarreal, officially called Vila-real, is a city in the province of Castellón which is part of the Valencian Community in the east of Spain.
How long did Robert Pires stay in Villarreal?
Robert Pires played for the Villarreal Club de Fútbol from 2006 to 2010.
Did Robert Pires retire after playing for the Villarreal Club de Fútbol?
After playing for the Villarreal Club de Fútbol, Robert Pires went on to play for Aston Villa Football Club from 2010 to 2011.

Question: What position did he play?
Self-contained rewrite: What position did Robert Pires play?