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
USE huwiki_p; SELECT page.page_title, page.page_touched FROM page WHERE page.page_namespace = 4 # project namespace AND page.page_title LIKE 'Törlésre_javasolt_lapok/%' # subpages of WP:T AND page.page_id NOT IN ( # page does not contain template 'Ta' SELECT tl_from FROM templatelinks WHERE tl_title = 'Ta' ) AND page.page_title NOT IN ( # page is not listed on WP:T -- works! SELECT templatelinks.tl_title FROM templatelinks WHERE tl_from = 362 ) AND page.page_id NOT IN ( # page not manually marked as archived SELECT categorylinks.cl_from FROM categorylinks WHERE categorylinks.cl_to = 'Archivált törlési javaslatok' ) ;
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...