DiyDz6+/JdHIqbvzBEsLIowOjmuG7TAURTpIYW0aMgP60F56TrzmY4PkdZgubl2uYenzr3JIBNew1ChfJeXDGqKjUB6rInqHLHh3o1nVCmCzR9Y1DbqyfYAkMS6O9h3eeMFv5t19DmBtL3FJ7Ebesa/RJZKD/Dgvn477OnvhpvD2s2IoB/f6lJ/iqqKdYq/pUhlNL68OZWIG8uueurXTUR/kDllKYNf1sil6avluXuFBq1C7USQ3Nxo5davv+4DxejQhF0xlVcN1vnER+cs6HbdyRH+nDwXPwhCYylosNzrucNHsQADBgCGNTDTPk2T1Hu0RB6m5rwV+svKNiuvu1X9BGgZRsFe1dc5g0dnH+xgYMOFWAQ+2twUpAjoRD15mW4eJlepOQdCuQhDbQ9oXlhj9ML5AB+HgMWDi9gzTYrLvwZNYsnyhGVjla77zKV4IwZ+aPRbkXXC41k5dsFx1NS2QvvZI0XbVcj11x7ixhlBjAHnrQG2MKcTAzMsA5aox6hGDdQy2YSgihdiVYxtoaGHPnr7GOB0zHHEG2NQ7ZM6baPawZjiPIQuFFa/q0ya/x96XrqFinRz5kDo3F7gJdzO3ETi7nYfV6efpzdJU5NfYnjCIuGZ3eFwx6/4639OsXR74PN+kfsYYqg2tStqEK8rCjGj79XLeReRcA9elj11WI1eDYZmUKsvzHTwy5EcbJMbsj9nS96fAeHxlMZl7kn3qjUehGO1eDChWd5xKgAOgJbW59drwY4QcNmqpQ07LN3B2IXZUNuW/G/LeQCMyXZADoS2mVstriO167dqnCeKGUixCYEPuQCvzE5zs5Q7N8Nm3JxQbtF5HCPMFayvAdQN8l1ps6rdrLI0I9c9REloxDH2i/WEkuIBPzIE3+OdF5ydv3lVfmUgyP4XhAAyqIhrdZS4HW7fVB3rI0OhZ/MO7PLfgL5UQmO5jjuhrbbNHjNhVXyRmOnSt8imZPa/bsDtxU9PFjk9QlqYNXrHu35cfJiPPOMvWFFJGoctZaO2KNUCVRlyb10m7r85nSK+JFsYiur7AreNuealvnlux55Ws1BVs5jjWHCr6f+CkM0m/7L4udHk9AaNurg+vthwP3hg9jgOmXLG4592qlzy0sUtPUNbxrBj2bSsINa4b+3tmg6vP5zodXL0Vd3LagpUiLTTdvvfKC7CCgbgwNaPGyzxj+J4PBhmeldhTvWU0BplFkP4oc2djNidQqH6oMJxddViTFsJLjym/bHtB9CgC9slPeJDW59h1UnIfgK++1DR3o2mU0nUiLCY45tzv5GiNcjbmKzR6NC2NKCECLiWc2761AF4ey5UY+WFVx29cvG8d0fNZ0/wK6hQDlcsUv/S28PJyN9KtxxAg46Vmiq0=
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