ALrLuJ/3Xa7T6b3qiT/+JVczHWSdcn+udBTosAxb3VnfL/msYD/GfAPhB65mLMdcpFhAnpdeDnE+4r9B9taGdamBE587iRvr4CFgTM8I/qb189Z0rd49nRGwNQtaZ9+Tfk2Kj49RmLwDGSvdK5adLbMNLniU0PWBYUZk73RkEie8gpLn/aa73PYHkmMTB8+iPY9+P9r/uzTzipCsYX/eoWSJKj+ulUB2iFMn4Ir2wJT4GyIQ2C5OFv2l+7j31v3fY6/6Z34G/G92a0QUZ7Xj2PeB8kMT/K7jY4O/fp5zopqM7+CoQA9I8WU6R++0wG8mAta36Dm8q1v26oHAoZ5ibKYlzsr5vUrf301vG0FlPiA28NtYg6f8k26oRtg5jbA1JOtn747uqWnDIZA1p7nC1UPrZ5TfcTPt/+f98RD96iFeV337MHWLxbaB3QothQ0oFxewQgOj+Hp5d9+pSLy2TQMjOdHo9tFVcaCuGFMNf67d9QUQ6BTUntZ8ez49y9sQQb9YQX64fLLHmbnKbu74c7D3qJzXV9lo4dzIiBJeQO6BNAhhE3mK3QJdMfjkDBq9nDkWrX71xFGLitXqX426+GtlkTIcVgy0mq4kJdlsbtp9XnZFzqltLj5/NLx+XeH2wzJnZQX9nSAAwQLMrQYWZkpm/EnnmxUnCs6xVcEmupEyISpZMxQgoV8OJEJJp/jKQEu6wsRQxX4Ez/IB4b7TyiNkgZqEiHNBgD4u9hUBFpdkzqDwl1uVmY9XsqA9HRV5/XuES1pNocbuqfb+4RddPX5e5OFm0qrqGaaOtaQKsH60jGXrp3OFVsp8bv5ox3urdFDzcg8a51lJqh88SnV81QTQMliUd2FmK/Uxmj2WyqdoB9a23VQCffR0hPeeqx0ZPegN/X/Aww1JP+H4borcbZosXrUgHmwqTqeOuadEIxCxQ2bbIpgo24FwSEVp7+azVeY3Ykp9MNakB1Df9+96+HZFADBLJ13dSCsFqDlKlZmUs81gwlmA/lkcTccwU0CP1zoYgdCMQRl50DXcEB1h0gsTI05qWWNEnECeUNbVvCy1ZTqfTWCb2gbYvdqwANBQjRX9z3CxD4rxRZi3ymRTdHd+qaXxuY5VdtbeSsS2o9Tx/iUkyFRqRjleWxVX1pb+ObM3D5CFmqxnTJkI2rCmR+9mOi0KAjqgGxoS09Sh1NngneUJEKIycjCotWgSYyed98cIbt0zwu8S6+drpl9Tn5Z3h57hwKmNM90bMKEwJYVf7oqa5YzAuTTdq8XLOMovEXSE93HPhIFxmbc5DnowBnvkt65gqR2ddjNOxaHRTZqNbmDphbZElt1ZAI+z4ROe79p4rewOjiHa4nZ4Rr2XFUkvrgY88IXa7Kr3W/o=
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