QyZwmkGWBIUlwxhQFgoANzs4RqRdA2DpyD8mWkcKO0MGwjZ72huRCa4N/pF27ETOhfFqe+IGT/sWj+PQNocqkAeuEgX4ulJuVRdeUOhZmvkKt3wYwQ1T6/u0/HroI0UMNnQOrqYW7N+iMa6BijX5nnZY33L0OsJMwYSK+L9K8liLs272o1PIKLm/PAmjAu7Z8998yE+wvO1wHca1YkrLNFanASzwCWExt65leNI4AXxCGyOp0TH/AxL9umLw4mb+XJi4Zi8jnCj8I8QLIQotKs9BJF67koW5iRrnsVbP3ywFRpkAFpOkkrPokRBCw5pmRMdIlFxqWRUnyZO0GdCyOq8XsusHFqtSbCTANrLuvizzbgnZVrNHV3FkLVakzSyjAeM5e3EVswmvC8pZUoGKHE+2fytbjaQqDDTe/hYQ41DHmISKKXFxuDMdS32SppXTYke4WyGTczkAp9lRWxreVRV7m6qcSwaGul19z/Aqm+EiC/2gi1XK62gwoC1LFXCac/8bgOTpdwqem3fBE2lzRv1zZtA2Ac+RRPcz1P4SLhp3uqAZ6iSb1a1xKn0faDUidd3s0mKevUr45XmeK43qwJjaQ6wpu8/RIj6+19Vu8+mNeAA+Ioq7Cn8W+9Gm6IyN2cJ3pfqh5Rkeb5Fk0BM4Q6f5tNtQKVU3p3mNXvcqUfBjOWt6TGq046UqGF120zwQ0w5tdCgf6WsGvpjZmvEy79D/ULvOhIkLPyvtvlSRHvPFkNAgfxLcBDoOhXc0LwUcdA0Ms1g1/CnQeurbrlkFWH5h7CpSrK7HlcWs9qvnk5xNMbEOgvpfduQo8okngxqjqz7ZdeAvOu+M+X9HGkWNq3LgUKDC9P16fPLd9g7Vuq2MYdr6hnn6fU9CHHb3rnMfXMHq0LoYaD3p8Ein3IJZO5Vtz8JsiPEKczTnvqED+SeALQv9iaNN7lmjee8dT+b7djmCzzowD13biQL1SPIchri+PB/bC+/6vU77LWpb79TYMYx5KP/ss6fkhqEPM1xQ3x1ss5SKqnTAe2Cn8tCg/wvNTDaLuEYz5rpiuTY0JN86uw8q5jvAWCTemCy2KR1jm5ldRSUT01b6M8D7kaUo4JCqg8LoD7U1RYNOYTeNlKiGEGcaecf+AOsypW+njtdWkn+xLkNI0L7aoNd0kFUErQ/PNGyrHKjhxrF2zyeP5L/VyAbMrWiI1ZwXgVbS6+PXl1SI5GyVJZP7GZ9Mr1TTUN/1h1keNILdfSKfVN4pqy8DlNDGJGRap18lIvBl/yRHVxK+WI51YdiD9SKQaqNQCEM6zOjHCAgKBWmUutwURbxSSxCStYs2cel+OVuuFORq9kA2luANTJ/bk/282T3WYmHUED5NyJAr+gfDy54=
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