Combinando 2 selects

[jurena]

Creo que simplemente sobraba un paréntesis. No he probado nada.

SELECT t1.accesos, u.`iduser`, u.`fullname`, u.`gender`, c.`company`, u.`email`, u.`phone`, ut.`usertype`
FROM `users` u INNER JOIN (SELECT us.iduser, GROUP_CONCAT(a.access SEPARATOR '|') accesos FROM `users` us
INNER JOIN `usertypes` ut ON ut.`idusertype` = u.`usertypeid`
INNER JOIN `types_access` ta ON ta.`usertypeid` = ut.`idusertype`
INNER JOIN `access` a ON a.`idaccess` = ta.`accessid`
WHERE u.`iduser` = @id GROUP BY u.iduser)t1 ON u.iduser = us.iduser LEFT JOIN `companies` c ON c.`idcompany` = u.`companyid`
LEFT JOIN `usertypes` ut ON ut.`idusertype` = u.`usertypeid`
WHERE u.`iduser` = @id;