Untitled query #8140

SQL

/*USE arwiki_p;
SELECT page_title, concat('P373'), replace(el_to, "//commons.wikimedia.org/wiki/Category:", "" )
 , concat('S143'), concat('Q199700')
FROM page
JOIN externallinks ON el_from=page_id WHERE page_namespace=0 
AND el_to LIKE '%commons.wikimedia.org/wiki/Category%'	
and page_id in (select cl_from
		from categorylinks 
		where cl_type="page" and cl_to="قالب_تصنيف_كومنز_بوصلة_ليست_على_ويكي_بيانات")
and page_id   in (
        SELECT tl_from
        FROM templatelinks
         WHERE tl_title = 'تصنيف_كومنز'
            AND tl_namespace = 10 )
  GROUP BY page_title 
  ORDER BY page_title DESC#;
limit 10;*/
USE arwiki_p;
SELECT page_title, concat('P373'), replace(el_to, "//commons.wikimedia.org/wiki/Category:", "" )
 , concat('S143'), concat('Q199700')
FROM page
JOIN externallinks ON el_from=page_id WHERE page_namespace=0 
AND el_to LIKE 'https://tools.wmflabs.org/geohack/%'	
and page_id in (select cl_from
		from categorylinks 
		where cl_type="page" and cl_to="الإحداثيات_ليست_على_ويكي_بيانات")
and page_id   in (
        SELECT tl_from
        FROM templatelinks
         WHERE tl_title = 'coord'
            AND tl_namespace = 10 )
  GROUP BY page_title 
  ORDER BY page_title DESC#;
limit 10;
SQL

Checking query status...
