uJ0i6VMdTNWNtJLjQCnhFwRBGjtGx/zYiaVjB+lgYKhWcu7Of8av8q/LjPFUgQQLu6OoVNtguarsavwxHXJ6Ij4Em6p8Iwnl0WnDTU/CY3ueQ8Fm1wxnhkRcO2nfgAxkw1NdLHY9z7pw+MQx2fzDyQg3JuOdELPj0lL1zUHKkPJC8W2Upg+3Cjd6rcxCSndjFMHJYXrNZUcEPDfG//C7sCMC8XO/wmKIDEbShSy7i/TQQp4BBcX+OXiNcQpk9BKj+obA9VnyAD2x12QrGsyu0/39/67DlfSJRgWkrfQixgBDB+7P9F4P0SngYHmd7RBfcQgPVex8A6+BukvrO6EY4jZ/ucZYAg2bMSm6ZjAPE1k+RGp57EDDMrEvYL+xRB8Ot3Ie9fgImhQgkoJ7JBLnSw6QzidLKgL547iQe+3aE34k0c27rddCXKUozLPLFanmW/V1HBWy8MgIzvyZvX3O1IT9HGtEAGJ7Zifylsuphvsu/I+IzY2hwrClFRGQTmtxSEJPqxi6NQrldP61ezeMgA8MN3hrZbe2kItMoCYILl8I6tZzYTZxKRwu9+zArmcSEUqpxTdvLL/xAicFb/A6ob7xfH86dz8bhohxQgN5n5XcW9C7NY2eGNGIcyvoidHhaARDkeXSAJsYjMFtGbFNWMjxn7PI9zrCWzF0sFmJVzRhnrLVzuMSjKjBUxn9DHjsqTHoZQjaO6FmICxwgmKdEdGK5u7hf/XGZOzUFd+F4i6xZDpTFD/KUCfp3eMIDVDuQWzsRF+IGfsMKnb092VEEv9vKUJbA2OFXe1Sq7pnUFVrbMwyDZY23aR1tX5ToFDSAPNQ7MNF1XVUOBbY8n9p4LRzMUufHW0rIvtu2F+XYU0jZoDbnyEMmHLA78Sze0NL/q3+AFsJIC4KBk7gEi7zLESh9r1merce/c6EIuhDIUaxwdIBh1HOrWoYq7/ooCmx2sgemR/8qQZ9a+7Jx8uq45loZu5v+o6pG1Ep9ZGvs5FHgB6uXbhgmEBVLrsTFM8iLuX+oagd88tQQ0csLXY/hNTKOPwmS29ndZidm6Zp+L5m1H+XBnd2g8z4onoQ+ksxj0YSNne6OCtHBSiFiQewdrZA11390NXLWJhoCdQ9gxHiHcbehPxJuM3MoYNoyvhNSifYqsN3Vzb4tnNrBU4SoYxV/oWVmCFIigWQe6zj9lwlp6ymTmrqu/SrWs/kY65anKAfpymSRjixSa5C1CDcKxEV7Z0TO5Us/pHWrF2MJxsh0etU80N5S54IA8I2Cfxs0ulbm3ecw6vzU+uvxr0wQalAKCFE+Ii/qLeHYl9z/SQ+fn3OUlmpfOBZLx2QXWEmfseTW0aNFVBKpebSPeSG0yP7tI5jjzzn+ybDjfU=
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