Untitled query #32149

SQL

use enwiki_p;
select missing_year, page_id, max(rev_len) as len
from
revision,
(select page_id, year(max(rev_timestamp)) as last_year
from revision, page, categorylinks
where rev_page = page_id
and page_namespace = 0
and page_id = cl_from
and cl_to = 'British_films'
 and page_title like 'Al%'
group by page_id) last_revision,
(select 2018 as missing_year union select 2017 union select 2016 union select 2015 union select 2014 union select 2013 union select 2012 ) all_years
where missing_year > last_year
and rev_page = page_id
and year(rev_timestamp) = last_year
group by missing_year, page_id;
SQL

Checking query status...
