Untitled query #32288

SQL

use arwiki_p;
select distinct concat(p.page_title, "******", wpp.pp_value)
from imagelinks
inner join page p
on p.page_id = il_from
inner join page_props pp
on pp.pp_page = p.page_id
inner join wikidatawiki_p.page wp
on wp.page_title like pp.pp_value
inner join wikidatawiki_p.page_props wpp
on wpp.pp_page = wp.page_id
where il_from in (
  select categorylinks.cl_from from categorylinks where categorylinks.cl_from = p.page_id and categorylinks.cl_to like "صور_من_ويكي_بيانات"
)
and p.page_namespace = 0
and p.page_is_redirect = 0
and pp.pp_propname like "wikibase_item"
and wp.page_namespace = 0
and wp.page_is_redirect =0
and wp.page_content_model like "wikibase-item" 
and wp.page_title = pp.pp_value
and wpp.pp_propname like "page_image_free"
limit 100;
SQL

Checking query status...
