Переписать запрос

// Получаем товары
$this->db->select('g.id, s.barcode, g.title AS label, c.title AS type, g.price AS RealPrice, "Товар" AS kind')
->select('FORMAT(g.price, 0, "ru_RU") AS price, IFNULL(ROUND(SUM(s.rest) * g.ratio), 0) AS quantity')
->where('g.office', $office)
->where('g.office = o.id')
->where('o.organization', $this->session->userdata('organization_id'))
->where('g.category = c.id')
->where('c.type', 'товары')

->group_start()
->like('g.title', $search, 'both')
->or_where('s.barcode', $search, 'both')
->group_end()

->group_by('g.id')
->join('good_supplies...