How to write Mysql_subquery in datatables

jibin_lejen

Mysql Query Structure:

select ()

from ()

where in (select
from
where and )
and

        in (select  
        from  
        where  and )

    and

        c.id = t.id

I used datatables library in php framework codeIgniter. How to write above mysql_query in datatables. Pls help?