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

SQL

USE arwiki_p;
select page_title, (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id 
                AND (wdpl.pl_title = 'P18')) from  
page
inner join page_props pp
on pp.pp_page = page_id
where page_id in (select arwiki_p.categorylinks.cl_from from arwiki_p.categorylinks where arwiki_p.categorylinks.cl_from = arwiki_p.page.page_id and arwiki_p.categorylinks.cl_to like "%كومنز%")
and page_id not in (select pp_page from page_props where pp_propname like "page_image" and pp_page = page_id)
and page_id not in (select pp_page from page_props where pp_propname like "page_image_free" and pp_page = page_id)
and page_id not in (select cl_from from categorylinks where cl_from = page_id and cl_to = "صفحات_توضيح")
and pp_propname like "wikibase_item"
and page_namespace = 0
and page_is_redirect = 0
limit 10;

SQL

Checking query status...