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 '%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 1000;
SQL

Checking query status...
