سبورتس رفرنس

SQL

USE arwiki_p;
SELECT DISTINCT page_title, el_to 
FROM page as, externallinks as enel, page_props as pp, wikidatawiki_p.page as wdp

JOIN externallinks ON el_from=page_id WHERE page_namespace=0 
AND el_to not LIKE '%tools.wmflabs.org/geohack%'	
and page_id   in (
        SELECT tl_from
        FROM templatelinks
         WHERE tl_title = 'Coord'
            AND tl_namespace = 10 )
            and exists (select * from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id 
                AND (wdpl.pl_title = 'P625' )  AND wdpl.pl_namespace = 120) 
  ORDER BY page_title DESC;
SQL

Checking query status...
