Untitled query #26111

SQL

USE enwiki_p;
SELECT count(*), count(distinct tp.page_id)
FROM page tp
JOIN categorylinks
ON tp.page_id=cl_from
JOIN page ap
ON (tp.page_title=ap.page_title
    AND ap.page_namespace=118)
WHERE cl_to in ('AfC_pending_submissions_by_age/0_day_ago',
'AfC_pending_submissions_by_age/0_days_ago',
'AfC_pending_submissions_by_age/1_day_ago',
'AfC_pending_submissions_by_age/1_days_ago',
'AfC_pending_submissions_by_age/10_days_ago',
'AfC_pending_submissions_by_age/11_days_ago',
'AfC_pending_submissions_by_age/12_days_ago',
'AfC_pending_submissions_by_age/13_days_ago',
'AfC_pending_submissions_by_age/14_days_ago',
'AfC_pending_submissions_by_age/15_days_ago',
'AfC_pending_submissions_by_age/16_days_ago',
'AfC_pending_submissions_by_age/17_days_ago',
'AfC_pending_submissions_by_age/18_days_ago',
'AfC_pending_submissions_by_age/19_days_ago',
'AfC_pending_submissions_by_age/2_days_ago',
'AfC_pending_submissions_by_age/20_days_ago',
'AfC_pending_submissions_by_age/3_days_ago',
'AfC_pending_submissions_by_age/3_weeks_ago',
'AfC_pending_submissions_by_age/4_days_ago',
'AfC_pending_submissions_by_age/4_weeks_ago',
'AfC_pending_submissions_by_age/5_days_ago',
'AfC_pending_submissions_by_age/5_weeks_ago',
'AfC_pending_submissions_by_age/6_days_ago',
'AfC_pending_submissions_by_age/6_weeks_ago',
'AfC_pending_submissions_by_age/7_days_ago',
'AfC_pending_submissions_by_age/7_weeks_ago',
'AfC_pending_submissions_by_age/8_days_ago',
'AfC_pending_submissions_by_age/8_weeks_ago',
'AfC_pending_submissions_by_age/9_days_ago',
                'AfC_pending_submissions_by_age/Very_old')
AND ap.page_is_redirect=0;
SQL

Checking query status...
