USE svwiki_p;

SELECT page_title#, pp_value

FROM page

join categorylinks on page_id=cl_from/*

    LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props

        ON pp_page = page_id*/

WHERE cl_to in ("Förgreningssidor", "Robotskapade_förgreningssidor")#= "Robotskapade_förgreningssidor"

AND page_namespace = 0 AND page_is_redirect = 0

and page_title like "%(olika_betydelser%"

and REPLACE(REPLACE(page_title, '_(olika_betydelser)', ''), '_(olika_betydelser_2)', '') in (select page_title

    FROM page join categorylinks on page_id=cl_from

where cl_to in ("Förgreningssidor", "Robotskapade_förgreningssidor") AND page_namespace = 0 AND page_is_redirect = 0)

GROUP BY page_title

ORDER BY page_title;