Scripting

I am creating a custom rule to replace the generic Email on Events rules.  This script works fine in MySQL Workbench and pulls records properly and also works fine if I run the SQL in an SQL report within KACE.  The problem comes into place when I try running it in a Custom Ticket Rule.  I have it set to run on ticket save.  Here is the error I get in the Run Log: mysql error: [1054: Unknown column 'HD_TICKET.ID' in 'having clause']

When I scroll down the log to the section of the script that houses this part, here is what it shows:

WHERE
    C.DESCRIPTION NOT LIKE 'TICKET CREATED   /* this is necessary when using group by functions */
    GROUP BY M.ID
    HAVING 1=1 and (HD_TICKET.ID = 4067) ")

I know this ticket ID is valid because it is on a test ticket I am using. Below is the actual SQL I am running.

Thank you in advance for any help that can be provided.

SELECT
    -- Ticket Fields
    M.ID, -- $id
    /* M.ID AS TICKNUM, -- $ticknum */
    M.TITLE, -- $title
 
    -- Change Fields
    C.COMMENT, -- $comment
    C.DESCRIPTION, -- $description
    S.NAME AS STATUS,
  
    CASE WHEN S.NAME = 'New' THEN
     /* I have taken out this part of the script because it is a group concat to

         create a custom message for the outgoing email /*
    END HISTORY, -- $history 
    
    -- About the Udater
    UPDATER.USER_NAME AS UPDATER_UNAME, -- $updater_uname
    UPDATER.FULL_NAME AS UPDATER_FNAME, -- $updater_fname
    UPDATER.EMAIL AS UPDATER_EMAIL,     -- $updater_email
    IF(UPDATER.FULL_NAME='',UPDATER.USER_NAME,UPDATER.FULL_NAME) AS UPDATER_CONDITIONAL, -- $updater_conditional
 
    -- about the owner
    OWNER.USER_NAME AS OWNER_UNAME, -- $owner_uname
    OWNER.FULL_NAME AS OWNER_FNAME, -- $owner_fname
    OWNER.EMAIL AS OWNER_EMAIL,     -- $owner_email
    IFNULL(OWNER.USER_NAME,'Unassigned') OWNER_USER, -- $owner_user
 
    -- About the Submitter
    SUBMITTER.USER_NAME AS SUBMITTER_UNAME, -- $submitter_uname
    SUBMITTER.FULL_NAME AS SUBMITTER_FNAME, -- $submitter_fname
    SUBMITTER.EMAIL AS SUBMITTER_EMAIL,     -- $submitter_email
 
    -- About Status
    S.NAME AS STATUS,   -- $status

    -- About Category
    CAT.NAME AS CATEGORY, -- $category
 
FROM HD_TICKET M
 
    /* latest change ***/ JOIN HD_TICKET_CHANGE C ON C.HD_TICKET_ID = M.ID
    /* complete history*/ JOIN HD_TICKET_CHANGE H ON H.HD_TICKET_ID = M.ID
    /* status **********/ JOIN HD_STATUS S ON S.ID = M.HD_STATUS_ID
    /* category ********/ JOIN HD_CATEGORY CAT ON CAT.ID = M.HD_CATEGORY_ID
    /* owner ***********/ LEFT JOIN USER OWNER ON OWNER.ID = M.OWNER_ID
    /* submitter *******/ LEFT JOIN USER SUBMITTER ON SUBMITTER.ID = M.SUBMITTER_ID
    /* updater *********/ LEFT JOIN USER UPDATER ON UPDATER.ID = C.USER_ID

WHERE
    C.DESCRIPTION NOT LIKE 'TICKET CREATED%'
      
   /* this is necessary when using group by functions */
    GROUP BY M.ID
    HAVING 1=1