SELECT C.`id_customer`, C.`lastname`, C.`firstname`, C.`email`, P.`pseudo` FROM `ps_prestaforumgp_admins` AS A LEFT JOIN `ps_customer` AS C ON (A.`id_customer` = C.`id_customer`) LEFT JOIN `ps_prestaforumgp_pseudos` AS P ON (P.`id_customer` = C.`id_customer`) WHERE A.`reserve` = 0 AND A.`id_courant` = 0 ORDER BY C.`lastname`, C.`firstname`