Fatal 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 '-120,120' at line 1 select c.firstname,c.lastname from `thisisagent`.`lc_customers` c LEFT JOIN customer_subscriptions s ON c.id=s.customer_id where c.customer_type='agent' and c.status='1' and c.lastname LIKE 'z/%' GROUP BY c.id ORDER BY SUM(LENGTH(s.subscription_type)) desc, c.id desc limit -120,120 in ~/includes/library/lib_database.inc.php on line 349