Xmrei60lSyVMCdgg4T0ETYpndbgG044qoCfBl0SJWhCm00VVe7CLmEXzqmlylBeiapzADIkMdZOXYnPMEgWx0AA3gYtzDf5PQYmWUu7ZSSHsF37/Ye49mhPtu4dRZRXfEek014ToMcPqhKn6L7IEg77puN5RiMAxY+MF7D9eiptuRcQN0qjOmgIpqKFgMwJwvXMV1pOt4QvO9xrCz5VGxfmWZfaIzoJTkFxYx0lQxfJtk6xckHcmSngMXAClCgyZhawrkSvrY5vc5VJRcWvmPxTAnQIIjhOf4jBirl8reLBYKS8SO4VJK7j5BiuFqUAqDw8iskcU0ZJ4rnzUT+JTyOPIg/ORisGGG78ZLUWc7bGpr8XYyJNDaAfhgsH85vnFdGhcDK0l5occG5cMevkGSDirDz2ypcbBH//M/ZxggUZ+QkMzA95iTTSx3rlyDr2aIZXJTK62sHuQRX9S1eR6Lq1t9Tb6pzum01ObK0KChCISFNVKJ3zf78rquG2fNbxROTcE29dMq4IsREzrdCrHKpedJBH0WuTXwerxvAni05b3nI4qFro9+hYIIqkdgUyRmwRp4+gqr7Faol1jjEaoTPdARg3yKuy6ljOMkmAoBaTiddio2lJfqnKSwVr7gXP961HdyHQpNKWgWdJe89Z6dgetGmdX/8IeVTiP8KC6IffQ8Je9CdTbGQlcmqV0nsQ2uZx5L9bSvvcnVrjBVYeYPUuX4fo2JGaLNVvCCqfft6taoWpEduxbSsz4UVZdCL/jc1maE4bCLbOxm2ekHYzBk7oaTamcaVk75JLXZD8P5JNwPkznO+6lvwD2zlZxJ2dy0Q8iULF8hj0D4K+4DCXTxwfM6ne7nVR7xCOE0VUSpUaQ+k1Mnu5edBLZ2OPxlix9otmMyNmD6iPmERAwbe5gTcOVMtbRKnt/FlZS0ndEUMRuhdZha52bnQRbwnuog0MzJ0Pk28rlnPrlHjIaTy6fAYF49ukNw5KSN/CD8wZ/v/bs0s2GJjd1rDe9ul8iQ8WbDEu80ADLhWCaeJI+r4/1uX20IATq/lKwQgEBJNH7vYWMe8AjvoO67ZJxWYx6CI6MRGkRh3DOUYBF/usrUeHrhVncF3omqbT0x3sVYFraoXDZUzFAmC3kvcguAMdbKxGDzx8eABUZJUcjZkr2xshTOWIUbHj8TpNENAeBC2P6uwX6LwAIt1TKM+JT4seOIpY6yPzlIyMYl+qqDzV7cdvFO6vQGfxCJo/JMsM/tti2cqr2SSFh8cy8MC8eCZyN6L+40r+m6uRPQfy402UILd5E09d+9QIi0YGKcBEdIWWy7TGhr90UooAI9M/2N25ibKfj9slnf74DM9ZZKw5VaOxLs+h9oWxQvewVgtY8MP4=
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