Monday, August 31, 2009

Superliga Top Career Scorers

Update: 8/7/2010 - I pulled Corey Ashe off this list because he actually only has one goal. There was a typo in my spreadsheet. Also, this info has been superseded by a new post.

The third edition of the Superliga has come and gone, and I was interested in determining the top scorer across the history of the competition. Without further ado, here is everyone that has scored more than one goal:

Landon Donovan Los Angeles 4

Alan Gordon Los Angeles 3
Ante Razov Chivas USA 3
Armando Pulido Tigres 3
Arturo Alvarez FC Dallas 3
Kheli Dube New England 3
Shalrie Joseph New England 3
Stuart Holden Houston 3

Abdoulie Mansally New England 2
Bobby Boswell Houston 2
Brian McBride Chicago 2
Carlos Ruíz FC Dallas 2
Chris Klein Los Angeles 2
Cuauhtémoc Blanco Chicago 2
Dwayne De Rosario Houston 2
Francis Doe DC United 2
Itamar Da Silva Tigres 2
Jose Rodolfo Reyes San Luis 2
Juan Pablo Rodríguez Santos Laguna 2
Luciano Emilio DC United 2
Luis Gabriel Rey Atlante 2
Matías Vuoso Santos Laguna 2
Nate Jaqua Houston 2
Omar Arellano Chivas 2
Rafael Márquez Lugo Pachuca 2

Sunday, August 30, 2009

2009 CCL Results By Country

I finally got the database to work the way I want it to. Here's the standings by country after the preliminary round. Not surprisingly, Mexico is on top after Pachuca and Cruz Azul pounded their respective opponents. Trinidad and Tobago are flying high after seeing both its teams advance, and the USA manages to avoid the bottom spot even though one of their entrants was the Red Bulls.

Expect lots of changes when I update these at the midpoint of the group stage.

Mexico 3 0 1 16 3 13 75.0 2.50
Puerto Rico 1 0 1 1 0 1 50.0 2.00
Trinidad & Tobago 2 1 1 7 5 2 50.0 1.75
Honduras 2 2 0 8 5 3 50.0 1.50
Panama 2 2 0 4 5 -1 50.0 1.50
Costa Rica 1 2 1 5 12 -7 25.0 1.00
El Salvador 0 0 2 2 2 0 0.0 1.00
USA 0 1 3 5 6 -1 0.0 0.75
Canada 0 1 1 0 1 -1 0.0 0.50
Guatemala 0 2 0 1 10 -9 0.0 0.00

Where's all the CCL posts?

Folks who followed this blog last year are probably wondering why I haven't been posting about the CONCACAF Champions League, especially since the tourney is well under way. There are two reasons.
  1. I've been working a ridiculous amount lately.
  2. I set up a database to track all this stuff, and it's been more difficult than I thought to write the SQL statements to join between the country, team and results tables and get the summed results. I'm not a database guru by trade.
If I can't figure it out soon, I'll probably give up and go back to spreadsheets like I did it last year. Ugh.

Wednesday, August 19, 2009

Now There's Some Trivia

I'm sure other folks knew this, but I just recently learned that Columbus Crew head coach Robert Warzycha was one of only 12 foreign players to take the field during the opening weekend of the English Premier League. This likely makes the Polish Rifle the first player to jump from the Premier League to MLS.

Tuesday, August 04, 2009

Can MLS Advance?

Here's what the three MLS teams need to do this week to make it into the group stages of the CONCACAF Champions League:

Toronto FC
Down a goal after their home leg, things look fairly bleak. These results would get them through:
  • A win by two goals or more
  • A scoring draw with two or more goals
Winning by one goal would get them to extra time, but if they couldn't get a goal in the first leg, chances are they won't in the return leg either. With their experience parking the bus in front of the goal from last year's tournament, I expect Colin Clarke's men to advance.

DC United
The 1-1 tie at RFK didn't completely kill their chances of advancing, but they absolutely have to score in El Salvador. They advance with:
  • A win
  • A scoring draw with two or more goals
It doesn't sound much better than Toronto's plight, but any scoring draw gets them to extra time and potentially into penalties.

New York Red Bulls
OK -- hands up if you expected the Red Bulls to have the best chance of advancing to the group stage... Mrs. Osorio, you can put your hand down now. Coming away with a 2-2 tie in their away leg was a huge result. There are many ways NY can advance:
  • A win
  • Any draw with less than two goals scored
A loss still ruins things for NYRB, but even a 2-2 tie only forces extra time. If the Red Bulls can keep from scoring another own goal, they just might make it through.