Usuarios de eswiki por número de talleres
ActivePublic
Actions

Authored by Platonides on Jan 14 2021, 1:01 AM.

Tags

None

Referenced Files

	F33998917: Usuarios de eswiki por número de talleres
	Jan 14 2021, 1:01 AM

Subscribers

	SELECT SUBSTRING_INDEX(page_title, '/', 1) AS User, COUNT(*) AS count FROM page WHERE page_namespace=2 AND page_title REGEXP '^[^/]+/Taller' GROUP BY User ORDER BY count DESC LIMIT 16;
	+-----------------------+-------+
	\| User \| count \|
	+-----------------------+-------+
	\| Mauriziok \| 256 \|
	\| NataliaChile \| 92 \|
	\| Ryoga_Nica \| 90 \|
	\| Marisa_Glez_Glez_Glez \| 72 \|
	\| Amitie_10g \| 66 \|
	\| Mboix \| 61 \|
	\| Jaluj \| 51 \|
	\| Porretero \| 50 \|
	\| AnselmiJuan \| 47 \|
	\| Giselle_Bordoy_(WMAR) \| 46 \|
	\| Linfocito_B \| 46 \|
	\| Gmagno \| 45 \|
	\| Cris_Evero \| 43 \|
	\| Odalcet \| 42 \|
	\| Verdelunar \| 41 \|
	\| 5truenos \| 40 \|
	+-----------------------+-------+
	16 rows in set (0.41 sec)

	SELECT SUBSTRING_INDEX(page_title, '/', 1) AS User, COUNT(*) AS count FROM page WHERE page_namespace=2 AND page_title REGEXP '^[^/]+/Taller' GROUP BY User ORDER BY count DESC LIMIT 16;
	+-----------------------+-------+
	\| User \| count \|
	+-----------------------+-------+
	\| Mauriziok \| 256 \|
	\| NataliaChile \| 92 \|
	\| Ryoga_Nica \| 90 \|
	\| Marisa_Glez_Glez_Glez \| 72 \|
	\| Amitie_10g \| 66 \|
	\| Mboix \| 61 \|
	\| Jaluj \| 51 \|
	\| Porretero \| 50 \|
	\| AnselmiJuan \| 47 \|
	\| Giselle_Bordoy_(WMAR) \| 46 \|
	\| Linfocito_B \| 46 \|
	\| Gmagno \| 45 \|
	\| Cris_Evero \| 43 \|
	\| Odalcet \| 42 \|
	\| Verdelunar \| 41 \|
	\| 5truenos \| 40 \|
	+-----------------------+-------+
	16 rows in set (0.41 sec)

Usuarios de eswiki por número de talleres ActivePublicActions