以Codeigniter格式转换查询

Question

I have a query

SELECT        l.id,l.name,l.city,l.email,l.phone,l.status,l.source,l.leadCreatedTime,l.organizationId
FROM    (
    SELECT  id
    FROM    leads
where removed='0'
    ORDER BY
            id
    LIMIT 40000
    ) o
JOIN    leads l
ON      l.id = o.id
ORDER BY
    l.id

I want to convert this query in Codeigniter format for eg

$this->db->select('l.id,l.name,l.city,l.email,l.phone,l.status,l.source,l.leadCreatedTime,l.organizationId');
$this->db->from('leads');

Im having problem in the 8th line of query where the fetched data is defined as o how am I suppose to write that in CI

Answer 1

can u test my code it may help you as it is codegniter format

$this->db- >select('l.id,l.name,l.city,l.email,l.phone,l.status,l.source,l.leadCreatedTime,l.organizationId');
$this->db->from('(SELECT id FROM leads where removed="0" ORDER BY id LIMIT 40000) o');
$this->db->join('leads l', 'l.id = o.id');
$this->db->order_by('l.id');
$result=$this->db->get();
$show=$result->result_array();

it is not in fully codeigniter format in sub query but it help you.

Enjoy code.