Output: mutcandidats.cromutcdt, mutcandidats.nommutcdt, mutcandidats.premutcdt, mutdemandes.cromutdmd, disciplines.crodis, categories.crocat, operationsgroupes.crosgo, operationsgroupes.idesgo, operationtypes.crotop, operationtypes.croanntop, operationtypes.toutop, adherents.crosyn, adherents.idesyn, adherents.ustsyn, adherents.datdercotsyn, adherents.auxadrsyn, adherents.voiadrsyn, adherents.bopadrsyn, adherents.copadrsyn, adherents.locadrsyn, adherents.quaadrsyn, adherents.cotadrsyn, adherents.ctcadrsyn, acasyn.croaca, ssituations.crossi, ssituations.autssi, vacances.auxadrvac, vacances.voiadrvac, vacances.bopadrvac, vacances.copadrvac, vacances.locadrvac, vacances.quaadrvac, vacances.cotadrvac, vacances.ctcadrvac, acamutdmd.croaca, (CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN mutrlt1.croacamutrlt ELSE mutrlt2.croacamutrlt END), (CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN mutrlt1.croetamutrlt ELSE mutrlt2.croetamutrlt END), (CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.ideeta ELSE etarlt2.ideeta END), (CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.nometa ELSE etarlt2.nometa END), (CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.auxadreta ELSE etarlt2.auxadreta END), (CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.voiadreta ELSE etarlt2.voiadreta END), (CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.bopadreta ELSE etarlt2.bopadreta END), (CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.copadreta ELSE etarlt2.copadreta END), (CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.locadreta ELSE etarlt2.locadreta END), (CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.quaadreta ELSE etarlt2.quaadreta END), (CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.cotadreta ELSE etarlt2.cotadreta END), (CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.ctcadreta ELSE etarlt2.ctcadreta END), etaaffmutdmd.croeta, etaaffmutdmd.ideeta, etaaffmutdmd.nometa, etaaffmutdmd.auxadreta, etaaffmutdmd.voiadreta, etaaffmutdmd.bopadreta, etaaffmutdmd.copadreta, etaaffmutdmd.locadreta, etaaffmutdmd.quaadreta, etaaffmutdmd.cotadreta, etaaffmutdmd.ctcadreta, (CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.auxadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.nometa WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.nometa WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.nometa WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.nometa ELSE NULL::character varying END), (CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.voiadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.voiadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.voiadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.voiadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.voiadreta ELSE NULL::character varying END), (CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.bopadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.bopadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.bopadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.bopadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.bopadreta ELSE NULL::character varying END), (CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.copadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.copadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.copadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.copadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.copadreta ELSE NULL::bpchar END), (CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.locadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.locadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.locadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.locadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.locadreta ELSE NULL::character varying END), (CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.quaadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.quaadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.quaadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.quaadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.quaadreta ELSE NULL::bpchar END), (CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.cotadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.cotadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.cotadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.cotadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.cotadreta ELSE NULL::bpchar END), (CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.ctcadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.ctcadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.ctcadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.ctcadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.ctcadreta ELSE NULL::character varying END)

Output: mutcandidats.cromutcdt, mutcandidats.nommutcdt, mutcandidats.premutcdt, mutdemandes.cromutdmd, disciplines.crodis, categories.crocat, operationsgroupes.crosgo, operationsgroupes.idesgo, operationtypes.crotop, operationtypes.croanntop, operationtypes.toutop, adherents.crosyn, adherents.idesyn, adherents.ustsyn, adherents.datdercotsyn, adherents.auxadrsyn, adherents.voiadrsyn, adherents.bopadrsyn, adherents.copadrsyn, adherents.locadrsyn, adherents.quaadrsyn, adherents.cotadrsyn, adherents.ctcadrsyn, acasyn.croaca, ssituations.crossi, ssituations.autssi, vacances.auxadrvac, vacances.voiadrvac, vacances.bopadrvac, vacances.copadrvac, vacances.locadrvac, vacances.quaadrvac, vacances.cotadrvac, vacances.ctcadrvac, acamutdmd.croaca, CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN mutrlt1.croacamutrlt ELSE mutrlt2.croacamutrlt END, CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN mutrlt1.croetamutrlt ELSE mutrlt2.croetamutrlt END, CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.ideeta ELSE etarlt2.ideeta END, CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.nometa ELSE etarlt2.nometa END, CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.auxadreta ELSE etarlt2.auxadreta END, CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.voiadreta ELSE etarlt2.voiadreta END, CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.bopadreta ELSE etarlt2.bopadreta END, CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.copadreta ELSE etarlt2.copadreta END, CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.locadreta ELSE etarlt2.locadreta END, CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.quaadreta ELSE etarlt2.quaadreta END, CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.cotadreta ELSE etarlt2.cotadreta END, CASE WHEN (mutrlt1.cromutrlt IS NOT NULL) THEN etarlt1.ctcadreta ELSE etarlt2.ctcadreta END, etaaffmutdmd.croeta, etaaffmutdmd.ideeta, etaaffmutdmd.nometa, etaaffmutdmd.auxadreta, etaaffmutdmd.voiadreta, etaaffmutdmd.bopadreta, etaaffmutdmd.copadreta, etaaffmutdmd.locadreta, etaaffmutdmd.quaadreta, etaaffmutdmd.cotadreta, etaaffmutdmd.ctcadreta, CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.auxadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.nometa WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.nometa WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.nometa WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.nometa ELSE NULL::character varying END, CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.voiadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.voiadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.voiadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.voiadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.voiadreta ELSE NULL::character varying END, CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.bopadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.bopadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.bopadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.bopadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.bopadreta ELSE NULL::character varying END, CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.copadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.copadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.copadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.copadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.copadreta ELSE NULL::bpchar END, CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.locadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.locadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.locadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.locadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.locadreta ELSE NULL::character varying END, CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.quaadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.quaadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.quaadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.quaadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.quaadreta ELSE NULL::bpchar END, CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.cotadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.cotadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.cotadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.cotadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.cotadreta ELSE NULL::bpchar END, CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.ctcadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.ctcadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.ctcadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.ctcadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.ctcadreta ELSE NULL::character varying END

Filter: ((adherents.copadrsyn <> ''::bpchar) OR (CASE WHEN (adherents.copadrsyn IS NOT NULL) THEN adherents.copadrsyn WHEN (etaexesyn.copadreta IS NOT NULL) THEN etaexesyn.copadreta WHEN ((typeanc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaeanc.copadreta IS NOT NULL)) THEN etaeanc.copadreta WHEN ((typranc.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaranc.copadreta IS NOT NULL)) THEN etaranc.copadreta WHEN ((typaffmutdmd.idetyp <> ALL ('{ZR,IUF,FIC}'::bpchar[])) AND (etaaffmutdmd.copadreta IS NOT NULL)) THEN etaaffmutdmd.copadreta ELSE NULL::bpchar END <> ''::bpchar))