lqdU4I02WS2um6ARthqJnlkNmMSQEx7fP5GuBkKhxOuFOcGwjG8v0jchkm/umumJpNbBHx1KA4qdN8+IrFMNomvPlHOJUMOT71WtNA9JTVzp9ul/nOUY8FECmjG1wWtEJqlk/5TABZyszaFWvQtOizBled5dPD+JSFSkrZLKdFQdj/frP5x49ghdfaArw/LwnbvQTahdDaoR3MrSYHZMXpQJ7iQap7DgkrmHd3P6eyuyAmLvOIK0hFw41dD57o0MNtvQ5ugcjlxmHj5dGCoNPqg/UtPjtsg7cy6V7jRnEsYlJoJZG3P9ts1Frn/k8C6LHahG6yItOe6/HtRHSNrWA+XOohIeoavJE2dLKsRHlITAG60xIzoe6xuoTuiD9znRiC84AIN8mKw3B5jjhaWm2lVF5imHQnkLhW00erXh9TTmXVEm/HDEc+/g2nZkh2KOmCOnvIXzJj4mAAYT9xuartdE2uJRuSMNbT272pEl+rD/aJkXNcL38F9D0e0jqygMkgGGYDG4u7O/lz2UeqOoMFHcysox3xOXexZEzdMAjcEVe/9c4egLBFUvUi8/DxObgyX2dazVKpAeALoGaLmpEwYTUiqEM9IWVIVxQ09kICzDrFFcwy0hK9zVsGren8K8fpax4lhwNY0e/7rEeKitv9GOfPrWVXZpcoHtbzG6od/LJQJLluxBN6fMBIU9gAON0QKpnPkOUMJeW34dKitr/hb0Ty8eB7fxiA4fF68Pe4+1EwxrWAiRNS0+Um/dBrREqHnky8ypTcikX6cmqHlWNLsnAdmMatbqkMhgM14fFwCjM/XwQ8JdU5dG19fNlmxTckTv3QP6B3N9syiGZ28B206/JMap1IECCRFSTaMCKkdpJqie7aRU0ow84kYtLbKHcEVF2RU6Q7Le2U/oNHYKqL0FXYnLb/WfEpAZILpipJzmOJy6mo/soAhKzjKpsZfBv90doGDI9H1Psm0WY06WFCLMD27CkAnIMkwJn824beb6ij0zBHm/KiBDj8veiX1R4Bd2xK4MbS9PDZhIOSSNIa4N72dF8JYPu1kzl61PIfcLep7O468xmnraxT2WNiyxVpNItWnD204RVnlKgw+buuzkHqSA9Z/bnYz493FxxPhBBrI/PTJqN5NEu/LjQ5KY5uGjuq1nOoe35+EnPaE+lb572VC7dEAuKIE4jkfeFulPUhS8kzjenfDZaEwHtkZpp6jDCXfmVWR6WR5R2JElNASUz30b8y7mBccFEA24q4EUKAesNKp7nbYg0LnYspgJbM+SG3tBwJLFYQFvMuEk0Kz/6NSkvmE/aW6g7agkDgm5LJzw1s8EvY5VLAQlY1PKjJ1GcPc2exUzDrwBEdfhi01jsQCdcKvE9znCG0k=
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