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
The Polish
.
Toggle Highlighting
SQL
USE plwiki_p; SELECT DISTINCT CONCAT('# [[Dyskusja:',page_title,']]') AS page_title FROM page, templatelinks WHERE tl_from_namespace = 0 AND tl_namespace = 10 AND page_id = tl_from AND tl_title LIKE '%infobox%' AND page_title NOT IN ( 'Planet_in_Peril:_Battle_Lines', 'Marynarz_Popeye', 'W_te_dni_przedwiosenne', 'Chleba_naszego_powszedniego', 'Jest_sprawa...', 'Przygoda_Noddy’ego_na_wyspie', 'Animaniacy:_Życzenie_Wakko', 'Tomek_i_przyjaciele;_Jak_lokomotywy_uratowały_lotnisko', 'Nasza_klątwa', 'Milionowy_spadkobierca', 'Miejsce_urodzenia_(film)', 'Letnie_wakacje', 'Manos:_The_Hands_of_Fate', 'Los_utracony_(film)', 'Lato_i_dym' ) AND page_title IN ( SELECT page_title FROM page, templatelinks WHERE tl_from_namespace = 1 AND tl_namespace = 10 AND page_id = tl_from AND page_len < 100 AND tl_title LIKE 'Bez_infoboksu' ) ORDER BY page_len
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...