4py2fV8/O9furuVxWEJxVmTWKct9wKQWTKpzCwfSnEnhtBPPvchVhzNNxZ3l3fTWZQcog7dpzUV2HaykOF2HISYux8rILC1cIaQ0XPwKwJRBDYLqyezi8MUo3wc/wfUyzFelditrRG8x9Lo7wr8AAXKbL4tGHTEqSmq+lWV5m8uYL25aSEL0VqQnd+3Q8lo0AEzGqGDsEQbHCz5HNSmDdd4l5SL6FgU6XKdF/GDa1PtNVO9asR8Iuuwn8uiX9oue1WTi+vHwfXWb2IfCRnFnZUViw9bTGmZ+aegiRpc9VVmVqRQueVHNGf6SCKhI7+25K8gkFOZoLq5XE9wvrYrv1cgeA+yaK/fD4ACr8XvIxF9nP/5wHvP9g2kVnquOQTC2alpcA7BOiC9fCjH2ohMcTGMdR0hPd8uiUrPjD1HV73ycaAUdqzMkzSbxMAbEw1MehiP1ZJ0GCIcM0RodiqF7eWLmPIIbmmBW64kC5dadim6w8JJP5haxfY5shpY+jtD9LzqKZm0GSNl7Q8Y0Ma5Jr1mcsos4VZ0+kq/cAIOlVNKV2FuZn3FmxBM2RoKVO5y1sQD7V7Gcbc4P0IjEJdtm++VDqIPxQiX91vN6i71GwzUr4YAPIbsXhQZgSajVN94aHe8erFOHouee8m1VbrpT+ifdebHNT1Ny1uj8a3sYFlXFNQ54UJxrRI2yg4JVAwy0hW7iWYIs1VhAdxiI1PSkqnQ5RBC6jfOorO3FOqobiKTcVzQt9NtNPBoPjUtgvXYdMNZicZTlgxa0blFmJx9yQK3AlHWrfZvQq8pxznXgpCDKFsusy1K7lJlIK73EaBSlggCKz7FbqR8+dcNjWaZ7kogpuDKfexZo//BAygzLnRnD48fAueRn2CkKGUmuXB9IaF52WahH4L1P5SVaMxDfdnidpLi3i0rDIdmg5UXdArKKN5QnoIKv8CyH+vTN+5e9ZRskX40ZLK0g3jAKygirSX+zsOaTtfUwNTSFD+Sh8lI6PcEUQaCCprsKvAqQzq2Bsiic+KdLBwE2UXhaWT0c3RkqpvgfVXt65lkr695WZC8b+EGVuSz35iVTdzJdcwmJjb5GpGCxH+PKQ9Dpc3oHwrP4/DeZWAi1PqmOdbNQAFVtOvSFQe8fuWbBz6wcc7nTNAauyMuSC4xg0a30E1sOqzs6ko8Wx30OZLrDfmAwCXLwZgOsB40nnqKBp6KonVvks3Vvni782i8eB9iATmvUJauZ3Sp0hk1xwRysfRyudLOWyqvhqAuPbaLgj8qQL+MwInktGXG31thwcTVaKIBEMzfSHOI+FeopJFMBCufUz8d9hh0XbupNaD4kxCIQF4DyBXUl7QhB0KteF7tGYkInB/Sa5LWCXCucDnRcVWg=
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 et.bottin = 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
LIMIT 100