XpR5C7VZSs2ySAq3SKr7lePrtANuXvG7JO+XLZ5Gm1k25Lzv9n+A4vDEUhJQ89G49qO5+hHhEeGJ2sKfx8+SzRPVtTx3G3v7Da/8HmRZN23H2Kyi5X2KnqG7m3buTrDoiU19gWRwG9ZHi1pZPGTBv1Xfw/wL6FgxDOMWg2XqQOWPMEM/iWnljgCHo2I+dDk/t9yzTK2FooaAlns15xlP1eS5U7J/QfMfXOPVg6eXIVHq80jculgSWEZ7f4A86S5rhQ6NI5DRlD7blHktAz3+jAKEiilxw7cTQzNkIveK4wWusRFMHnAE+DNVzusU7ldBp1RuyReCTJTGfV3LkbQYb3z12x0+jZHy9v0U5yNehteaf9nfRKMEfhkYuU2v9hbONwAqez1IgROPE+r3X2S1xIeEFGa7FR9KHeKvnxS9suNTfrTpSujtDM6oPv54OBEvj6dx8UohZji+tXiHcVpZrY9AJwAL96LhUgb72S6QInFmGEog2FQ5VLd+IdOuYDbj/FZjeOWOQJ4N0d5I+3Su2GhcdQuW2K16qYs3ZoIzgXP6THKHhtZ7lw8fPVUJpIA2Nu2DANA88lORAhqsmIz7xctViEFpLwCYEe7ktxuCVL/eXe3pu3RvJlih/vRbZgTA9SuhN84hyME9SiOcIBx5tzTHTU0q1HlpDJ586Q5WZhU1Z/fG98Rsihl1Z6sKzOP4rsj73MhQihdOy4rbF2elpfUwl5w3MTSZqitguvLrLaZzIvGJ8YpNxislDrwhpoImXY3kXoxi12Gv3Vr2m8preUTbgFLdB+LVX/3LLT/aFxdGzjrPq/BBwp0zb9rcXtj9iaas/URaz4VoFEjWVw/BLYRZXhdCzFQUfckMzbBru/FJPh3+mM3n3z9rVf747ts7GIxnRwzScV+6mUeJsj8XyTYQXqi0huOdDqusf9x8gbYX7PzFayoxvWy/XgDdjSTgy3ScI5l8ghyNnGevL8nAcOp+3rn5GveSERh4+9n2rCniFl7grj9ES8/HkcDBkeeKHD73DKhZsaB1PQsjNes+al0xGzI8MQ/fDFtIQr+k5kox+qwhJ3OWvFKvThwrrceUYVMU9Kh6JKp/pZIho3i4Xau4HubnQiTQmd/B7YdL8dnKb74sBZVuss4uVkI3g018LNGcEO827Pqu24m1BWavgrs2VbJV6loMuo2Q5MXIEcD1uLzWovuNVRUUbAGApN3yy9teojD7happfiqPQOkiHtXIlg/Tk4QxOeMQ1ZZUDgg3AaivcKhJRgctUa+a/HjPNz0UyX0WNDFad+4eX+hChcwn2n0WpvC34QCERJAap3Ld+lJ3S38qgn9ZmI6w8Ve676B66lLOmR9bhNstZT8eC0y32UWIbWzyck7NSZs=
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