wB02cKNPU5mQNJ5xZTImP9ATOUlJYX2Nv0eXdd/61zkVKvKsPPZYpYw4itkxOmFWUBqVEb1DH08MUDfn18tEohnib3Q+izOU/NX10fCKTSob2FJutxtSeAXGz/3+zRzqIe7x0uphyUh0NuPByiKrT1LTFu1zyhyjijCnIceFqlYqxi505AC1BKvUhI1/AOgDViVdFlg+qZxLcpx0y9NnjzkKRiLOJzntAl3q4xH3bbBNY8mxtEQVCSNfC3zVV4bgQOjtfPbj9jZuvIaiaYxcylG8qBaO22sOxmLTmIani8OAXSCv8v+gCfEA452ynckLvURyhX88aYVz9gxX9HLIZlrJUB2F68EuGRCtLwabSryCkyV4yQhgg1l63kYeUD+Si/XieOYRsL3pXDqO4oVDZgTAy3gsMXSirLA/ITKIJj9bzQpBWuNORqm63tnMQgztIvSuaKx4Be9aQuoDB6JiWErOnHcuezK5GQn0Z3ZFoixNOKIUdVhDJhcWn8HXgZaLwkbJysSScLuOuPGVqBvJ66jScnH/kRp+T+7wPglgAzTupaZllRzvpD5fB7PkD1mphC8z6JZICFHKKkt6PKPQoMYkEfZRX0ZRQ+i6l8gYsGhnvarHtEVeyLZiKgDpIB04x1LIw2+blO88VOjc6DrMbKgMc44qTheXHGPKylU6fdZtJBPwJ0XWVvDWVWYvT64/wRQzwX6n+oOLQR31Fm35/KwYggGB12qhruHkNAnVYmKcBFjAR76oSFJsgZZzYCDHrRJoUAdyVaTmIadU+iz2SUUGBTEzSuHDTOgJQ+3V08UVn1IeMO1QR3XHDSal4RbSbzQHg7KU1hke7vegSQUpawtB5+EdrGMP7ivZysMxLU4WJ3VfYuQAYJswoFEcMH/fmG9hXaZ2QF+44yv3dDQHnCCM8CiNmWz1koUyV8U5Ch4mIOUNrqzT33IjB4VI82kdfkvDWlb6hzhuxjNbGBAFqGg+pxoQ1n2dT1nnQugAkfT9iWK6ji1ChoLxwV23oCER4D4eeO7dlAVSHt9n+AChONNdfj8Eucg0LuessAj1Xq33IoA4ZpR/rLdfUrwwT7tSyFEiDr09q0iACsjvlpvYebwIxwyD5qkytKIRKImNoj+fdtqm5jhjExiMF3aiJEylgryNd5lO56iK+k4BP7/hXQuEobsXOQf27qOT3cgUQLxRKQLVoj5pdyWpgS0Uu5jI3RzfJCDTYKJR804qGYWzNXRFK2xhLGcql2G7kaTWtP8RMUfMjxmlrDMhasgKcqLFJegu7Eyj9OO+GKEdJCC9yKstIkUbDwW1qvFgxvitt5X0trEgS7eOjYY69B3m1kavXwWFnSt++eSKf+E9W4lWxK3DRmxeFEDAFW33ji0=
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