Uz6uG6lnJrkgoMs+835iV4AbT4nlfo9k5n3FfW+npEa+Ft0eR/0pTukbjYGinL1ss/J6FX5uW201piEDhdD31c7KwM58Hex9iUIfRqFlBlw+C4gne7bbGLI9oz4xcs+dJAOEsSqgUCvl6VlOwgVF8NtRq4v6syFlFIwrM8GlmDsmrH82ZdX8taK2Jmgzs3QCnPFNrXTs+4RvtdauQHEmwptt2SoHbGeJZAkfUtebT1wjQ6Q+zLAiFLMx+CF4sSVxvmD7mn3F6eGH2D624qMVoQcl6v09fpC/PV9fjfxNtwmC69Ws3vIT9wlCbai7OqutVnMfKADbSvbAgknnLTXWxV4gsDSJ1tPLxrDG0Dd9nXhbp6/4qYFPpWiQPtm6eXvBxOPupBcFZGswwmJZpDy6hV24x4lslC1iQlrcqKFlbVei2sAArELzVvEdem0kDuhLp3lNrLRKbUY9M9mxCehGEvq5n7VHYwJqTDESdl9NPfaY4+9VkSv4bndko01umBDEel7+vuU7QcuO40TdHJxA/ULi1cK99248Mvj4LUHWZZ25QwkECRn6MJvtpCdcq6UfxVoIfTLx+hgenJTqSLOYFDp7CrSrxR1L7Mc3kJ6hugxXPib6d0fCIKd453dZEpe59hz59LHf0gKgUXRG6cOKY8qy0dlBRiyHtYtAy6ant8rVUwJOos4xUXvEGwuH3v4TtMoAdYRj9MkAY0ts99DGuzBZMgzFnH99IznbMwMRPOeJgc80lyFdXmcodo1UJisByvycUt4u1gSWtPvbeo24NdL/AM6npr1BdYWajVT7iSQ464IUzM2iN34RzfGpI6dK0VjLPwrzj8LZaOL1rypwpk1ZdVY47IabAZXQq3hm0/zaB/j4/Zt15uUQqehKXkBqr6MpmRa7qH7x1T2crtp5ZfmC7SGbWCHezKBO1sa3LE3WTYABp/2zjiLXPUhytRbX/iSH7J4Gq1fiV+zSreQdx3Xa0yDv3J9NTu+RKdk5U9i9jAIctcl0dliGh4diFPT50ZdMfuHBB3ARfaoXDO0BmKfvWXbsRVMHHFUh1WTxc1QTqnCfKHYDCCZ+q/ka3dp/QRWfCvq47pegXV4WN3DylLkatuKZqagqTFBh/ncEv8/Ngr++EN35u1qHIlxzJJDVQRKvY/221j0OSXXetq//7AULY2INBCaluupLIJKx9tpMw76DLIFS9jSu/a5TIFKF7ou0lIOWHmLx42EOWV/hFeW9DxTg4gcqOcA/rtY+7G0wGPwNas/kElF/ecwJmpAFQ0Ko1DNjHhWzjZgycjflFb+1aCH+4bEAoYV5COBu4i+y/7O67lhUCKj0Qscajq2Sx64ycDZCfjM3NogVH8mJ8pL5AZmGGaCYGmuwiM8=
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