Searching history for open tickets in the past

[onetoefoot]

I was trying to search for tickets that were open in a 12 hour period.
This 12 hour period can be any date in the past.
Regardless if a ticket is closed now it may have been in a different state in the time period I am searching for.

Any help would be appreciated.
Thanks,

SET @end_date = NOW();
SET @start_date := DATE_SUB(@end_date, INTERVAL 12 HOUR);

SELECT
*
FROM ticket_history
INNER JOIN queue ON queue_id = queue.id
WHERE ticket_history.id IN (
SELECT
MAX(id) AS id
#,ticket_id
#,MAX(change_time) AS change_time
FROM
ticket_history
WHERE
change_time BETWEEN @start_date AND @end_date
GROUP BY
ticket_id
)
AND state_id IN (SELECT ticket_state.id
FROM ticket_state
WHERE ticket_state.name IN ("new", "open", "pending", "resolved", "on-hold"))
AND queue_id IN (SELECT queue.id
FROM queue
WHERE queue.name IN ("Raw", "Temp"))