UPDATE custom_data_1020 SET post_qty=post_qty + 1
WHERE id in
(SELECT ad_id
FROM custom_data_1014_ad_list a, custom_data_1014 b
WHERE a.data_id = b.data_id AND (postdate BETWEEN b.postdate_begin AND b.postdate_end)
AND b.application_date = DATE_FORMAT(now(),"%Y-%m-%d")) ...