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
BilledMammal
.
Toggle Highlighting
SQL
SELECT CONCAT("Q",ips_item_id) AS Item, name.wbx_text as Name, description.wbx_text as Description, COUNT(ips_site_id) AS number_of_articles FROM wb_items_per_site JOIN ( SELECT ips_item_id AS simple_item_id, ips_site_page AS simple_site_page FROM wb_items_per_site WHERE ips_item_id NOT IN ( SELECT ips_item_id FROM wb_items_per_site WHERE ips_site_id = 'enwiki' ) AND ips_site_page NOT LIKE '%:%' AND ips_site_id = 'simplewiki' ) simple ON ips_item_id = simple_item_id LEFT JOIN (SELECT wbit_item_id, wbx_text FROM wbt_item_terms JOIN wbt_term_in_lang ON wbtl_id = wbit_term_in_lang_id AND wbtl_type_id = 1 JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id AND wbxl_language = "en" JOIN wbt_text ON wbxl_text_id = wbx_id ) name ON name.wbit_item_id = ips_item_id LEFT JOIN (SELECT wbit_item_id, wbx_text FROM wbt_item_terms JOIN wbt_term_in_lang ON wbtl_id = wbit_term_in_lang_id AND wbtl_type_id = 2 JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id AND wbxl_language = "en" JOIN wbt_text ON wbxl_text_id = wbx_id ) description ON description.wbit_item_id = ips_item_id GROUP BY ips_item_id ORDER BY number_of_articles 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...