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 (10913, 31956, 14475, 7158, 7132, 19798, 28071) and IFNULL(cp.qty,0)
            group by `cp`.`supplierpricesID`