Oops!

Number : -2147217900 Page : /best-sellers/Default.asp Desc : Column 'products.slug' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. SQL : SELECT TOP 8 a.idProduct, c.description,c.slug,c.googleWords,c.shortProductName, c.descriptionLong,c.prodListDescription,c.productNote,c.listPrice,c.Price,c.SKU, c.SmallImageUrl,c.ImageUrl,c.Stock,c.fileName, c.noShipCharge,c.is_outfit,c.relatedKeys FROM cartRows a, cartHead b, products c WHERE a.idOrder = b.idOrder AND (b.orderStatus='0' OR b.orderStatus='G' OR b.orderStatus='Q' OR b.orderStatus='7' OR b.orderStatus='Z' OR b.orderStatus='R' OR b.orderStatus='I' OR b.orderStatus='5' OR b.orderStatus='N' OR b.orderStatus='2') AND a.idProduct = c.idProduct AND c.active = -1 AND c.excl_BS = 0 AND c.is_outfit = 0 GROUP BY a.idProduct, c.description, c.googleWords,c.shortProductName, c.descriptionLong, c.prodListDescription, c.productNote, c.listPrice, c.Price,c.SKU, c.SmallImageUrl,c.ImageUrl,c.Stock,c.fileName, c.noShipCharge,c.is_outfit,c.relatedKeys ORDER BY SUM(a.quantity) DESC;