KACE Product Support

I have a bunch of rules to notify supervisors when tickets sit in a status for a certain period of time. I want the rule to also send an email to the ticket owner. When I add this statement which i stole from another rule:

OWNER.EMAIL AS OWNER_EMAIL,     -- $owner_email

I get an error. I assumed it had to do with pulling the owner info from another table and tried to add this join statement to fix it:

LEFT JOIN USER OWNER ON OWNER.ID = HD_TICKET.OWNER_ID

Here is the full query:

 Select 'lwalters@wacoisd.org' AS LISA,

'cfrey@wacoisd.org as CHARLIE,

OWNER.EMAIL AS OWNER_EMAIL,     -- $owner_email

S.NAME AS STATUS, T.ID AS ID, T.TITLE AS ISSUE,

U.FULL_NAME AS SUBMITTER, O.FULL_NAME AS OWNER,

T.CREATED AS CREATED, T.MODIFIED AS STALLED

FROM HD_TICKET T

JOIN HD_STATUS S ON (S.ID = T.HD_STATUS_ID)

JOIN USER U ON (U.ID = T.SUBMITTER_ID)

JOIN USER O ON (O.ID = T.OWNER_ID)

WHERE (S.NAME = 'Follow-up' AND DATEDIFF(NOW(), T.MODIFIED) = 10 AND O.USER_NAME = 'ajimenez')

OR (S.NAME = 'Follow-up' AND DATEDIFF(NOW(), T.MODIFIED) = 10 AND O.USER_NAME = 'trott')

OR (S.NAME = 'Follow-up' AND DATEDIFF(NOW(), T.MODIFIED) = 10 AND O.USER_NAME = 'mmccormick')

OR (S.NAME = 'Follow-up' AND DATEDIFF(NOW(), T.MODIFIED) = 10 AND O.USER_NAME = 'sfelkner')

OR (S.NAME = 'Follow-up' AND DATEDIFF(NOW(), T.MODIFIED) = 10 AND O.USER_NAME = 'ckluk')

OR (S.NAME = 'Follow-up' AND DATEDIFF(NOW(), T.MODIFIED) = 10 AND O.USER_NAME = 'bgamboa')

OR (S.NAME = 'Follow-up' AND DATEDIFF(NOW(), T.MODIFIED) = 10 AND O.USER_NAME = 'rdaniels')

OR (S.NAME = 'Follow-up' AND DATEDIFF(NOW(), T.MODIFIED) = 10 AND O.USER_NAME = 'lmland')

AND T.HD_QUEUE_ID = 1