articole despre orașe, fără infocasete

SQL

USE arwiki_p;
SELECT page_title, page_len, ll_title
FROM page    
#join categorylinks c1 on c1.cl_from=page_id
join categorylinks c2 on c2.cl_from=page_id
	LEFT JOIN langlinks
    	ON ll_from = page_id and ll_lang="en"
WHERE page_namespace = 0 and page_is_redirect = 0
#and c1.cl_to = "Moldova_geography_stubs"
#and c2.cl_to like "Orașe%"
and page_id not in (SELECT tl_from FROM templatelinks WHERE tl_title  REGEXP 'معلومات_' AND tl_namespace = 10)
and page_id not in (SELECT tl_from FROM templatelinks WHERE tl_title  REGEXP 'ص.م_' AND tl_namespace = 10)
and page_id not in (SELECT tl_from FROM templatelinks WHERE tl_title  REGEXP 'صندوق_معلومات_' AND tl_namespace = 10)
and page_id not in (SELECT tl_from FROM templatelinks WHERE tl_title  REGEXP 'Infobox_' AND tl_namespace = 10)
#and page_title not like "List%"
group by page_title
ORDER BY page_len asc
limit 100;
SQL

Checking query status...
