Most Played Designers, 2009 Edition

Lacxox's geeklist (http://www.boardgamegeek.com/geeklist/38463) reminded me of the articles I wrote a couple of years ago about how many plays were recorded for each designer for the users pf the stats. I realised that now I have the plays in a database, an updated version of those numbers is no more than an SQL query away. In case I forget, here's the query:

select d.name, sum(p.quantity) from designers d, plays p, games g, gameDesigners gd where p.game = g.bggid and d.bggid = gd.designerId and g.bggid = gd.gameId group by d.bggid order by 2 desc

So that's ALL plays recorded by my 600+ users (including plays of expansions). What are the answers?

1. Reiner Knizia 69673 plays - an average of 117 plays per user
2. Alan Moon 26208 plays
3. Wolfgang Kramer 20931
4. Thomas Lehmann 17086 - holy dooley, I bet they're mostly Race
5. Klaus-Jurgen Wrede 16975
6. Andreas Seyfarth 15938
7. Richard Garfield 15481
8. Klaus Teuber 14935
9. Richard Borg 13120
10. Michael Schacht 13104
11. Uwe Rosenberg 13103
12. Bruno Faidutti 11843
13. Friedemann Friese 10283
14. Donald X. Vaccarino 8877 - the new sensation, it's all Dominion!
15. Stefan Dorra 8430
16. Martin Wallace 8404
17. Aaron Weissblum 7992
18. Brunot Cathala 7625
19. Dirk Henn 6615
20. Michael Kiesling 6469
21. Rudiger Dorn 6282
22. Sid Sackson 6249
23. Bernd Brunnhofer 6109
24. Franz-Benno Delonge 5965
25. Stefan Feld 5963

I've left out Uncredited (2nd place) and Michael Tummelhofer (practically identical to Brunnhofer). Here's a quick list of the next guys: Burm, Gimmler, van Ness, Colovini, Daviau, Hostettler, Cassasola Merkle, Tavitian, Cornett, Maublanc, Yianni, van Moorsel. I like this list much better than Tom Vasel's list of allegedly great designers I've never heard of.

Now, what if I do this: (which are the most played games)

select g.name, sum(p.quantity) from plays p, games g where p.game = g.bggid group by g.bggid order by 2 desc

Let's go till we find something I haven't played :-).

1. Race for the Galaxy 13103
   
2. Magic 11023
3. Dominion 8878 (Donald X. Was 8877 above, the database must have been updated)
   
4. Lost Cities 7480
5. Carcassonne 7324
6. Ticket to Ride 6451
7. San Juan 5984
8. Settlers 5935
9. Puerto Rico 5846
10. Power Grid 5560
11. Agricola 5521
12. St Pete 4580
13. Ingenious 4429
14. Tichu 4387
15. No Thanks! 4375
16. Diamant 4313
17. Ra 4280
18. Hive 4049
19. Loopin' Louie 4003
20. For Sale 3956
21. Crokinole 3856
22. Bohnanza 3735
23. Pandemic 3714
24. Category 5 3690
25. Coloretto 3544
26. Liar's Dice 3521
27. Go 3387
28. Hey! That's My Fish! 3360
    
29. Tigris & Euphrates 3340
30. Can't Stop 3335
31. Memoir '44 3220
32. Notre Dame 3217

I haven't played Notre Dame, and don't really need to.