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.SHOP_ID = 'SS0172') AND (a.FAVORITE_ID='FR021') AND (a.PRODUCT_ID='SS0172-FR021-3') 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 a.PRODUCT_IMAGE is not NULL 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 =