Query Run
select c6.cl_to, count(*) from categorylinks c6 join (select p6.page_id ... 1 year ago
select c2.cl_to, count(*) from categorylinks c2 join (select p2.page_id ... 1 year ago
select c4.cl_to, count(*) from categorylinks c4 join (select p4.page_id ... 1 year ago