```
select * FROM(SELECT
ht.xjob AS job,
GROUP_CONCAT(
DISTINCT CASE
WHEN vt.xpath0 = 'mainSend'
AND (vt.xstringShortValue LIKE '%@U%' OR vt.xstringShortValue LIKE '%@P%' OR vt.xstringShortValue LIKE '%@I%')
THEN vt.xstringShortValue END
) AS mainSend,
GROUP_CONCAT(
DISTINCT CASE
WHEN vt.xpath0 = 'subSend'
AND (vt.xstringShortValue LIKE '%@U%' OR vt.xstringShortValue LIKE '%@P%' OR vt.xstringShortValue LIKE '%@I%')
THEN vt.xstringShortValue END
) AS subSend,
GROUP_CONCAT(DISTINCT CASE WHEN vt.xpath0 = 'createTime' THEN vt.xstringShortValue END) AS createTime,
GROUP_CONCAT(DISTINCT CASE WHEN vt.xpath0 = 'task' THEN vt.xstringShortValue END) AS task
FROM
(
SELECT xjob, xprocess
FROM PP_C_WORK
WHERE xprocess = '8f6d740e-a69d-4d94-8481-4784a62c398b'
UNION ALL
SELECT xjob, xprocess
FROM PP_C_WORKCOMPLETED
WHERE xprocess = '8f6d740e-a69d-4d94-8481-4784a62c398b'
) ht
JOIN
QRY_ITEM vt ON ht.xjob = vt.xbundle
GROUP BY
ht.xjob

) t
```