为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】：wind10
【CPU】:
【问题描述】*：
总共1个语句正依次执行...

a.NAME AS orgName,
IFNULL( b.channelNum, 0 ) AS channelNum,
IFNULL( c.snapshotsNum, 0 ) AS snapshotsNum,
IFNULL( d.dailyWarningNum, 0 ) AS dailyWarningNum,
IFNULL( e.cumulativeNum, 0 ) AS cumulativeNum 

FROM
(
SELECT
oi.id,
oi.NAME
FROM
patrolling_task pt
LEFT JOIN canteen_information ci ON pt.canteen_id = ci.id
LEFT JOIN organization_information oi ON oi.id = ci.school_id
LEFT JOIN patrolling p ON p.id = pt.patrolling_id
WHERE
1 = 1
AND oi.NAME LIKE '%��˾%'
) a
LEFT JOIN (
SELECT
t.id AS id,
sum(CASE WHEN t.industry > 0 then 1 ELSE 0 END) AS channelNum
FROM
(
SELECT
a.id,
SUBSTRING_INDEX( SUBSTRING_INDEX( a.industry, ',', help_topic_id + 1 ), ',',- 1 ) AS industry
FROM
mysql.help_topic m,
(
SELECT
oi.id AS id,
get_unique_items ( group_concat( pt.inspect_channel ) ) AS industry
FROM
patrolling_task pt
LEFT JOIN canteen_information ci ON pt.canteen_id = ci.id
LEFT JOIN organization_information oi ON oi.id = ci.school_id
GROUP BY
oi.id
) a
WHERE
help_topic_id < LENGTH( a.industry ) - LENGTH( REPLACE ( a.industry, ',', '' ) ) + 1
) t
GROUP BY
t.id
) b ON a.id = b.id
LEFT JOIN (
SELECT
oi.id,
IFNULL( count( ae.id ), 0 ) AS snapshotsNum
FROM
ai_event ae
LEFT JOIN machine m ON m.device_id = ae.terminal_id
LEFT JOIN canteen_information ci ON ci.id = m.canteen_id
LEFT JOIN organization_information oi ON oi.id = ci.school_id
WHERE
1 = 1
AND ( ae.time BETWEEN CONCAT( DATE_FORMAT( NOW(), '%Y-%m-%d' ), ' 00:00:00' ) AND CONCAT( DATE_FORMAT( NOW(), '%Y-%m-%d' ), ' 23:59:59' ) )
GROUP BY
oi.id
) c ON a.id = c.id
LEFT JOIN (
SELECT
org_id AS org_id,
count() AS dailyWarningNum
FROM
warning_message
WHERE
patrolling_state = 1
AND ( create_time BETWEEN CONCAT( DATE_FORMAT( NOW(), '%Y-%m-%d' ), ' 00:00:00' ) AND CONCAT( DATE_FORMAT( NOW(), '%Y-%m-%d' ), ' 23:59:59' ) )
GROUP BY
org_id
) d ON d.org_id = a.id
LEFT JOIN (
SELECT
org_id AS org_id,
count() AS cumulativeNum
FROM
warning_message
WHERE
patrolling_state = 1
AND (
create_time BETWEEN CONCAT( DATE_FORMAT( NOW(), '%Y-%m-%d' ), ' 00:00:00' )
AND CONCAT( DATE_FORMAT( NOW(), '%Y-%m-%d' ), ' 23:59:59' ) )
AND state = 3
GROUP BY
org_id
) e ON e.org_id = a.id
GROUP BY
a.NAME
执行失败(语句1)
-2103: 第92 行附近出现错误:
无效的模式名[MYSQL]

1条语句执行失败