Desejo converter esta consulta no codeigniter em consulta de tabela de dados ignorada

Não sei como converter essa função de modelo longo em consulta de tabela de dados inflamada. Eu fiz pequenas funções de seleção com dados inflamados.
Não faço ideia de como encobri-lo. Existe alguma função para fazer isso?

   public function fetch_data() {

              $this->db->from('jil_requirements');
              $this->db->join('jil_users', 'jil_requirements.rqm_userid=jil_users.usr_id', 'left');
              $this->db->join('jil_merchants', 'jil_requirements.rqm_createdempid=jil_merchants.mer_id', 'left');
              $this->db->where('jil_requirements.rqm_permission!=', '4');
              $this->db->order_by("jil_requirements.rqm_id", "desc");
              $query =  $this->db->get();  
              if ($query->num_rows() > 0) {
              foreach ($query->result() as $row) {
                 $this->db->select('count(jil_mrorfq.rfq_requirementid) as total'); 
                $this->db->from('jil_mrorfq'); 
               $this->db->join('jil_requirements', 'jil_requirements.rqm_id=jil_mrorfq.rfq_requirementid', 'left'); 
               $this->db->where('jil_requirements.rqm_id',$row->rqm_id);
                  $query2= $this->db->get()->row_object();
                 $row->total_count = $query2->total;    
                  $this->db->select('count(jil_quotemjdetail.qud_requirementid) as quotemjtotal'); 
                $this->db->from('jil_quotemjdetail'); 
               $this->db->join('jil_requirements', 'jil_requirements.rqm_id=jil_quotemjdetail.qud_requirementid', 'left'); 
               $this->db->where('jil_requirements.rqm_id',$row->rqm_id);
                  $query3= $this->db->get()->row_object();
                  $row->quotemj_total = $query3->quotemjtotal;

                   $this->db->select('count(jil_quotejcdetail.qud_requirementid) as quotejctotal'); 
                $this->db->from('jil_quotejcdetail'); 
               $this->db->join('jil_requirements', 'jil_requirements.rqm_id= jil_quotejcdetail.qud_requirementid', 'left'); 
               $this->db->where('jil_requirements.rqm_id',$row->rqm_id);
                  $query4= $this->db->get()->row_object();
                  $row->quotejc_total = $query4->quotejctotal;

                    $this->db->select('count( jil_pocjdetail.pocd_requirementid) as pocjtotal'); 
                $this->db->from('jil_pocjdetail'); 
               $this->db->join('jil_requirements', 'jil_requirements.rqm_id=  jil_pocjdetail.pocd_requirementid', 'left'); 
               $this->db->where('jil_requirements.rqm_id',$row->rqm_id);
                  $query5= $this->db->get()->row_object();
                  $row->pocj_total = $query5->pocjtotal;

                   $this->db->select('count(jil_pojmdetail.pojd_requirementid) as pojmtotal'); 
                $this->db->from('jil_pojmdetail'); 
               $this->db->join('jil_requirements', 'jil_requirements.rqm_id=  jil_pojmdetail.pojd_requirementid', 'left'); 
               $this->db->where('jil_requirements.rqm_id',$row->rqm_id);
                  $query6= $this->db->get()->row_object();
                  $row->pojm_total = $query6->pojmtotal;


                 $data[] = $row;
                        }
                       return $data;
                    }
                    return false;
               }