A Database Error Occurred

Error Number: 1064

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 'order by cad_files.id desc' at line 6

select cad_files.*,(select count(*) from cad_files) as total, cad_registration.name from cad_files,cad_registration where cad_files.user_id=cad_registration.id and order by cad_files.id desc