Is there any compatibility related to this SQL statement?

Is there any compatibility problem with this SQL statement? $ Query & nbsp ;=& nbsp; & quot; & nbsp; select & nbsp; * & nbsp; from & nbsp; $ member_table & nbsp; me1 & nbsp; left & nbsp; join & nbsp; (is there any compatibility problem with the SQL statement selec?
$ Query = "select * from $ member_table me1 left join (select *, max (lead_date) as maxdate from $ leada_table group by user_id order by lead_date) temp on (me1.user _ id = temp. user_id) where me1.islead = 1 and temp. maxdate <= '$ timestamp '";


Is there any compatibility problem with this SQL statement?
Your have an error in your SQL syntax. check the manual that corresponds to your MySQL server version for the right syntax to use near 'select *, max (lead_date) as maxdate from haoshutong_leada_cn

Local mysql 4.1.21
MySQL 4.0.23

------ Solution --------------------
Subquery 4.0 is not supported, that is, the select