سبورتس رفرنس

SQL

/*USE arwiki_p;
SELECT DISTINCT page_title, el_to FROM page
JOIN externallinks ON el_from=page_id WHERE page_namespace=0 
AND el_to LIKE '%.sports-reference.com/olympics/athletes%'	
and page_id not  in (
        SELECT tl_from
        FROM templatelinks
         WHERE tl_title = 'سبورتس_رفرنس'
            AND tl_namespace = 10 )
  ORDER BY page_title DESC;*/
  USE arwiki_p;
SELECT page_title, concat('P373'), el_to, 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;
SQL

Checking query status...
