reYo7yMeL//VYtMOJSgRVJsoirCwDUbxNovVdS8hIQwu2Q290KYrpkPwg7B9W9KBCW/+LwHeyf3y2SOIFbkIAZg8ZdVHHau3MrfP9Q+3+l/O1gBANsBDjaoqKENgopcyqmoHI6IGy+4gcF7qv5Dtd1B17qqq5zkACIHMav+lpQYcFp/O+l+4AMsbrck1HceOcw/Sb63RVQTIw9nK1hssJI7dg4jfJzZoQUwj7l7doclIF56rthfLXvMtV2Y/UXda7551TY8bYPfbpu58i2BSsLoaZhqLQ/9pV8m7KkatqnVQU/BJOk5C/dml6n4O/ABaeFPy+lFqvRVDmrO8BTwah/E0Wi9mNpngI+pk7WL0hpv9/RmqRZqpZo6TbfO0UqXDv83Xc/4joIE7HgHmeMFSeiIKbdR5q19XXi73atnwiCgtV7/3thlNhH+ZVtzMWmum5VN2WjBFH2rZZxbjrlieA+e0A4/r6YihDQ2C3akb7zl5ftNoT/IVg756vLj/ZfoNZIJJynidJHctLR1NyWDUuWAxdV8HsMRTVFz3t9VRn6BaeLK3i6MhpGSCELLq/LKS1vU5BYCZdGTMbNaCi70Rgrile+LCMarzjwXBnt+0Vfzchlud1xENRfafhrCkJh54IU93fK3x+TRmI6L6t6nzVwLS1iXQm259TDoAPeO81pHa5S1oZJaeQ983WAyIkbuVjLngm4LGhyaoM5UNa1wb+8Xl6hsnj3nn1+K8pTO7F/2SSXmeJN8X/IdVzr/SydarguMuv+TA+3yF4M/v/Z68jnIR9kfhECueATu6qze/tTDRZEVr0YqM0+OPQNdA6FGN+Tvu05lbZ+jYfsY0p5Jf5H9OTv24NxQEJrz9HAeWUym1d0lIiIasDepP1Xcrxk/AEzSbxCbQgBdSMNOedJ0sen77s/qkFyaUnzpF/5Xqmflq9wUMV70w8a3e1KttutgD3FqY0RNK5Oqcx0KktNZ2qpetozVefd4L8Yl4E2Ws8weh2gZGMhru7YLUFJgz27FIukcdcg7YPJRDipoZJ0SwwwpeNMlu1TqFERjM2Ci6YvGiXvxPEMZ0jP9keEB9m8C6KtAzkK9t2WvF38XwDwLBrih7eFRfr0vOLVkjcIbD5aNi+EQ8Chklxd8dBxtQ2WQSViEjNw8l5V+1Ph1n5smpY+Ewj8DVKQ8IQVECHoOXFgklij/STbfxw5nhVSo8+b49s8AsXNuzsqXhObqR6WERhonBqOk10l4EohdW6KR74hURV6b3yfxfg5oC4jiV/QcTuNFz+6y6ECUF21bXSwNFt5GrgzbnQgGwIX0ocWe195zFmKqlVQIyaM4gLm5EKdXQU/9JQ2ce6M7ExTVzw95cbx2+9fpQ9WS5af3oSyQ=
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