EVE Technology Lab

SO, over the past week, I've been mining zKillboard.com's API for region-specific kills. I've created the database in such a way I can drill down various queries, which aren't available on ZK like so:

• What item is lost the most, excluding ammo, in system X
• What item is lost the most, group by system, order by loss count
• Show characters most lost fittings, group by fitting, order by count lost descending

Or, alternatively I can drill down deper

• What ships are lost on a saturday in system X
• What ship does a player usually use on day X

I mean literally at this point I can query ANYTHING I want against a kill mail, especially with regards in how it relates to characters, systems, regions, corps, alliances, items, and more.....

Note: as to not cripple zKillboard with my queries, all queries are cached for 30m, should I need to re-query it if the import script fails for some reason. Additionally, every subsequent query includes a lastKillID parameter and a regionID parameter so it doesn't walk over the same data over and over again.

The script, currently is only looking at one region in low-sec, but it's been coded in such a way I only need to specify a region name in my cron job, so in theory, I can watch ALL km's!

SO here's the question... what to do with this? I'm basically interested in any interesting queries you guys could come up with :)