gu_home_db is null or '' - by year
ActivePublic
Actions

Authored by Krenair on Jun 7 2015, 1:17 PM.

Tags

Referenced Files

	F175899: gu_home_db is null or '' - by year
	Jun 7 2015, 1:17 PM

Subscribers

None

	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)

Event Timeline

Krenair edited the content of this paste. (Show Details)Jun 7 2015, 1:17 PM

Krenair changed the title of this paste from untitled to gu_home_db is null or '' - by year.

Krenair updated the paste's language from autodetect to autodetect.

Krenair added a project: MediaWiki-extensions-CentralAuth.

Cparle mentioned this in T192288: Write wikibase statements data to search index in MediaInfo.Apr 16 2018, 3:37 PM