SELECT DISTINCT epu.idUnite, epu.nomUnite, epu.mvtUnite, epu.svgUnite, epu.faUnite, epu.poidsUnite, epu.descriptionUnite, epu.idFaction, epu.categorieUnite, epa.idArme, epa.nomArme, epa.distanceArme, epa.nbDeArme, epa.toucheArme, epa.modifArme, epa.notesArme, epu.nbArme FROM epic_unite epu, epic_arme epa, epic_codex_unite ecu WHERE ecu.idUnite = epu.idUnite AND epu.idUnite = epa.idUnite AND epu.idUnite IN (0,71,72,80,97,607,91,92,1,2,,,108,112,1,74,116,1034,1035) ORDER BY epu.categorieUnite, epu.nomUnite