Fpr2FOpytEetudAwnIDQ8EIeReud4KFEo0EIg7PrSFjfM/uq8P2B0hygF/oo/paZSuX5fahanprqK+oRv5ELXApdBfTjFo0HsubrUe9/iLlt6QdYuv25LLRyjgEY4TDMIz1bYxn0vrvsf/Z6BC1LWWdnpJHK2QSh7ye7elGf0Hbc2MyDBNDtp3QXKQG5J6F7shScxIrF9aDtNmsvn35uq0VlsAZHzIP5WwiG/ob8KB44jO+p43eXTx1ql3uyaek4GaefiLztiL11CRCRiaroMblrCVWFeTChZSgyQ8UPioSkIV7zgLWtuE5yWYm0+r8ndYP98UTi1ecMA9fL9LnqFxVaekealKk0XGoI915Q/ljavlGjr/xW5P72ZoKqq5DGtGVedFylOPCWrLMWQu+qSL7Ag5Dd+uBfueX68tKNZd3q6IpuUKOkXoTns+RJ+/r1rQNtKfO5INAjmoyPqKcZxaizagkId/fa64V07bqAf52WovyIDu74u0EJeU20BnCVQHebQpsdqJkouiKp/xHycyG779Fp4s79YqT+XzqnPgq/zUA2RPGMWdjOd9T1xQkX0Leg6woCIRWeg+IZ0EHllVeEipKRzIQO7SsbQwkU5wcUrB5UUIcubN49nRm0PA3HFSe4MqmT77Y+XEjJxfFOEH1IBgta2AVUMtkU6Kjk/7YCAI8qKn4kTZMgPVQjQuwGldzLvVq8lhBB1Lf51KyWjR3wGDtkuz3/9tYUyaqJM2PDjglLaOU6zPj4IlaIrFYVcEJXyUsp6N1asJsLIVKqI/Rf8QSUNfZ1aq7ju/U/9bWK45r9O1mBfJohrTM+hIXDfoysHB7m2GwTGfQe3bl6fk6eDcd41+GWxixkULYIbRyfNEGbKsJEgBTJPpUB5azIP9Yv1LUWoK2KMQasGozaFhLwSf+E1jD0ywcDkFSlLbOpejlb0KV/8u+VygNkhGufN9OEyGKy7AyRG/2QPbwy2+w7n02/Zo4rP5+IT91HrXAcX8PfeGjejLbG3mH+a24xPDgwCoVfJPN5ynUXXGCaWtHRhOUuaM5Zq3QS/TjzoXLLnuFJkLQuvB+R9S9zM1taYey0DaT7+KcuE58sWUgnAnoWt9RWRRilZCCigvEJ5hSA6ify5s2x49g1kUq3xLj+avNys+gIlVb6ggDBw1ARnZ2GZ3EjA51bWCP5C8sQig7pmsikQo3g4ISEh4zLUe22ZyjYgBzH20groEmG1Z728tSatIPNOhPXo3+vqi2p8UStGGhzf01lJUw0Q6wg7dWZJBUbbj02AETxop/DJrkXipX2ctHqAmy/LC12azbtyrtcVu8HFzqB7L+0OHiNajMH7pJ/+FFAtW5NHjbeDgNNXyisvxB1g4bQVkgzdHc=
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