Change Details

MariaDB [centralauth_p]> select count(*), year(gu_registration) from globaluser where gu_home_db is null or gu_home_db = '' group by year(gu_registration); +----------+-----------------------+ | count(*) | year(gu_registration) | +----------+-----------------------+ | 2227 | 2008 | | 3592 | 2009 | | 2817 | 2010 | | 2406 | 2011 | | 2197 | 2012 | | 1344 | 2013 | | 10836 | 2014 | | 2817773 | 2015 | +----------+-----------------------+ 8 rows in set (27.68 sec)