| | |
|---|
| | | t2.car_number, |
|---|
| | | t6.region_name as communityName, |
|---|
| | | t7.region_name as streetName, |
|---|
| | | t8.url, |
|---|
| | | -- t8.url, |
|---|
| | | t9.address |
|---|
| | | FROM |
|---|
| | | ums_base_case t1 |
|---|
| | |
|---|
| | | LEFT JOIN ums_data_dictionary t5 on t5.id=t2.grade_id |
|---|
| | | LEFT JOIN ums_sccg_region t6 on t6.id=t1.community_id |
|---|
| | | LEFT JOIN ums_sccg_region t7 on t7.id=t1.street_id |
|---|
| | | LEFT JOIN ums_image_resources t8 on t8.belong_to_id=t1.id |
|---|
| | | -- LEFT JOIN ums_image_resources t8 on t8.belong_to_id=t1.id |
|---|
| | | LEFT JOIN ums_video_point t9 on t9.id=t2.video_point_id |
|---|
| | | <where> |
|---|
| | | <if test="queryForViolationParam.eventSource != null"> |
|---|
