| | |
| | | WHERE |
| | | caep.community_id = #{communityId} |
| | | AND caep.`status` >= 4 |
| | | AND caep.evaluate_at <![CDATA[ <= ]]> #{endDate} |
| | | AND caep.evaluate_at <![CDATA[ >= ]]> #{startDate} |
| | | AND caep.feedback_at <![CDATA[ <= ]]> #{endDate} |
| | | AND caep.feedback_at <![CDATA[ >= ]]> #{startDate} |
| | | AND caep.sponsor_id IN ( |
| | | SELECT |
| | | user_id |
| | |
| | | WHERE |
| | | caep.community_id = #{communityId} |
| | | AND caep.`status` >= 4 |
| | | AND camw.evaluate_at <![CDATA[ <= ]]> #{endDate} |
| | | AND caep.feedback_at <![CDATA[ <= ]]> #{endDate} |
| | | AND caep.sponsor_id IN ( |
| | | SELECT |
| | | user_id |