use lvwiki_p;

SELECT DISTINCT

CONCAT('#[[:Kategorija:',cl_to,']]') as "Nosaukums"

  #cl_to

FROM categorylinks AS cat

JOIN page AS pg1

ON cat.cl_from = pg1.page_id

WHERE page_namespace = 2

AND EXISTS (SELECT

              1

            FROM page AS pg2

            JOIN categorylinks AS cl

            ON pg2.page_id = cl.cl_from

            WHERE pg2.page_namespace = 0

            AND cat.cl_to = cl.cl_to)

LIMIT 250;