Thanks Chuck for your quick reply... as requested:
Current Version 6.0
I set the DISPLAY ERRORS and it says as follows:
We're sorry, but the system experienced an unrecoverable error. Please try again later.
Query: SELECT count(*) AS vcount,avg(c.rating) AS avgr,p.cat,p.id,p.title,p.rating AS avgr FROM comments c LEFT JOIN photos p ON p.id=c.photo WHERE p.numcom > 1 GROUP BY c.photo ORDER BY avgr desc,vcount desc LIMIT
Result: 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 '' at line 6
Database handle: Resource id #6