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
KHarlan (WMF)
.
Toggle Highlighting
SQL
use enwiki_p; use enwiki_p; SELECT /* MediaWiki\Extension\PageTriage\ArticleMetadata::getMetadata */ ptrpt_page_id,ptrt_tag_name,ptrpt_value,ptrp_reviewed,ptrp_created,page_title,page_namespace,page_is_redirect,ptrp_last_reviewed_by,ptrp_reviewed_updated,user_name AS `reviewer` FROM `pagetriage_page_tags`,`pagetriage_tags`,`page`,`pagetriage_page` LEFT JOIN `user` ON ((user_id = ptrp_last_reviewed_by)) WHERE ptrpt_page_id IN (SELECT /* MediaWiki\Extension\PageTriage\Api\ApiPageTriageList::getPageIds */ ptrp_page_id FROM `pagetriage_page` INNER JOIN `page` ON ((ptrp_page_id = page_id)) WHERE page_is_redirect = '0' AND page_namespace = '0') AND (ptrpt_tag_id = ptrt_tag_id) AND (ptrpt_page_id = ptrp_page_id) AND (page_id = ptrp_page_id) SELECT ptrp_page_id FROM `pagetriage_page` INNER JOIN `page` ON ((ptrp_page_id = page_id)) WHERE page_is_redirect = '0' AND page_namespace = '0' AND (( ptrp_created < '20100825053045' )) ORDER BY ptrp_created DESC, ptrp_page_id DESC
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...