YmOuQiRoMFsVXMhx024qaFKm6g7E+FGgGHTv/MvBHhrphoPoZJFzvMpgpN8d7vsA+kKBqFWThYzCTJ29gos39km0yiX30h8D+qsaWF8wmDmYlHDTBg1segzzl1hj/bxtn+KhqliSN3gMZI4wvd2CUnTzEus45QGT2rpFtQD/MdWP7Yg+KVgwuL0lvAhQrG0AL6kxJcS9b0ZD4wh+ntQWrhvwiF/oIuvkqMMYtFC4PhFa0igtYsXxJWEuUnD/8SpkZV4FbyAeFmlSlIoTEUi1m6qXQVioO63dRzr0h+rdEsVs5nXelaHtB7SHMRqs1cJbJ4Xtd1J97XHThIDiOJlkzl+5+h7f9W9a9siu9uHjFWpzsHX3rK/0KePVOd+ISgobgVrX15KzZKYkfRz4R4YwAUC9zGsPlhtJy0QXRq3I9vbG6RjfcgxedTfBsauYTT1vk5puwomjMc+TV2AItArkF/LFUGXxSS526ModOnZrN3BcI3K8eCAsql/HJwy5+WEWobVAPTYZYC9btcbN6ni9CgWoKIjIDy8t0+i7lF9JHGv2x5CPHP9vq3R+QHVzSUemhg2JBzEsq8YTSeWqJZuhBRqzn+kenZwQtVb0x4fxkXmnMVdazUxuCTW9J+IDaWhrWvdETYiYGPtRCCTQM3vrd4l/xdZ8QB7xrCveRhuoGdJS/NQUNJihKrRHEXOzsqXfkX0ETCVYuHdJs5qcNDf9tyw7rFjdChifoFhODKkKNh0EeeIu1VmA1gEj8uCu7yaqKrPPrYYhMSw6MzIPrNEMTaP8fx4R8XtuH9g9O3D1GAMCBwKFgLPmpeI/mnIiFsHV2syOXrLN8Loo6yiUZ69QYhpJb5TilSyw6zyyTwXRnzVdhHenjv/j+rdpoU/9dvpVL8oMdAah2tTQxqRWnnBRur0O5or+aR5/Ny6WMYTW3lC5g5N4He9vWpbjqliiSRrUuR0gntIbpeL6AJmTSWx43rVWsA5NtDQ0zhHFxNL/xWPS1vB1gOXJDeRes6T01AZ46Iy71NvUIjGN+xgkeYfjipIsg+gOh6evo4CjiCVrLQjQrnBD9rHuVOBwiqYwcGrVY7y+2Gnk6OxVQGPwEb+6Dz5nnpxiWLA61Ww1uYDaSpbAMo9HCR2HxZXfRwcVMtoRn+eLQPQYun1LFptyA9DaDq0C7CMG1dUKPdXtRaTHRWFvleOUJlmu/GwnDKaexzqVl3O9Ll4xa2yCDhJ1Bjf0DifPyh1WaI5NUp1QRzYHu/cl6Wy4TkqldcWHR4z89/jRgjkidP57iUgOZqkMsXpW6byShdmeWTjENJhUkUUjFin/4Zg7SKnvDYaxZ/bge0T0z0kgagMdMYg9oVDzfudVJE6QaIC9xgCQqHo/0eY=
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