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
Kasyap
.
Toggle Highlighting
SQL
use tewiki_p; select l1.log_id, l1.log_timestamp, user_registration, (datediff(str_to_date(l1.log_timestamp, "%Y%m%d%H%i%S"), str_to_date(user_registration, "%Y%m%d%H%i%S"))<=1) as diff, l1.log_user_text, l1.log_title, l1.log_comment, l1.log_page, rev_id, ar_rev_id, rev_len, ar_len, (ctd_name="visualeditor") as visualeditor, (ctd_name="mobile edit") as mobile_edit, (ctd_name="contenttranslation") as contenttranslation from user, logging_compat as l1 LEFT JOIN revision ON l1.log_page=rev_page AND l1.log_actor=rev_actor LEFT JOIN archive ON l1.log_title=ar_title AND ar_namespace=0 AND ar_actor=l1.log_actor AND ar_timestamp>=l1.log_timestamp LEFT JOIN change_tag ON ct_log_id=l1.log_id LEFT JOIN change_tag_def ON ctd_id=ct_tag_id where user_registration > 20200000000000 and user_registration<20210000000000 and user_editcount>0 and l1.log_user=user_id and l1.log_namespace=0 and l1.log_type="create" and l1.log_id>00000000 and l1.log_id<1299371120 and (datediff(str_to_date(l1.log_timestamp, "%Y%m%d%H%i%S"), str_to_date(user_registration, "%Y%m%d%H%i%S"))<=1)
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...