|
select distinct a.ACT_ID,a.IS_REQUIRED,a.TYPE,a.SCOPE,a.CRE_TIME,a.CRE_USER,a.BEGIN_TIME,a.END_TIME,a.ACT_CASE_ID,a.SCORE,a.STUDIO_ID from SD_STUDIO_ACT_USER u,SD_STUDIO_ACT a where 1=1 and u.ACT_CASE_ID=a.ACT_CASE_ID and a.DELETE_FLAG=0 /~ and a.STUDIO_ID={studioId} ~/ /~ and u.FANS_TYPE={joinType} ~/ /~ and a.CRE_USER={userId}~/ /~ and a.Type={actType} ~/ /~ and a.BEGIN_TIME > {nobeginTime} ~/ /~ and a.END_TIME < {hasEndTime} ~/ /~ and a.BEGIN_TIME < {nowTime} ~/ /~ and a.END_TIME > {now1Time} ~/ order by a.begin_time desc
|
