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 * from wb_items_per_site
where ips_site_id = 'enwiki'
#and ips_site_id != 'arwiki'
#and ips_site_page not like 'Wikipedia%|File%|Template%|Help%|Category%|Portal%|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.