4Ypr0vc0KN3WQVZVyjwvwSZytkbBO+u4BY3w4sDt/hbivf9ofMvIOAOEk1DkcBDTJtMXhwMe3mKPyr/CueGqhzvBMU1uE6O9FTpokVdmRiVxQRe5B+JLJxKscwMPUy2eewH1Zi8OPycqeul7UwCzntjc6J5Yq4uK/QcBCVJzRQpTkmPL9cA+MurzOTuP+004YjcqbEdlvoMfsYDCvN8IfsHkOUspht7KBEeyxhkkDmvpGaitc3oTs31/RQ3vaKcjCpiGpwzcqQIq0PA5hDSNr4LIfa7ODvvPhzv8nMFTVqcs7ZZ8LrVQg1NEDtKRun5QW08V3HFeV9c9uOJeXRbzcJwWh0lew7WGCmIFpnLmtItozJUEkhJhcjztSBd/BTTY8NOQBCFaS8hfkezfmz9hvMs3sdpbRk6w/dhd5TGVCcPy0guQcl31ROBkfW1Kz2Vtql29BPDC5zmxB1vFa5m61LPfkh2hHPcRK/aUQJ6W5TL54qE74oS7da8Pr1E2mDBl1AleXFJmvsakjxGAFQmG1g6hHSiByWu/HexEByE8PZlhiEjWpYtV9OjzjxiIYtAxdDQp0ClB6xWm3miPfEjsclmnjELJa9ZtxsnjJtwaYpnwwwC/0BYMsmICVWKdmLeNNtcrK2kQX0ttX8ZWtDWaQzDoGAU56d3F69fvdT5wkAvopsaonaQcWj6xf+WJar2nEM22dDws3aJjLmDoMiRDp1UftgpbznSLCkzhcIM0WRb5k/zq3V9BzxapGsId6M/zJDzQ48G6cIDZBLADTJfitcCyIhX+/BpgQfVg53U1z7gQUpY38OlMnPnWFz8qgGpP7Fef/0HFL393CaPnVTppHA3XDSr7ckTNNU3WZPExz4XuTQz1KBn65o2wKsjZQff5dO69zP7Xbq7t5zsKlmPthHZwyFv4UdDJwbyiN4g6m2u99rP53RtK47OfFT8o+Rb7Cc5FF8pg6qHhWgEWjjpH/gtk05wkUD87rsILDOxeHwhtrZylbonU5bkw9PRAgqEeWcfFRD/KKOmmDSmbqDZNELdvreZge39kcAoFt5R9UKycpxzJVriishoeqxXjsCyZs7jqTH8hK41AHO2HSKvZBvq08/YWqrc/bz2io3byQxjfiAHZ4gK1l3OHNqkSteOoCa53Y8QmzJCWWxPr95wY/vutc4ucLNQbJVmVcSnZtvMRQDM/DagLlw/1698bbOD381lgzbE5zNbMyokxClmCkNu3wibOXnoz8O2UctU39Poos7jyPIwh+KnKnU6qs35GFDrugbj2nPSh2Zi+go27kQiCeqlE3VLIxc/lM63xWYNodxhyV6YWF7VPZ5gU8rKXkOzpiIAOI66KQfLSQ5cHBKNltjj7R7xtuV9okJ8=
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