col : goal | date | venue | opponent | score | result | competition row 1 : 1 | 2008-5-28 | sheriff stadium, tiraspol, moldova | moldova | 0-1 | 2-2 | friendly match row 2 : 2 | 2010-10-12 | hanrapetakan stadium, yerevan, armenia | andorra | 4-0 | 4-0 | euro 2012 q row 3 : 3 | 2011-6-4 | petrovsky stadium, saint petersburg, russia | russia | 0-1 | 3-1 | euro 2012 q row 4 : 4 | 2011-9-2 | estadi comunal d'aixovall, and | andorra | 0-1 | 0-3 | euro 2012 q row 5 : 5 | 2011-10-7 | hanrapetakan stadium, yerevan, armenia | macedonia | 1-0 | 4-1 | euro 2012 q row 6 : 6 | 2012-2-29 | tsirion stadium, limassol, cyprus | canada | 1-1 | 1-3 | friendly match row 7 : 7 | 2012-2-29 | tsirion stadium, limassol, cyprus | canada | 1-2 | 1-3 | friendly match
what are all of the stadium names? when did the events take place? where did his play in 2008?
sheriff stadium, tiraspol, moldova
Goal Date Venue Opponent Score Result Competition
where did his play in 2008?
1 2008-5-28 Sheriff Stadium, Tiraspol, Moldova Moldova 0-1 2-2 Friendly match
2 2010-10-12 Hanrapetakan Stadium, Yerevan, Armenia Andorra 4-0 4-0 Euro 2012 Q
3 2011-6-4 Petrovsky Stadium, Saint Petersburg, Russia Russia 0-1 3-1 Euro 2012 Q
4 2011-9-2 Estadi Comunal d'Aixovall, And Andorra 0-1 0-3 Euro 2012 Q
5 2011-10-7 Hanrapetakan Stadium, Yerevan, Armenia Macedonia 1-0 4-1 Euro 2012 Q
6 2012-2-29 Tsirion Stadium, Limassol, Cyprus Canada 1-1 1-3 Friendly match
7 2012-2-29 Tsirion Stadium, Limassol, Cyprus Canada 1-2 1-3 Friendly match
Sheriff Stadium, Tiraspol, Moldova
where did his play in 2008? || when did the events take place? | what are all of the stadium names?