Registration year of dewiki users - Quarry

Fork of Distribution of registration time for users with 5+ edits (huwiki) by Tgr

This query is marked as a draft This query has been published by Polibil.

See https://quarry.wmflabs.org/query/37312 for enwiki.
See https://quarry.wmflabs.org/query/37314 for 25+ edits.

SQL

use dewiki_p;

SELECT
	CONCAT(SUBSTR(user_registration, 1, 4), 'q', (SUBSTR(user_registration, 5, 2) - 1) DIV 3 + 1) AS registration_date,
    -- SUBSTR(user_registration, 1, 6) AS registration_date,
    count(*) AS new_users
FROM (
	SELECT
		user_id,
		user_registration
) tmp
GROUP BY registration_date
ORDER BY registration_date
;

​x
 
use dewiki_p;​SELECT    CONCAT(SUBSTR(user_registration, 1, 4), 'q', (SUBSTR(user_registration, 5, 2) - 1) DIV 3 + 1) AS registration_date,    -- SUBSTR(user_registration, 1, 6) AS registration_date,    count(*) AS new_usersFROM (    SELECT        user_id,        user_registration) tmpGROUP BY registration_dateORDER BY registration_date;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

Checking query status...