KgOnDZR/+L79Lhm3ecHgPONTPZ/7UR+SVUYIUYjDBh8Lj7D3IqLg0YXXnYPsFdWndEsuy2fTcd8QIv2+IRj3C9t8xaR/ZIAjAHeH7RbyB0MW1/h52zqd/tIbJldQakxdyKbD9TIJoQ/Z+956jVeUg+UkEfbpu0yvjvpZ9e0xgRLMKzGDuckR+6dSOENfi0dLVGTNl7eH+tI44xp0Kd115xvXNVl86abTTgblGgvlhbqCdqEWCE2x8daKc3ZETo3f5Hdt7i1QsFIPzhQ65NyKAF/oG/bzCdfZYQpLB00KXV6yVPjBZEuHx60//j/qocg9uGj/chcplnUASvwz9vE9nJBJ5Go644oHMkJeNxRmU4unaCerXK+2FRvny70J28X2Wm5jNgTRlCTxaZtGrS/6ne/r+zH/CPBti8L6QrqwUeqfjFZ3iibm2v0IbjuwCba4dglN1vco/0IIrub8oiXkhELAFY+/uM90LtderqGaYTzyHy3FcdrbAvXrg4OXVE5QWxjwb1VObJCasAkpMzV0O/LSKD4q1VkpltYriF6xP7+CIFhUFOEng6OQ0d1P7hcUACD6tCjodY6EpHOlgEGhsWfg87uGmN8yMgRcb22SsZY4BsDSD2tQvheHJML2u+3lEqA1rmhQ7TinN/d6vkQa6VkvhMIFI738YRDbTw+yBsaIxgr+lzJmaA+QexW2rjCO+DF6ALwKHvRZ/yeOipB1j5WPGybUErHA27p5qs9D/1qjJNCxG2oB/QD/hFoH9jcFzs8AjeV++XAWKbfTAUgqy6JGBF/X3RdVYqfypFM5WDATHWSXtJSiIBb34aosVHYbzMB5M/NAxKHuv4szF5IjYKrbJmfBploIqTeLGTUlv/uOu1puysx0x3pSb5X+wuSbIrxuXGlGvlevwGFVwR3dEUEmtuN/FtfWy0UJLAITRH6oatO87ly+f7G7kcn/q5nmgO5dPsPHPaocscjCRSg+P7cJNc8LO4BdKju3EQ9klhJ+a2qEbDj+ShTVvKbsl9dCa60rSXg+r3jvBQaoEYtsnG/WLqkaD82JfGG6/KNZ0f4Bw4qSQ1Yy9vFcnJT6/d8iMcQpWerffQikbEXiRFMXOCAQOdxZD4CtKuxiJ5JsijQIPR6cxigbuB1Jusnap1PFwH5ojYEX2g3wIP58Ifhfo9xDwD9KHdw13gGmL24RUOmoGQVkgSwm1wb+MzHzydRXQwWCj1wX6NvlWcHVlB5NWrrcZIy2Ng05XlGPVW8YJUkiC2E2yusfxr/5TJLiv31//MDsMjOu7BedDOMAny+/LHOc6IXXfBVN2XAyh51Qequ0b33K0gol2bi4nnd/XNTxRHB3EmiEnm49H34XNawjS27rrpQ3E1zT1l3ewsM=
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