Untitled query #8140

SQL

USE arwiki_p;
SELECT page_title, concat('P373'), CONCAT('"',replace(replace(el_to, "https:", "" ), "//commons.wikimedia.org/wiki/Category:", "" ),'"') as s
 , concat('S143'), concat('Q199700')
FROM page
JOIN externallinks 
ON el_from=page_id
WHERE page_namespace=14
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 100;
SQL

Checking query status...
