6vEUKIyCkTXiKEhliNOYDDfGFga74XoXueDNGF0qFZ83yj5luWOIqaTMhY2mbAWs6cqA9w6cquBT9HSr8F01MjLb1g4wkJNtbAWk28Hc5iRQ+nn7iTxKMfIoW/SHUfG+VuDuwHDsb5PwMJUy3PjyZXgL19lTS8ed+2QJrdAsnjSdigrFbhQcB0i7bqu7PCOVn8CLBTnsyK+ZCLQjz+VsKjPr1fhbgp9VnGYIjLOIm52Jzxp0DKmKTTerTONFpSwxM3qF2UghTwpbhnoHJyYipbeWmbaf8PBkg0PHaRNCdBowuDt+jWgPK0jYBrVdNXUUccM/SScNDyyTAaZqP6k1Gw6rJcusJdMjL2zjetmVjonf72fcmgTaiVU05gBye0WKjqARk4pVVbRWnwsRA1ZB+ibFG3HpW1AV2b83RoOj3f94K3Ci5QmPDYObSmEjUPTF7/Zs1DXuwqGJtHmTlxVjI24sniTGBzhRBMsIgROst4ZpFYiHLDYFwnXqGbYTwZxQO7ZO/eJxLCttPUTb2kU5mwxZg4Ld3KGlKUhRNwKWf8+xrejIIps+YBALCxQxZ4dQo3BY2YOyrw9/ct4PVAJsGws/vJmdec2o4iXM1KeaEhdwwMG8loszqk/yrbOdvh3Qg7xuDWY6BXnDBsaj4dwpyUfo/nBqT9VJU6Cu3caauqkeVkXXCt2yA+CoevGzb89MlhjcfkCR99NE/vmndt3gb7WVFG71JsnM3zbu5Us9maw45h30ORRf6zOQ/BDwA4WPt25kUiC63XohOsYRajcM9tO3OtS2d6ApyPLpk6qMIM1enxPlG4JQwmstck+GPalVlqAYyICxSqnuOmWzVMw1ZijqGahDwGwhB+GsFc40ix9xykTdMLCBvJQ/0vhkR8L39SBjZQ7CeuQ/60YxUYcMoobnBzL8HcMuaYKzU4TU/gwiSTf4vbpov6blfPkMsyiBamKAj5OV19Y7WppQSKZwxf5LmCFD+0lzBd1pu6xE4Z0YkN1chQZWEDVZ4M/VgMaE7xViVz2aVBRygYcWaeQKkSOp5OMqBmgHT/5lupPVb3U+iX2uPTKlOv613P9Bm4VozldwnW79fo7hRcceegBJwq515farmZyKDDelejIV77jDXm36jinuFfyynWyRcqUZMf03739F5GpnLQbMIawmQJHcdN+qSZi+tjgtvOmbcsPGXe0WMUbsrmURCL56QyC985MJ0SV/K98N8mq0Rghn3VPW8u8mM8fDC5h6VFuQTd6s8YXC3JAJ5UI4j0ONXAl0vjFYQFV+B4dERzjJ98CoOOlbApZKbAHvU4P06ZbHy3XzOLBzBkLhE2r9fiSxxlaaAv9WcvpuvJnd1BzuQCQkodFRo5DovZsXEZfTqkQ=
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