UirgSIMVwkvrANspdUrkL7ZDoaFbtomqE3W4990E+A5DVKUFf3fXHAgTNbVrYJ/P7bfWkSo0Jccd18kLxIGm7KVCf5e/l158YJc/M/3w7PuSMnrKDMxmLCmYOlSTKDRJmNkwc6jGiWDLZ1hYK3rZtO6SnFuH+a5NjvE0WntnL/p82iPmoOEXg7dVe9i8sq1Guh4CdfS+/zBp/toQeTNbfEn8HwnsYFVN98ksFErsQO+yVSYyDNAaKM2o4ITuIaeFbzx07pMpmSjoBGN5ATJqFo6aK1o64m1KWKf7jiHDs7EwYufmP9ZcpFIeU1ZGS99RRAAAyfq3fqzmPZ0A/BV/g4bb6/PZi4w2TMZ5GEWfIKcBvvkjZW2V6EfxD5uBIZQRloDDfHFfwuG0XMPnyPA9PoY3UAlMWR82LEwLuJ/euZ7KDWgE4ozV1d3I1iqY7qH8++Bf+b47QgMizeEehbHEfeYsKJULCJ3CcYdlr3Dj85a4mBxf/d7Txdn+sb7HOjBUEDnG+CNNX50mc+S77sEjVQeKgEoIoHs/FMwLqMhGfD6swNgG6gM2kRocAz3Hmrkuw1TxSslWUY6TuTAGqlCT8ww2Pv3yu1bDM5CGaQrgbyXBPfvBaX+3OaAFbvkCOMSit464SxyCgG/ml9ubRx0TJArcqUgb2vLzGaELs7qz9NwjUO3bI7fNjJaOTOXxUoVze4qUPnTOPrGTJxlTUs51OhrSmayQYtakAjY36MOu1Pir5RlbZmLgUrGWr5/RUWxmoONCh4LgjKrqIblkLxb9AemcE7QvBsLcE/h31H5mDFirGTkUeYfBJcp49Y+uYwxGxd4NwyxvhWcn4lhzYYtjOTmPcxoGOY2naaUmH+5Be1ith1h08jSrfGUhFpwydRlpBSTWGt4tbbma/NKAXX0FBzK3ng4Czi2Q3motstPnj3Q6kscCmLiwOFDL1vRBXi1az5W3nqFpoTwiMpLWDeSwy1gb4Rhoqejy2aG0ucmq+K5snsxV3y4710JIJjSAnFy2JlCdMNP6eoi9V9atoKnmK5GXXBqTtHxNUla2jhb7qtfyv6A0Q1HLE+I9Mu3VS+kSk8k2nTHQETBE+HxmMyHNWUJjlKoGcMwfvEIo90xphBAv++0E/g4JKNvWabEZQz/ZrxObkaRRwU48WmkTwOJY9Y+0pneGla6ycC2vKmku3TEBabmLnH7WRVyquPspyvBQR8TOT9ITX1CBRmYHTqGswdZa+malIfwsIyibjmlBwur+ZvXNWy8KmQNURrGSEjUVMFZ3+P6qRQjKQ/aXGLBfcCu6Pfp7WO2mAOd22ZHGvAwaUfA8p6ApGecX+iRg9suUCpC6SRwpX7kfPdmoEcAsJxb0XmstuCGpxEuLwx4=
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