a48Hlyg0OHO3eaKJmP4y5kMRpIyS9Pho5HJULn3ylFf5NFplwc8FzwZJfvQ8vn8nCS1g825Z0Cm7YSKRpnQQxsWUW2YplL8vPTmHeLgIQnxl7ejQII+WCc82YnI1k9Hj2TZompUvU5TEXYaFrfzCNyKEbFg4BHlOCZgSqnUD9EB6YcHU1G9xQ0wHu1vna4Y+EETqVfcbuEKGk/kB+tmWg3ZiFS78HsMfR0x/yfLYGdxsHrw5jTaQXDmyTkDB6Upue+Hu02qgOlVQAC0pXEty+7ZbucEe6+eoLK7Lk/1JkKfxpb6B7aT0SW1BEwqodQcyr++0DHLMPaKLGUvs+A+ogqRi5KDcXKRQScklwtVhcuVVn5cdGwgofMG6dhH+vDZtRFEsfW3P2XMpsjd8XnmOPrG3hDNFtEyWRmCaZUhg/nxD9neShLJcQ3hcPBLYiusA62a5SsJy66jgZA9lTe1FJHp7pmmB/5YJ96e4QknrWM7B6AewATQ4KLJFx+VB1kHyYS+XbMcN27Da0ZnbOu0MjkvQJty5mZucmswGETNY10QF82H9SViMmLn8G6ac/53VF9EXf3WBHeJOWsBxv0vP903hlE3In1aFBspBDOl66OqAwYk7NVgivrDRLQj0h3D+UMbnepSoBtwMFy9nVtv4uP6gTyQpXSn7MYFfNdijADskxLxp+py8gV0eYGI1om1BTsY81R0ojG5dc3gGwOHJyJazsftZSbjVdsJc72b1hHQpNm4IlLfIWhCtBq1tQHp3XN0fBM0wwE48HfhmrozogathdnjYL2kFILkXh0p1A0At9gJZcPBLojhOqwq6FqkvO/PpTe88pZ+ti2kLEm9AzYisduZi+0uPXqKiRB8S8cokgZUA19MjlOT9XizN+X4WsuatAoFNSVj5JvYcCEQF2rwZgvH34XuwAYxfYtkLgyZUd6dRC6kHMQ4C4WnxW83a24a+3z5QlGy34ppCDU/u7NMpnyrL28PSitB042kMDtBP6v5d7YGqyqhkeL9D2u9hDorNHeMq7BqeRrmD7qmUFL5y8wdgFvEDehpCZXgS5GRN6nTkR9TLKyGBIODu8LNnheYdN1QImbXi523Jje052u7LpUOhp8C2SeSgsn/dsl/WjiAYpt+L0G7vzIu22EvlhD8XdyLRLIog/tIQcVbH1fGhoW7C3gqBL35WsrBq1+YJd7O+3FvFeSp1ejkTKckbwKKX+yLzKcgf0c5p2/rJ2aZ6H2PUFMEnFsdazUe++y6Rud7iOzZCWpWwgFoh4CMs/L0VLtFsWszT4vNl6+cAjww0xdvjmi+yugToNbpvq9bRCnYRV9Rxm2NODbvuhbXAJ+ObZj91Xb7t7+3ASUYtxmmOSdZuyA7PJ7p6vdg=
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