SELECT DISTINCT B.PRODUCT_ID,B.PRODUCT_DESCRIPTION_ifg,B.PRODUCT_DESCRIPTION_long_ifg,b.Product_image,b.Product_Price,b.pof FROM OCCASION_PRODUCT AS A, PRODUCT_MASTER AS B WHERE A.PRODUCT_ID=B.PRODUCT_ID and A.occasionno in (16,76,77,78,79,80,81,82,83) ORDER BY b.pof