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
FoBe
.
Toggle Highlighting
SQL
SELECT DISTINCT page.page_title, revision.rev_timestamp FROM page INNER JOIN revision ON page.page_latest = revision.rev_id INNER JOIN templatelinks ON page_id = tl_from INNER JOIN linktarget ON tl_target_id = lt_id WHERE lt_title IN ("Törlés", "Törlés2", "Törlésre_jelölve") AND CONCAT('Törlésre_javasolt_lapok/',page.page_title) NOT IN ( # page is not listed on WP:T SELECT lt_title FROM templatelinks INNER JOIN linktarget ON tl_target_id = lt_id WHERE tl_from = 362 ) AND page_title NOT LIKE 'Sablonok_listája/Törlés' ORDER BY revision.rev_timestamp 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...