6Xg298H6FmD8GR9avMUVRAqkTj23m+F0nrdjfUOhakOmJ6oP94UsCdquHVnrE2DT8WXpT1j1f0ODhF9/thvogWrwF/iYMdvpLbp8gi3He5mNCSoChujC3IlIvCAVJc67b3pQGC/zMnkbP74yftB5KWvzmCqzZBsJXViPaAUobTAKBu8/hgUWm+2tO0OiYTLz2tFHZhvieq0I3ypE/mcl295VWVWRO+ObtrCYdW8G0HN0303B76lt681bU7iY1zXrXpFj/TFPH/oPNQPJg0asDgSFfgDXtJLZ8sZUWFOG85ly3himb1kJRdCo6KrqrjGsEkBI821fDJJ4MXzbbm9+cgn+y/FxGbA0/i+JA21iXpe/98gYscfKIOlYxKzuEDw91qFNEWNxO1PnGEPQZySQiW50RsfPD0deHXN7kOhY3QbHIJ4HhtQs3ZUT/zzrunMF1G2ux2r4gYTLR1etLXk3Yffhratp1saCdodjGWZvEW96Yjm3kHw7hEIMzaPR2wJgcsILBGRkh5w5k5BZkHZKhPg9imSHKG1mUMItWIGUdwvhA2HHmrnWcb8z9MxgXyZB68bKqnSulHERCcOQG7yrLyQtBVcr70jNrdQSBVRusQ3PXQOD7omYIezEOQlWDsbPNHBsyvQQ3gSHiyOWZ+S7J+t6V9+V1qTIpXb9lqOcT43C5ym2t09/hYBkjfbLxY1gbdJLvUbf42ZikRvowHmr7oVuzoN3ABfBgvQM4zYU9NKil0ixsMmtXT5el3D0aozmAV2nHRL1bUUQdu9/f7sIrZPfosZI6YXcHbGP8yofYYE3MuZm9SHj0PGghWr6+7Yvv7ZtUI9Man/EXTyzDRGZGMqpvFCnFdd4CYuxlCjt9C994zeTr3w83qMCqyXC5gHD7CJbSZgakDZdK2h+z4PWCfaUdNZGA0GsRcvGdnFKzowfC0guM9/71EjEKbh+ZnumrwXXHJc3JxKd71nCOewwLj7NaTaviO8YtY+gVKy4miWpQlG27MZ3UU3ga6tI1EQ/2448kPYT01xyMl0cqB6qy+dxu/6cCTLP3b5fGo2zGipEnR5ZFMP3VU6yTylc1jSNNjtRgHHJk3phsD0b/IBB/oaX1mQ37mzZABqVK30WhW+lAlvutO5Yy7v3jrvdm73YvrmuA+jnuvAAtRanHZtkCPmMGfxrBMLPsCtk85keL06R8kXzrNdiMSW+oKPg8fHHgnZwdqWzpv29lLkE4l8B9ZgbRYHZzD8wX8FhlajRCpp+Yl4E+4y7SKCeNrCjmhyapkxaH8ZkER6GFwkP36WOzPDqt4XOizR3RWbZrWTpXmywDCNa5QeEyMmi8lxq3pe8ohILJYFfjhZrTOk/TOiroxpzCSUWAx74jOFUehE=
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