SELECT DISTINCT WORKFLOWNAME
FROM (
         SELECT id, NODENAME
         FROM workflow_nodebase
         WHERE NODENAME LIKE "%CEO%") AS wnb
         LEFT JOIN workflow_flownode wf ON wf.NODEID = wnb.id
         LEFT JOIN workflow_base wb ON wb.id = wf.WORKFLOWID
WHERE ISVALID = 1
  AND SUBCOMPANYID = 101
  AND WORKFLOWTYPE NOT IN (1, 171, 89, 105, 223)