b66KEf8/RS3l9W+hYkjmrtvfGU0e5jMImaQ6rH+oGdFCJfy9/MsfA6T9i+lBZDFr0T+Qx3qZODVdLsomIU5BKOOa4jIUVzyt9FJ6itV5dlLtowcpEdqzC/xXbfEpwdmRlDidqCnPITWsblO2WkyastHBdL0Vmq75J6ySkLsmU/+mY6kiwxZXuivjNfmDyh2Gk1orFGE3b/Om1PprQoKMLTB03dkjEkxDkJgvjpAqK+ouAIkmAOW9RrT3Nl0pmbTaYVTPq6M2E0prN3aCko4eCz5sDTNuTIyCbhQXwJB226/ga7riLu2rZARrT28X9ALYGAO/f89NVekQUsApI8FKeV1cfsQZJb12R24CmvXJv7OGXOCpGFp5wTlzCkvD0MBrwmlHQGiq10H992hOsntuUpkEquVcYFCzf7Fd+Yq3t9TL/d/1uoZYwhCioBiq5RCT5LACS4Dc4PgeVyeREK41Zs1r7eC2myaJbS2NCDAS9mywupGSK/UpVq3Xxp1q8lo5fGHaDIknMj5haZl/sZpgM6dZLqUWzIEPjmtHfLxjPy+/UTnyjvsNCETRKsu0vsAwpF6paidC8nfYT4I5p7iHmnWWkvg79PLaC6AEJzgMedBTtBlpt4KowCsGhl9OHg0ImCdWwPeUgzejwQsW1qGsvw9PVJaD/DcnCIcISZ+1Lrc1X/DgvStwZJGpHePsiv0yqlngngngDf5P0zxVxVKG9NE1aREO2wHjL+qFKNNkgKsel1Re+WYtuXuZ7E/XMes6AMH+Hk/TIbQH4OI8crTE2vU2ni8btfJoV9GQUia/IlojYM4Jl/Q/dBMQ4DRKHclNaLNGjAmii45tbbvFIO+AMHMF9Ygf9rsb6ogRnkUGHMdvwvi0qYB6pdNX/2ZeCH88AlSsTOrSmGi8+KyngxWKaJfEQt8ldbcoWPealqCh8sgOlFmPzPznpOFUNQR5WY65qnE8A3Euwby6KYkM8vha4lfzwwcm0csY+bnEc4d4RuG7HSIuf9umTTnd4c1CD6hFjYtFDz/1WH0jlUQXEITwIf9V1zd8N3ssP4+WQJ4l3JxFU9HWj33tiW+bwbHt4z+YTJ9BzzAr6qMOtAUsX5HW/DYuP9zDp7Gf6bm45ai8RPMVW0pNdtGAAmK/O7STMZKCv660K/H8FFccJZu3qk81yKTN7FrQbD3cOPSfH1Iyu0+bvy92jjAZdCRb5zQsHqM5/bm8RaR4T4IfJ8ahIfKbtfsEWX6bn0kcWfOyDxN7lMtXXxO/y63FaqELaZAsQbbmb3wxIrEtdD02cTRugLaRVsFkMc9ReIOtUk9z34VnzcmkWU9q1Z4cx23BMIURT7gMnadOzSZPt7+8WYJ13ijD0S25QdZkoCFSDGtCGWM=
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