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
MPGuy2824
.
Toggle Highlighting
SQL
SELECT page_namespace, page_title, ptrpt_page_id, ptrp_created, ptrp_reviewed, ptrp_reviewed_updated, COUNT(*), ptrt_tag_name, ptrpt_value FROM pagetriage_page_tags LEFT JOIN pagetriage_page ON ptrp_page_id = ptrpt_page_id LEFT JOIN page ON page_id = ptrpt_page_id JOIN pagetriage_tags on ptrpt_tag_id = ptrt_tag_id GROUP BY ptrpt_page_id HAVING COUNT(*) = 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...