Need help on converting mysql query to codeigniter active record

@jollytsr,

Have you tried running this query directly in MySQL and seeing if it works correctly?

@php_rocs

Thanks for your kind reply.

I have tried in mysql. It works perfectly. But unable to use it in codeIgniter.