duplicated ceb disambigs

SQL

USE cebwiki_p;
SELECT page_title, pp_value
	FROM page
join categorylinks on page_id=cl_from/*
	LEFT JOIN langlinks
    	ON ll_from = page_id*/
	LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props
		ON pp_page = page_id
WHERE cl_to = "Pagklaro_paghimo_ni_bot"
#and pp_value is NULL
#AND ll_title IS NULL
AND page_is_redirect = 0 AND page_namespace = 0
and REPLACE(page_title, '_(pagklaro)', '') in (select page_title
	FROM page
join categorylinks on page_id=cl_from
where cl_to = "Pagklaro_paghimo_ni_bot" AND page_is_redirect = 0 AND page_namespace = 0 
                       and p.page_title not like "%(pagklaro)")
ORDER BY page_title;
SQL

Checking query status...
