use cebwiki_p;

SELECT p1.page_title, COUNT(pl1.pl_title) as number_of_links1, p1.page_len, 

       p2.page_title, COUNT(pl2.pl_title) as number_of_links2, p2.page_len

/*,

CONCAT("[[", GROUP_CONCAT(pl_title ORDER BY pl_title ASC SEPARATOR "]], [["), "]]") as links*/

FROM /*page*/ (select * from page pg1 where pg1.page_namespace = 0 and pg1.page_is_redirect = 0 

               and pg1.page_title like "%(pagklaro_2)" ) as p1

JOIN pagelinks pl1 ON #p1.page_namespace = 0 and p1.page_is_redirect = 0 AND

      p1.page_id = pl1.pl_from 

     and pl1.pl_from_namespace = 0 AND pl1.pl_namespace = 0

/*

  JOIN page_props ON page_id = page_props.pp_page

  AND page_props.pp_propname = "disambiguation"*/

JOIN /*page*/ (select * from page pg2 where pg2.page_namespace = 0 and pg2.page_is_redirect = 0 

               and pg2.page_title like "%(pagklaro)" ) as p2 

on REPLACE(p1.page_title, '_(pagklaro_2)', '_(pagklaro)') = p2.page_title

join pagelinks pl2 ON p2.page_id = pl2.pl_from

​

join categorylinks on p1.page_id=cl_from and p2.page_id=cl_from

WHERE cl_to = "Pagklaro_paghimo_ni_bot"

 and pl2.pl_from_namespace = 0 AND pl2.pl_namespace = 0

GROUP BY p1.page_id

# having COUNT(pl1.pl_title) < COUNT(pl2.pl_title)

#ORDER BY number_of_links1 DESC, p1.page_title ASC