6htqUkrqJHyGco110qvKc1ldvHXo8vdRCErkz6/GXqQ6pKx/3RmDupX4bk7LnI2FTMtwkiT01LxD2alnfLJHuy076yYHuutASJqs5WZ4Msrpgul+v9v5BSW0enJ5fTGGaJHJL4HSyeeGh30mxUwTB6ZaWjSNsEP94jo+/G8BjEVDGEG2Rcj/ZXPpCzhlaqhso+t7nVVTJVcE4YZe1J/eRATi5cmhBCVrZM5DSzsStG3IeLS10OO9RJKcVMd0Hh9O+mZwuDnwEtoY7KU84xtBLxUH5xyGSl+yej9bkfNNtmQQFJyhRqNqLRZGtW0P1JHc67Z2kbSleBZpFJ+GctoIO/I9TkMBN94nv3Ao5wjO3KKWID7JPWy3VjSPPbKg4Y6vyINpsq+RKj2yYNzauZOHL5nrbY+J8x1y8lLTkRI03I3aO4rX8b+gzqhQH2uBQWawXk7vSfyYBVnXN4T/mK0pbTqOeEZHbXsutV9oPJdtBEPM+sY6xXBufBUOd2GavBi3FXtLm7eBIvcNO9iQ7MU0mmIYNMUVLcO1ELv1fCf2kTdpKvmIqrhAxVR6qtB2uSklVJZe84/nvyNG+8yOMlizqVHHTykgEt5VaTvcsrMW0Vh9nbaRk/l9afW5xp+ga+i4Rkh/8TYDlPnDxEoLj0P7+0TXm1D3f0MdRiiKJpGp+gwMPNlkxqhO6z4SxXAlbFkMrlIL9zp0FzbB995cQ1ETPPipr4M4T9JgJ6jS+uGsGaqPUMFb0UHi11BX1PWltH/sjJz9nTf6W4+GDyeHWPu0pngNMWhYAiRrivhmA/A//OUH0f97OTiX26rqqJ3EkRMPwc/sNeD2da0AFM+BYZuyprZ53DqhuU5Jv5Tnr6mWQgJpoRfc1j+Uh4UdhH7QV/hEkxx5nybJqEN6hSQ/iYeF1fpMQkTMcRNAfOUI90bosXb01ORXiLHcJbj0tt6LwCbcLcQ3V+3noc8HP2STQtuoG/HNOTd17TDx6E97djFOjFM5VV60sDEPfCBZSbzO24zDnPU++NnlDqJ0u3DsofMGokFb8o3cKlGJZWGoPI9vByT8wFFP39ZZPct7IBT7VsSHXGCP3u+WCYMheHH4YVYLZkZL/wbuWvD24/4A25VoJdtz+tdgHu4Z03LAkXdL/38KwG1CPq54Tav2YGvM9nuxonCRJ6t08apCi2NcYBy3TQplBmKlIJRxznBSTGDyWQoBHHhfHlXyHsqOpnLHE90ZwgnFTZd+CVOtirfcAMkS3a8VPC+wD52iXVrrkuQ94PcMQ2iWO7321EyA8YGf55EXsYXnau6UnKXP7L/IMHlBw0GD/zoWWeyKKeKpeGILwYtevq7DI76pA/Spg99T7MduDwKiQQD1pNb+rfbw7Ho=
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