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 (27948, 27964, 28113, 29502, 29938, 30067, 30094, 30099, 31503, 32451) and IFNULL(cp.qty,0)
            group by `cp`.`supplierpricesID`