l/8oM0SIQHp/2K9oINjdSdIrE8VOEPVk9NmINeaiQ9+eVhWP9u66B9OLTG5COpIjXgORHRoRWuv82CvkHw6jYrnZsARKafg+Tetf6jPOH1gPtxqsoGK0Pp5MXa3J6v3mdySkk4yIrssQbl0ChTjgsTu9f37lKH1vVPcI0hZQl90E22Ho1oPadln706npydNsKhX6MVGCpoOm0g69/GBEL7v1KjHq54NuAgec9TlL1Rw1XOj5VsqT/v8LPR/EHBedz4sAkawpAgiOtkB7JqmHPiuuTX0RyNsgpKoIoCfYVamEi8Z+ttSDKwkHbqxyTmZxwdHUyA1BOHCvpPlIXk4MC5DKbLw0qDaz+vnWzbrfxiyiIeN4Z6R1xDsunJ9D37AQhxyfg0Qzpgiy39cgGO97TcIpRp9xC1S0/2uhH3kvo86gPJ7Kr64s2W3TqImk5piSzg72Wd1u1+h972v7L9guQyhGEm/NvQjjQwgTHVuqARApN7SwIZLkgmMQfKG2mSDpG/++PS7pBrMXWFq+yPmST6M3UwOeDIH5RxrKuix88YsMyoJKcSvUFItm/drUZMbAmhcfPNBxfT9fdwFh9z/lRa7N8TAIn9LOHD+0NQTauAnOZp2i639zZESmr5MNEomJyeGW4Qiclsl+iAUk0slEjnDXK1NhcTasLg4sziLl7dRQ25S0TVWnDdK2aiOqaO/x0UyrW1rooG5k5RNT2UrSRPPpUG23FfAPvD1C508ViLU3GX4WGCbo/vZ3CWSam8ppCE5e69L3X9zLjlsDKL0ZjJDUCKaNcQ5bxBnkEW25mPMxeVWWHalVz2BdOFGhxZtOameWoIcysLYjs4BCJxXR9aHZzm4CRgaPZsAV43irOaJahR3qYxRfLlBP+FT9SUD8HDTBpSMiBe9gKnrZ1kk3BucT1HP0aO7B2BYYOy2+tZkGKjxINrsXn+5FZkfJPqXs1DkIn3vyGj43MPmqbaIRC28gd5vBz4JWbY+iB9q4sSbXZACdnhVY42b4ba6o58RmxI+eRG3Hhes+e04JJYfRIFUBF3M7xeGXRjMMSvWz0qBM4KHIpNiwaIAKc5oArGTmXNurQj4Txzce9o/CUVoAYgV/6Mf/tfLEQoplgdQBMfLRp8wo50V2hf/X/sIKn2zbWuaS51I4HAg9SlFqSlPRGm+rq+UI0St7ATtJM3dDld9Xu/BmVr9zaKOg2zQBGGVctBi5L/4eWqkUCzjHNoyF0iPDdiFKkCdkhScz5Y4k1mIP5CwhPUJU1XykJ+Goqexy2ix9W+fh9yTgx78ptjir5EIs8D6WM1YZxVsJyTcqNvALBSKsISeNUAhWirBi+ClgEXWDZ5Fb6HEd2UJbKMtolD0iJ62eBghnqGYNMhk=
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