select id, redirect from sf_404 where url like 'let/commercial/tipperary/thurles/yards-and-stores-noard--newhill'Would redirect