| | |
|---|
| | | |
|---|
| | | |
|---|
| | | <select id="queryCompetitionList" resultType="com.dsh.competition.model.CompetitionListVo"> |
|---|
| | | select * from ( |
|---|
| | | select |
|---|
| | | aa.id, |
|---|
| | | aa.name, |
|---|
| | | aa.coverDrawing, |
|---|
| | | aa.cityName, |
|---|
| | | aa.registerCondition, |
|---|
| | | aa.introduction, |
|---|
| | | aa.registerEndTime, |
|---|
| | | aa.age, |
|---|
| | | aa.heat |
|---|
| | | from ( |
|---|
| | | select |
|---|
| | | a.id, |
|---|
| | | a.`name`, |
|---|
| | |
|---|
| | | a.city as cityName, |
|---|
| | | a.registerCondition, |
|---|
| | | a.introduction, |
|---|
| | | DATE_FORMAT(a.registerEndTime, '%Y-%m-%d %H:%i') as registerEndTime, |
|---|
| | | CONCAT(a.startAge, '-', a.endAge) as `age`, |
|---|
| | | (a.baseNumber + a.applicantsNumber) as `heat` |
|---|
| | | DATE_FORMAT(a.registerEndTime, '%Y-%m-%d %H:%i') registerEndTime, |
|---|
| | | CONCAT(a.startAge, '-', a.endAge) age, |
|---|
| | | (a.baseNumber + a.applicantsNumber) heat |
|---|
| | | from t_competition a |
|---|
| | | where a.auditStatus = 2 and a.`status` = 2 and a.state = 1 |
|---|
| | | <if test="null != cityCode and '' != cityCode"> |
|---|
