| | |
|---|
| | | grp.group_code AS groupCode, |
|---|
| | | (SELECT COUNT(*) FROM ir_group_intake WHERE group_id = grp.id) AS intakeCount, |
|---|
| | | grp.default_duration AS defaultDuration, |
|---|
| | | 0 as sort, |
|---|
| | | pg.sort, |
|---|
| | | grp.operate_time |
|---|
| | | FROM ir_irrigate_group grp |
|---|
| | | LEFT JOIN ir_project_group pg ON pg.group_id = grp.id |
|---|
| | |
|---|
| | | AND grp.group_code LIKE CONCAT('%', #{groupCode}, '%') |
|---|
| | | </if> |
|---|
| | | </where> |
|---|
| | | ORDER BY grp.operate_time DESC |
|---|
| | | ORDER BY pg.sort |
|---|
| | | <trim prefix="limit "> |
|---|
| | | <if test="start != null and count != null"> |
|---|
| | | #{start,javaType=Integer,jdbcType=INTEGER}, #{count,javaType=Integer,jdbcType=INTEGER} |
|---|
