select id, redirect from sf_404 where url like 'let/commercial/office/tipperary/cashel/main-street-cashel-csl240080'Would redirect