Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Reinhard Kraasch
.
Anlage von Benutzerkonten in einem bestimmten Zeitraum
Toggle Highlighting
SQL
Use dewiki_p; Select logging.log_actor, logging.log_type, logging.Log_action, logging.log_timestamp, actor.actor_id, actor.actor_name, actor.actor_user, user.user_id, user.user_name, user.user_registration, user.user_editcount From logging join actor on logging.log_actor = actor.actor_id join user on user.user_id = actor.actor_user Where log_type = 'newusers' and actor_name = 'Briannapollock' and log_action = 'create' and log_timestamp >'20170101000000' And log_timestamp <'20190701000000' and user.user_editcount > 2 ;
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...