15cOvvXYqBjEUlITbFxQUmc6IHYs2PLX6OWRoUOF+wk7KlhLMioaMl/t+7eXN4QhjIrpYh0zI0idIP2lJua9KPNQ+ubZkoAUSfYISwEP6kPXcJIz150VpnphlN1l/C+6E16/SNMILD+vsrrQMacNArEycBUi4RYzIqiRRFU21i65Cjpl/aVjwdUZMQ+wlqnyOEl3axnaOJeYAMftURo7Slp/i98hp0FPg5fkyJYYXD+ydGv5+WqoQm60UjFl11g7UaB92bjFQyUvpZ7FzFrWAGYvoe/VdCqsGC8L3ZRKMwH08FsVGQ58S4kEyjoN+xgZA1kpf0NV9ElKgy6oP+lrQhvxnVFsl9SByedpTzVXLMn06IseqRAu+c3dOdTG+gg91q5EYRr1CmKIe99vQLwRogruAObTQ2y06Edn8aETuIYtrYYfDiNFrfgyxRWARaFTKIiDctkKbFyUFCEUqeM5/eqCI4BvWf5YENv6MPfPd+I8vxekGQieuz4wNfXEudClo2GI7/34Nnhtpc5vA3mEykxg3ZpqMhNS7Lv5GPL2com2+z9mtSFoYiBLOJXCjEDjuErGVvHQgc3ycXqtzYTyXJyH4OP71up0LgNsa0bJQQzc/xbIGOghV9HJ4LoTRCxu7Q3DjAf81SrM/ieMpQ1t7Y5PX91mX0ikwIt7iKJO3Kf6cpx1dcwVwk+Jcqhu7frZ8N698k6KEtx8l6OqGeETRvLCvJ8cuFfTIDDU1O5cP0vq0nP/wdppKkebBJfCqrYpojOSCQB1s9M+QLZhC6BHCBei8+c1sGClWa9Q/UmpP2x0SNZLVT+4AKeFEYp4DP+9CX90UoAdlMeESlZUY8vNceKl0pTBo0iuyCDqJ4AqxKT3lmVF/u/X5PAquZDv2h7PCxpKad7MD+nF0oyDBf9nO6eN8SsUhgaeX621TV09wNfmJqOpN7de7c4gINdTDgiqAU7bB6DKO1gTlAx0dCT3BVYqkH/F7AzkdIjkOW67nYGMTlKaCrgu/LftntXy9a8yBwfLsTUW0UJx3lvnYKadpa5tGp87UKh/tljV5/KQJRFVJo+xZNJPkBCXNuuXhJ9uAzSrRYuwgLEDylzdd4DjtZZ6xzvowh5JzKGRhvDFJKaR07ep3XwmjIapczaISatD9rOYpTBoZNsfATc3mAbMjKBIHRhsuta5xrS1eTyufB6B98m+mB2EE9RnaU4oPc+Bu0w5mC0ed5wlp4495QKOOM4up4sDfihITOoZxlu4TJvLogO1yrxjDL8YY3nXl9pOzVjyA+/i81KKvsN3wf9wguKWTE24pdqzFbbW+m9rYjgRojxPD0Dyypy4FkRzb5Lg3WsqvXGLUWeELj1RBUMUERV5a7p42uGyH465BmM=
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