ABClR9ZZUOpnL78Bx6aE5w0KzHEISRiZng5TPecuvBV+gHNX40QQ/txWFtIKveJsjFRRQ+RQQ+0G0W30Hev+nw3uHjGmo06ViRYzlQbrh8FT1LiZPUgL1Fw9RMJHeb/Qtli6z5WNAYYXpoAaKXjqO3U9AY67dTbqoApyUIRziY6dxi2FXDyrR+XHe1F2kggySsg2Y7ic3eY556BavTFMZk0ZKy6XLds5WQhzd/S+q29nkckuwlIdIvPGwrUazsu19w1YbsdOZatm106FU6b4xYA4CUBHYBhCwRVHJIpB6d6wUIKmQ4KVjkf7+glPy/2EdEIygMR03IwksQrWDeZuIRV74ps2udMFXiTMmBl4z5wzgIetix+8pR6bIUPgMrx70+0RWHQHLK+PXZWtEm9Ztg/o0IXjgnSHTq7arqxjqbsYBm7Dhb0BsvwFdD1emaUfQqQ5ZiO65X125EQDfKllPzBPtKRShQNkimoBSZ0mx3KOSILQ7/RluGm4nmAb5fBSnA/1HRX8NLB1LemC4W1evLa8w7Lon70a5R9nrcAyMnusIHJ+9Cb7uv7u4MCzt9zriV7ntfs+sNclzkOpm9X9OXxGAkVS/aXOTfs2MblfV1A5e1CE/BkYReWf0QsFpw8nvKyqJPg5pHvQRNGauVAvxwakpVug24hJbWTmLCl8T2BOZMaCNG6XxTp90GKOMKiB5E3JuwyoHWsoVvw/znYhnR7dH1f5ATLonDsn/VsYEvQBNOoSGGvE/UUz/xAbuiXw6FOLwuRS1hxRhq81hF2+7WA2vyY0j4/4sUY1rw5wfWP9A8CG/OYKeYXiPykFaHQwqq4hHnhwJ1WkCsomjY4t/SGtzPhWQiy08fpefXGzyytIhEYYrsYDxVLRFbfZ6Ctxne+T+krNK87cPhsL+Pm4EKcdp54MzbQj1cRiJIg4IjoJ8Z4A/ppRx8VKWIWaZ/7pdGRw3rR8D7LRZEEHgF7CETbh/PJPLwQJ19B92THuuJc7hGPrK84niXxFWmRAzpEQxrmIxspbf3V7YC580iRb6xgu4n5mme13FKaOglgA5OQqnmPSjwRvUVs2GNCvi+F8mK1MuANQGzUtpkAecXNViqoN9Jemfc6uoOLxwQH9Ri1x/4hkRqFEUBtSyuc4gDzQJQwbIboR5fgSnry7RKN17HROt/UiCCJWLfHc6hdIm9uu0OrKccemcjh+ilPBA6TAZGFiNsAXktkgUkCpIV4fhxtCsEXlo1LhJ+HDycLzeTPCMfhZLv6LfHkql5kCWY4BsL/TUj7CNdToigpl7W6Qya9q5Ewc81hN25vVwajKVpA2hpw/WjQSUvkoo0Tfu7Lf2nheDSYSufCsihOQmjGmxMxR6BkdpKS7fDvvwvI=
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