Mysql compatibility problem

[Gugulethu Ntombela]

I'm trying to execute this query with an older version of mysql:

update threads t set t.threadStatusID = 23
where t.threadStatusID = 5 AND t.threadID IN( SELECT i.threadID
FROM items i
group by i.threadID
having max(i.dateCreated) < CURDATE() - INTERVAL 14 DAY );

The query does work properly with mysql 5. How can I change it so that it runs in older versions?