SELECT 

        p1.page_namespace,CONCAT('[[قالب:',p1.page_title,']]')

        FROM page AS p1

        WHERE 

        p1.page_title LIKE '%/شرح' 

        and p1.page_is_redirect = 0

        and p1.page_namespace in  (10)

        AND NOT EXISTS (SELECT 1

        FROM page AS p2

        WHERE p2.page_namespace = 10

        AND p2.page_title = replace(p1.page_title,'/شرح' ,'')

        and p2.page_is_redirect = 0

        )

​

​