Fork of
Wikidata descriptions matching a string
by Meno25
This query is marked as a draft
This query has been published
by Meno25.
SQL
AخA
use wikidatawiki_p;
select count(*) from wb_items_per_site
where ips_site_id = 'enwiki'
#and ips_site_id != 'arwiki'
and ips_site_page like 'Wikipedia%' or 'File%' or 'Template%' or 'Help%' or 'Category%' or 'Portal%' or 'Module%'
#order by ips_site_page desc
#limit 10
;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.