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
Edgars2007
.
use euwiki_p; SELECT #concat('* [[',p.page_title,']]') #concat('* [[:Kategorija:',p.page_title,']]') ll_lang, ll.ll_title, p.page_title from page p join langlinks ll on p.page_id=ll.ll_from where p.page_namespace=0 and p.page_title not like "%/%" and p.page_is_redirect=0 #and ll_lang<>"en" and p.page_id not in (SELECT eu_page_id from wbc_entity_usage wb GROUP BY eu_page_id) and p.page_id in (select cl_from from categorylinks where cl_to="Ko_udalerriak") order by p.page_title asc
Toggle Highlighting
SQL
use enwiki_p; SELECT concat('* [[:Template:',tl_title,']]'), COUNT(*) FROM templatelinks WHERE tl_namespace = 10 and tl_from_namespace=0 and exists (select * from categorylinks join page p on p.page_namespace=10 and cl_from=p.page_id where p.page_title=tl_title and cl_to in ("Chemistry_external_link_templates", "Geography_external_link_templates", "Fauna_external_link_templates", "Social_media_external_link_templates", "Dictionary_external_link_templates", "Heritage_external_link_templates", "Music_external_link_templates", "Theatre_external_link_templates", "Encyclopedia_external_link_templates", "Film_external_link_templates", "Company_external_link_templates", "Aviation_external_link_templates", "Language_external_link_templates", "Astronomy_external_link_templates", "Television_external_link_templates", "Anatomy_external_link_templates", "Sports_external_link_templates", "Radio_external_link_templates", "Software_external_link_templates", "Medical_external_link_templates", "Bible_external_link_templates", "Drink_external_link_templates", "Canada_politics_and_government_external_link_templates", "Cricket_external_link_templates", "Internet_Relay_Chat_external_link_templates", "Baseball_external_link_templates", "Basketball_external_link_templates", "Law_external_link_templates", "Golf_external_link_templates", "Tennis_external_link_templates", "United_States_government_external_link_templates", "Snooker_external_link_templates", "Cue_sports_external_link_templates", "Ice_hockey_external_link_templates", "Auto_racing_external_link_templates", "Rugby_union_external_link_templates", "American_football_external_link_templates", "Cycling_external_link_templates", "Rugby_league_external_link_templates", "Olympics_external_link_templates", "United_States_Congress_external_link_templates", "Gymnastics_external_link_templates", "Professional_wrestling_external_link_templates", "Paralympics_external_link_templates", "Figure_skating_external_link_templates", "Australian_rules_football_external_link_templates", "Swimming_external_link_templates", "Football_external_link_templates", "Association_football_external_link_templates", "Politics_external_link_templates", "GLAM_external_link_templates", "Video_game_external_link_templates", "People_and_person_external_link_templates", "Flora_external_link_templates", "Comics_external_link_templates", "United_States_Supreme_Court_external_link_templates", "Singapore_external_link_templates", "United_States_law_external_link_templates", "Biology_external_link_templates", "Philosophy_external_link_templates", "Doctor_Who_external_link_templates", "Museum_external_link_templates", "Author_and_writer_external_link_templates", "External_link_templates") ) GROUP BY tl_title ORDER BY COUNT(*) DESC LIMIT 100000;
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...