BbYnFM6C72LS+BoZwmEYmb/Uh0uXwrICpQJ1VCf1OGyMELV4wgXoz2MhublOIJIlw6PRcHc8IV88rTJqZzeC/ct+tbnzpNtWW9rUqWrEpd19EVmZ2HCdHUhHQJCcIEKTLIE70EldtrwFDW6AuiRvJlvU9oEw04JSlhQCSQlOCIZbHuP3EFYrO6oHGHQUY9U/lg6v9Wcto7XTWvU2Nr4jth3mjhTs7jZrPrgLrXKEdBWz5vP5n4kFZwMuXpeqMAWIdzrl85PRbqKI6SUyG4j3+gPUKeyeLAzMxNCsq9NH1jK6GPbTvxeJ/vo/EVVXK0jvxJfC/7ZjlLjo+efQ+qGo/HRYGj4ywji1R8fgjJDIwd9clomBXNdvhvO8kj44FqRVeJ1+kRrlPr4sJXZ7uz2IP0acGm6PfCuRqFZxIhn8np42K8EMzE7YMMzkJEAEwl/fGCNvLrKcsPcYoS1BKuUWyg7fsaIkAy6Vk3iPkop51TxkOaawfYcEAe7g6XFn+O3dx1WRzP8UeLbNq0E3d2viCHosqd5W69LJW0N1W/Seo5qNXzxybzNbrnFtqWrm6EeKR1SYjY9kG6TLudmu67crDV6V3+KC1h3u/ZMbBc7lvsNe1xw1TYXp6FlClleOOYUiLSiZGbh+i7ALreoK1tlb08UlvPJgiLN3jICaV3Lw1tXosIOHd5l8X7uRYeuRdHDc6ECP/VFXavq7ZXt9kpdr294byxGPfd1Cp76QwAhd8tWsA3RP5wGtdtw4d3fnFMbmNsS9vXb0Edvt5u3Y4j8WKWb5xLUSJ4ZT49GFN+YE+Y+iHbs45/LHdJt96Ymu87OiSQm4AfZmAHK0PqrwRt1K/7EyZ+lscYUM4t9CXLGZrCTBgg7sfUAu0TLbUedNasRoMTqEDhHaQE4zx/joerblSZcBMvm4XMug97Mn6gmasw/GyCztmgBvO43SLyYz7PmGpp2nUmsWO2IimFZiBE3t7/LNG9DPlChEEkL8uVfYqWI01RtcGXgoLlZRhsseBTXuhzQ2TB09F/rwF5s+jN1aswdmij0ecMoM9+CE5eWk/jEj51zqEjXJGtjvwuV+sPpdlZ71/UU2CfwHyIwgGMLC3G+OHQDNiJOdHk3dIF2TIx4KlnvfWpcBDFnLXRwbXvEPenNpXhNI0vB7X70YyRgCCyad1Q/dCgCyldhvc4C4gUC/7KqDNoaYUtESrQvoXFDZ8KWdwOszst1P7bjSD9t0B5LGUcHqkVIrECLYd0h+qzo0G7GJxFrgJwY9A7ax8tpiGQ0HnRqOaE9/tMblKeGb5Ppe27b0uploNPrNMfo91jnq/fFYLdTWXcEe4GBXwliuS8zOJReSos/lBkEQGJCC6QxyPi9FpDlJPeaCGitN6zffs1EPBXfQNyFUar12Os5uwivqnin6Y++TkW/ZAccqp1z391fsA8hdK8bdfiDhfBf6VNaTjg9IL3VCiEwsub6K45LGlM04OrY0GX+SV+VuLVl66wJRLBdisUwPitX6Hc9gIAfxSIeOPH4AeRyvgwNYlCXOfrRzyGYJkX3E5s9jaU3gUcijXiPtYhW6wBBFTKBD/oDkqw09NH1HtXYdwZO9zSA2eRvTS3DvcHNzskEnnH99cF6ghtopPvFZ5o5wjoj6yltTYX1xIch3VfmRCUVLfJ/myEg/8Zxwd2tKCV4VmftzjCL5Ls0JRNfGCsXiDAP7t0tRoIpiLNJE/7w=
1 - SELECT et.id, et.residence, et.bottin, et.emploi, et.msss, (eev.dateFin > NOW()) as vedette FROM emplois_temp et
LEFT JOIN envois_eer_emplois_vedette eev ON eev.emploi = et.id AND eev.dateFin > NOW()
LEFT JOIN residences r2 ON r2.id = et.residence WHERE (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' AND (r2.emplois_masques != '1' OR r2.emplois_masques IS NULL) AND
((SELECT desapprouve FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0')
AND (SELECT affiche FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '1'
AND (
et.residence in (select res_id from utilisateurs where res_id > 0)
OR
et.bottin in (select serv_id from utilisateurs where serv_id > 0)
OR
et.msss in (select msss_id from utilisateurs where msss_id > 0)
OR
r2.groupe in (select res_groupe_id from utilisateurs where res_groupe_id > 0)
)
GROUP BY et.id
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100