SKL4HN6kme5VK88SRdQhzFMg+bssvYNbwrDiNGRuWFkktE4EyaDAVJSikoR4Jn2SFUymuT6q4/jXqzQXagvAyeH9194qmE+aesWBHZVE2XxVQgcpCMRQagbc7Ei+PMe2ApsTt8uAwksQfktmqXGHiDLmBiToDZ2YzuU/vsTKRyNrlyLn/uTUF6pMhcKF2FDgCs9ic6Z1ibZY2wuN7SMZPrsuCraPYmNrOfi8XyhVRP2dDPydQLVOavdCBkYKab88ep+QsOPBl7L1wjZTNQDf4XuNmC7ZIH53LpFMAlNtdQEVhkY/PUWTChWadq9EJ6/gmYWlpXTalAOvkb++k8oPTwGV2mP0zz+ers+k7grVmLs4tzjIgxrYSub0xMg7yg3EW3eLOrbDTFOpKn1bdnGiV4JnD7CHG2rSsGNq+jlvl1RROjYamJTOKoI71hb5AwgPfAhZnraw5spN+QgRNO9WVqc88qG9ikkTy8Pf2LdP8LOcrpxkgE0Y5HAGRx1RYF4RDauKOr0nUjeZ+g4nm0CRjb3eHXJDfENR7ai9msUFfgPbJPQiTQX7On9Qzd0eztE7b99n9G3uVpVEwER0GX9E5bRNBTmKgZrLYhEEp8WNu8eEcJZpcIDex/2D5+gW2m5khm1TrS3qb/G6qR3rDWhvdFzPCgnVk2yQ/ufN5VxrwBqpiDdjh++gYn8/iBaJ2d7rmwdGos8A+K32xGSTp4VKnS4fmbLglxwmU8Lm4NdoMDG5CPaNcGhuifAyQg1EBsJ+DZTX/MBTf1VojPOWDZwQIQjcbySjP2c455T6bz8vNQ0XT7WTowMkfREHYqi3kzHfWQL+u29VFRkdu5tqbFOgU2L7Y+WnmAPMssCMQ0TjPikvNLMH2M5mxYNivTXNirhfkzPPvxbw/EYFU9gWZt8Y799ZXYxjbvT5nyt30YqTjbyvpMAnU7CqJCWdi3YEvul4NIUA3fI+CJyZiAfxBL30iGbEp45qy2CzpgNfE43UomnU5EtWWzsHRowI6hf6vvL6jraGP9R3psxZI/UrA4W/C7T/2x0dXAfKfLVq8AU3x4mEn7yj8RbO/d3dWM4A7TsHKsL2sExIg57oOZ3wwslk54bL6/MORYqw5FDdvhFxxnehB4JpIWhsvTd+R4LzqSge/DdCwhzFF54rYaxMDqt1jvc3czZexZfXC1bTEEHJWxIK0TYQ1OKN/BysIAOLQ8s+/V/SmOfE4l3k9x+ubCMRghPOcjiy+dKddklClH/60Z6iAwnGAk7xjoz5eVkbp28ti3RgYNDSbBe0WWsQ9q7N4zzM2u2Bf9Hk7nPhi+19dGSePQbeXfpMH2Nx3i+ru/lgHnf9Sabdokx1nUOgV3QyokJU/md/vT/b2EPeFIc=
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