7jhSZv679kXCIEK3ZSUrDVSQe9chjdDli3cRPzqO+MhNbdFCR8tORE6F3Kf852donrWv1fhrho8ewC+YnkV+I2aFv5vEMW/jWSzzndbobqdLvgahs1n3+zXKJWr/nmbZYnPcs2Lti0Dj1F+d45gh+1FR8TiT4e9KLr/3uTSxu/1O1JE+F6sMGksNVLJoy2mrEWXjBgVnshjCBwylxggmXKPht4VuM0sCT09szo3MkKqtwmNWtiNqgqumIDJ1zIeSbyb0rRTd4fvI/6c7rNjGfzOu1wNO7XIEQuK5r9yeRj+eaG5JjFLoULEBUolLoLK+AUwojGVja+KIOmjFgXQz3ymJMwD6Y3v8Qxexor8LpIL26bCCbejOGMlAUrs/Y8OldcAlcP+CbCzSe1S+ttpTkv4Fm2VzbzKbwFn4bNAtutXgZtY7Jd4dHSHM2VWih0jq+N1BsOWUwm05c5QPHj9/xgat14aKB77Xa6exLEdDn//BRHNRcl5lT60x08zbTjcTaYA4xmFLJy57TJ4hXQFwbj0HoTb/1ihYh1Jj/RfDvuNEQ7hO4/K1l+N/wHOxI2xCZHN4gUInLZIFMLExJK8o/5tbd9ZTlxDhHdR+//PkFKN0+BWrnJX8DlwY/c1+XN/1cNTe+S1zdVEzBd3x3OxoqUNFLtDQWjdUH/p/ztQk2L4cY+d3/MvFa1RUtP9jg4NWqvwFSrlTqRHrs6Y+QPhEfaDz7pOYzZ0nw5L2VK0rdjFYO7L0Tz7P60V/1+x2cK+PnCV1o+N4FQnDVn6qQgGtbVOZEdeW8+XtLEiQFDGAI7FkwA4cPpXLmBCKHQt/rsFHIhsdZrgRNWiO4H9L8oZPbZNPJxE1fU5xPoWo3xkTvmtprUu3qzcDejEyG/Lyd8xiw/OKXi+bLQv7yQzqpFud4qxwzVengV4H887X8qZgxRZU2n182FsFG6MXiAaztQ+XPp2V6yenh73+nINIDEl5sNgwdvWwEY0Tm+zYn8VC4EnUlCWh8F8sjzTC6aKBqT5/OnaiBM8F59lyDblBeo9cS5FD5dp/SAxRKBQrA+uS6XwT4J1gVJ4sAA/uGNwrgZpAFtpras9IUKSDOh9tUeuER6TVKW3H3vLY8dthSB2xYAsmRIhGVCbBOe0LWNrDzgLhZ0ThdrF8SRwvHEreeZ2SwFNOyYjT0lKQIrFWYCX0dQXLVX+GU+Scl9ffNJxQXe6gvUVOumMtOPSYUTqY8TdtL7YlZM7103TMJ4cEXX+B2lr581Xlq+VXNrd1xbSU7A5tnKKevGBA2i+sjkYvRp844jyGd6mmqCOwWN1Hk5RDN5PQCaP8Mzje2dQzfNWBZDUtkNgKqBfz5g15B3F95tk1gxFrMCuuhck73ANSARM=
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