ghUYzYPHN+m2F+10NiUe9Fyv7uEPoPdu0PkUcaaszxgR9qmOk12PvAB6fOmc376AQ2t3k6bbp+KsRl1gHGjNFZhecYNGiLCZCPgkuEuOA+dxEWN7Q1HqWDR8Iv0GjdxwUkY3MPC9WJlUyvOLPDldwCyM7jUwmdBaxZjttVRv5w+eFwi5halLzJTBPsUxkVUa9Vy9tFkfB26YlonkWpp20dPsJG6RidemEAH18dst3SlYRJJudq6GMPowtdWQZz+Nvp4Vax2jT+01LTfiEhyHP6tpJMZ/YNhKxHd3uI8AS/ZoUGMW3oK66GG8yoWZTNaIyEN2NZ1tks1ZoopcO/yvq9XCUVGU/19lZ84zhnmSVlqxSeM9wEL9rTCV9ORDEtoaYudOJt1E0ktnrvD481oO1UobOFt1yftgV9qFS1khxgbNVUOCPliwxMqoG9j/AaTLljCW2F5sgLZLEVhttdbke93/hAWzjzjCpkBOxjVupmbmqXjkFofp1VN1BWQdIa225Bz7zSIYWR0bbvwht6WkGFwA4Wk0Rq7nkVRn1josd7Qu4tPQbAK6EVVegqenUpbSt/8TWk9gIWg7E0I4a3TsXoRKoU6p7MnEoSGZSgKXjhAu+FhOfDzGsZqH3ydqqdopclJz+ES36ZjPNZ9l+sEjEBI/7cm6ohM+iotAUL7Pz+z/1IhnNucfQ/9xBCG2GZy5f3D/tjWzD5g5al3bs4nh2jH+5GoG0Q7vFS02wKTv2nCV1FUssZH+Zt0LtEtQq2L8NDkgqfBLyL7Gd1ZMAVov5WNlCDBI7PLHcetr1iqDj7pBqjezdBZZL75hZAsrNqKAW/TEqQDz4VEohIYvPK0Oah5Uq5TDe/cblkiCXumlRsnfsuXcB9C/gY7+BE+bDngcO4wW6WBHMobu9nbFh8MYYRuYA/zTReNxAHHIiCHvCk6tLdODisHrnEGaAnyJhZ3tkh47N/ntfEKcBliIvqJ+CfGUGGuU/+hvZVcTd4wM2xw+akNCahShIlXjEcSIy4xOTYV579lyXAPAuuMvaFEgJ2i+HGVB0FqMEKw5lzNO8qggdoohCl9/CaTUZlWab3rf32gT2l6KEqeBbX/kpT4SS6UVOIOWwygPtnOQRdGnZz9ZUWdeAnwj3gw2CEJBALz8oS1tCs5BLCKI9h7+T/54mAke/phMz6G7exnWGSfCTwnTyp90fcDLjrXwdNw6DgU6Mj1yQDXkLo3dV0osIG81qAq84Eq+l4MH2/1YOgwEJvc2zt805xseIZkJWhtMpxfKv1Svi5/34K0oQi4EDFasXOyfNfK43neV60Ryv500PnKqys7aRt/82YcLb/FwMdJez7ysDw7MLYaPrhHIHK5RCquVc/9FitnRjYvE3p8=
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