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 (27400, 28738, 30303, 31260, 31431, 31820, 31999, 32617) and IFNULL(cp.qty,0)
            group by `cp`.`supplierpricesID`