/HhEsKmYwZtQSARhaPJyV1r7b0FbWWUsEYYvYTomxDrGK+eD8OWVUbdXtF4utx1zoRVxwufnxZv6YdtwBf6dOVADLofIFaLPUJtj9V4bUzcQ6LKA8HCBUD74xKK1yISCt5/qjNRh6oFrxlTUvDsL0EbwEDLO/hujfrUEzGKbvUWTe4td+d/t3x4lBr3jCug9aTEbeCdOVDzcybeytr42B6BxlYoiLU/6KMJccv785mrIs2KYF5NBnym6736vNp1OiXQG7sEP7OjPwRo/ApmwnsKGKY31199GwSyA+8TqF6msR6yxRf8Z8dDZZpjG+C2uJSOgmx1lHfBBH7hPaDmNKv00t0IfY9Me15blEUZjh7vd3a2C8CnlSfhEInAd2vDFrnb4w+zockgGbqJ9iLxgKggJiZUHJ3Y8op/zzEiAJT936x64E+ZKDY+gRQslFFuM/jPrvqH55JDfEycPsG6sl+h5gwY2w4YFnQm/2i8mooCJgf6Oqi9wFDa9qE+tQx3BxaAQswsCmCaCiK52yOLzZD7/MbBQTSBw2b0c2bIB+XS+xB84Hq/GWu2UN1wL6vQo1R4VCG+mUONv9lQCdAchdwp21pr/Tal7+r4MFEwD42doRpFZV7BYYrzXnXXu3aKq7SQOI9Tg/bAfLV+eKndZzUMa8DDhVrithhDnqEy2yD27zLd0H18AaYZEsOYHUyOXVFj78ef+FwriTw24jw+Qq4J03MuhKiHoZVvwt0RAyAkRuQb9Jq4asbZzvwI2zNxOBl+Uk3c3qk8OUlhn+42kzGDQAug5aifaSJ3gVyLSLFnwuMkVp4UNu4gXQFoZ4S0B/+8RQAR8USuofdy0Dw153n4mAxIJhSbyHxGVVb12n2V4mjltGaCNiDCVwjgfZOiFg0Uqepr8vByClYQi++paARI7E8VQ/3wQ+Zmd4Tvps5seLdCg240gnQU0eZIHB5N+JmD+z0SSWovQfUIEoXAauxVSrK9MAjLuGWvx46Sp6gRnM9bgOMoWAnY2Pw+uG+cy9oseC8dVIB6ePfi0+N5NMInHMiSrRF+AlW/iEc4R6vdD1zaYfS03XcS2zkUyKPUps+WBbE4obG1GeUMfCHnw5ek+2L0q9s39vukavRukR1JCHf96lFlxiTSFzj7yConNoblJd4/8LrnULT6NSr6CFrTu9yqQUf1x5OlShODn4xyueht4ib9COTpC1fEvU4FPZvXKewE/i5xBB7rXCXOfCs6ZD4OYI36UWs7tezEZa2sL41WmX548RLUoSKStnIxqD+nAKxJb+qCBkdL58YKxy6/Thnw2NR9e+iOajbcZBFfhWzkcs6ogQphgO0rl9HVham057yElwfzOl12vgQdMISXHnv3W6AKHeZZW6yo=
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