SELECT * FROM MARTSERVER.VW_SHOP_PRODUCT_NAME a, MARTSERVER.VW_SHOP_PRODUCT_FAVORITES b,MARTSERVER.VW_SHOP_AREA c, MARTSERVER.VW_SHOP_PROVINCE d
WHERE a.PRODUCT_IMAGE is not NULL AND a.SHOP_ID = 'SH0188' AND (a.FAVORITE_ID='FR001') AND (a.FAVORITE_ID = b.FAVORITE_ID) AND (a.PROVINCE_ID = d.PROVINCE_ID) AND (c.AREA_ID = d.AREA_ID) AND a.AMOUNT>0 AND (TO_DATE(a.EXPIRE_DATE,'DD/MM/YYYY') >= TO_DATE(sysdate,'DD/MM/YYYY') OR a.EXPIRE_DATE is null)
AND TO_DATE(a.ISSUED_DATE,'DD/MM/YYYY') <= TO_DATE(sysdate,'DD/MM/YYYY')
ORDER BY a.ISSUED_DATE DESC sub_favorite_id =