details of duplicated ceb disamb

SQL

use cebwiki_p;
SELECT p1.page_title, COUNT(pl1.pl_title) as number_of_links1, p2.page_title, COUNT(pl2.pl_title) as number_of_links2
/*,
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
SQL

Checking query status...
