Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Slovakia related articles on cswiki, missing from skwiki
by
Teslaton
This query is marked as a draft
This query has been published
by
Dnshitobu
.
Toggle Highlighting
SQL
USE enwiki_p; SELECT REPLACE(page_title, '_', ' ') AS title_cs, page_len, REPLACE(GROUP_CONCAT(cl_to SEPARATOR ', '), '_', ' ') AS categories, (SELECT count(*) FROM langlinks WHERE ll_from = page_id) as iw_count, (SELECT count(*) FROM revision WHERE rev_page = page_id) as rev_count, rf.rev_timestamp AS rev_first, rl.rev_timestamp AS rev_last, (SELECT pp_value FROM page_props WHERE pp_page = page_id AND pp_propname = 'wikibase_item') wb_item, (SELECT ll_title FROM langlinks WHERE ll_from = page_id AND ll_lang = 'en') AS title_en, (SELECT ll_title FROM langlinks WHERE ll_from = page_id AND ll_lang = 'de') AS title_de, (SELECT ll_title FROM langlinks WHERE ll_from = page_id AND ll_lang = 'pl') AS title_pl, (SELECT ll_title FROM langlinks WHERE ll_from = page_id AND ll_lang = 'hu') AS title_hu FROM page, revision rf, revision rl, categorylinks WHERE page_namespace = 0 AND page_id NOT IN (SELECT ll_from FROM langlinks WHERE ll_lang = 'dag') AND rf.rev_page = page_id AND rf.rev_parent_id = 0 AND rl.rev_id = page_latest AND cl_from = page_id AND (cl_to LIKE '%Sloven%') GROUP BY page_id ORDER BY page_len 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...