P5PsKUZuPAdpxt8sd6Rp0IsnWtB25PbdFGXmTyAIBhq3r042ssNiRj9nonfCDkWdsUPZPry2wRoMphqM/Vc4795BLGq5pTp7zQPdo5PUnJaa/QOXA/vJ0P+voAEflunHhSlETACqgs3zH6ykAsJ+xD5DVoW1/H3OEOEQud2h5DhKPuYBguHm/BfufS/1nyY4u0voxcYAqoJ/Gn6BiQ7XkggQGqSf9EzNAdNS+5zy0gJssQbWcBaX8B8JXRZx1ZBcVXwOvFdu1t36+LkqRr3N0xbf+y+XmSGWSzmJgX0bhlq2+7/l8/krbXl3m/bM17MJmr8+GWSpod05W7cKtr9jyWLVnnZ0SahsSoL55P7D0f+uAkecsk4jub620fewCVzKY1hvAxnZuq3++XdWDz9thoIBABvba5mpE8PD7qZamiTayngu0rKCA3lp8SSU6+4S1OapdNh+E9AwbTapSIZ33XVVEzH+f2aWoigOSDgEaLQSZLdJ0ielA4Ax8m94TkuhRaV53ZBhxyInU8lYyhk5wPLLuY3AMP0KjLhy4P44vi2jAKoEBgn8unOKOGFzdSJ+jM4+Ih8u7nOo4uDPlaFTb0zU+hizkyqiCiPDY36NjBYgMkQSwD0dwsdg8Z5UXYSpSDl/PBfgnoJlgVv5V/t0DX520xGlPnQ4nUZDE8cY1ZDItipPxsRwPL2DM73IG2zQHM3wVETM/dAKZNsdXSPmLNzmIonSa/DhrAQMJ6OAsAclhfRixUeJQSnNStuJMn59MNFOQkDpWIpyuJlaiU1fdljG5eZJJs7M1IPCCCTb584+VCdmFcASUNXXtXEYBuXD5DSQabcNo9U771E/5xdHO31hpCPKB/sCXq9ematvxIUZ7wWSWBXRrKeqfI0lebEsFEBAlTY9n1FohcUUpxZhYnlSPBI+BdtFYzYXfhLCCT9cRIxph8CgTuQV1PoLYlm1ODkTvDwzLD1LnUdQKmzMsMsod7P6LzOoFoie6iW1P5XMTlLTDP9VzIc7+4RZLTq3dUoL0XZqHbxmu4e9akLVqtxdmB+p1sjzlI83bxyf6kx+cjUEKHOrQ0i9J8EXo2AICeAqmFNE0rErDj/Usnw/Vl6E7tfkXNWDdktEQk15KgXx5jfnpUhX8ui3TM9stvv6sZ8tmPdohak4lsAcGBOpaOzJCFoOLjDceDifFmOoewZoQjCnNFTm+cSFSK1x4ky9RLUc0vkXhImNhp4JaKJnclsgEsSXV81aJLScmkFbqQ9OnEpejndQrRID1A+X7lD06wlBKw/S9Htu5KeVMFg080DMl+nxrvj+nGNRPG7whbJys7eTxCX36u4P56tSti/b6ZCDiMHGtpUGMsCLygqa4mKXZKMwwEaiUdquuTE=
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