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

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.

Country           W L T  GF GA  DIF  WIN%  PPG
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.

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.

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.