coord - Quarry

SQL

USE arwiki_p;
SELECT DISTINCT p.page_title, el_to 
FROM page as p, page_props as pp, wikidatawiki_p.page as wdp
JOIN externallinks ON el_from=page_id WHERE p.page_namespace=0
and not exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (wdpl.pl_title = 'P214')  )

AND p.el_to LIKE'%.imdb.com/name%'
and p.page_id  in (SELECT tl_from FROM templatelinks WHERE tl_namespace = 10 and tl_title="ضبط_استنادي")
and p.page_id in (
        SELECT tl_from
        FROM templatelinks
               WHERE tl_title = 'تصنيف_كومنز'
            AND tl_namespace = 10 )
AND pp_page = p.page_id AND pp_propname = 'wikibase_item' AND wdp.page_title = pp_value AND wdp.page_namespace = 0

  GROUP BY page_title
  ORDER BY page_title DESC;
limit 100;
SQL

Checking query status...
