Result consisted of more than one rowselect `cp`.*, WebPriceSup(`supplierpricesid`, 0) as `Price`
            from `v_supplierprices` as `cp`
            left join `catalogcode` as `cc` on `cc`.`CatalogCode` = `cp`.`CatalogCode`
            where `cc`.`GoodsID` in (28194, 30216, 30434, 31229, 31371, 31422, 31604, 31613, 32758) and IFNULL(cp.qty,0)
            group by `cp`.`supplierpricesID`