UyAdLdd8ha4OJLrTqkoFu/nEF3d7PiHxlz7kT8+uvRgeyJtTCyYDzpiR9mQD8Th+XFa67MgLep/iz9Bu9cumW0XLEBq0Lk7mGNWpDLd6n5qrMuIi7hA3w/KE9qpQR0gfkNFlE/vfhY1xlSjxTR93sHxVgizqvhxegY9IdNBSAe2pyiTtbIbfYM8Cpr+3hlBoBdaIkoQH6P/VtzIQIolO93eyb68C2AwNQCXcs3TVc0b7opXDlB5tZ/vL/gPn/SWx73k0pjUbj541/EHI9StvbNgN25O2mUmCphkuJ0sXpE81++eC9iTp05wsO6OwnI6TaKy3jAjpjnVaD+OrHLOZlyELiiE+EqG6SAKbqRtlIqwpQMVMurUHkqeVCXY5xGJfBTPOj3OKwfOXmoZGsBYRPbQgAB49HpjfiCicMrXu8v4+dpfgXF6USHFGvqoLUHiSeb8BFL3923gAV5Bv7laSLr9wfJPfDSxuzHz6EZA3j73mw3VG862ARXhAtRVeoBWvw6eyXyT7RR36bb0H5IWSgUpjBjQNdZSfAoW8r7qcbcb6cv8LNupJsksNU7O+gHyNbMGlqpTkGIX7yB70qTnVcr2X/Yvs1dMq4UDa+aHFzjoUivUoNxdpULrlLWKhXZLaX7WHnUMrnbsuKj1wLe7A1k3zFXT63G0ObyGkI7p8uvOJfWfmR6YaKqxqoYXehPFYwVvJvQaTSC/EZgMYxtyGUfqErfjAReGSoh0TEh7vxePj8V/RUfW5fmor8tTQstm59BTv6vsSKGIRZGxK+AUCVeKAr7eQM5dDXj44Z3v5Q/TZOA3KDoJ1FYSesReudEevbMyqmqdzbOnrAnXFRdndN0pU+4pGa0jRQuhf9jjzovKoI4bHOa+FyZnIujI/ggBkhdWca3Id9oZ4sx3fm2E8uzCbn/O9mDTy1ahmE7la5YbjI67VLB8zZ69047mT2pd5aIP0aLhNVqXK6SFpstZIA2j/aAqBd7bvQMJgRJVLte6ksRkVNiJh/RTo/YoiOd2dWSLYes+q5ySNZLI9k1m8XagGJeUZcJXlwNz4j6Jz3PCf4cbmAAjQtCTa3roOJ9G5WiRribW8EeKlTfTnsIJ7ukRG98Z4cKlywVwsP1mQfUJG00VKLfxWjlTEdJk4IVs9tyL5a+KrSF+nHQCKG0E4YmFLXPnLl7h0DYyME7fbLyW/p8qW4vQw6nnOXfzyKgLv8DAAOEPZUTIDaeo6milGx0hZW9peVJZsRYcP+tO91JW5yB/lkuzF6iQ30/JZBrA1ptATn4VX9AYASALkT8miJvJcrRe2S4Au7kfxFZ6JA+5JXxCql5pdqrAgAWYhUmWfWwPMaQ0ukqdnFU6MntgQTsQ9wAe1RTReNKEugQ4=
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