SELECT * FROM `t_b_salvage_application` t , `t_b_custer_info` u where t.application_state = 7 and u.identity_card = t.identity_card and date_format(t.create_time,'%y-%m-%d') between DATE_ADD('${starttime}',interval -day('${starttime}')+1 day) and last_day('${starttime}') |