SELECT
					COUNT(*) AS num, ordprodsku,  p.*,  FLOOR(prodratingtotal/prodnumratings) AS prodavgrating, prodcalculatedprice, ordprodid, imagefile, prodcurrentinv, prodhideprice, 0 AS prodgroupdiscount
				FROM
					isc_order_products
					INNER JOIN isc_orders ON orderorderid = orderid
					LEFT JOIN isc_products p ON ordprodid = productid
           LEFT JOIN isc_product_images pi ON (ordprodid=pi.imageprodid AND pi.imageisthumb=1)
				WHERE
					ordstatus = 2 AND prodvisible = 1 AND
					orddate >= 1714487691  GROUP BY prodname 
ORDER BY `num`  DESC
		 LIMIT 0, 6