영카트 쿠폰 관련 쿼리

영카트 쿠폰 관련 쿼리

더시민 0 72 0

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 "

0 Comments
제목
Category
Facebook Twitter GooglePlus KakaoStory KakaoTalk NaverBand