IBsDyjEf1yVrzPPXatBILifF0Ise+gMJLSyLlinfKGZj6StoayJv9kBQ6m4wtkSXis0Ich5jwEnJXzgUBepnGaAEG49CLblLn7pzpl3LBBu51z+WTjKUBdjY1QEnbIE2iAeu6CiSXRryYkLjXkbfVn079ZVLhEn6PVg0/eASJXj8bDblNIhrbBkBanYf2tJFH7bPlsQVA3BdXkIolvqhYwFKBz/xFYr3qaU7p+nRZnFAfJ9U52DBRmrSzpJ4Qr6Bo+t6Q+9UZzyIW5osoEmLkhuUJ6IvIHUDh7gVtVYh7EbtL1k/zkeRslsMjD2KyF0r47UE9AxiTCaUMcEGwmMDFp4FuqR6stOM4Sh/KvN4+B8iIqn3SAR9dwxncibqHbsF9LUrRNyZc6J3yqnpcD6WqsJW298IINBgPvBK2LkEhuj9hTjSToI/HmTt2dtXazyv5NewyMjoRPb/HiiaZnkvc6AAtvnyJ53Ylpu/UpAzfIzgI3yYwykPmIW+zjbkCzNGDRIvpz+PP8cYqca+f9QzIIuro+eDTlZEVqQnsiwshSnRjLhAZCqKA1K6AZnY4iMryh5+Hq5XFM6dUolX39Jt2oNUQUEjAUpE+Li/6jclYvQ4mYKY7aCYmQSXxpHtDj0+hmxUifmc/A8aFx863FE+GcFwrd7Ry7/8phTP9iw7u4SbqJnBIUO0RwPXM81ytoezYuUPC24wX9cLHg7uCNuW0i9JMj9Q6tkDGkz9oy6Or+SUqmCKN2/FI7f3eXnyx2NzPQBWkDoSJQ2sy0jf6oZMFa+tFDZkYxWTP6phZIIGEMniT43/7KOIgtw0uKN6RS4uSvYrj5TxwS0ARiqHgkxSD0P5jTM1AC4Z6TVDoYAaSAgGfcELpdHK6MUKZ8fGg1v+NS0WzSGcot+FitcZJXalRqU1/VYLIi9UfE/U2ImvvjE1LkE7Kdes8C8+WbeTlbBh614ZS4burLfTNz/Rv6luid29u/LYj8vI/tbmGn+u/veol6Y80OOifvu+Bra5rwO/ya95Szjvfom7Z3phFyaL8KtQhxNuRYIiYpfdfmmZKDFzwS9MV17Zy1OA7Nukh7eZ6jepTRNkUSXu0s6QeEjeBNBezYe7t0HpnEtw6q24tY0sysVzX/1/M8GAw1NpAoOJvM8bfCC8FpuCtQkVrEJYADSewBvNfhQZVFAv+lDgThXr4rr2z3lpMDqLdVdbL14tVSINux6sae3+r6ZirwoJIPTy0VWQroSdHbI3yWiXJ62bJUWKrC0Py+LTvTr8ff3p8paJGS+X5qinQl1cUfMjPIzX0f6NaagIAS2bg/PPDWI70wwK4ViYGgJt1R6paacp3u3kPGDBEDW6I5M7gH2bNk9+9XaI3L0jhDMcwDc=
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