AfKkHPqImDZdYVFvIK3wruk7FEL2mu8+oEzfK4niRbLpC6jkzapU5C1+U1eGH36vpWZ60N59CZghEdc8ONze6FFHeHiuL5goStj7KtRxzNJYl2zkmEb1vkoQdbkuIcy8Ch0p1NSZyOfJhXzTAru/r0lFyYPzx/uz3BWOxP3lloL7PziiSUyOUOdvT2zzwjA5z1SUxtCmE49B6QuDaAkOuOR/e6OoXIpbA15NkEGy2hv96i8DcSq7XijfBAVB9D8w2I/gfnUrXjerpQDJi0qJURAf3DncXu6kT34PNl/B728ZA2EGi9Opq1WubqEA4K+gkogH1HE7dDjQ9MuiD4aX4qdZ2Flfs7yKAnOA3WSrNg+ovO2j+IG0E4IYGzhnZL4uj6AjM8zkgi+fF/fVlJoA35Gl4gTYFRFi5DNjOOMhr9kh7pFCclPGt7FF/x/QTY+3FCJN0KQ62BpLMWpcM6wMQmsGxeZw2tc2ZHeliWGIChpGfkm9o1UJUBWBKkBOv/dnLXYGFKLmsCfVYrvxTFAB0diwMFg0O5bZcIKqrSLEQtUHtT3tfgT2S6+mAWtgNmc6pb4UtyZRjnz52PVF2Uwk9hj70/9ffWX8/qtmiSRpoFi43k/1ZkqhvA2C0UIT6jpJsJ++Wev4ntDOESagzn/IwSNpqR0coCFkRxFeJvZNr/as3qXLa1PlCTInowTGxTqhGU3dHd9UfN4yUCCvm9HcyWsIyTWZ/lKAAwKMMc0w9mwA+KZQzDradVSVMIykYBo3dIC0vPywXq/tN8Z29qBHx9m78SpXj0ecyekGb4rJm4F7QY9Zv/1SMNTv/E985h4Q2YXFDPWKSY+1K8m97CcW90jWgLuV6MkW+lArJUuuwGKEGzeJOwWKBouzDlqatsdmxLwjEwWVp7WOgCcbUclTpLXs1tZ7auYaaItcy2SLo+2TNvcrxQz707tZhUTLcKo9MvtyOz6WHaW8YOYLzKmFn+TDEnJRGWYmmk7nEo45RJ3EjyD6d5khZgjV0fcYsIzlfk8fp/T7e2TwVzTbv8qeTk3UR8NkDejSFAQUueBeKwLkR2pv4dKu35FkOOvseAWk1mSSdC+35k3JZP82+m5JF8qKHffYDwuq2GjArBVs8p2UeLqUfpdE33WC4Zl5QfJvVk2cKwzu/Goo9d4aVcTQJNmjhxRo08DlHFVnh1dvrtju73bQYlpREaa8avGitZiglXd0zp+NSOZ29caOJnT3R91hBZexBB/kKqFdxPkTbdy/x3UgM4uFrHuesosUow619pn/dp16Ys6d3HUl6vPbz3IlyNCs27MXGJzMHkZReTtg02YEJ0MHKn0HT8pA3h4ToLHD4BNuVQeYcmX2hBVVDSbeiPjACGikKTXdh2Y=
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