xfom3jmpScx7qg/5n9T+Au+BctasmV70PTL8oQUukMBiPHgc3MsYXPqrAUNgS3LgixCG5liJ6J/M/mujameikk2ig7SopIQlUVlCIZilNHj/PyO+rcqn/wvQ4l0gHQMvgR7dg7GLvD8iCFNQo+3tkhjcIjTkGFD33/2tbdSXzFmd3H1wgQC2cnFCQXX2SMR/FCQZkrhvsDYv8Y1/+mcAv24jdBZNhZ/mgVcOGae+v9q/3wGnt6yZAuoLDB5FHHV1o/SJ5cttD5eYH4We/hOnT6/FRbSFQYt0Ooc/u88nQlWy/fBUf1yEMgcGsteep5PBF2gN9fTvcVJLYkHaK3724lUAFy3grpk1ovabAenUrKvDU9bysfHbXO6Fpg7hV/SOjjxkIg+KA0bYeX2TjAeBdsybvPq6zI/BlAkXxRDxjU7SY9fM4Ki3liqbCSn12Gm/JNKijd/zlEkMz6ZKIMryKRxgCt/HVnJjVKGkM841Ig5H7v+qs4PD94tAEAKIffktHYkAUKqcK3Wa6qxbGVwxDsWWAXrATeBVykYULiTIArSU06zBaaXtCt1oiBU5gnwfvwa1ffyBWj/eiqmnAuyliP7P/pkdAuV2m8zgz/2UiO8axo8yW2aKFIHwP3N0aJ8njUJJcQD9RL5VJ5pTJYj4UZqlBrzaKJPhMXH16YC2Ta6g7Nl0bSDTOJerxwcQH9LWoq7gIS3UbtK8NzDbmdaWlWyRxmEot6pqo04vMRFy04DjeqGWLa4CEa9m1k6BGP9rIItw4xOP4yJYDPsnaD4K3QOglaVSn+bKw4J6U7oYEH67VQPj6PNMzt3VKQQxN5k4Jr4fYWU+m/ECEB201b88mhyZUAd6Q20kCGZ/nPVBt2+Ex7ixlY3l+Ll01J39epcsdUYNiheaWny0o26RNj5lGKhA4h5NAGUSN7x5FymnPCI00vPdqLUuBTOp9GvBz/mCCgTOIiTWnpfFF0HxexlW7amKZepaSk8DXnwo/xLyAmZcVyOU7FSQ/5zOqQKuWiYmfKgfoeNLZL5sfIBntI3hoaZSr8dz3HH0ilxYP5ezg8WrCqqneS0ObptP4zWhCLuZ/NS4Q6NJBXm8PTY5zNPGFTaMp5AqT9U8ih0OSFXXI+PDL1w0La8z13pxFg35+nqm1JyKmKSuPD+DqeZ1e5NvQij4bl5eR/9hHMj2WEj44WWkFyzcBABVOqT61L+RwgxZbRx2c/2e5sRO/e7JUDdkxCf4/OOymW12t3YjqIkLhESWnnQRS2WkPYaDDfTER+7mo80yByUEtbIsOPCZ+mCudC4uGxDyaPbhS76KG5+av1Tsm9deyfJm/vTuMeIu+E5czjwUX//FsGXZ5Km4OQ3DkqsMPWlSOiZXBCKwia0=
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