SELECT SQL_SMALL_RESULT SQL_NO_CACHE SQL_BUFFER_RESULT
    CONCAT('kill ', mainTT.ID, ';') AS kill_cmd,
    mainTT.ID,
    
    CONVERT(CAST(`USER` AS BINARY) USING utf8mb4) COLLATE utf8mb4_unicode_ci AS `USER`, 
    CONVERT(CAST(`HOST` AS BINARY) USING utf8mb4) COLLATE utf8mb4_unicode_ci AS `HOST`, 
    CONVERT(CAST(`DB` AS BINARY) USING utf8mb4) COLLATE utf8mb4_unicode_ci AS `DB`, 
    CONVERT(CAST(`COMMAND` AS BINARY) USING utf8mb4) COLLATE utf8mb4_unicode_ci AS `COMMAND`, 
    
    (`TIME_MS` / 1000) AS TIME,
    #`TIME`,
    CONVERT(CAST(`STATE` AS BINARY) USING utf8mb4) COLLATE utf8mb4_unicode_ci AS `STATE`, 
    CONVERT(CAST(`INFO` AS BINARY) USING utf8mb4) COLLATE utf8mb4_unicode_ci AS `INFO`, 
    `STAGE`,
    `MAX_STAGE`,
    `PROGRESS`,
    `MEMORY_USED`,
    `MAX_MEMORY_USED`,
    `EXAMINED_ROWS`,
    `QUERY_ID`
    `TID`
FROM INFORMATION_SCHEMA.PROCESSLIST AS mainTT
WHERE
    (`DB` = 'xxxxxxxxxxxxxxxxxxxxxxxxxx' OR `DB` IS NULL)
	AND NOT (
	    `COMMAND` = 'Query'
	    AND CONVERT(CAST(`INFO` AS BINARY) USING utf8mb4) COLLATE utf8mb4_unicode_ci LIKE 'select %view_db_process_list%' 
	)
    AND `COMMAND` NOT IN ('Sleep', 'Daemon', 'Killed')