public function getFilteredBrokerCustomers($search_text) { $broker_customers = array('cid', 'esid', 'name', 'broker_code'); $broker_new = array('company_name'); $select = $this->select() ->setIntegrityCheck(false) ->from(array('b_c' => 'broker_customer'), $broker_customers); $select->join(array('b' => 'broker_new'), 'b_c.broker_code=b.broker_code', $broker_new); $select->where('b_c.name LIKE ?', $search_text); $select->where('b_c.status = ?', 1); $select->where('b_c.renewal = ?', 1); return $this->fetchAll($select); }