Untitled query #63532

SQL

SELECT CONCAT("Category:",page_title) AS titl
FROM page
WHERE page_namespace = 14
AND (page_title like "%women's_sport%" OR page_title like "%women's_sport")
AND page_id not IN ( SELECT ll_from FROM langlinks WHERE ll_lang = "ar" )
and page_id not IN ( select tl_from from templatelinks where tl_title in (
    'Stub_category',
    'Category_redirect',
    'Stub_Category',
    'backlog_subcategories'
    'Category_class',
    'hiddencat',
    'Monthly_clean-up_category',
    'WPSS-cat',
    'tracking_category',
    'Empty_category',
    'sockpuppet',
    'Wikipedia_category' )
    and tl_from = page_id )
GROUP BY page_title
#limit 10
;
SQL

Checking query status...
