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
.
Toggle Highlighting
SQL
use lvwiki_p; #http://tools.wmflabs.org/lists/itwiki/Disambigue/Disambigue_con_disambiguante_diverso_da_disambigua SELECT CONCAT('# [[', page_title, ']]') FROM page, page_props WHERE pp_propname = 'disambiguation' AND page_id = pp_page AND page_namespace = 0 AND page_is_redirect = 0 AND page_title LIKE '%(%)' AND page_title NOT LIKE '%(nozīmju_atdalīšana)' ORDER BY page_title; #http://tools.wmflabs.org/lists/itwiki/Disambigue/Disambigue_con_immagini SELECT page_title FROM page WHERE page_namespace = 0 AND page_is_redirect = 0 AND page_id IN (SELECT il_from FROM imagelinks WHERE il_to <> 'Disambig.svg') AND page_id IN (SELECT pp_page FROM page_props WHERE pp_propname = 'disambiguation'); #http://tools.wmflabs.org/lists/itwiki/Disambigue/Disambigue_corte SELECT CONCAT('# [[', page_title, ']] - ', page_len) FROM page WHERE page_id IN (SELECT pp_page FROM page_props WHERE pp_propname = 'disambiguation') ORDER BY page_len LIMIT 1000; #http://tools.wmflabs.org/lists/itwiki/Disambigue/Disambigue_lunghe SELECT CONCAT('# [[', page_title, ']] - ', page_len) FROM page WHERE page_id IN (SELECT pp_page FROM page_props WHERE pp_propname = 'disambiguation') AND page_namespace = 0 ORDER BY page_len DESC LIMIT 1000; #http://tools.wmflabs.org/lists/itwiki/Disambigue/Redirect_che_puntano_a_disambigua SELECT CONCAT('# [[', page_title, ']] -> [[', rd_title, ']] - ', COUNT(*)) FROM page JOIN redirect ON page_id = rd_from, pagelinks WHERE page_namespace = 0 AND rd_namespace = 0 AND rd_title IN (SELECT page_title FROM page WHERE page_id IN (SELECT pp_page FROM page_props WHERE pp_propname = 'disambiguation')) AND page_title = pl_title AND pl_from_namespace = 0 AND pl_namespace = 0 GROUP BY page_title ORDER BY COUNT(*) DESC; #http://tools.wmflabs.org/lists/itwiki/Disambigue/Voci_con_disambiguante_uguale_a_disambigua SELECT CONCAT('# [[', page_title, ']]') FROM page WHERE page_namespace = 0 AND page_is_redirect = 0 AND page_title LIKE '%(nozīmju_atdalīšana)' AND page_id NOT IN (SELECT pp_page FROM page_props WHERE pp_propname = 'disambiguation') ORDER BY page_title;
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...