use arwiki_p;

select (page_title) from  

page

inner join page_props

on pp_page = page_id

where page_id not in (select tl_from from templatelinks where tl_from = page_id and tl_from_namespace = 0 and tl_title like "%كومنز%")

and page_id not in (select tl_from from templatelinks where tl_from = page_id and tl_from_namespace = 0 and tl_title like "%شقيق%")

and page_id not in (select cl_from from categorylinks where cl_to like "صفحات_توضيح%" and cl_from = page_id)

and page_namespace =0 

and page_is_redirect = 0

and pp_propname = "wikibase_item"

and TRIM(LEADING 'Q' FROM pp_value) in (select wikidatawiki_p.wb_items_per_site.ips_item_id

                                                   from wikidatawiki_p.wb_items_per_site

                                                   where wikidatawiki_p.wb_items_per_site.ips_item_id = TRIM(LEADING 'Q' FROM pp_value)

                                                   and wikidatawiki_p.wb_items_per_site.ips_site_id like "commonswiki"

                                                   );