H7c95MC8AnWyAY+G+Ek0h3qYJfe1Yialy/am7MVrdfIik5ar3LydTC4Bp5G39lNyvaiJKaNN15CDyVN9HlImX2BokTMFni5WUIOzqyXkJd3RM0pp8bjr4Fd71hOapy9R4a70Z9JX6k+0Rx+47hVU7R7hennU1VpOajRmg7TwnuSUaangBfn9j4hHnH9u7qZ33+f7B4PuGhKX1P7AOJg0HKyntG4/Aoho1P8ZXT1kB571BcMQIjcJmftcVWotCxnkwxoMCdhNquMz7TAAucFFa2IQ/TWr2aINQRoaqZUuCVjAAPtVdDPeXH05yqkt1e/20fMcMj+5nh7hXH8c1YxQAMdjIc79bb0GQAyGTxhEri9k5i9SOydAYZ1HeiLKbf7LOhwpendqygb2t5KqaZORHWRRJ5y3+0cg5oZ5NzNK2S5Zc0ROLUxBdZSAwWtnYDfqbz2o7YVIxwq/kWsWDfWW3kcy7Gwew9IFk61FbKYJdNfva9aBEt9ip3z9SIrXi/kUj6RTvluQHR4zbxiiGWxd9X+J4wi3qwYeh1N3T1UQb2iCg9RgjzQ5o92wGnC38iv4VY3L8qU+07coNUXn8AIDMPV1QJ5vk6MoLzjSo+mAKpv1vlYu+2ABVfADiT6ZcrOYQLWj+m+OLE0ioZMOqHJZohhYTARlx1F/No442JKyv1J8o3AoV16rCz0rXhE7lz1eeoQPwBuNGoKUjQ01VusCp/hY6z1YP/iNRfSZs4Z/XU1LOOq07VBJtO2QfzyoXavHOCpe5vsJm4mds+dfUVZSNuTa1mxDcPx7rT9QOjwiN6YbrpebC3qJjk4s56QA3jBW9BRfNdgQYjrELyDRRROTCH3SIdNmKQNcz/a0iqY7MhaFQQHAouvU65ebbnAG650NmeY9QSuW8zkUQ+7oQgIxKl2GNgTdZgLLu94KqoGx/P+IuHeJznIxpzdPQmmfPPFfi8Jz7xSfIvqSZ+kFiWQIZ7mLBDR6ASPtoQ+edStDV4Q2oPq74xdVPASYP6sTyd3AafE1bWvLmBKMSquSU9x4jyG5wP5ga11GlqiAyiROhnB+o1LrBGO7OWmmcywZlAtwf3Ur7DyfYa9/j5Pd+V/Wsq5Mqg/YCqk0pS4Mxra/pd/PmM1bLTVe77LRWzlxPeCEEsjTf+wSj37XRC/tZ0nkFvHytdg+DcQfaarc0rQ+pVU/WLM9E1xpKnptZYcpQnSAr22LLAbuTthAdvrUj2H6atTnvXqns5KkYlAperXi4UawnvmIe7J0/LpOYVZavIrNeyVAI1k3mKOVzfjIv+GgXcSwEYaaO5kl3b697RnLpqZLr2SvfNXhGpDUfNidJ6G3xzPdZANe5rlUird2S/3of6NXRnR52DJvIJPx9dE=
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