USE lvwiki_p;

select p.page_title, cl.cl_to#, (SELECT  wb.eu_entity_id

                    #from wbc_entity_usage wb

                   # where p3.page_id=wb.eu_page_id

                    #GROUP BY wb.eu_page_id)

from categorylinks cl

join page p on p.page_id=cl.cl_from

join page p3 on cl.cl_to=p3.page_title and p3.page_namespace=0

where cl.cl_from in (select cl2.cl_from

                        from categorylinks cl2

                        join page p2 on p2.page_id=cl2.cl_from

                        where cl2.cl_to="Latvijas_ciemi" and cl2.cl_type='page'

                        and p2.page_is_redirect=0 and p2.page_namespace=0)

and p.page_title in (SELECT enp.page_title

                    FROM page enp, page_props, wikidatawiki_p.page wdp

                    LEFT JOIN wikidatawiki_p.pagelinks wdpl ON wdpl.pl_from = wdp.page_id AND wdpl.pl_title = 'P131'

                        AND wdpl.pl_namespace = 120

                    WHERE enp.page_namespace = 0

                        AND pp_page = enp.page_id AND pp_propname = 'wikibase_item'

                        AND wdp.page_title = pp_value AND wdp.page_namespace = 0

                        AND wdpl.pl_from IS NULL)

    and cl.cl_type='page' and cl.cl_to like "%pagasta_ciemi"#"%pagasts_(%novads)"

      #  limit 200;