PKKvNf6roMJUEmnNCtTpEdFUbLRQWDHApCGLu5/5VaELL1QCpAU3+yPep3tYj/gpNhepEpBLGsIfmKLJQ21sbg7Xm2Y/ttD/Qvvy3CFC6bCkzAeuQAVQl4cCbK4RpRPqAQxW8WUnisc811aHzXeP57rEvzyudfOL0aaCDbVvHC5X6e6a/N/MFANbGcVgoRjQYpKitjD0D370eGw3EMG0dohnY8DHQVVgWu8jin7QUHpVPeO7o5huYHdfkYA5PSTLLrlCCLj9pfNXmVrp6pffTBARMq6Iw77GI3l6O1zTjQAylJjBhMo2NuAtutqMQHO/JYUl4BjYZZPz6A9I7x6682KlFx8p7twq8IAIuwNJb2XwlgXzyG1Q01WV3SBz6UjWheiSjkDQabtsTkizepWczo49+uGj/OqXaU8PkDjC54/xiiqJh9tdEI4/mxkeGUN1ny6j5r38dsT20okelZiZvRSKOlH2YejhH4Xvc0IPL8celf+4zsTqDtEvNYWWx1KKjeGmPrfhgFP/7GZWkILRXLyqogWQ0sBLaiQcURIb1Fippv19AiK6KdUnSDzKwkolgWRWdMr48RWZcPWuVa1oQ6Ys6yEJuXpx0xYmrxlNjgSr8WrachuIi2x+TBdkpOVIIVh/jszQcl0LcXcAkd3hCCmDgNxBih6XW+sNAY7Mmnobz7knyMjYiXxPjFNbtjTxwlGKGjnRbj1sOrZnJ38qg06NqJCIN79ZzJVf/uaNXblfRh3IoaYb/ufI336TaO1U73N45Ux1O5xzP363UwwOKMmTmBdnxW4528fGZmV9SGAPy1ynFG6+GtJjmg8liKZTLiVjTUgTRrF39ocEAMhyZIEONsWsYsAG5lvweLX9voALEzqkgSN+6YUz6SsKzXtRSNvc10mvKNY9nVX9kCMKOS6hU5d+dvrwB0yn4monyqU2/37Ciua5fFGSC3tfuQghmpHX0mIgl2Wl7XyLXXlk3T/VjDUgQnVUdhMyjACr2pFSm8Wwef6XwYiDhUBVL6ZOJo+JRgCtWdzU42CqLu97mjUv9KJy8sg9goNPr8Iqhc3sy2iyVXuCRQXG4pVmNvy/zt5EqCw4WJIBbhAf35+jy9Ae8+zRF0s0swzESgpsqyMOp5Q33yt+sdgFlPA8FNuJ90u/01AZ7V/fx4qVNaAu37ejTnIuV3j+DbRb9LeNVfhL/xuPl2HEl1TD2Dx8wjEkJN/+HbxSDLSb/qcZMOp3vqjcJsgD56wnIYIBGJpzMI8+1/l/bViKnezIpc23owbZokucQYxEY9PMNSQAuDLsC9dILipzYYNIhdobeWMVYJ2fyYFpqHHes8uLqfW2KtU8wKO62fG3cRJ+GqsJQ1+sNDGV2h4vhvgjB9qktfE=
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