| | |
| | | common_problem_url, |
| | | common_problem_name, |
| | | operational_guideline_video_url, |
| | | (select classify_name from automessage_classify_administration where automessage_classify_administration.id=automessage_transaction_event.classify_id) as classifyName, |
| | | (IF((select classify_grade from automessage_classify_administration where automessage_classify_administration.id=automessage_transaction_event.classify_id)='2', |
| | | (select classify_name from automessage_classify_administration where automessage_classify_administration.id=(select parent_id from |
| | | automessage_classify_administration where automessage_classify_administration.id=automessage_transaction_event.classify_id)), |
| | | (select classify_name from automessage_classify_administration where automessage_classify_administration.id=automessage_transaction_event.classify_id))) as classifyName, |
| | | (select organization_name from automessage_organization_chart where automessage_organization_chart.id=automessage_transaction_event.department_id) as departmentName, |
| | | concat( |
| | | (select classify_name from automessage_classify_administration where id=(select parent_id from automessage_classify_administration where id=automessage_transaction_event.classify_id)), |