miscellaneous

I wonder how many times each country has earnt the number 1 spot for energy over the years, just wondered as it makes me proud to be British when I see pothead keeping the number 1 spot each month Lol

Lol thanks chimp thats an awesome thing of you to say and made me smile :) dont worry about sj i think the fact nobody likes him is finally starting to get to him.

For anyone thinking im randomly hating on sj, he had his usual vile posts deleted from this thread.

• Philippines - 12
• United Kingdom - 12
• USA - 7
• Australia - 6
• Sweden - 5
• Canada - 3
• Netherlands -1
• Unknown - 1

Oo, so if i win this month uk top the charts?

Whose the unknown?

priceless in aug 2014?

Priceless is from the UK, I'm 99% sure.

Based on profile setting from country:

mysql> SELECT countries.long_name AS country, COUNT(*) AS count
    -> FROM history_bots
    -> INNER JOIN bots ON bots.id = history_bots.bot_id
    -> LEFT JOIN countries ON countries.id = bots.profile_country
    -> WHERE rank = 1 AND (year > 2011 OR month >= 7)
    -> GROUP BY countries.long_name
    -> ORDER BY count DESC;
+----------------+-------+
| country        | count |
+----------------+-------+
| Australia      |    13 |
| Sweden         |     9 |
| United Kingdom |     6 |
| NULL           |     4 |
| United States  |     4 |
| Canada         |     3 |
| Denmark        |     1 |
| Netherlands    |     1 |
| Nepal          |     1 |
+----------------+-------+

I think your query is a little flawed this time Ender. It's only counting the bots current country setting, not the country they were set to when the month was won.

Yeah, and Benny has since bought some of those Top bots.

Rivan/Vector have been doing the buying aswell :P