| | |
|---|
| | | department_id, |
|---|
| | | classify_id, |
|---|
| | | consult_content, |
|---|
| | | concat(consult_user_name,consult_user_phone) consultUser, |
|---|
| | | concat((IFNULL(consult_user_name,'')),(IFNULL(consult_user_phone,''))) consultUser, |
|---|
| | | consult_user_name, |
|---|
| | | concat((select user_name from automessage_sys_user where a.submit_user_id=user_id ), submit_user_phone) submitUser, |
|---|
| | | concat((IFNULL((select user_name from automessage_sys_user where a.submit_user_id=user_id ),'')), (IFNULL(submit_user_phone,''))) submitUser, |
|---|
| | | submit_user_id, |
|---|
| | | concat((IFNULL((select user_name from automessage_sys_user where a.guide_user_id=user_id ),'')), (ifnull(guide_user_phone,''))) guideUser, |
|---|
| | | guide_user_id, |
|---|
