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
DannyS712
.
Toggle Highlighting
SQL
SELECT page_id AS 'pageid', page_title AS 'title', ptrpt_value AS 'target', actor_name AS 'creator' FROM page JOIN pagetriage_page ON page_id = ptrp_page_id JOIN pagetriage_page_tags ON ptrp_page_id = ptrpt_page_id JOIN revision rv ON page_latest = rev_id JOIN actor ON rev_actor = actor_id JOIN user_groups ON actor_user = ug_user WHERE ptrp_reviewed = 0 AND ptrpt_tag_id = 9 AND page_namespace = 0 AND page_is_redirect = 1 AND EXISTS ( # Only 1 revision SELECT 1 FROM pagetriage_page_tags tags2 WHERE tags2.ptrpt_page_id = page_id AND tags2.ptrpt_tag_id = 7 AND tags2.ptrpt_value = 1 ) AND EXISTS ( # Move log from the same time by the same person SELECT 1 FROM logging_logindex lgl2 WHERE log_namespace = page_namespace AND log_title = page_title AND log_timestamp = rev_timestamp AND log_actor = rev_actor AND log_type = 'move' AND log_action = 'move' ) AND ug_group = 'extendedmover' LIMIT 10; #SELECT ptp.*, ptpt.*, ptt.* FROM pagetriage_page ptp # JOIN pagetriage_page_tags ptpt ON ptrp_page_id = ptrpt_page_id # JOIN pagetriage_tags ptt ON ptrt_tag_id = ptrpt_tag_id # WHERE ptrp_page_id = 75025628; #AND ptrt_tag_name = 'rev_count'; SELECT * FROM logging_logindex WHERE log_namespace = 0 AND log_title = 'Hemlock_Semiconductor_Corporation' LIMIT 10; SELECT * FROM revision JOIN comment ON rev_comment_id = comment_id WHERE rev_page = 75025628
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...