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; 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 ('32593','194906','216815','566401','620989','1046562','1093306','2284812','2875039','2911355','3412663','4019807','4225728','5546165','7468659','7998347','8079205','9466654') AND (ptrpt_tag_id = ptrt_tag_id) AND (ptrpt_page_id = ptrp_page_id) AND (page_id = ptrp_page_id);
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...