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 |