airport redirect query

SQL

#SELECT page_title FROM page WHERE page_namespace = 0 AND page_title LIKE "%(\_%";
Select page_title, rd_title from page join redirect on page_id = rd_from
Where page_namespace =0 and rd_namespace = 0
and rd_title rlike "ir(port|field|strip|( B|b)ase)|erodrome"
and page_title rlike "^[A-Z]{4}$" #like "____"
And page_id not in (Select cl_from from categorylinks where cl_to = "Redirects_from_airport_codes") order by page_title asc;

select page_title from page
where page_namespace=0 and page_title rlike "ir(port|field|strip|( B|b)ase)|erodrome"
and page_title not in (select rd_title from redirect where rd_namespace=0 and rd_from in (Select cl_from from categorylinks where cl_to = "Redirects_from_airport_codes")) order by page_title asc;
SQL

Checking query status...
