in9v/Ehcp1Lxzl6H13EFNxXAK24CkPE2kGze1q0D/k5szTxacB7rAmwQrDWiLHYYlMS5TlqmXZD0yq6oqhIA61tOarQ192+iMPe39W2H8f/htSJGXCZMUfqsUh0g+Zv/Na7/WPk/gFQN5IBt8fYH3xSbfdT6Dxb3XRpVkCZ22rp3p/zHbs37vKH9XmybVcRJeEEMSU5xgDCECIl3t3a4uQRPS+xAGheeBZDRPUxtxOsEK/L0S97lVej+kTMzIf2D5V7pwH/ME7WaZvf3ccOlpIiauJSTXkWBmJam0f6LdwTHjtbpDL9hAiRu4U1diOFpBPtQaiLGWjM4TKuuO5q2LJiLs4AJA4XNVLJGQxGls1nf/65tUO1J8Xo5nWEApa36/fIx2wvjd6jUG3aVERs/JeYbbTjtVn976/Fgq5HbqG9bmVyl9npUJRt5fAGy2ScQQY0o68es09mjs9K/ljUlw6hPMfI16aLnpx/uwfEU1+8xl++SGqNh5FXF9lI9F2tUYwTB7Vqklz2cPfpOVj0OTr4XqRM2OzTsh4+AVxBtyN+SNdUfduee7J3eV/tmq1sxXyksE6LxBd/dfDDRBezMWEQmgvrNaLSKwmA3j8hs4A1slQfs88yqrbDBwV+HzbY/M0X4YucB+MHHFCL8hPtTe16UZWGRHptsLjgfUqK2Gt3bT8MIbtpYNKjm9GhSsa8/J9t56edWpbZLbo4xMq2xNF+z+ZciUJrCLcNmIK7O3n7tkktz5WWlSQzHD4TK/JnbCftt0FZOkkkiYcGIeyfjk7J3DmdFr0TyD8gmSQFiZgP9s0rmxSdM3iq2R3Nh/EXzU2RqELHxK5LqBWPzBd1hM4akeUUORxlExNcwj6lXAJGGW6IX6FeeuzcsRwBwojrSaUM8pZTMz9SBPrNHTAZjjsYR+WBOamU9lYssiaQryNRsKR9iR9fAFPuCKJgJT3oh5RmAebmaPJ8pLf9EFXJc4v/ldwrAJ91W7/eJpwyeN8T8lZOLYJZ/1C1zUyUJCBKqIEfe00BAkkj0CSqk+j+K3GO/LR5uRJOAE/8tn9q8wsWWpVywEFwqScetxm0QdTMyo5llvqGNSvCDhTgdMvjgnBi2X6VwwGZ2XanS5VJvOLL459NK79JuW3CiauGXRdRbDarXAadGfnsSkeqGigmNZlwWkfom/CsH4f/MjdeFUp3xnFDtNrehpJRgm/5aVzedUf7X6DOTrrfMGwco+q3N+5QwTlQO397wAjVoUQbgqluK0mcZbrDoZxe+RAK4Iq4GrP/EyzzxvJ0I/9yAcnGIR9YIdLxPRW8gN51MfOaQmhx+Vn0BlxFZ1E5wMRoZp4q/Cm2wGVWkTP8CVTfmDnyepEVl6678CgRAvRY7p7k=
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