yxKa/uI4C8R6ymq0jzM5k7xrVE0htbK/PHqXKGs9QcUe59bU7ZsGouEJ85/9Z/+Gnen+ItQDcFCuByRa0pzX9jJMXC8Egxb900GdSLHbICzGvUFBueJq82bBMVFtN0xoj5RcissfkZ4CIhBAbdS89Wr1LOu68Kt7EJBakYS71as7LZ/xOn+WD4BP+kMZ+5F04l5XPPqhikVrss/U/R/AMT7KzCfZqvspdMg46cfQ3i7xPFzueIt2t0D6RWPMy6f5bgVQyzhkka59tqxeuOG0yXyAWThVZFHz/W9nzYah7BSe7jHTAJKUCh6xowzHMhWdqFdLhem/uOIl404G8PO+YkvGpNTEc3HZKn9Lcr8ktNct+pyplIPHpSW9Mw5hfmw4QKYlK9dHn0XaT7LUD430i8dQSeuBDU//b9xOxQvkS/sB8TTFrLVB+qYp+xzD97a+dijubZ9P7V7fjM2CtgLBrciRisyQHY2FzJHaWiBYGo8jrbTKDWpBwfrN1plORWJITSXPn/ics88HNxPFoqBFIaDRbWRuk8fvCUSJL97yYW/JCOraYy9PJ/uAPzTvcDkso4hozeVEayRdwQiIY25rucpbKZTW6VU0R3nRT82G0S80gE4DVS9lQUWR07IoOzP3EkS09EdErSpy1ziVJmBmLt/r0g2lSIMAr6OUoXI7sXMlxXNG+lfFJ9h3VIcsGxbumbvvGGLmvs+n+bHyqqsCeHI7QhsCvSDEESRHP23SYo3OBSozbWxSr3FFBy05sOYaPPoaY79Xq4DIN2KVRL1bkGyd19utJPzFHAkODPJtcGL4HZYFnIQMTdMPSqBbo7UJzJGsAznfizRys5Rs476u+TsKxf9iJkjHlVHQ378fM6RZmVU3O523GbAxlI+1tVAA7bRVg9JI7oC98AnzxCVpvVZ+lM6u3vLTAoPGytcnw7O4tgI8eYorkutw3VLGJqURPm0lB19fUmfx/raPUjK9FHgeDH0ST3wKOE+7ZmxI2ukhKOR+VRp6wPMLuxNHWx6ph/GXy14cQUncDa9sE2QciS9WCHjhOrL10QwQyPt0kmkCqZcNDFh67QMZuTbmD/PqULHJf5KQzJAZcBVnyRznSlM5J2a3pLuu7P++NNGD20U/RB4Dgc6rR+2T+cA3myh8REnEffWYD5dlmFz30bZTi1glBpjq8pBCWdJp/Z/8G/wYT7vrkyysaVU/MQOA5vmnh2K3veR5c+m184UM5XRNtl6rrqbM1WjZKTJ54gEMrlWj+ICkhSIyarmfSviQSfw2ISO+F40FtpZA8TL10jKGHtHUOafILDaTCvWzRUeb5ggwT3oOPvwHa07gTO2hgZj5ZKGYJybJHzt2QSHDO6YhXVFrbT23ude2RSmiiU0=
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