Description
12/2以降のキャンペーンをマスタ登録
https://docs.google.com/spreadsheets/d/17jlkaog9frCMcqpySfvQaCk6ijaFQdnPAt11wLiaOXY/edit#gid=1578687105
12/2以降のキャンペーンをマスタ登録
https://docs.google.com/spreadsheets/d/17jlkaog9frCMcqpySfvQaCk6ijaFQdnPAt11wLiaOXY/edit#gid=1578687105
確認用
SELECT
camp.title,
camp.child_id,
camp.start_date,
camp.end_date,
reward.mission_title,
reward.mission_type,
reward.point
FROM
master_yamada_campaign AS camp
LEFT JOIN
master_yamada_point AS reward
ON
camp.child_id = reward.campaign_child_id
WHERE
camp.campaign_type = 4
AND
camp.start_date > "2020-12-01 00:00:00"