details of duplicated ceb disamb

SQL

use cebwiki_p;
SELECT page_title,#CONCAT("*[[Format:", page_title, "]]") as template_name,
COUNT(pl_title) as number_of_links,
CONCAT("[[", GROUP_CONCAT(pl_title ORDER BY pl_title ASC SEPARATOR "]], [["), "]]") as links
FROM pagelinks
JOIN page ON page_namespace = 10 AND page_id = pagelinks.pl_from
  JOIN page_props ON page_id = page_props.pp_page
  AND page_props.pp_propname = "disambiguation"
WHERE pl_from_namespace = 0 and page_title like "%(pagklaro_2)"
AND pl_namespace = 0
AND pl_title IN (
  SELECT page_title
  FROM page_props
  WHERE page_namespace = 0
)
GROUP BY page_title
ORDER BY number_of_links DESC, page_title ASC
SQL

Checking query status...
