PiRXfBRzgSPSzMNwE2evAZ5lSo9PWAYnS9SMWdunl/aSOWyEnc8hMP2iCqkEOw8TPgtmcXyuyNDZjHKOSh5vMklQNw/5RaDPiquPOaC6W4soP9lM4luOcVLS1jxmgme/g2fCVfgEgMQ6BCx8ZAokFeyoIO6CCDYaNdL33xJRfFMh4ndlnL7mbgfAFkXZ7xG702gUubtvD0QsDF22k7/aPAADshk/dmsnQHpEJ8tOeFNeu6HlRqMtFNWkMmclTts1vArZrGPC6evbPGHDwhQJWkFba1vFifXEbtJ41h8BRUoqFEP6Hhv9Cv0JzqIzJVnzewcRHqNl2j8ssx/KiKF5feokdhjw/c//AvSO1zFc0tz4ku+XjPU9KCka+oyjTgYQMCcy8A5Qteb6wAu4ITsVacBfVauBWJO/RjjG9p5o72aIcuk8DLqc4YdWr/ygH6/xmN0FbhmrkFxSpeVoF5bhcfO+WJSDibzY66Mh4Tvnx1hHVtjbNhjaDkJp2T++gNiIivah6E7OfilXzBe6IiKUFZcu4vGTpUMSHdWuwWPNzL/2yBrE0mfKgN+lebWE4zy63P8jdxO0EITUN0T4mlUCoxFlNUPrM6zjUw4p0yUWHbRtCbcF2Uee8wfR73/bPBGut3GxU9juxKsTYnwYJFpjSaYAMMIhAWb9xon6KMpwIbfyXwy9oJjsJgel9DTp0GO/Vr5HoY4Ou7A/mRE3a6gaLmOKxOugWaUwWwpFcO2Lt6TkPpKrK/lCGZlDiRhAJxG8UtH1u/V5T7whf5cWsR0CHyMwkQdzBT9MnZQ25mfdi3Z28F+/uS+X6yQXmRWlu47//tynwv8tfWwdBdrV968FE/Sg629JWoN8+ajFJeajfcgsYZjoTrx+3w5+0Zcn4D7hK6I3H+DOyLNtSKqJfPgN2ZiCWMLHpgLetU1HZJcqw43MaP0blUIJI1a8AxKWxZV5YoNNLVTJ6xISC0gbleZWddDB2Igv8cPbRZmyfTzaccbuL6182ClYSUDaEMoSv8FJsWNzu5PPzQNIMhOe1G72jeMw/O7Fny9Ba8oA+klrRZkrKB6L7phTNGLhKAGd8hyZ3CGAH4vLWDDdathMdlYkS19K+MeHx7WCxgLb3IDmVxl98PQ8f6cp3wgXYsyesl/ERUqGfiPnkTNGiwu5BXw/sT9QGkU1IAy9DEJrAmA9+BPFNVST2N/MPhYURhCaCECUBjbEcqk6Coy6X+mn1PWUY4D3e9g7FfyIKnAMrtQNXB0lYH064wUO8W88nNpwMwwVIuHkrywaM9Ri12/1BHoauiXlhcvr/fwUgCsnXIb2DfepXIv9mkVqaIlQhdT678uDcIwkIcGYGkkPPO521x6p94xSTH8exJPVlV9Kxkc=
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