MELAA7nUDt8OxxFgsEwbig78Czxdqxr35PNRgYUd3yjxrVR+Rzm3LIftj6rEolW0uHFy72QZ2bCdz7BoS4O83OdXJdKkytq1Q7i0MvmuE4hNZRDiTGwsm10On5dr2s0MLluv19wqG2PUCkXoRsdfvIv3V2P1V5UIUf1rDRwxoKwkJbsIm/2O2rM8ekb/9NiDRn/LGV75w95YFUNUda1Qad0c+J6p0tTEqYqf5JFqo5z7SlmBcFYIAQOTVcNX/Wo2az6ql4vyS03LYZ8F3Tjhnbv+NWV2ok1M5/JrCs7wmJcYvDcD2yLXcMDqE30XCOFFOWEdf4RvWC9c3EDybbpOcAPsgivTaZGoNIAN4QmBYz+JEb7mc5FuOPSQSpgXQkvHRSbwWVUqC1n+j+p4ubtoLfXQnL37S5BrUGIIyjh00fv8ccEAVwPJ8e7Aoxe+i8H3RDGkDkG4GZCItdoers8H6hXOPw//EFV+aRIdJ6BVfl5zdBQl8TwWGpofXBnD1j8IK/VWmctjMzxi1kjw5B0ZIPCfPArPyiPS8LU+UC/4oYmcKBVGfuY3GbjVve/OEWO76+h/Z06mmN0fm9dz+ok7Fimwlo4s2ZOYakPipEBa8CD7AbNqBhEP/IUp0GiR49COVWGn8hIXVJZ5VSyb95v5b29pVERCNwOpv6/YhGkz7UNwMqzinRMjEklR6ek//zokVBDR3yEZz/i4L7oykQFhYak98iAIdihbIrGvbKXtVhEGbL2s6qVfvXEAOtQD4BbBVwGawaQEIuZzLxvyyr/HUd96HxGvPYz0+YK6N3yx3YAXDYtzv45Hj5rCtF/cY+hwW+qKBB2WYjsyiA9N6de3uQuu1I0oLEu/VBwlpsVdAdlF/TAI4Nsyo3s7diizpa36ECiG74AQPOMsBjMkvV/SER24WH/kCjR22B9/RapvZSP7UzYGVTUfssadniZTga45O4N6V091Q+UN/0CaGXby4ZZdRaERw9y/1kDdE6xLJrF+22evY7R7WrdDNS04seXa2ThhB9KASZNEC8vbXdk1fJcdpBxp0b0J2m5EiTvdijSP8+NvA4DMBCDldqLhu9JoIzyH2iWQS+i+9/3zDY6Yh4cNQBRS3PLFDmi/ycTP8xVNtjsLlEEee38Skp2eDDz3EHBoKJ8RgQk61Vuzu4oo2eJLin+g9a3BddoqOo5NWoSqzgWGdqRh9bs038FKw88ld/k08at0n81p+kYsuG1v7/I+c2v4dMZqedKhSWLRMIu1EAQAiYePUKeec3tNBh+CxRn7s28tArfKd5jo9NQQUKzZvUW0r5cLRAztaHFck265rRi5QHK52ZGVp1v3Yvl3KH9M9LR+F/RAUdKEqpWvjmlLJucqshioxw7nvvE=
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