uGDJt2+faFXKVCCUd4bdedIfI/5ETiLCfzVQKMIjRl2oDDWLt6z+c/9ryl6aEs5D8T76M4X0e3B/Dvu2Fe4f5XDx5iNeOLDrqafyK3+xYdxxzsSXcCTt7fbxjTez15xUM03AS4ZGNc8U8H2q8MHSr61wjku5Oa7guxgeLj1gwEV6jZLOWUXWp3ZF5/lq5aLWgRKWh5QJqT0dWfN+VHI5MLDk8HzoT+DRftXJEA5VSGEfPJpLqbj/RkPQFXAHtUQgwR08RBYr+ZYNcVONbnPD60b9BGGxb/E5TAf8cc4QuLF3Tq3cbkGPHjcvFlTRenvhStgjQLolknY/Zm+rJDnzS1SG4xzMKA5ZJQOCF+z4Go3KY6LNzrpkPsnknmcFRdGdPrgGrjoRenKSBrwlxYk/4pZfyU4eGYkGOl2LHEGBftC16T6n2ds4QtyCamMxJHHITa0kHe1HxrZ5NNiSGrgknVX7mv/fCy5LtjJYR8fVz7MSQhofUqDjBXG+zoI0eS77SANEd5cp6224F57rozhTonViEoYgM+BxVxruFhFX00hWTWdj+fHJ4+bUOEHKYzVWGdCUU5HwneoXdJRDee5mCOYBLYy0gE+1LKgv5wVM7j4PNMu3UYZbplkT/wFyUff67LHrusRy5mUOrmcXjx7cnuQHKxnpIX8apnrTgzy7X5Inhy/E7sxL5hKF5IwgKmEXkHCIQDi/tkjI8GuFB2ftVKZL2I5leeGkWCHtzh4j7Tdv27JeAvr0e9keZxIIVk6q9aPBl13EacUbL+zynEbaLWjqgQ9L+ViZuuhDMzAvTVaLPedS2vSWDNJiTiYbFfKP5dKuD5DwNR9FgeQ4T+McRia/sv4Zdeqs9J+MqB7HYGe4uKDw+wD6NuErA9I02ZjxrP9kIrBKgwhgsmRjHFchl1ZtzsSAXJfSAL5GpUtoMKIdvZHQfLlf8cEZp1oRW5zFJQqboMmV6JnfJg4x65micUSqOV3OMCHrNswQoOsnSQN11BmVtzB8noaPU2jR5xxWp5KXchwWVr16p5d+ci4rTiQQV1UWppCDAZmmFANXMfNX9dmueSdepj7JADd8HRtQ5fYlmKsxMLU7Vs7p/XpApXuAYfNG++CX0FcrL8ZtnHm44mrUUz2pV3ZTKVH1YPRLejCzzYGJKKlfSFaejirXkbcsw/HiQUX6d9El8L5hPvBVQY8KpBGzCHaFa6d/zSPeVTIKkncb45G1/vGt0mPjcKqN4GUNOumRNZgG15M7M56uU4UGjVEBo2Ww7vKymRfXfx9tu242GbZ3V5F6h7/bmBixYXe0BfgM/TbQyuX6kK4gSaPT1EA7cFDq923F6FvCVokdQsHNgelFKyeHiB8TWjjG+R+QP3o/yNJCsog=
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