How to solve this SQL Syntax Error

Hi

I need help to resolve this SQL Syntax Error. Appreciate anyone can advice as how it can be resolved. Thanks.

$sq = "select t2.*,t1.* from (select id,name,points from celebrity order by points desc limit 44 ) t1 inner join photos t2 on t1.id = t2.celebid GROUP BY celebid ORDER BY points desc";

Code (markup):

I got this error running the above code:

You 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 id,name,points from celebrity order by points desc limit

Any advice will be greatly appreciated.

 

hummmmmmm, that seems to be good! wich version of mysql?

 

nothing looks like error... check version as zonzon said...

 

Okay. I will check on the version. Thanks!

 

I tested your query out on mysql ver 4.1.11 and had no issues.

 

My version is 4.0.25. Maybe I should be upgrading to version 4.1.11. Thanks for testing out for me.

 

Yes. Subqueries were not supported in MySQL until v4.1