BR6cKXm7M9tmqRjnpjcrq+KOyR8dGcdqYdrWKHQaNs1MaOirAfrAtM9IWULtsqZqAoWUo9LaGqWtx8Gvm9zGlrFMp/m9/7abGvb/wvGUf+D+Mb17Uz1MZBAm5mx8r4JiWhhtcOuZSdOJFZ2kIzso3wAE8YQelKDBhUS+tCCuk1OvzQLq4LIUezll/mTHGi2Uvr+8Ltx5u78fPSsbXc35vHjCyFeZ0vvbbk1dHoDMNHXf4P+KJxl7wbhYfODnmzsl5Hy6WxyGiRG5YOoi2BzfyrVOs6SMvovb2jmiT0kOceE2xZ4jp71TLDz0ZwsID/zSfmgjJvVC2ZX8JDgUCdvtHmk5v2vCOjt49+u8/KY4zf3fsJe74IYFVYt6LudehMPxHOKCIBMAvMiB3TwS7OdTUoVRWPkxveuxtYunTWY3yJk8qzhsE85a34iWhAJcF3ouM7xtQvL9igVsqytNm3GmcgzTPIZPPG30i41rRV+69nhI/U0JoOBGH4yawoF/zjCYaW3H2AxyJfb0YmaRuW9r/sUSqWFljmHcDYxPsKp29Hna+7+K7stRjvZ00/ssigN+/wWNZBfTjFB8+pzfqLlUoD+DTtPVQsa6D1OFcFnflZwV0NSlo20TdLV9Nhv4FbeF6iXuBYTw4y/Z/8wLL3EgJJhn860uV5bfxs50R6OlLN8ZF5gxQPlmvdkeWfTk5e3wgR4/TD8ECRC8vEsrXvwFiBJYlS6+3mTJahhcuLy9d/8H8Z0b62yx6h8UlaXkpHQK/P+TQA8EDzv6/+ITZIbxP6z+ZFczjZYxCHYKc5RmizlHzLzACZXe54fH68Hmar5Orv5K8FDQL8QQq+dK+RMs8A9WKPr+ie2xogOik5zZ4zN6SAQyes5z19DSQcb3DqSnMu/NWOyPn3hhaIA4kJ16a0wT6VaXPlOQkyK4GufAfCGbfGmhDVCxqXQDN69BHkIEVfOesvEmgK6yEiXHWpilBk45sFW8I/iLTftatttyfPZsWwVaLSwcGrQl0+wubcxy7qJb2lnhruXBbRnEuD57j1IKe+R0VVKM6KQPQRPouO91WIPRWCWKqKT3S796WLgHEfDJqp+HRNL+8TavX+q/r+PAn3x7R44ulHQqM2oXDN638yOiHM4vDuo5g0G5YIuimDrlvPC8umnSaRo/iopjaQuHMxPQC1T0+YbeHamT/S5FHPQVbNcGDWc58exvc97btwazJNK9MmhwNATvYq8Dl9X/RwgNp3ZwGn3EQ6akwuB9xA7S97UltwF34xe6kGwWkZdhWkufb8b70sIRZdHRBlfJJHC6UvyEBxx6Ezq4/LCku3MlSEezW3MnDkwoE71a02ryh2nuIOeOnHZEz0KnQ5C6GxV0T/AAC5pB2yM=
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