Lybl2gWPAJ5dx9KQgLutg4zMeIBSNFCnxt9S+MBV4dOslQKrM8pSfcqdLhjs06jgvfVnXHAczZqoIsmcKq9LmYiFqzqiUaUiUOphcimOkH24D/2ww8GHdWkBdx4ilhKqI884joEB42BUs+iP6CzLtNIJ3M9GRlYSu1db/1rf9B+Vh5K72JDGGD4xrGL/CehEZDtc/HCumggCXaI5Qr/+f2RKuUFCGzL5lBm4bx4EK0RBNYkuhJE11kcD9afZS5hcdGxa4pT6wTRjQp5TL3k8kAO0MoEX3CzSiY7OwnOYG/j0v/tYtFcluPmu4DvtKn9yohsNNV7oUKmvzB6KvlgcAFg76P5/6yura0uJTu6ZZbECTggfYcrXKClkSPO8DKOkxXPgYDqe/kRFWdH4K5454G1HUEuRuR4iCVgQCEeI93v94fKCYQS3L9S8EwVH5Gvp96EJErMYoJ+HZkBvos36zKNd4YrNoG7nbqwuQliTcgmY8X+ZzU8ACuNpdNRqliXRoCGjnoP3Ipcz0pXIC7oB82F7c+R0q2v+8wx/kAuORi1o7CtltZJP/YLaEwldUd2wxkqp8NZsEfvP9dZfRiNsptltE80WZ4Hx96lYtCiNCfJyYRpHy9tmwB7fhPDL1t9IK5vuY9rfpmVw4v3wSyxkjHMdU/stnr7QKKgdPGUEzKyKd7sslrw4MTIbXYqAdvAht3EKH8unNsP0z8MeoUwjNb4dQkwZLeaQH+QxJbyjHdzuecZ4Z2C61NCKJj/mBRI5mJZjHLwIcB1K97lN4AAvAcTVAA32qe4LY0EU27kIEl44psRiUTJ9EXdoIkcTuMspZOYpZEU7iVlWN43uawoj/mmTb4EJHSwPm27PUvLcPCXi1NTY5BUy9RYL9KOkrZvtAVm5/jSp/FBA6r3KYM4JLWvjl0EwR7fLluFJfjTlbgq/DLq3nJHuRCX0agLhoNRqFpHDs8O6U3detcIuc/QLo2TyvDb4h0yIhs8/nZEcDvEVz+3rBmAlQhoW5x2gvZ5d5P15w6f0GWGpFFpiSSsSkx2lSKKJQTxxzoyCtbV9Dlkr1WmJaR4sO9o9M33h3ESGptO2aXVzl14SCI+P1b2Z78MUh/u0WK84GzoTDGlYSkDXs3TDBzpRhGkxjX+tIon30T+4CyqgNvct3qhAaJIKuxieERld8q4f01gOhak/rNnwfHmGHc77cCPWk5ogbAXu/FdCZ72ztNGe9tKW38ARLI61aTbhBL5bDfjgrshJJB1D0SP53ObXmA1+ydYU2BRTSUs1fu4+T4u26PL32SkTqwIX2B0d+iRX5myBIYq2LYJYeU9Mzq9INBIBbUGQYtNosxwNluq+hDTfcA7+MpgndyH0SOanhqn80mU3vO8=
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