مقالات بحاجة لصور من ويكي بيانات - فنون

SQL

USE arwiki_p;
select p.page_title, wpp.pp_value
from  
page p
inner join page_props pp
on pp.pp_page = p.page_id
inner join wikidatawiki_p.page
on wikidatawiki_p.page.page_title = pp_value
inner join wikidatawiki_p.page_props wpp
on wpp.pp_page = wikidatawiki_p.page.page_id
where p.page_id in (select categorylinks.cl_from from categorylinks where categorylinks.cl_from = p.page_id and arwiki_p.categorylinks.cl_to like "%كومنز%")
and p.page_id not in (select pp1.pp_page from page_props pp1 where pp1.pp_propname like "page_image" and pp1.pp_page = p.page_id)
and p.page_id not in (select pp2.pp_page from page_props pp2 where pp2.pp_propname like "page_image_free" and pp2.pp_page = p.page_id)
and p.page_id not in (select cl_from from categorylinks where cl_from = p.page_id and cl_to = "صفحات_توضيح")
and pp_propname like "wikibase_item"
and p.page_namespace = 0
and p.page_is_redirect = 0
and wpp.pp_value like "page_image_free"
limit 10;
SQL

Checking query status...
