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 l.title ASC LIMIT 0 , 100' at line 1

SELECT l.*,c.cat_name,s.name as state_name from link l INNER JOIN category c ON l.cat_id=c.cat_id INNER JOIN states s ON l.state_id=s.id WHERE 1 AND ORDER BY l.title ASC LIMIT 0 , 100