nxEkMvYrgUJa5/5yol8rdThcDiAiG0ShISVsbeBJjdTx+LO5sJdkTs7t/vmfum6/0hMHVn8uGNxs/tMtNd5UO+DZHAASUIbBrFQqO1dt485jGZHAaEm3+f1LJ0USdcZJyQ7ddyUUiN1osO+25v/ILvJEK/D8HhxPaTI0FAxp0rnDjmSEWma1JwYPmSkuWqPX7wGb8GFzTyjTcQ/wJsSOJQm21t7eE6HcE3GPWrKWojvC/LZqRrVYglBlO946ls4ruKNM+cgjth2pCxq0VnXPi+2kLtylXLSYsbg5AKNBHMkfpnXQZGly1RdwmyWjAUAlt5icXuzwoNQ6xhvNTtwhKkvHuz7x2thxHaVOp+5V0CyGu4VLuB7BM/P40XJIacFuWzCH/My59OqyS2+ya2Ppbux/zXF3sPw+1vMKYkpW3/NIHZCFSKCj5222c5wdQvuMOPOmtAaFMk5zZsu58HLpqz4iEu5PslSkAaEDQlc2tbCY8DX7f0cGq3cdJUl+F1HFjX+8ZY4pDf5lX3rkENmBPoSR8q6K2DhP3mqjZRgBTCDMRkDI8llbzZ+2wYO/tKzOeoCsKpWTglWxL8wzCIj7WHrcy7PF1aZ0cOuHChNK8rXI8jlBW0+zMctZFRq+STRXZ6Uy2yfYuxtjV7+Sy586ULQMedcBnfggjuMqVe5qNj14G8YYtSkFv115qb18EAIq4J5miGdxLtX2pZaUoz9TPbbQbKt6Sgf/ThWlCF26xD5obxFSitebB7hyH3zgGH3MKdUoV361mLT5SzFoZONZN9Dg6EJ/jvd9lqJqYbX8Ii6Wzemv03xA0xR6IoKo5KrE1GUzlN5NcQA2QJlcsE3EFP3HsBKCP91aU7mWnkkZyxwhZpjSvyVhTXlSqtXyaRd85l5PRXKGw+hbth1MqxZ//ihEcw53I0y60K8QJVCPz4mCBx/IdXPhCxiTr9E46e0KxBj2gYDsWPze8iJUziKLkgzBeFly3oQUyki/CeK+E/4EmEgJzYoAp8h5LqSUuTjhj/uXy3TazbG0enEyi+tXfxiP0h7fpCKI91F80P1ubqszrcHrC5oMHqvRgEPw/LAgQJBDMnklgVIyK0BaFVAJ3A+7bHGaiJaxbTJjIjGOXi3D3lduK32zWlr90/p3z3cE731QyV98UCUgcXVDPO512HG2sDKm7Ni1Hf91MuqBb/G0QLqHybub3ZOnLofE2iCFt+Aw4yNjfCcq4Zz9sHDMnYs0gcozEuW6ha65Nnu5/kQwUFAh2VtcuqFxmCkzpnbll6rNuQDPYHq7hDdRvK/cB2iDiVsYM1Y4e1hdCIVexZHhFiBibhosxJhcORRVzgDTaoHyE11Oqy7iUm7W7vHxvYoe6hJE9yWfmsBVSdo=
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