Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Pages with afd template with no corresponding discussion page
by
FoBe
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 ("Jogsértő", "Jogserto", "Copvio") AND page_namespace = 0 AND page.page_title NOT IN ( # page is not listed on WP:T SELECT pl_title FROM pagelinks WHERE pl_from = 404 ) 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...