use hywikiquote_p;

SELECT #count(*)

#p.page_title

#concat('* [[Category:',p.page_title,']]')

#concat('Template:',p.page_title), CONCAT("Ssawiki"), concat('Template:',p.page_title)

concat('* [[:Category',p.page_title,']] - [[:w:hy:Category:',p.page_title,']]')

from page p

where p.page_namespace=14

and p.page_is_redirect=0

and not exists (SELECT eu_page_id

                    from wbc_entity_usage wb where eu_page_id=p.page_id

                    GROUP BY eu_page_id)

                    and not exists (select ll_from from langlinks ll where ll_from=p.page_id)

           and exists (select p2.page_title

                               from hywiki_p.page p2

                                where p.page_title=p2.page_title and p2.page_is_redirect=0 and p2.page_namespace=14

                                and p2.page_id in (SELECT wb2.eu_page_id

                                                    from hywiki_p.wbc_entity_usage wb2

                                                    GROUP BY wb2.eu_page_id)

                                                     )