ewGOd0sydmEIoaTxJZdURhAOQHk85bXVidAcWv5z7FTwf1nwM8jV5Zb4VMRFfTotxA3sYt2PUmQkI5+CYshVIJMAZDL5FjMXuV0izhapg4y0H+MED9gkOYj/rts5MQsz0MtpFrgkJYLtOT+AiAukySx5udWYGEj8qdLGAeQkJLVMUh4xv6HcswgKAPiOpozeEByS7tykTLQCJfMwqwCmHuRv0an8rVknZCCvY0AhiLi6AFGCtjs8r0u+T7Aig8f/ZhSOUzuZc7efPQOUfCeLZgrL/14IsSLSba1//+w7Grr3MjEVJvcEV4YfDkQ7PO4537/HaMnNoyM9OUnHt4OA6joDYgMJH4mIXjnHQDf+/MDH3+kVsRtFWNPTz/vdsuKHugatq3/Xu7XaI+0KG34OiZmquGiDe5SP9XjMahpLrZHaivB/vkT3/auRYEDL5hXyEen4BvY7oAeVZz+qX/PCbwLrbypYwHFFLwLDCDAu2G2Q1RbExdMMGHjD0sNn2jwiKqCESMnW7BAThV7zhGQr8lIyBip2ozd9iWnHm3Z5CGe3suuKW7M/D3c7vTUwGcUv1OH1muGgamaUGCNT75Dj94tofZptjBKgI61OQxotO2UtbQWjozRjtoKgQgZ0rYDtI6u7AYrmFN4Duknw0akxFMZWC+nXkC3zK+wAq3CKQ1pE7J+S/VSIpBv4EmsQnXCZo4dvyYrqebhVEcFA5MpoqOxJWsdeWMKL2NvfqHjYXJB6331tG26IwkgUKN0Gr/bwYGe2gaewfaKK0v8pw2een2tvKOB1H1csAixWb/VxxamZ1irpEqZcd/eEbtwEcw5on0smlLtcMegahYXvZPV59y/pu5r2p5aKjoBQEYjcaGYiiRX100P+F8M3NA6lSby480Y9EQl1aBc3/qVQWnm3qhsrREbI4thw2xTFo/mLSfJg/zbsF96n5f6KH0hOE86grgbra2HVoBvOMcVtpAH2ZuJaCjC9VtBctA71n2+j8A1PcOH/inQJjHUb5eMrPjPDln1tk7thWML7LaiRLVVsXhmU9HpEOTdTseyvfePJgLy00xqhv0G5jEns7aE0/G+YvgV26eC74UEvMqHudOYCcKSlKhR7FZnu3Brw/UMyGpH1jLsSeXi1L4i4GHK9MaRYtFNjJJ0wQd9sdKqk/UDUzlESPmWr4WbGj5p+HA0jwD5HD5WiLyCAxf002tYq6aEn43SIy2yMf6AenkvTFIWuis0yLT4EV1e0dt1z6xDYtkIO5pmMKXNbuGdU4s8v/8zqlRXBETuQlsaL3AzIqxBVRX7VzuxmOwyiAB3bndgIJsjIoxpngR/PGXDanX08R/tIft/1KIUl+BvcHmxOFRmWttk9zsh62aT/w4qgJeI=
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