| | |
|---|
| | | </select> |
|---|
| | | |
|---|
| | | <select id="getByApplet" resultType="com.panzhihua.common.model.vos.community.social.SocialProjectVO"> |
|---|
| | | select t.*, t1.phone as streetPhone, t2.name as columnName, t3.name as secondColumnName,t1.name as streetName,t4.name as communityName,t4.phone as communityPhone |
|---|
| | | select t.*, t1.phone as streetPhone, t2.name as columnName, t3.name as secondColumnName,t1.name as streetName,t4.name as communityName,t4.contacts_phone as communityPhone |
|---|
| | | from com_act_social_project t |
|---|
| | | LEFT JOIN com_street t1 on t.street_id = t1.street_id |
|---|
| | | LEFT JOIN com_act_column t2 on t.column_id = t2.id |
|---|
