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 (2) and A.product_id like '__H%' ORDER BY b.pof