SQL version 4

[eluser]sudinem[/eluser]
I have a sql query which works fine on Mysql server version 5 like this:

Code:

SELECT max( cnt ) AS max_no_rows
FROM (

SELECT event_card, count( time ) cnt
FROM detail_attendance
WHERE date = '2011-01-02'
GROUP BY event_card
) AS T

but this does not works in mysql version 4...How to restructure the query for version 4