nCX2DKyb8ZSgkQ47zJIgH62G2z/CYQBWdDKTYMLR229hO5JxnKm8Zpib/pWa32IsZkW1cY2i1ZmtFQlGRQTgLccWzpL4j5/VHAOY1VdHQD1EFBs36B4iD1CzC6JIxBxu1M8Z/UtZ5KFi+H3U6aXcjv8Dm8ChX1Xm265RmSP2RewUWbpRhPKBx9kMr40NdTav08oAdzsNYWrQ0M0RLXyRSfNDrzYMt6bQE2jTCKy8oArlAdtUkIVVOq4qvbdv361X65FqMBUNgtMjc6ioph52//KFbZdOMyCG97w3wFwVgAnUSyA+UTsRg1nrnS/cSar070LFyjjtaobDDD+2hn6xeUoD2gOvYE0gP6o6F7NB7OJKbWAfaCcWQ27XAC/Csl87ev0odBYG/TrVFG4I2Y6T2ro7TagrShDBClEeQSY9O9ci/0fe8d8uG4VimOrQpwCpkSUTu62lDLW6jWGZQNaitIRLZMkinR3kV37k5d84C5ikNk5vNe1n+8byaP1Q7tDtPjEs79zcLbJwW573udo8LT98hxaxe8q/tKP3cI6tADdbiLcqYjXnZf77DpxySR1njta1cWj9QukeQcQS4n6q2+S4zdVrdOYxdsw0tdhSn6Ddgbfc95nliPxR0kv1hbkx5+ctOwEN/IQY7+YDxZltLfpiPsLvSNiyNmXJztRBvIpVX3oukEw71/CqmnqfxdxY1wKZbOxU9PuqcrB/BOyUR8uj3Y7cV1g7Lr0HeEUWcd7hBBVHrMmRHkzfj9UsLwkkJEj0IM/nDxHTVn5JNlZIo2E1tOsxyJbQGUjo0DaMF8kISj8xMerMSw3b1dXVreDdNKmqc5zfdRdzFVZuEtKOJOjD5IHTKrGov6QzKdyYkB7+x5Z+YIog0ASgNW6HWVl09nJdxY9BvqMkuFZS0asezV+xAEE/w2lc4Js7L0EiPMVAnnBJ9fq0+G5ujU83vMlmLSfn9tAnS+PTvlAyfIWdiuGyZf6ggf/Rs+b6y1cPxdcwQpJ0ttudUxg34IjlO8ITg37RZMSItLN+XCKCl22K5LF6xhhnhS06fMzeA5bURl+7V3h+EY1KRSI8MsqvpOBz+iT7V/XhnsX4Lb0rGY8yKaio+mC+Gtj3awvbMd0gZAfjtHz5bTk2neG49I1UOPcTITJfqs+IFAmaQUb9w8ZtnCvTIuh6DgnYxXfvEVewEqwh4sL9BE8XEKEBagxkkiztJ0U8mb+xccGfXGZbTgFhFQkHeIxHzejckTHC+lpjoKrei3KZl4Ugz/VbS9/55k9uhnxWUn5uuWBbGgmQniZWR+PM2uONAq5aN1Lu/Gw3i6Iqd1BKd3EGLZ8QrGZj7LJuIo1SsAYgB4HItSowaQAKvc+didhvrytUdLK/TdY=
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