select id, redirect from sf_404 where url like 'buy/house/cork/kerry-pike/clonlara-kerry-pike-co-cork-10002'Would redirect