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