Pavb U r in my way.

I too tried to fine tune the subquery,but nothing helped me(i.e, not major change).So i posted here to get some guru's idea.