A10iR5D2+kde9U5RiKwpa7R2jIA3nqj4phJAfImWdrCVrBmZrm97kGExIwaVByi4h4Jbc/7Hv6MngGvtwX6RH28QJzqdbCHgu4T34vjyCuj1vhuWOeRrYmYPoWHG5OWwAyl+wDnpasmhHRqSqXMcYBFcKZvIjAlACgX0MmMIgaSILhRLTuDeAfkTJ5KZ+hNdXhMUyBkw6mno4f27ig92iIQ6Q0lQiOpAgnfZak4rO4K7MNiVEcTcb2YPKKSirZ/aBO8y1O5tECD2Bw0Hee1xZ88PQ+xeXKEYsD10JnX0HuAt2H1r8VRGY5Udt7+LtsA+6J4D8j0HZFMTNUYB3UQWwG9bIzFQ/AWUtAxQic9pzuzeXJbZ1Kk49MumBUGWefx0F6otHMgWilPDdwhmhKkKlWEAmjBwOvoGv7poGuZvC3H90r/ERYhpeHiMZ+2uFLZ6Nqon4vv9TQosFydGoTOSxhXnRrVLJ/Tslhk7JCS7MB56+85FgMQrVOC6n1PjNYDJ9F0kY2Py4G1DmCbkO9uhz3KNzotb9l5YiL38+Q0ydOS7pieLl8+sx9G5RJOajyqwfcvFsWoKcMhucl8M1gPqV5LGuV4209zPPmejhsNETj/lVaFDuU01swNIJjqAsSOs67XxRT3Yw65syt1iK2ZcyYvdcc0vXcXHQH4uYqQbmHTORNstrF4rcwlVWBuaT8KSBZo+bWN6A8Yzt57H9j6f8ndKLNPjfmw0iRxaA24P1hh+Gbzyvj6agde/zh69G9TSdbC5PvWcc/uyHBvCk2qj5o+GvkOSFx4SqQqDbkDZvP3Su/jg7qqswkQP073H4EeX0I0hxSVuTci+XDUFSI5NJ445kZd6R7e67C5SAiF5DssUhEK0Jk1tp5g5fIi3eBfaHVksuQ6kpmdTi9ItafxpQ8+tO5EqmtqlBod7FJmPN/i0JsDAnUCcnp1MwMawWV/QQrLowCSgTak5E3EY0AdXeLw71UAm3I5IxiUotkEHYzI8I+FRA7Hxe6lLWdeZmr7phSLa4i9KLwPBDnzfoCO0Ng6CMyLZzHlnPzL5h4Mt47v065u9Bfc4KrjGpmJIo6dU2KlyMlk2k6AYfAbjjW48DxzYk34sPqD7+kbnt2b86mpTm6BgMpADq05bJYXPkwenI/azipcbDY8C38fP1LcR7iIUgXc7qxmtXoUFNqMLBr/OJSDjYz1fKtJMtksZzEFw6R/EdURnttvwAQ0obCvz0eqimcP8fl05WD9XyU4Na2T7107EjZdw1NE3slxVQTV2M9t3MrEg3OWipc1LXfFeC4gMWUkxnKELoxp8NBgevmksVZ7wZw2ceuWvbP6Er3afLCtCvsCIcxLdMa24ZqjfEcgexorldh8XJ2Q/X3M=
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