6x6x7YOE/CpCETcy8pK+s1FH8q4Pr5wbmhrbTnz/3gyPskaUVMAPBdj8OhflfR0beRsw/Kaem89FFKL3bR6k5MydQcsV475w76wojckGE4t+vyT+iqOX8TtCnu7J9d7iIXPAT5aE3+ZU5XuX6u7XrcZokosNdVgsjpbSuhnjXvpe1ep6TeyMX30VT2lg9S/azI8KkBUxgimi8pzIzwkD4/nmptgKf3k9w7PdFwGWh2kZ6+GhOeI5Z3iBNJJsUxYcgL+y49dXlNIr4D93BuBEmRkOjGdtC77OwxKKdvRKbtjdoLDxry941LMWQ5bN655f/43S/jzQ4zsVl/lyEFUreE7s+swdJCoLx1al67u04r2PMiAodWHZBkh6zFNwxbmad/SHqK1c532HQ1ndva+ADr8PkKVNOAeW2x43S7A910/NOn9Us+W3haPxxsMhmGdv/hikTR5SiLO97XYg6u6iT2WWhN42u2XN0if0BXs8ENXz1PSKhFM+OTEZQ0ZMmEsz+XrY1B0pHrjSfy0eAbAD4hish7LzxrT4CTfyA+b4zJn+WWUae1ASU5LeJATnESmSLj4fqc2YII25OiPnMoLNkTH5ODAmHEZKkpGhRVaOHkZIcsTIAeepMQ94M9msUH6e0IHWqDOmpKQx5FeK/SuD7XV6a8jjquMmLnDltgEwvcL/V3yfdN/UFcUmN0QWtoTdYYovyYRrJYo85ith7kqOYs0Sbbco0aWVgQ9lrb3gF4OW1fyp8NUE3rdUKIqgDDc/Ln5L5nnGw/LqEa7JOcr9veS8mFCwQFkuvrqRIFN8dFC1/az+l0NI14mP2e4Ggi1vavCYzQFhOadqBorLmO+KTJj2FK6N/ItVdUhBbJSaYTz4EvAJkNiYqXIiU4MpDOKr9CCa+AcJehVPY6OSVRTNbgDv9/TiiXKwT/+KoF3zV4pNNvMeBwYOkD7oJwF22ySbTC3O4zraqYVIYRl48Hb8urQUWvOkbY/5ElC0GEkccQUGAFKaPYEic1KZVAMvGPn+srGQX54eHJIDVt/pq42CbLNRNk32DffpwPX9wcvWCVNq046O5mueiFEay+utaNYuHZJL5OVpnKPXyd/pxD2x18HoW+UJlP1u/OJcqH9uaRgpaH1yXmILTPu3SK4kJ4RzdOfOIunVO6ax1DC0eNm4cEcDUfLULVWPWkRGQguAMPz+6ru6Wipmb/YMI7rry6p02y7OTFSO/GHMSOzTag2HAoT3np3fo3EMx9sjFZ4P4KLkTSSMvHF3DscnIy7eNEvV/K7hYcedXnHTUavkirUmELRpC/K93rTGFLKahhsS03nzAuBcWAOBGReB2dkvBpVgrSssJLqo7Jsc6RM+ua10AgfLqX/pRAnQAK1FbkI=
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