Scripting

I am trying to create a report that shows us the amount of time that was spent on each ticket in the last 7 days.  My field for the time spent on a ticket is listed as HD_TICKET.CUSTOM_FIELD_VALUE4 but I am not sure what I have wrong in my SQL statement as it errors when I try to save the statement.

SELECT HD_TICKET.CREATED, HD_TICKET.ID, O.USER_NAME AS OWNER_USER_NAME, HD_TICKET.CUSTOM_FIELD_VALUE4, HD_TICKET.TITLE  FROM HD_TICKET  LEFT JOIN USER O ON (O.ID = HD_TICKET.OWNER_ID) WHERE (HD_TICKET.HD_QUEUE_ID = 5) AND ((HD_TICKET.CUSTOM_FIELD_VALUE4 != ''))  
WHERE T.CREATED > DATE_SUB(NOW(), INTERVAL 7 DAY) ORDER BY CREATED, ID

The error I get is below.

"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 'WHERE T.CREATED > DATE_SUB(NOW(), INTERVAL 7 DAY) ORDER BY CREATED, ID LIMIT 0' at line 2] in EXECUTE(\n"SELECT HD_TICKET.CREATED, HD_TICKET.ID, O.USER_NAME AS OWNER_USER_NAME, HD_TICKET.CUSTOM_FIELD_VALUE4, HD_TICKET.TITLE FROM HD_TICKET LEFT JOIN USER O ON (O.ID = HD_TICKET.OWNER_ID) WHERE (HD_TICKET.HD_QUEUE_ID = 5) AND ((HD_TICKET.CUSTOM_FIELD_VALUE4 != '')) \nWHERE T.CREATED > DATE_SUB(NOW(), INTERVAL 7 DAY) ORDER BY CREATED, ID LIMIT 0")\n"