npyLjbe1jeGfgfs/WkY5o2AoMYeUj6psr7nQlZx1lAwwhmuu9DpdcUPLI/FGizZxBQ40rcOwb6vtYr1prc95f//iRs18sbTxgIJPiF/lTcYAd4aveXnSD00CWgsdU9XbEGl+k6H2T8tEhMEgCvxiRDm8r0Q4NNTp3WBJ9iuM1J2dNvUDvjL/cSCEyhpZAGTo7GC1s7F+YpWMCaKRz6xdrFCGkoLSIkvx1oXmqFe59vA6Ozi2DS4Oi70sxLol/rHHK62p1ZOVPMk/dytDb3irmc6/eUS9XGwmgPomcz61nHjP26UBWH+osVMmXHff8zTabl5h7VWioxN55hyiyKBE0UrqeO8akdPssRpS+BDHErjJ6B5CM656HojIlV8H/nX4nqK+7jtNJsUAtDRhbDWBrVBeIURRAJpcS/dkSUokGY1UPLfeFH6quezuKGUJ5TN3wTzglQq5f8QmAzJfA1F3s2aD5oTUEHOX2k8Yf42j6ucfEVqHfmGJVjrhMp+TI6Qm2LUoNS8W7CHsTIeNJzbmvwUdgvJm8gOlAx/FZxuO51J/G79Ob5xbkqwMHuCvsnELnJj9TOcTvWIZOdMnlgu7r01W+QwCvUQ7PS+W76LzrbV/FcutvPW9cOK79n+Rh6g8p97B2mVRmDDuDuvPJ6kr5rxbl/u73HxJRAVjEHhr9sx0DOTyowF/j7q/AYqRWoXa94uFNKlN0vdlvPuObifJa8mVdG1TbkP/idqBq0CG6YqKIyp2otRZT1QtTZbECLsMEsybrkhdBdwJ1qIwYDauLT/WvaG1OPRsP2gGTqWmYIjAQogWz9Il9rkY6Bpz02CXeUadLCVnyXnidK2wEl+LkOhLixWwPI96p/ERo/wNQyJmrjJaGGVd0Po+P9ExHlolBAxxZCQLTNHnK7lZaWRlBs0pISmuTquAC8pPBVXriRN0L1FZQH5rb+ScF8D7z+h/B+PTyN1YIsDg5ADKYQPCRadDGWThqgbAutSNpigBahwtMYSM6vNseafzIvvP/XYhkaimBkqBCKLGMqjoJOTrtp2hI6IUh3RxkxDemeZXlc4W0i2QhTH6d6Ll3ZNOKhZtGXAow/QG0j0NBaUYbva6RbqSGfiOn2wrT+91h+6Sn5tyVY2slhSNAKUWN2BOacQ9ezoc+oiyhUQYj+XifabDNrPa/Z+Vlvb2iearHFK+6sQ6lO2O0BIk2UTx9h17RKTFMiW/b5rlzfbhYotOctDvJPlvHuYqoH1A9kmLTg56JUtoFyeBb7+W5iZBBhHXExcAqrVmLIA8Y7iT74kOGdO2Y+bCFXAqRg2NUsrUvo13X0kLHC2mk8k4Pv6s97qMPq4FL4ydAcP5vfuVfwQMXUTezZASMc48pdHaNWRvzVE=
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