$products = $this->db->from('products')
->select('product_id, product_model, product_url, product_short_name, product_supplier_id, product_google_feed, product_colour_variations, product_live, pcolour_full_model, mp_model, mp_leisurebench_item')
->join('brands', 'products.product_brand_id = brands.brand_id', 'LEFT')
->join('product_colours', 'products.product_model = product_colours.pcolour_model', 'LEFT')
->join('netsuite_master_product_list', '(products.product_model = netsuite_master_product_list.mp_model OR product_colours.pcolour_full_model = netsuite_master_product_list.mp_model)')
->where('mp_leisurebench_item', 'No') // This line appears to be the culprit
->group_start()
->where('product_supplier_id', 0)
->or_where('brand_on_netsuite', 1)
->group_end()
->get()
->result_array();