DcVCkCsUUQov3NXvsRVa5JKMRrxzsnVaYsaU+AaDj6kKyPqUhfoRzNeXKZcSw4nSHRhJuevhkr3v+NOF3C11OIQYIx8edHifNDIuLlxa8rZ09vvvydsHRavymAkaJ045iM2flEhmp0OTzM+GjembjvlQHV2Y5C0ScsroBf2H9vvD7M1KJjCFELiUA055+2v6iWJXOURF3j2lsQocv4IG4z2VDdtezPeA/dNxr57kGH7JfX0vQHxqGgIWM5IiWl7P4BRqY+tzIscy3X3Py//Q5hwKzrDhC1L5K6VDZfiDi3pC2Jk7HahispqwCmExsbMMUdr38OHkvk7QR/Y4Qz7EG2AWzhKwYdLwUhQIBJDyMOrNqa4+fxAMxdahXTJ3GXCshjawoDw7HOsnhJKVk1UUtpHjUSw6z4DqidHeHz7PjSOqXnQis1TTYLERDNSTDr4OJmhuejS4F28JEWora6HLdJt+ZkkOuQDjblfblCCwweziBtD4amjVT2blcVxjGPqu8zgX3r+h2rLMlhfKcRgLLs71bbZm/vu686txn5T/eXSOeGa2aAjhfcyZMRhzB4oo2OSqzttN9OYjoE00a36mmzcJy+DA8WZRH7PJWXRUs3k33Ffi2QLUopp5OXUENLGcKG8GLPm4Ys5NkbULLPqVW/jgc9EN+YjjvdqOlEsqSG4MFyIxtrigaY6Gow+SxcUgK0pJs2e3p3sx6r4opOqP5pfwS1yALFYgEJ+o7NXiGpW91Tdjc/NIPVlMwZGJXNaPaBmpPEGC7JGd26D3n35heKzKHa+Eg4Wmcxw6eKaPbuDI2dQIf0otLkYDDMVUYb0sBuZBO/oU3J3tcomL4bqT0diB0ulDY/v8yZqqhtjL+ZjTLLyuCjwWf6nkW+MrPP6oyvzCMq6gdSInx1mJIw+R/KvS7yZRINXN82tV4mVctBlWA4Kwzt5Lj4+b67SXNJwq0ML1uw6Y8U8YOaNhL06cytM74oSQGNJk93Zhap01jMWDIYv2vW+xvshZYRg3ioPxtMUBp03TgHdGyswiAyahbbAn46TDlQ3V0Zkv+HHlN37ARTxB2tazy5C57kY1Zp/xjFFDIefq8O5j4pDFzUb6D1p7It3KoBQpwR/FnOiQDHFRi1iBOK4gIWu8HIMa48MjnBvMOiz3yNprMVv1sFcCWjfeWcnKgZTjATrsNUJnAKWh60mjh/usKDkjtQ7GkwNgTMpRjaeIDJj26b8XhNZlZXf6KN5/J9T/bR5xayl5VL+NERoTzBcdkWUaYdaaHPCTSbkGaafDfWHnJbtXFzraYQsSHCeIPLbx0EV40y17aM/tLzv8oTOsx8F8nCsbCFCCpM1f82gcJ/FS9k/M87u/yt9iER1g4Ht6GBFoDl8=
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