Systems Management

I am trying to figure out a query to email techs when a ticket get reassigned to that technical group. I am having issue trying to figure this out. here is what I have.

   

SELECT
HD_TICKET.ID as TICKNUM, -- $id
      HD_TICKET.TITLE as TITLE, -- $title
      SUBMITTER.FULL_NAME as SUBMITTER_FNAME, -- $submitter_fname
      SUBMITTER.EMAIL as SUBMITTER_EMAIL,     -- $submitter_email
CAT.NAME as CATEGORY, -- $category
P.NAME as PRIORITY, -- $priority
S.NAME as STATUS,   -- $status
I.NAME as IMPACT,   -- $impact
HD_TICKET_CHANGE.COMMENT as COMMENTS, -- $comments
HD_TICKET_CHANGE.OWNERS_ONLY_DESCRIPTION as DESCRIPTIONS, -- $description
'USERS EMAIL ADDRESS HERE' as NEWTICKETEMAIL
FROM ORG1.HD_TICKET
LEFT JOIN HD_TICKET_CHANGE ON HD_TICKET.ID=HD_TICKET_CHANGE.HD_TICKET_ID
join HD_IMPACT I on I.ID=HD_IMPACT_ID
join HD_STATUS S on S.ID=HD_STATUS_ID
left join USER SUBMITTER on SUBMITTER.ID = HD_TICKET.SUBMITTER_ID
join HD_PRIORITY P on P.ID=HD_PRIORITY_ID
join HD_CATEGORY CAT on CAT.ID=HD_CATEGORY_ID
where HD_TICKET_CHANGE.OWNERS_ONLY_DESCRIPTION LIKE '%Changed Technical Group from "%" to "Desktop Team".%'
and CUSTOM_FIELD_VALUE7 = "Desktop Team"
and HD_TICKET_CHANGE.ID=<CHANGE_ID>

I am getting an error when I run Ticket search result below:

There were syntax errors in your query.

mysqli error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= and HD_TICKET.HD_QUEUE_ID = '1'' at line 22] in EXECUTE(" SELECT HD_TICKET.ID as TICKNUM, -- $id HD_TICKET.TITLE as TITLE, -- $title SUBMITTER.FULL_NAME as SUBMITTER_FNAME, -- $submitter_fname SUBMITTER.EMAIL as SUBMITTER_EMAIL, -- $submitter_email CAT.NAME as CATEGORY, -- $category P.NAME as PRIORITY, -- $priority S.NAME as STATUS, -- $status I.NAME as IMPACT, -- $impact HD_TICKET_CHANGE.COMMENT as COMMENTS, -- $comments HD_TICKET_CHANGE.OWNERS_ONLY_DESCRIPTION as DESCRIPTIONS, -- $description 'Emaill Address here' as NEWTICKETEMAIL FROM ORG1.HD_TICKET LEFT JOIN HD_TICKET_CHANGE ON HD_TICKET.ID=HD_TICKET_CHANGE.HD_TICKET_ID join HD_IMPACT I on I.ID=HD_IMPACT_ID join HD_STATUS S on S.ID=HD_STATUS_ID left join USER SUBMITTER on SUBMITTER.ID = HD_TICKET.SUBMITTER_ID join HD_PRIORITY P on P.ID=HD_PRIORITY_ID join HD_CATEGORY CAT on CAT.ID=HD_CATEGORY_ID where HD_TICKET_CHANGE.OWNERS_ONLY_DESCRIPTION LIKE '%Changed Technical Group from "%" to "Desktop Team".%' and CUSTOM_FIELD_VALUE7 = "Desktop Team" and HD_TICKET_CHANGE.ID= and HD_TICKET.HD_QUEUE_ID = '1' ")

I have no knowledge of query language so any help would be appreciated