6akFVdMPpqBVAfCrZe4nMzEB/5iqbPr3CSezYUvQjRplfKdcy5ZzJniGeSP6hnZyab8Bf+hS7ht1c0nfGka3RAr89ACmeB+P2G7JWrMPCvIx9gvSqH0EQAus4ELAfDXxR6dcmTGZ/rBQS8SSNxzbbyOdHcpXmXyucM1z1sfvWeF9mUatw9lBKdcFFxK8nx3+AZL30fj8rL7E9837S6yaLhqQcpQyDvqz7WVrBFyzqz2SFU0M2EXUE5F9TWtOHgYBdHKd5A8fYOX6yei6BxJduCuHj8OE34IaFiNfk8jzqpxN5+G9pSD2lPortjW1vE7lSNBQ68LEXeI+gU04+6a0SCWd59KympT11Ea7uBkHsql40OX5aMZdlzmj+VCzN71G33iTh4flMLs6SCT72GT5UVSZJblb2xcliehE8tn+9KNqOTj0Crr5zva0Bi00tsL2gzFA165CpS1DdXuxsvY8aRPKoDqTRgEIbcTx1pOHN3W3WrOfSKcprTj6u2DkvhoprAlbHM/Ozou0JBzmdu5QarQkPh/etLjQsS7q4YQyVOK7sgUQJOwuaJn3Bdjp1neQTESW0jwYHXh7E7vMK+N+713CadCYUx9+731ayLjizSqS90APLcZwB35R8wXhVHZHWcH61g9E9t9LiTD6ycuhnQ3c0ktul8CKqkRCNZ8fDZe8HTwIJGBC7XVWeyz4uRTd2QC90ddgGdsBMdZr6aSNvCdvjUG9/oDUWXxmNhS2Enby30dpY7xGN89gZPKFP0jKCW9/ON8fyzfhtRoOUIkDQFIUgArm5aVjf2/I+pwYs7a76qvJa+J01HcSS6/9tq2CU83sERv7h5yF+d1kph1YchjBzP+xwM5tuuQPm6y/GjiJArQpW9LZGn9qlTOihco1OSSHW0ubkZskiLsQeJctJRY0Kle6/wiJqX0eKVIM8VykawqVtaoveFzXEjAvPtlscR9nb3accjTgKDFdXgpdQxs59Yj1T8vb8SQKjiQfKZbFSDb8U67BUG7G+xbHq1nNeImdq1kv31Q2UfjgTue8x7KK/JTChdwkbJL6BD7Oh3hJWUPo9ROSkHCialhN+06gCcIzV5JRbLLrzxOTnnApJ4KBWYh1BKMhGRJOtP+oalyWCEd7hQmf/AEH2wOLjLAJ5vZOqsSQq4YzVeEyzu0f8zLdszyuS2Std1jy2oCP/Dj26uoNkT8wkYi+xXglvmE3bDoZx4thVqCBzvhrbHemdYwqmo64bQ7H/qtzti02eXSrLa8one2yMzvSRfHkipqMGrqOLbSm173XWK9O1E7CTtDgYqeT9pvmblOlUnYbVk79k3ud7rNGlhCkltK6J05Gq+qROEehtpa021Sq302ZOpVk/JEZqzPGXSBMuHA=
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