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
Softly falling rain
.
Toggle Highlighting
SQL
-- query needs updating for new tamplate changes. https://phabricator.wikimedia.org/T299417 -- SELECT tl_from, tl_namespace, tl_title from templatelinks where tl_from = 5974403; -- It will change to: -- SELECT tl_from, lt_namespace, lt_title from templatelinks join linktarget on lt_target_id = lt_id where tl_from = 5974403; -- SELECT p.page_title, concat("[[", p.page_title, "]]"), concat("[[Talk:", p.page_title, "]]"), r.rev_timestamp SELECT concat("[[", p.page_title, "]]"), r.rev_timestamp FROM page AS p, revision AS r WHERE p.page_namespace = 0 AND p.page_is_redirect = 0 AND p.page_latest = r.rev_id AND r.rev_timestamp > 20180000000000 AND r.rev_timestamp < 20190000000000 AND p.page_title NOT IN (SELECT page_title FROM page WHERE page_namespace = 1) AND NOT p.page_id IN (SELECT tl_from FROM templatelinks WHERE tl_title in ('dab', 'Dab', 'Disamb', 'disamb', 'Geodis', 'geodis', 'Geodab', 'geodab', 'hndis','Hndis', 'surname','Surname', 'wi','Wi', 'wt','Wt', 'Rfd-NPF', 'given_name', 'Given_name', 'given-name-stub', 'Given-name-stub', 'surname-stub', 'Surname-stub' ) OR tl_title like "Db-%" OR tl_title like "%isambig%" OR tl_title like "%_name" OR tl_title like "%index_article" OR tl_title like "%_redirect" OR tl_title like "%index" ) ORDER BY r.rev_timestamp LIMIT 200
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...