Chemical redirects

SQL

select concat ("https://en.wikipedia.org/wiki/", page_title, "?redirect=no") as Page,
 	date_format(ptrp_created,'%Y-%m-%d') as creationDate
	from pagetriage_page
    join page
    	on ptrp_page_id=page_id
	where page_is_redirect=1
    and ptrp_reviewed=0
    and ptrp_deleted=0
    and page_title regexp '^([A-Z]{1}[0-9]{1,2})+$'
order by creationDate desc
limit 20;

select concat ("https://en.wikipedia.org/wiki/", page_title, "?redirect=no") as Page,
 	date_format(ptrp_created,'%Y-%m-%d') as creationDate
	from pagetriage_page
    join page
    	on ptrp_page_id=page_id
	where page_is_redirect=1
    and ptrp_reviewed=0
    and ptrp_deleted=0
    and page_title regexp '[0-9]+\-[0-9]+\-[0-9]+'
order by creationDate desc
limit 20;
SQL

Checking query status...
