SQL
x
use hewiki_p;
select page_title from page
where page_namespace = 0
and not page_is_redirect
and not exists
(select * from imagelinks
where page_id = il_from)
limit 10;
select * from imagelinks limit 1;
select * from page_props join page
on page_id = pp_page
where "wikibase_item" = pp_propname
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.