NOTE: This page is experimental. Bug reports to carter.barry@gmail.com. Query language is SQLite3.

Prepend rss. to the URL for an RSS feed, csv. to the URL for CSV output.

QUERY: SELECT COUNT(*), player, winlose FROM players WHERE game_number IN ( SELECT game_number FROM games WHERE game_number IN ( SELECT game_number FROM players WHERE game_number IN ( SELECT game_number FROM players WHERE player='skurvey' ) AND player='barrycarter' ) AND game_type='D' ) AND player IN ('barrycarter', 'skurvey') GROUP BY player, winlose ORDER BY winlose, player

To edit query (or if query above is munged), see textbox at bottom of page

Empty result may indicate error: I'm not sure why my error checking code isn't working.

Source code

COUNT(*) player winlose
12 skurvey Reserved
15 barrycarter Waiting
3 skurvey Waiting

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query