AbbczeagA1/bOQfGDp9m5r+YofaUCOQYE+OWeIRuA+X88pevsIphrEbVlPhkZPKHdhTSplZPAHa55wSp2u+pCXAowRxCkloz5p+fiSX5dOhxZmUfG8lFH00w+DgLu7tN0g7hiBYzaYRqhNVLLbNuTnCwR/pBiWlqx88b/PBA+KpZo/Pbc+hGNWV+bzod630m36xrxYKlx2Gh4wLHv9u/TBaahxFccYrJ4WEQ4h5pirElwKXQCSCWVu/CRMjAI3h+OgfFuQTV9TbQt/OlW+0+KF3XXXnQUt47JwuYWBJaDEBnRP9MPue2ePMwGHjohGn62K5hf206Oz+Bz2hsP5fDosaMcEazz7cKkPJJe/pY3s6Zqx9UldF5cGRSulC6dK+7jMyu7JSj7cuPrjT/T+c4XBUmhzcuoi0bwWoKIAFRA6PGtS89UYME5S3T37v73ED2+q1tjeN6GgbGyH7Iil12GFHmonHsg8nngXUP6FfZ+6HvaJg8WLyROembIZS+VZA+rXx9e+A3eqWeJ74baAVdi0yXMAhblD1dkeMQi1Jqd5XBSkPe56vVGI+I2PDI+aAqUz6kYxhMg8sxGrcXwdhl4xtyw+rvD9OqQuTAMwbS6q3fEg11406/yrsnFQl54rMcu/9uDv+4uVvtS2UhKkxKWBGlU47/fEStwfAvS/f6ih1as9Xk4+EA0B4tTkD4c9OA15fHWle0OmoHwlaeD86mUaABlpHYyZg0D2X/H9Z/HU1WpnoDtGzypltZQ5yGJ/zE5uO2EZUmss91YTjeNRSM/eP6yemizKiDe0Ed9g+QbIXToqW1OScWniMw8EbhCewKDfuW2F/W4hoM5N+XWQOkzDCSwkXX5BHGAW07OoBSGHbHB/6r5wuaQXHMEQssNVSVBfQX6hgxqRaaXX/X1enx7PzTVr373LoFFJsT90OZ3JTrrn5LmdzTW0Uo02IpAzHizymEoY37qyERjJ5G8F4V0bs1O7iwGMuEna3+2nhPJLxNYub4wO3hieX3hO+0b2UTyja3Tq0EA+0abDrg5924Fg/46wqxm2XkCXrpmsVqkQ8Klbk7WjRlWdkTJrjoKmcOoy6CFYUL0xZKwdXVi86ei8E5iiPR/IEHPkBFrLk/JzAsBvFGNYKTm+GhJCZ1TIciDvOV5XghcE/AQAwECAo3I0hPfAodCVoThvEaF1FxR+P3MOfw4iamtv/y4byDsoVIf7sqkqtBi2vuDo01gTmqp1/wzZ+1tgTqzZZRQa8fcnpLl9cybdMayQWPuDvXzyK4BktCHpOh/jUzFEL43K8jAef5okG7w0cmcFhKlaudVBM855zzUOj4Dv/jI70+6DwVHRc3JvfRJDQ9R8OWmMdQT2GQI8Ed+WR+8T7i/rM=
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