jf9VZG7NJu100h081sWAaENY/skjW9TNf8ipvWs3QFrioNv5WSg14sQJPq3Mf84C1juYS4ClqSeYv2O2/p83zfvbOpYlPcEfZJl/wLc/H+HAfplXf/qaZhLJycyMlPXkSDca/Y9QFblgbO6u6qW6tC4y600DGVphSkQbMCgTJ0Mf0R2CPgBNkFpiH0DWjhWnDdsqIMCcMYarT5wglZbNYrSHyHSLlb6pKFgSgqgaJ8W5Ls08wjq6/vHKf827VaQI6a1dQn08ggGEaIvUmK5nmHK7QR6eVNXDLN2y7g/BTg1y1CDEKwJ+V43CR7DEyieWwUJDG+vNFVaVzN0SrkOTv0Es2uTjAlkqHnmPLnsO60RFVJnpKZCxtpT/uV8an/W8IwhA/oXk6n3y6lAwj5FMBhZqgCND4zQ8jgZDHQFy6HavrTozFmb1ZuytpfLnV5LXUCgDFgzg6SMjHKQOzm/656puMZR5xLz5cUk7z4/53Sq4Q02fTBjBnghv8yaqN2o8LgBEEMgdSMLDxGiroWbnRa11fTZQFz4P1wrGQzx/UMqL8xLhGl8T2ycUeMwamYibt1PC0+HdSqjbKTH00dtVVN0cl8/jd8yh6AUXuz4SJKQ3I4zVtIc/Rryyxzc64pmQMM+jo4V4WoSC6qOm/gDR7R76P7FiBEo/1I4AMUDAGIr/Um8NYp4vM++i+b5XzQOK/pu9p9GG4/6FKaJsKzrl+PHB1C4BENqOvWeB0sm5M4fbRG6OMbMKjAQQPAgplwLDNRkUou0LaNmbPenCWrOzGLuX8DJXgwIkW8TYwUpjtUjrYIwwC9LHHFC81cFNifqVPb9CruU4GZU8PgdLUW5TAJBkV2lTOyAx9K7ii2Ri7KPtkGMrhwT/uqdhiY+Vv0VflINy7wLs9ut61o3CSUQxagwDXIiqVkFD3rccfjkaQjDSq2HnEUbxRKgoJ8PSpMlUFsXtrg7WnPFFWwH2FREnzfBZTb1kpP66EU76RM4f0WjF4QpLVeeBgCurw9MdXRQkZDrOjbfIUOeVVofco5qUctV5BHeYCHxV+sXFat9+JJ+4A9aBwTYpvqVWNj1cNpWjoBp0+Ad7h/3c+21LDLhP5im7x57c2+F71qi/Gm4Ids1BzVqSZ3hRs0i6Rut7Qd1rpg4rKtUrm1mN96tvZ0tWlLNzmOIl92mlLbW7S5knxmIxsMzCpwZ/fjpL+aCyu76uX1UQQF3oB/89PlHrpILVCU2Iyrz9p8nheg6h0yCin1JkLsCv8qlYtAys9entN99FOft8Yw+XTiaEoTveWBJzqN7276GhemJvwhNo3vEckW9xwW8yPqvagKK2fpVgC/HgaOBucW+jp9aarCj9MaxuOdmxiHfIzDnPKxB5JVc=
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