wbc - Quarry

SQL

use arwiki_p;
SELECT #count(*)
#p.page_title
concat('* [[Template:',p.page_title,']]')
#concat('Template:',p.page_title), CONCAT("Ssawiki"), concat('Template:',p.page_title)
#concat('* [[Template:',p.page_title,']]'), concat(' - [[:en:Template:',p.page_title,'|en]]')
from page p
where p.page_namespace=10
#where p.page_namespace in (10,828)#(10,14,4,828)
and p.page_title not like "%/%"
and p.page_is_redirect=0
and 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 enwiki_p.page p2
        #                        where p.page_title=p2.page_title and p2.page_is_redirect=1 and p2.page_namespace=10
                                #and p2.page_id in (SELECT wb2.eu_page_id
								#					from enwiki_p.wbc_entity_usage wb2
								#				 	GROUP BY wb2.eu_page_id)
                          		#				     )
                    #limit 10;
#and p.page_id not in (select cl_from
#																from categorylinks
#																where cl_to="Nozīmju_atdalīšana")
SQL

Checking query status...
