bs8Qd4rH7unwq+7KoWr4VekHMw0YWmDOWRUUSUHyxewsrg9JjQp+vsFhN+9di8So/Do/Nqd8IHfB1WyG8o1e+BbE1Ezr7KGtFFzKP+3hGR3oZR5SZZYSGPqBqzuTQXLORiZptgBipWggLrScS0bKQL3/+iE5OaMHNmZHAGWmrzxeq8GgaQAdAoVHdOjwgAbKQjOx1i4RJpzKWUJ6QWrTDd61bDjTsbljAR+y95ZPUd0tJGjI7ZzO1yjCjn0T734AVqRxLPEKldPa5BSeEesfaVUDIuzLeznIzJ5VNYxxywzNCOq+NFCYmI/cE409o6V8bZwJ0HowsIM327ET8BLYpdrX8h4ZHk+Y+G/DMDMswrd/tEV6ak+SCzB7fqFIy+iplsPgXnPTMgBH3zdo/eO4pnsUkZd1oPAQGfkoYX0+yk67y1hJspUg2GKDSc+50y34b5T/HF8kMql06rmrB9B8ERNOC+SULgd3ou8/xO1M5ooThqOjml+By9YTZyp7bBLwTEtbpVgiRrYjtzCIs1Jow5wLICTs0dG0fi7ERWYHePpl74vScE44VaY9gcvzNaX5lA6BBfINfpo37KW0Mn7GtRzsYXIcvEwDmXdvRQgfblA8EvgcDwv6CThsXb/tJCW/Zi5C1poEDdmm6GwctpIcP+msnpn+6yLDgpljc8qrfuGtwkW5R+wPcmHEYZI+ZUOFbyiZ9vgCpvRYI8i3YToCU889Kgck1aW8+iJjUW1MSGQ6/a1nSj5/3QpjCClvfDd09tHqgCi81QCPQaYxgqih0ghXxfh0Zd+JBc/nSyv000/88WIcJLtzerij18kgB3aekFhlFG7EYL7yF4Na6jy4EMPD64PM7iU2ThPnp5c6s5mdIY3kjrlQFNtcUyvYLJRVvrs4jl24v6qUt0h2+x23QX+jUwbw1Gs87gWAdu6OrXFYHfL6lSE0i1Y7hAuoMSZ7JDIo987jxvLFX0sMoLr7SDJzn5kp4/HKhFkwxql5eTbg5sTj/Phqd0DCwfm1wT3V+xA5x0Fkd1fhLNjKlOFJFckT/eRKqXcle2Ks4bMImJlAAHWc2GrVnnWC06Aq2KqHWdmW4wy2h/MlWPW3LyUiFx/dyiqRr+3z+CGqjqK5quWv+YNiRKb4rMbOhC/Koab1x7X0fKsSoHQ/Vg0PB6gBSBmbhnqLd5KNsUX/vUOpJLrdELU54YmGsAx7AFAeq7RvID3T1WKYdbrmZASHfFskYd+Um2tWcvViV10YOcMQRvWWf/MuLY3hqjyCZ6NxcbeR5cRX8Fel6fXEsWlLHRpt2HkkPjqBTqu+c8mKY1I2z5S+n3sinb1CmwVollCFO1SESTd2svEZCTW/QD7zc9gSndCdzsUF2w3KlMZET4U=
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