HGESmJlDgEygg+OR9C0Atd1+K+Z4KYxZQHsf9SjmKK6Z33zDc32e5FNLTRSPpU3zn29qH4feVkF8x6SDGje73rNsp8U7f0HHTI+kmUWB8PiRtd+CxwHQdR7s3+WAieQlozZtm34Dw8JbKHHQR6b2/V+pcseYSXGYEUazYd0kqSq/PUskqByi0LaE9ssA/Oe/rVoqB/V921LxXcLao9HzL6jrJGd/s1BuAOEmMr8ZqJfjy2gXu3McAueoOrwnlvE+dAiX6aUYzRk4XWJL3BFP0YOW5hHBzG3h5V9siAxP/YGDfeJjjHdZrpGwij6wsm0+IZuCCIO3VEYlqdOpAGp1VEQupfQwGucK7etlCF22RyEfaf6V19llsbjmNzjjaqQhJL321KxUFpjc7BGzV33bBneL7n1EcczG1UIyyoL+DadE4IFTsEtxGWQyOCG2TM3NCjyxi+/Nkaf1t+Bopl8gXnWyUO3kLxNsbKPhc+ivbrTYKZg0fqdm2Mqr6vLaDsAXxput6U4vCkx3G7mGCZRaKRnnNNA+HME4mD737Fwb7K5fqum81+6UbHDZewMS7tSfU0ZK7xCEt536lbOqLq1uZb1Hix/N6x8mAbWgHTDRpYk9MO3zJPAehkxKbeG0g0rXXqaS6iQxNF+0/8Kb5EE8Tp8rsNpr9hkYURiM0eGLUZVHLtUj0Q/DG4xiwJAHccqsRImKEw3r5Dz3tEjlSyg2H5VbI9AgDZF0P6iEfC/8OeVuCO8GV/AuqxZtSAqwDKMa0eb4rHPatg8iBcSG4AUl0S+2mHA0Y10YhMGuNlvM/LUREDqvSjJF6orcIbJfguRRJJuOK3z8p/VoPBG4JvgF+9MCQctzT+8IUCk+oERq1svwvU3zGP3Pmigiamdiwi+cDEKsr+E7svG4eAhRswrNe3KzbTltl1QpPPpMsmwjOBe/kDTAzJSVBCVdq0FRPS3pPo4y5kqqaNd2ftA5DRn5Fe82la2EDUk+zaQuQx0UvP4osGhFdGH8zGg5OKeu9a60VjgX3oR0gZRqmVoEPTk6iymP4t1Fc6wGTXfswb5JeBY4twPXeFgnkIt6x9sr3ySaUdWmOEavm6xEHXu3+Y5by8T40BgSIorWMI4CT6YV7wvc4cm6uwqCgSzdHNLQCoVvb7QHR7BB79oiuOZMV6Nt+kYsycM8CLqp7okFGlNA7X/bcSGQpKcMANWQf2l8HHwEmwfxjWedSuB52rhtcAEQA/BLFJyvMWTmSUujjs9GWjRe8USAq6d5rYOAZGSvrSObNQdTDwdQlpXOrHYuhlRdf3/Z4iGIDVMyJK56Fyv+0DwtIxxOo5mDQRitxXlgl18uyNK9J1bFE4gCL+fTok78VbkclNa2wvIFdkC7uVc=
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