CxZcG6/cbjCVDYXyx91y2s8Y6ZO+beL1ZZwebRnh9RjHNzrC1M++NdbDxQB0ffcC/VaXub6xmghc5WInYezdX5NviArDGiTakN0cnnZ3VXur3hAouYELfr9979mss3SFNOb8n1LaShLMGAEpVqL5v7GlknlwSixcCzkrPfK8b5JwecwGrxsc+lgBz1vvQo3DTPpXMuLtFVjDgCcYerVkof+PM4HS1SUyJA8cMJHyTHL8jXHWk2+evuagmfqMFzD9knMA9WP2HHBmkyV4Fjnvv7rYtgKh0XPcIli2nP2ZYRAyL24Oc//aS6V+HHoLXFwOElgPfv/FSZX8Vdbn2vOM4F0e9r17ZpAjAB4EFma9541rNe5xcKtbBFo9yt5fAa9GKmXUHGwwMhZQqD3l/rhhbfl+dDmalrwwlHT0Pb79o/xH1qaadYyzYVh3zf+OFBE/JQfxnwTOGqkGi/DFTCstZub7rLyri7OdQCCpBBtLJzBPA7cRPz3tg7Og5ub8pyAxuxIA8SiXtsZAQCN4P2/bIGbnElVvBr+G6gEbj3QLz2TN5t8epwcgf8TgFlB0fq6RqHQV8zawcoyP5vjDE55rVWzRwdcn7ozjZ1PtS1IWKGC0vf/y0aVl3tTkFLmnSwJEjy4XrATwhcz9p8pwL3cDbu3LfEZPbI/fBsyElDO0l9omEyQ44nbsF45qkUQvTnBanPETogggjxxQgkutn7zx1wesg+au6FuEkGbsguAFP6nVVdVVqrriVKhqgUjuL5lo5jIdm11zTHa9iP79nvNHJ+eoWLLpcaRgNb3ahWwNSzLqDrSKsunyX5xAJdEWugqNk1VXBfvxjqMcFb57Snav9csrbOYrVRevdEEyPTP54oL0Re/PPGOynxUcMRunLFEEghrIYr23E3xjFi0F2bULQmD/g/Fv4dIlf86FH4IdzC5AJHFkSRsPZDfn7FqFq9ZtNPpHukf+BJeKD5yLiYX+Hae/Dlji/zLkJy4UzsCkxzscGFCgfRA7zwD3Q/O+hJkgSrVHG6DEi17aQYHysSPSdyCUK+UPjmPm98EkkfEB1ce6/5+3tEgXuesAK/JkyHEHbJYu2r9Rb+Sqj5NcG65ZmtEjxt+woHFB4gnfK11FHDKE7UCd2O/m29nBQVqYHFVuuXyBcT/HvKrTTg2ycsYj+Ay6GNVLenCYIzxz5pqltTXa9XMwC02pVn5cKDoUJxRnHENC6L2FrJFNrQoLEIJxVOljFs3tXXOh2metISAFB9BTv++n+ieVBLWDRnCM7W/trbelz0HggD47BGsPgdXbPTgwWthGdUnDVV8fDKyEKJLZGkfpPIHtE8k6fsyncKXg9Bp+XSoRkyyFd0ovSNrFNuhrU50VbYp4L1frBTg=
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