영카트 쿠폰 관련 쿼리

영카트 쿠폰 관련 쿼리

더시민 0 528 2022.06.23 22:49

select cp_id, cp_subject, cp_method, cp_target, cp_start, cp_end, cp_type, cp_price from {$g5['g5_shop_coupon_table']} a left join {$g5['member_table']} b on (a.cp_target=b.mb_id) where a.mb_id IN ( '{$member['mb_id']}', '전체회원' ) and a.cp_start <= '".G5_TIME_YMD."' and a.cp_end >= '".G5_TIME_YMD."' and a.shop_id = '' and a.cp_target <> '' and b.mb_1 <> '' order by cp_no "

Comments

Category
Facebook Twitter GooglePlus KakaoStory KakaoTalk NaverBand