Untitled query #86748

SQL

select
            # page_title, count(cl_from)
            CONCAT('Category:', page_title) as title,
            count(cl_from) as total
        from
            page
            inner join categorylinks on cl_to = page_title
        where 
        page_namespace = 14
        
          /* and page_id not in (
                select
                    cl_from
                from
                    categorylinks
                where
                    cl_to = "Hidden_categories"
            )*/

            and cl_from in (
                select
                    ll_from
                from
                    langlinks
                where
                    ll_from = cl_from
                    and ll_lang = "ar"
            )

            and page_id not in (
                select
                    ll_from
                from
                    langlinks
                where
                    ll_from = page_id
                    and ll_lang = "ar"
            )
            #sr
            /*
            and page_id not IN (
                select
                    tl_from
                from
                    templatelinks,
                    linktarget
                where
                    lt_namespace = 10
                    and tl_target_id = lt_id
                    and lt_title in ('Wikipedia_category','Sockpuppet','Empty_category','Possibly_empty_category','Tracking_category','WPSS-cat','Monthly_clean-up_category','Category_class','Hiddencat','Backlog_subcategories','Category_redirect','Stub_Category')
            )*/
            and page_is_redirect = 0
        group by
            page_title
        order by
            count(cl_from) desc #having count(cl_from)>20
            #limit 300;

 limit 10
SQL

Checking query status...
