5HVtfdZGn5FiUn0qop52mtWUzEKpI/9OiffnQ0QD9OgXwYJbhAl10jR+pzh+/qdVGzV9fjJZ2qRtfJ1vxbp8+8sLudP2+srVK9TJI6imsPrUl3WKsVmUQCmQstCNfqUAXLU61vCXQpOsTg5KDFdM49RQX5fgbVXTX4ysdXm7mor9CBCyGT/jI1WAGut3CRwVQIgXSoh1EBTUDqbjgFIL5zmPH006tPzP/SFI6DPos8sNlZNOB1TChWbfkuchowE6aGHKEM8zppNe1RRJJQsi2MkDrAkLTN5KnlMUyr4VN+thA2fyOxNg0ln86HMJ6q5N8D9mznYUPvudDiUkr8/mdaZm85vzndEKIX4NRt7bXs+SWgGmmdfi3GIzxMh6woJ3zUX5Fd0AzQcrMk/mvFYYXUe38mkWEOHuhiGYrqs8jEUxiy1rBZrjvrBcwEyWyc70n6ife8vmde+FFEm7o8rKOHAvMDGTjeDCL4cAOFrzT1Pe9JrUtouRSjkgkOqemiJgi6KSVtyVTDSyEMRVzMSUbo1ukZWb5bJBsk76ySFqht3VcvY3pvwMbz7JJ1vas7uXZZTK01naXmqdXM5Zwy9+hNoFPrYdCyIIP/gd7U9c66eB5qSK/SM3dYs3KU/zLIKtjf4C/iQPfp3onO8F5q0dPGiP9qpQE/ZXFEK+JMwCFKgo5T/OXpXgTW1tT400EISBzZIsL2O5Oz5Da5vrUskDCYtzqtCCJ6eNzsvrCjxgRuimJ+zfbPGbC/RWP2TdXKh9Sip8N6p3YrNC9EYEe48AFcrEO/2IOa2wE7R6ywyPv4yBgCOzMdJYxc5n1kGZyb0IuDYd1ygdPaeaSsDc9V9/bUyNwAU5taQ4N+N4oPbhxUnDhzOQpTPJvl0raysPvwWljIwzie9Fj4Glw/IMZHZ8sbsIbDa8sLJnm2JU2m6M985ixIwPXSKXQ9Mh6OzvQDhM/DO6QJ8VoqxMgs4cvrpsn+mCnR8jJYwzwCVThUtQULo2o4iul7qyvWcfDIaUDdUcQvI+oAMoBF21s/I8J+xbVc5VNegYULzarkP0bsiAqDRlXRSuBjKyuEvNgxRzI4EBZ9Iqn7LaQ4XFPCiUeQZmDDhucmZrrxm/awRCAbCDlWJm5UuFcLWQOlD5kQdVCVYCpz2nVgUabKK6n2xQhZulOokeoigxVq3PZB4ZWaggxu1/XVkmDYtELYNJVnPr1CdkdGaNKmgpo4lKMITe49uk7ZWVPqU9XPt5egbNs2f3SMhtMFwprLMtXkdypXFSvuhgXpKYFdPN1iBhCoUZW08nalhKt/pcvPXIaE7GVw2+Rz4UCoF/bsZVaVnctTpOx8NGFhWBjVcnXZI8NEyObArZmtP5APIa3nIOYT2L/6E=
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