6TYf7tRCOwMXrhN/AwrzOnEp2TxOeQxuOAUWmdYE+nc/4Ni+/C7arhp60jFOkSTOIvru8kRnE5U2Wu6m89RqH0j8DL+nTUFw8obYSbLtowYEIYJNraLX9YqTLS+RwPYGNIQpfxOgOr+D/SwPinzsecIAsDOgiiSiV/HSMg9Y5QulukoWSIIntp7Jb4zKXPoEg0tkmg6NNKYom8s6F62bPFY0Ormsf9qfb0Xl18IP8syjnx7LeWbS/Oqtl7IZKqu3lPRcavFRojhOuM1izyve+PCeDrQ37/UZjOxss37wKm/VCqKDYxiSjFFvEgDkPgeFSn07Gzzq2JGkNoPLRqorFrWNtx2n6gYFoqytjpqksBVLIGlAd4ra96wnflM8txWBa30Jrz6YpKluoW818IEF5iVRp6ZEXI0yo5qjcImXIMJ7RBgaV/mnrTsLXqYhIjrzwx7PvCzcYMAF+2zIJAIoF+nliQlRattBnWKuCu482eHNKX+5OYYwTp7NlTvh+kDC/cX1ZSICRbsyL/Wgxo3eG+6CsXHy6kM36aN+v99S0IRkG5qNXbzK8y5E3s6qQkNWrlPfHASBlNQLwNMVKqsAoe/171vqze+bsUoYxRkhK0vLKEBZ0G1TudrZ31PD1awZxJ59pyFgXOrJ6KdJKzI4qj714pKBgET0XND4yGQ89ynHrNZR5Zek2dDUODI4GrZuE101hKj40PuZZBzOvFUeo1taaj7v2UEwMv5rYGympK9ZNqajX5EhMthU3Qlh15YsDyB9Khi88hzqIqWyUWfHyEIpXSrm2pO8wZ2GDBLe016IRaLqoOCO6gigihpd0RNe8MTU7k7BnjzOLpMxubtAYO5oowDcfkrKkRld2HklyZOwM+lML2eP5P6Xnu1IO7oi7nzl2+kdJV/KyxHn9N6ToFVfpeaJdxyqrGpDQ20cUzkFWVo2bj+VflLyyFYu8XlP1YAehubuNdQKBbd6VEs2QmOhXnWENTQOdh/U9nIL3CvcmcgSjk7D0fHc2JsRFFi6Rk6M10gqzq2WKSGGN5LtvoTwW5N7wN5BItIECtJIGOmUnzgDfwFcXB9r5gCop9gsyUE2t2JxCSuVD1mZ4UD4JMleOp43vqeeeSBY+vI1ndNihJ9F4yJ6fZKuQ4wcWu8gp7zDn6nbRDNS7QvIlRGU2eKPWljzd/ZG/bOAzkJXhwN+OWWsxZ9Rs/3Abmz76Y8LhMgxsqA8WWWNKSlkTZVIdPSsCgwJLLiYYGbbzdLbE5IDnWimhbAjF9lXre60LgO4PeMbxDS8mQ6/hoQ7RXPoGBeIFjf4W6yS58fa97krzSJMcBN3lfwns2Sa+6pS8cF7bmABs/E+sOGZAQP/iXvrAjYF7p4mfAELTMgtuyY=
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