[SOLVED] SQL error when trying to order users by Subscriptions criteria

Database loading error. Check and repair your database in Components / Community Builder / Tools. SQL Error (visible to super-admins only): 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 'DESC LIMIT 0, 100' at line 12 SQL=SELECT a.`id`, b.`name`, b.`username`, c.`session_id`, GROUP_CONCAT( DISTINCT d.`group_id` SEPARATOR '|*|' ) AS `groups`, b.`email`, ( SELECT GROUP_CONCAT( e.`name` ) AS `plan_names` FROM `hn3cl_cbsubs_plans` AS e LEFT JOIN `hn3cl_cbsubs_subscriptions` AS f ON f.`plan_id` = e.`id` WHERE ( f.`user_id` = a.`id` ) ) AS `subscriptions`, b.`registerDate`, b.`lastvisitDate`, a.`banned`, b.`block`, a.`confirmed`, a.`approved` FROM `hn3cl_comprofiler` AS a INNER JOIN `hn3cl_users` AS b ON b.`id` = a.`id` LEFT JOIN `hn3cl_session` AS c ON c.`client_id` in (0,1) AND c.`userid` = a.`id` LEFT JOIN `hn3cl_user_usergroup_map` AS d ON d.`user_id` = a.`id` LEFT JOIN `hn3cl_cbsubs_subscriptions` AS f ON f.`user_id` = a.`id` WHERE ( f.`plan_id` = 1 ) AND ( f.`status` = 'A' ) GROUP BY a.`id` ORDER BY (.`subscriptions` DESC LIMIT 0, 100