Qo+hcRtBEmOooGQMChFFyhWMdkDTXivfxCd7ZVzJYbCztgZgxyHiefATI8NTFUgp7YhkacEzbg8uhJ37LvqfvxhVYUHaeXPw+MYORFfc8Q/ZbDycHxa+LHuUsq11lpm6qRdyuRlPR2ebXfU6FDCjd1j2WLk0wnLAiko5id+Zlacsug/HImCi0R1xOkLWOmqx3XeTDOd6GTSUgnnaFbXttA+EHbGvprTKWitTIr8TbJpU55rjzgUEj3fITqcdXVnUKE8D6b/MX26BumqhMju7QuYGai+cHXgKh9ZteF7PtS0QDAzCQK3njOypTxIpk0VPA4JWhTLvS6w1yMoRzpYP/P25zkPUmrZsfvAClzFNHP4RS4I0RwapCzwSvMyunwo/Hg1R0krwMDKAOwQtVbELradaUHSRGrxH1vJMaM3BpKFigVQg2F3sWEL+dQVivKa+wTXCjD92DnjMwd94gzxIZHMPJdk6+rImuX5KQ3Li+2gwVehagrzCNnyRgTiKhnYaJp655ne/AiVtbV548CE5wIATxvAd8YbaxUO1jE1u3n45uSOyB0W70SPLIWla+hSqGyDxOVT9ffeeI5M4n3Tgh8Z4j0tCw/IMS3AiEyO0KKLx+UqoO6XWklC8BsTrfKPGdmOeU0X+LOecwm3jE1TvEDRNfpPf7pP1ZN+bVDADO6hzIjPaJYpUdXf7eprTL+KHLkbBj51K5Xze06vrrq2GBOwwo7RXQnLmo+3j7Sy4no4ccUNaXNqb50fzhPmbTeZxNUnvU/sngKo60+JGz0WSvNjFAIjfWdy625sMs81VW/Umja+UhVqhh69WuEnFnbn8deNo6n9e/dxJLJOeeBv+a4sxZcdzFAu+SXnXYfLUYffzHfJDmNlk3sou9D7/06CMeira8KiHaRNhIgbOUyvF5AP2MKmmy+rLq8AhjhlUqymgIcXIkAljGQcz7VOCNZGZZlwqq4EKA9uDGX/CTfFBmdNuRzRS5qjS/vsAIvCau5GPEQrfWV6x9qXZhup4mnhvh2/MPkWNN+tKkxtgEfQI+AsHhdVKtnocPFu9TUWi2YZNEuDM5vNzA7Pl4CacPCSJaf/N6UOw59ISPIncnj1txTAgx+Qf+FfG88gum0nXyG6WSwd04IHlcXMYGNIn/ppXBL3/NF/Drc+AqAGEaCE60f2sExpse8lS/NyQB5oTYNJpiroaP49mjbwXroaAlOqJd8WGvQmktfhYmR8n9/ZBOazZits2LeKeR4mIH5MWIoTtqVq03/aYkCTmdlat9MyFUT7TwADRTJRIorgHZqlXPwGPHzd95cub3A9AcP/PPS6xPxcnOsJ6WOBC8vfOBXbwFa4Aoe+43clBTZ5IZXJt2EVOfZOK8C+WPDn4Z6g=
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