9bYgzS0lxCn52whxvwggbEQDnvxTo3rvRFhzFWDfhIMsCaIzg4JobvdSdncP8T2XSnqVNHdhv6LnLXmOLw4vkusU5y4uio4R/FW+BEd2NETZTxVBmfdEaeWUApPvKLW9Aloqa+PkXT11sCfoaY4OHTtqKRAyyRNowzyiWfQgWgMqJBbbMP3TLK64X3kjDJTznf5E/Wnfk2LUaDKauDS4vIZF3aWUrJo/auAoU1A7l+MFiWQbdU0vaJHEaic3LTwJlW2Je6UG5Ox5ee6qqPifrLLIlVgrOpeffHNNMw45W3aESWptwAIoQH7CHAcLaZvVN9qgxG5Zx6aeiggKbfbv0c66C+z26jRT/t7RR91/t4NkHymU9q6ACr3Ex1ttbi2KMepR0w7+iBcQ0v37ilLjf8yTA5gB2+Kl5t8RB86o/wooVnGMkDetorcgjdqD8nU2jxiEV9ETGLudNEdr2GM5ZbXvrQAi6yeK2KKrVpM4qxbDxtLxaWECT58iC9M00QGs9ZAHRGNLTelRNDo+0+YL5qUt/ohm8xtV/LAAVENEd0ZelQ9RfjFZXku1DpkQGQIwYuyurlhw7io3zNI06f65kxHs2jlQVhujBj/21XarF5SiJpFYMZh8G5jT+xH9vMjBKHj0La5PgGtkE9Z8G6IlblcqUHgm7GflJI5kdslbl67C74bxQNT0oRG7W+aNxWisol2Y/9TBNkpgdpSVOOU1jaxpS1MxbtW/sMr8AiqDEClOAZwEjTZ6DI87P0AzgeH5C0oHZj/8KMj7eJr9mNCvnRkPANvpfT9/K3fW/ITHQ7gVBrxrlm/XIA9vNEi5VNkFcI48qAH8c/OQU2ufodnF/N0gEn2uBPQaksc1zsWaO+WcilMNO1/ONv52HshNpY6jmy/g0VYVATLfWH1VPUCbdc7StowQbQD5JsKlE3eTV6Q33d0LE90jEVYkJ2I/YAT/8lwp5pTT9xhywzHNQz8/BACvqZ7hB2/2jGMlQl1V9xji1YSgvxfxZxF4JRS7BbNHhzNZtTwPHyBdp2Bs9EliQzVJFgy7yL8QcnEDT30qX6e9uy2IKuAwxHEnVtdO2dAPqswoRHs/1s4JpS0nkaGnkBqrdyBRklmB33b28UbcIPbCp+kseUeUyZLv2TLwsljAqmsEi8WRSq/QHpyZimKpr1LXoI/GVYnqJq0EN34axVIV90nH8vFxVXQVKom8nB0fn86B4a4t9I6E7P32D3Wv6GpCV1E3GS0KTX/NXl1a0a7iLtPAgJ3gOHM3PfdN9YEF8xApLXyK8UqTxC1lVolLgs3rNIvuFAtA4nOmOePl5FSGv0Cdw0HzHIwpmqnDyXhNQy6kru2H1Wk7leiKJGLj0oSyoVuUH9PTSQhui6Y=
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