SELECT adh.genid, adh.nom, adh.prenom, adh.defaultimage FROM cms_module_adherents_adherents AS adh, cms_module_adherents_groupes_belongs AS be WHERE adh.genid = be.genid AND be.id_group = ? AND adh.actif = 1 ORDER BY be.number ASC