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 (8960, 8961, 13949, 18936, 19784, 21144, 21575, 21597, 23585, 23586) and IFNULL(cp.qty,0) group by `cp`.`supplierpricesID`