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 (5,19,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75) ORDER BY b.pof