Search Users

WordPress database error: [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 'GROUP BY u.ID ORDER BY u.ID ASC LIMIT 0, 12' at line 1]
SELECT u.*, um.* FROM wp_users u, wp_usermeta um INNER JOIN wp_usermeta um_level ON um.user_id = um_level.user_id AND um_level.meta_key = 'user_level' WHERE u.ID = um.user_id AND um_level.meta_value = GROUP BY u.ID ORDER BY u.ID ASC LIMIT 0, 12

WordPress database error: [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 'GROUP BY u.ID ORDER BY u.ID ASC) AS total_count' at line 1]
SELECT COUNT(*) FROM (SELECT u.*, um.* FROM wp_users u, wp_usermeta um INNER JOIN wp_usermeta um_level ON um.user_id = um_level.user_id AND um_level.meta_key = 'user_level' WHERE u.ID = um.user_id AND um_level.meta_value = GROUP BY u.ID ORDER BY u.ID ASC) AS total_count