chrisv
Sandman wrote:

Sandman
Yeah, Snit had to create a new Steve Carroll lookalike account when he lost his fretwizzen@gmail.com account, which he had used a long while:

year(date) as year, monthname(date) as month, count(p.id) as nr from usenet.posts as p join (usenet.authors as a) on (p.author = a.id) where a.email = "fretwizzen@gmail.com" group by year(date), month order by p.datetime asc

OUTPUT: - --------------------- year | month | nr - --------------------- 2012 | October | 11 2013 | November | 5 2013 | December | 27 2014 | January | 3 2014 | April | 3 2014 | May | 1 2014 | July | 12 2014 | August | 9 2014 | September | 9 2014 | October | 16 2014 | November | 50 2014 | December | 22 2015 | January | 12 2015 | February | 8 2015 | April | 3 2015 | May | 2 2015 | August | 12 2015 | September | 7 2015 | October | 1 2015 | November | 35 2015 | December | 4 2016 | January | 12 2016 | February | 9 2016 | March | 12 2016 | April | 14 2016 | May | 22 - ---------------------

So he created frelwizzen@gmail.com:

select year(date) as year, monthname(date) as month, count(p.id) as nr from usenet.posts as p join (usenet.authors as a) on (p.author = a.id) where a.email = "frelwizzen@gmail.com" group by year(date), month order by p.datetime asc

OUTPUT: - ----------------------- year | month | nr - ----------------------- 2016 | May | 2 2016 | June | 6 2016 | August | 8 2016 | September | 82 2016 | October | 16 2016 | November | 2 2016 | December | 11 2017 | January | 33 2017 | February | 552 2017 | March | 502 2017 | April | 494 2017 | May | 144 2017 | July | 448 2017 | August | 1391 2017 | September | 475 - -----------------------

chrisv
That thing is fscked in the head.