Replicas browser and optimizer
Show .de accounts at dewiki
This query is marked as a draft
This query has been published
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.
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
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in