Toggle navigation
βeta
Home
New Query
Recent Queries
Discuss
Database tables
MediaWiki
Wikibase
Replicas browser and optimizer
Login
Fork
This query is marked as a draft
This query has been published
by
Luke081515
.
Requested at https://de.wikipedia.org/wiki/Special:PermaLink/153290067#Bottung_m.C3.B6glich_.3F Shows accounts which are registered in 2016, and have .de at the end of their username.
SQL
USE dewiki_p; SELECT user_name, user_registration, user_editcount # name, registration, editcount FROM user WHERE user_name LIKE '%.de' # has '.de' at the end of the username AND user_registration > 20141231235959 # registration after 31.12.15 23:59:59 AND user_name NOT LIKE '%@%' # ignoring mails ORDER BY user_registration DESC; # Show the newest accounts first (includes deleted contribs)
By running queries you agree to the
Labs ToS
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
All SQL code is licensed under
CC0 License
.
Checking query status...