SaHqn5+i532VvFIrI/4lkJ1JWGEJvvdkwJH3xXV1z7MaUR1qSlLgSL81KsOe48bXAnrVRP0m2mCNYGHSuO4XndX2jTibXTJeTcO9V5pPY8vKUuOUbKTCpkHzLyZWHZD7kyYqPRRBtQvE/vW/iHkq2NdEwSXbPytNmkVW2l+lqtHQw/k6U4+0FgNncv6EgZQ7PGXuvdOW0CcGe6tY4sC/QLrRKYhXjY4i9DZtKLkT41njtrJ7RAuHHQjrkTazuqYdZwEnswW6iy+zPORxFJSFNviL0aTfwdBs57byo7Gvmt6XzXx7n5yQs/ZpPk0yQkv+tmFXpsES9Ogy9ddtTntcyl3xPvX2a9NnCP0dNAA/Q23hS6fNtnomFwsLGYAffeenku20c6DngwpqCyKUNipEVCNQxdSWdspxykCTXrR5jJsZqEZ8GI0JYYB+4qpMF/nT5xIKMxKa+9HUt+azKFo+SZ8eeHXDb79fTu/PhgeX97Fn9F+Rw1JrXqqiLvJpDY0f1OUEQUFXoa/S/VkWQbZHwCuynr0tghAaualBBJbAX8dF83UScLBNrIagrBqmJB+tUkXtUPQe9EtVY5y0ekWMs5QVwizsn0eXJ9eU9Av4gfTC55KWih6MzgcmfZbdARXTsAvqXjTXDIlk/1uZ3414IIkJLQ4fGIqyvJwGBZBLL5PYA2plCIpU0fl/o5+97gYiykvTJJJd/7b1U0XEDcjFRPPQ4wnsLxdamdCFT1dsiDyBs/HPEtu6mTgcYhtcov5Cw4pD87ArgwU2ctJsrt2KMZ/3IVORwVYDBPPh9R36lfSvIrgBte5WC2VcVKLgHfYJSURgRsRewBIra+AjJaJgI/Tho+NtpoYUvsKXF9SNhjNrlIHLn5ba7yHjoll9OSAONZxkfHhMj7DYZbh1IQYUIs7mHyVRq6D6qiotN+GEeTBZgwbgaBjhcpMdJbTkR0FlUEMqBhYAjHCMVqG1UcRZe8mcPfzxTKuh25Zed0yqBpaNBylAMhq7ezEXg9TKg4H+y1wb3PY5VrdHlZpJPevvRdZk/MBP/11zLq2/SuioGVE8gwpsZtwricQ1TylHTtW4IQmqe0oAZDGQHjYK4T8OFhkA2izkD61J6uFjIEvU0EZV0ezG1E3n9nvm0Ul7F2v8pItVsu+uu4B4JOrM0NOlBj39q6gkhC6BfOiTwV9gEK1IoXN62Qxxue1r1JIP1A1u0ZVq9wEQJkMUaWxD3KWUAQYnsF2+vCB4XN42u80CNnk6xX1/vRtG7xb+y5Z15fVUCGo17C1KlqY7kqBRn/fj0auT09Uc9dZ6ewUqkGlrGETtf3cfGXcV/mN1lo1DWfhZ0JlCegyVrDDPSL1hKSJOIv5CTUPzeaLGWT15mGc=
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