PYCQvgnRBr9ibnbMLbIK5vo59EgllstW4uu85ZC4o986XVtw0f3fI3c0pmDh8BidYg3AKG5IH5Mhon8d+JaBu0KjoqEfDfV1KHxIeecOV3wV3+5fErV5e4bY9DDXHGAl0mboNUZmYDDz2lFXDI7yLtNgUO52JWLILTpAK4ZoaSAgIskn0Bnoa8bYT1EBgqwxhM+fHyaWNmLH7XDueWloHkJtJHJ+ln4uWnitu8cTpPgQe5Q58ngi73q3eH6y21p0T6WITkzWVj+JtmIOqLiB4WyKTYz2w6W3gzDbIEHxDy9pB7TLwx7BY1Fqqv/Vrn+0xME3nUPrN7wjQAjlC5hivO4/8H01ThJ8u5FU/KPhEBKJ2WmCdkMBqZl4f+aAoP8s1h4Jd28ZX6iFwYUzZsIYQydgc3VlBRwkc+W3whs4JPzjR/K6/PlV6Pzytv/yvyfkTbv0ZF1aPyMcYiV12boyaftMmUU22To5+mo6Kure5cgzCYcVPwW/YVgUOkwxGhsqk7D7xMXXSK3SWQjCPIC1EugM6+klkanz3qSGoBwX712+UHoIvbcK/P3OYV6igdR0rAnsxqjMsPUXrXuDGZE1E2Xfj+rUcRoU1iQ+ymIXGn4CEBbfEFF1UpYqG+XNTYjHLh9lnTGu5tf+D9NeAQ/1D3H943+5HWvfapFlpybN2HJ7LlvooVbUyNjXf6FSEKvRZj55ATm5Op7+sl4y7yz3dgHfmMrSeAZDV7PUQ1bzao3vIa1B3BvrbCy2tEnWTu7OS+KFV8V+w2ojtJ231j/3ZEVhXrJMaYaJyFj3d9tAaEPAhEUFSbRNv0qlMEyblu6yWehcNY+mjAAxSUEojsNEQYbaI1Y0bQqGzLi7ndMrRgpnbdSK4YFrA55HUGBayoqFMMfHzlho7M3yj+8qKTCoMxNXAakJgouwr7GbcWT1oY1vb5/gqgPSLOXeQLAFwpq8/RIlSs4uzvd882Xj3x5/Kxgrt1nb2PGc0XjT+mWpzjbsZJwsqXVdKPFef002XMOTKswMjjkd1aUizQU+DIhh9HfRnhSACnj+b/Eo5s0lYGkMblqo7vVy5ha4z2rCmTgg8uwkZtU3gmCMMitqqcgX7lVM+hhWGfK1ztpB3ojRmG0/4MGoTVt+qYyCAMFx9NhLFwG4h+0V3H5jQTLjS7HQNAJqX6r1l8PN1Uvopw8PlLUiwqhSYq4hNSpA2Q9sFH1OvclYLVKJ1FB/m+F+9pNYDX8K9XmlWitTRlNRd31hBG83umu3S2q1PiAvCcWAZAyiRrqieVUmSm2Vk1mXlsPyrNXQbpvz1rBV3Uq58aXAVf8LmonAUqq6Nn9Wk7h0E93BoPG/hGF7NP35nshyWlPT5UPtaxipbKlNkd/U+WY=
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