OYwTDG5I810U3l/PhVFljPBrszEgkB3UJjQHM6AeERp9j8HyQlBsSA2dDOEqmu8yFiF+lVRk5U1TNqBtYyGeKXnz30IqVULT0yVSFLq65YNSF3MMa6VIsQr3dCztLxRc4lxrxEsfYJwWjaWkPPNwl9EdaJQdzdeEEHAGEzMWHzYyCsw+HEA3TBc9v5rUS4whYhTYUQDbac149kNDLNOgGd78Zrpxlzd1LlhX4635gEM/jBFCYmjIdh8MqK6Q8Jo2oLJYR5Shk25V6+AWjVYxFIFFyTuF2UhxSzYBrZjRNn+XScBPGmyhPlEs/fFWYToME4Zhyx+x+GQaA4JHC4CWNGpb58fM3Zb1f8nHgA0HPkErKIk4/mtLjkIR6CsfIrgT0Eq8fr5vQ9oVDcVjczVqtWOTf+8cTMjA+ZR3MV8XCiw+WgKaEQEfnVpWMBxPMpZFImeQFdNAxgOC58QjowUX97wwb785QRtTJfe+TcXPJUw5yQiP/Zm4GHCU7C6U+cLUoHJ4yHkAYsqfwPQUbqJynHnbwPlrmLkqhE46j4EclxD2Xyd+l14MwfrEj2XvUkv7K6x755VeYm81dXWse/AmqFN2k5A6/tGPeiyEKZ3edHUe1KqnVMk7kZX3JHJlnMYjm/TGaY+Zaf/aPQIOzLuFGiXbYox3lyIjbwqJVt455WGbNYdnnTD1Hz6itXrKV3U7ysarLe8yrChWnHuTb7/hNPBV47s+DST66xX6dKvv8sKtN0HS4racYUwIlVp1qWnYfYWQXG/1lt0IONRW2emZghy2NJ72qTu1ne7cslowonOKk1vMjwsxk9AWbJmSRp887cJno1svVHsUfNE7pOlZ6mf+DomORIfrNWUywuo71c9VCsPNOsCRwkPGchZ7PY2e3t9M9+Z2/k5IFAvZX4VT1jh9um0VVPqAqdlt1GQAUdSX9oSlqnfW9oCksnDsbQgOYh/3Kuv5J0GBcdj3yDuQ/IxH4Le3FttHe0tnz9kWMynYX+wfkSu1EcuI3g7wtdQwU2/4vY8tKmy8qMKsJmZBtbqYatob2hifTVzRRDBN2jHj2XEOOBJIpqE0u2CCU7QbeHw6hn41Fpml5FQzpCs0At8gKCf3uhlKq0m5oUKXSHI+bibmDpTFyxVeLyISidPY+fKzsm4yS5XPOqvGIY2UQ40BqazCpa6xnMxfk+vVnSsWM1KSTVEWbXpR/eo+ebg30u51z/4KXjodZxMqs4zng1CKJRhwJNQyAK20c0gpnIgqGXpaSSuDBtqKXat4kvojwL4/rFohX9vgGntGBFO5Br5DYwgDDrC61LeRdXs49BWYLBKLsY4mojgZmO0wiS1gIstZssrdLEmjnDiWwhEQ2LOWkqszWcPX8j7vKfoNX4t8qRS4goJIjQPMeoTMPJmJTKvyNFS5wUDUFs+a4stYNzkq5Zbvh5T2+3SZ0KNhNYoEkCgFBVHXZMLlp14wg/qgFW2VEmQv8W3HSHL4VE7NNfLO7LWSbk9Dh+Rx92ydbCGSRLFzndcWj43Wh6OWNskGO1I4EsJOWm4RQmdeJSMiYJGOMyzislin+CpR7i6o4bAJdAisg06DdjYIMxRv1oeGppmq98BHYZihzUE7S/rCEuFqpAMbXZt0oQA7bamBpdOrcrEEpwT0bRDrqzzeChAzMxP5cZUsvdY3Hf5/QdgmvGT88JwoXfni1L5JJh6vQEnQ9QkQ75xWbwCAVaI=
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