YzppX6ftVLxw6kbak7RoIEVNozWn0xhVFNNEBBQYOxS+9dzOAoH3d6EFtQYGUbOKbTRlqlX4uARH3UR8SWYXokRhslhFXS9wBUTSSniJcd3dan/VZKeyIkyBRlGkeMqtEfBOsO50r+ItDol6L4AMEkN7zP6pHn5u2QWCjjp2Rf4pIxzkob1MaT99OGGbPSms8rQOPE1ChozWCxNQMn/BP3uxJghnQzOgEodQzdh1TWuMTIeBuCUtBI7LIIma1/5x/BxsKxu4A4U7Dxy+ilM+SWmlPHAIEzhAplJydIc9qXrwvmk2RLN54dr7yhq4ciNU3gByCeEK6Fn7Trnkcnmki3CAL9mEuuBga267W6krF9+uA3rLowLX24Ex/hHDaoagkTvuXvRoVm4WbuUPxriOXfBBWq87tN4e1XydUPPWbpPJLWZDeqhpIaxHP2arRgKey4ZpdL4pIj1jJ8olGRInenQkQpyDT10EKnu65RhUI6e+nJxqpnE4/OaTrZAMI/q4svG1mWI3cg1CAcDKfD/T4SsvBCJqOX109LEKGRUcFqgmPzGBlfQiD/JYefL2/NUoI4gAUgW09Qrsdn4InSGEZKjRNMktskPfWwL0lVAn2WEpeODi+5k8MvmwrsbQd5q4mlc/zP3mX+1r6BT3VGiH8iC6eMUpW9qhIm8B0wgxV1FZzq7uOvbwwzjAnyx+/JGdiJqq4EPNkLdib9xaC9V0g+HrB/8Y/h+yJJ7HyKFHvM0bxIFmbOvi3xzWm4iIrs0L3+eR9qhyDTa8HnGRMUeft9ZSvDqhzKWraOxdasEgyAEMHl0rC6yTtBsJUj7s5PzSjG7mFPqiQF7sh34sv078vB4ndWUo4xTJiIG6ds5wXG6kBhT3/tvtZRpor/5K6pQpe/CyhiozcxTsoy0kEWwuBFR9+Cd+D21wN9O6aEob4lch0H9IXroA05MH1pDMQSPldguxD04N0kQnsYn5fq2k8cOpbmoayrdm/YOXiTle9lwZHrkl2Xg5s4Wu2uLhRt9ZFdd/jlIl1tGwUM8yj3meUL6Qru6HDPYLuIHCRJlGC5gIQwj8bivWQiOWz/fdJuJRJvj/xJ8LNOS9ZFMhFkIPB31HoxZ2U4G2oqGCy+WItU6uexQTmRcxAc/qoLRXfFYTESOCSKv1XP1ONUAUYK6Rne3HAz+cIR66Yjt+Se1EUS2ITR+IIWep+0x1hsA/hU5K1izkfWoK5nkmCkKIKeyaTkf72Jw3VIxcZdfzTNeDVSfLkWmrvQ+Ymj9YZqgokKBmsWBPXDTN3JHeJoICEElLEkMe037Mtx4QcSaDfGKVVqF1RAvs9MDbh9BwmXxQ2cCUQuJzGwCFbbXL0MvY0tFeoBLX3kGpOp3LNAr1Vog=
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