have you considered using query rewrite, Manjunath?