SQL Error 1064??

[petemint]

I recently installed a mod for a legend at the bottom of my forum. It all worked well, but then found something better, so I re edited all the scripts, and deleted the folder for it, but I cnnot undo the SQL query.
I now get this error. What can I do to fix it?
I can't use my forum anymore.
Please help.

Could not query forums information

DEBUG MODE

SQL Error : 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 'FROM (( phpbb_forums f LEFT JOIN phpbb_posts p ON p.post_id = f.forum_last_p' at line 2

SELECT f.*, p.post_time, p.post_username, u.username, u.user_id, FROM (( phpbb_forums f LEFT JOIN phpbb_posts p ON p.post_id = f.forum_last_post_id ) LEFT JOIN phpbb_users u ON u.user_id = p.poster_id ) ORDER BY f.cat_id, f.forum_order

Line : 170
File : index.php

The site in question is www.thestealthelite.pcriot.com/forums
Edit:
**EDIT**

Not to worry, fixed it now, just re uploaded the original index.php page, and all is ok now, ty