Untitled query #81988

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

SQL

select rev_timestamp, user_id, user_name, rev_page, pp_value, page_title, page_is_redirect from 
pagelinks, 
user,
actor_logging,
revision_userindex LEFT JOIN page_props ON pp_page=rev_page AND pp_propname='wikibase_item',
page
where pl_from IN (1796805) and pl_namespace=2 and pl_title=user_name
and user_id=actor_user
and actor_id=rev_actor
and rev_timestamp>20240200000000
and pp_value IS NULL
and page_id=rev_page
and page_namespace=0
limit 10

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.

SQL

Checking query status...