2B3eftm1FLiDFJ43fG16HiJXnp4KAyXgDGIitzFnIww7dyIBfRNOTWJKx6TdogdUL9M/Y9U4khLLUrOtIi9Y3YT6x87Xll1U58Ndh+m9411wuZVb6o8+QoSbw62SUMmYH0DYgrq+8XR4st2zSFeh8STSqgW9n7ZG+aZ/sw95a47WtSOuDfjBRqzwONd1IFjzYqrV0lnUgogXmUadOA9yzyOFlnhkelpws92oslxlVMJ5QchZtoss/iYH3SVKpV87aXnsIy3dNk9BX8mfedSUgmMSA4mDwannjyApPbEmgSvwlua24p7AYRxeXKsogb1ibUm/7TFWk/DtmrDoF6K1NSplYlCW7uaL/nQEteY7zu5sNIUGR8uZEd1FiwHlkB68XH06usIw2QmWw4ou8b68wJedajFAl1dPx1OWcYziYGbR9jeF4nkxMFkXHqK8vt+1hw9CM0qI/PK7LfJp8D5Vdxw6+erGRyxCUSekWJ2kALgm9CL4rJSb7X+bXSMyJYZ8MRMY8A3d5V/HXG5QAJRbRH2Et+EWh2UT8SNTbcGNbO36tApwo+A+pbq+pkUptJnubUrPb+i8MjW+Uvh7Rf7YZSDgZ2WOpvmY7M9c8SYamdN6IcP3L6sfrX3yHmOIQWogSNvy8vMqxtzz+U9Ijvzqv7LsvVLW79FW11Goqxe3KgGVcXLvEdU9YV97Tm07lEQEAQdYKC/8d2SVsEL9qDXhlMQovI9NFDQaHZKRAUCze1zrmlFa23a1huLnUzhOlMrPz+pLchMrTrzebA+qAeFaCZd70sqok79ZBwPsegGdtWSff3DdgKdJKA/b8ufZPwvFNhWraMGrO6CqgXrCuq5hhj8SQRIvYjEKU9ol3REtELQl4zSAgpqYyvdpypfpZgR0H05P3KgUqmkbZpqYCYlUGKDcu4yfby2L/Vi/iKPzlIsNDbU0gVWogjJtVDcvAtd7DVazqsiaxdBf/iQ7z8ymYnXVEf0dMY18YX2jbcfmeUyg1ey4yc3Byak59d29ksxTsyFqyI9nnTiylxYAq0HRyPL8LmoxNXFKXkxLwIkysJ89XvjEpXh1KKDXV/TJD1Sz1lFuZV9cG/1SH+G/zZh9TW71amIe6tlRtnyOmMzHpDDoarE9M7TH3AqYad01cWAxALo6XDHX8O14aoDNQrzpQiDfl+alxYShXeEB6315CE+l3QK55K4uyRxw6tCQn2u2qMtyRWZ53gsVz3NzIq/4VRr112fa1ZDDI06Nvi9fqP2P8aIIrbGVyGq2OZDTxCFYpN02/QqXCzKiUoCzsv3svV2uU1O/e01mQk+M/zShTisdkc/54sPA+/U2dXmkdk5th5huWPdnhX4KBNuhBx1iPmI6k3oEVa2eOaYoKyI=
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