SELECT DISTINCT PRODUCT_ID,PRODUCT_DESCRIPTION_ifg,PRODUCT_DESCRIPTION_long_ifg,Product_image,Product_Price FROM PRODUCT_MASTER WHERE (Product_Price >= 751) AND (Product_Price <= 1500) and product_id like '__H%' and ncid in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,18) order by product_price