Untitled query #84956

SQL

select CONCAT('#{{Q|',c1.cl_sortkey_prefix,'}}') as "الصفحة"
    , COUNT(*)  AS "عدد الاستخدامات"
/*from categorylinks join page on cl_from = page_id
on cl_from = page_id
where cl_to = "صفحات_ويكي_بيانات_بحاجة_لتسمية_عربية"
group by cl_sortkey_prefix having count(*) > 10
ORDER BY  COUNT(*) DESC
#and page_title like "Mr._Ibrahem/%"*/

from categorylinks c1, page, categorylinks c2

where 
#c1.cl_to = "صفحات_ويكي_بيانات_بحاجة_لتسمية_عربية" and c1.cl_from = page_id
#and 
c2.cl_to = "بوابة_أعلام/مقالات_متعلقة"  and c2.cl_from = page_id

group by c1.cl_sortkey_prefix having count(*) > 1
ORDER BY  COUNT(*) DESC
#and page_title like "Mr._Ibrahem/%"
limit 50;
SQL

Checking query status...
