You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') orderByJoin on u.userId = orderByJoin.user_id left join ( select value as las' at line 11