Untitled query #8418

SQL

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('* [[Template:',p.page_title,']]'), concat(' - [[:en:Template:',p.page_title,'|en]]')
from page p
where p.page_namespace=14
#where p.page_namespace in (10,828)#(10,14,4,828)
and p.page_title not like "%/%"
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)
                          						     )
                    limit 10;
#and p.page_id not in (select cl_from
#																from categorylinks
#																where cl_to="Nozīmju_atdalīšana")
SQL

Checking query status...
