Is there a custom rule that will allow the service desk to notify a submitter that their ticket has been inactive for 1 day?
There's an open paren on the second to last line in your query you posted in comments:
and (HD_TICKET.HD_QUEUE_ID = 5
It does not require "(" so delete it
A few questions for clarification:
1. Are you only applying this to one queue?
2. Are you sure the only "inactive" status is 'Waiting for User'? (in our environment we have "Need More Info", "New, and "Waiting on Customer")
3. Do you have any idea why the table "ASSET_DATA_20" is included in this query?