/Nlrf07PthnXg692F/dnzG/qv8rzuME9r+eun1/HkBbQP8GuLPFwBZoPeFYb41WILf5a9mKsEfwUpgERZ+dA2cwz8jbeo7H47AXNJ86uNmeNfR/Ep928Ejb0/dEmrrVN658jG21rVyjnx9FR7XovpON+1cIbzo2ZAPSOaHuASleAY2uTVTweFcd16NWp5+uWtn8MlPx/uNmYhBIZZjVzpxItETj2Rbeef4UyLBeM0ivQvGSRGbDkrnlvipWqH9MBp6+SGgDMWQTuohL7tUlhvWa4zonRjLw4sX+glLKiwyAWIJfNUMXxxMyjhAeGz8UgB3pK+XvCGFvQv7bc48ryQ09fDt39bPBL1oB6ePi+Z2Jhe5Fw/7PdiNLZZX6wKFgLYiS3XQqvKl1qkXTI2Xe2qm1Hb51+QvWH8D/K5t1qr5BoV5ONDLa08y29+AnVctNJEydoq8Wy7qWaHjUltxaIZtRDo9/O6WH0ceIPqp01/S0kqlEEDjsNP3P3Kle5eY0i8KDuIE+VWpbICcUzymEYJRb05YX6HJ5t8xqFvAM2NiNRBRjOBn4v2TadNv3x67JSAtWaNWAmr4ZZOqLgbWTAWD1/PsobRpoGLXjzz0xONc1CqgqarmHeJk7sRdMbKgHrX0DkJFaRhz/MKoyN5v/8po6DJ2cMTQ/bDUdOlNX0U8TgUUi9qZkH1VRy9pPWqxJu0eXixZmOUehP+knTa20OupB6BNMNRV87zvZF0lGPCfG/19x94d6ekw0eTq2BzIELkDx/a75xS1H+pyY7xqNJUPgr3Wk4LNKf7yL4SKyD0T51NKvRF/FIgEY9zWA7jQE2wBq3eieWea6M/IJORLaGLv08y4uj6dBc71CA8RFrTHN509hDEVF36CVCqv52wsJRYbtT9/y9UfxJ8iMk3twnfWo2xGil78AWMB0FCUMEAiiwODG9xAbopAELLiLh+PgLsH8yS0Cx4XAkeHAn1/5O9B3iWUMwkCcQEmWujqnOQ72v5B4w2WLS6nonRpZ7WGlf9DQ4KHH80Hi+h21Eu+JBtzftDXl585SrL7zi2q3JCx/Rg4he/LCw8psAtZ/DeJMMLrvSGCJUYUpujxIIn8beNTauhHNgbBgOn7judV62Ews9vV/MiVbEH5d0iOaDCK8t1DU8atHylehyfXnH27ojsHeTDsFs+lciBVCuRFsf8lTTPndcC6+vFjlih8ILxP4MygjmL42Er8MBvuTU12ElAmjvsHbcMxQ0TP3VdeTjyOC+mDSvTSbReMSskEAsTiCohYMR/03K5ec/nRSr66KepSLyhHt3M+IeAAHqm0SEYC0BgeQX1OXr9HZ+L8a9wUKzmisHitXZEBeeC95JzDVlWjsJ7RFIgetoVLQsLT8=
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