articole despre filme, fără infocasete

Fork of articole despre orașe/localități, fără infocasete by XXN

This query is marked as a draft This query has been published by XXN.

SQL

USE rowiki_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 "Filme%"
AND page_id not in (select tl_from from templatelinks where tl_title like "Infobox%" or tl_title like "Infocaseta%")
and page_title not like "List%"
group by page_title
ORDER BY page_len asc

SQL

Checking query status...