XG4pIAqYEE04h37i0sBzw8E7yP7Dc61pnQLfy7dfyHIVUXK3SQTh+IX4tArzoMwEe8jTWuXu5qJraFM+cfxSliTvUMxkP34pZLeKYuv0POYyO23LFuVNfdaFa7H6DJR9lVyDBBNrhwwYEqNy+UmZw0I9DAEoIzG6Q5ENE6SQeCfy8FCGQq8VlqxGmXSNSIEp6WcW2Kq3oimB/rIwIRC9QJsQcEVeZ8SBc/oIeZcoS46BHqibymTgCY5pQN+qp818K8m8hw63gSZdoept2eSt59oNAs+zPzFI9qIhlzCGLF3KUm5o6YMvdBt3La53VOpDrzlarX/gomhIiXI1R0PTJsALxoEREy7w/yrMB8eiuyBbfypozfP6PwNnNIVWv6l+VwsSqs31yov2KxqedNIbvF51cyOU4Toaq1P51NwqyFOMVqRtKPzKaMA37ZmcBTuD8q0ulp+74D+5SSqYnMeiv1gCyA3i48ZELc/xyBVclCPzhsULmhnBY/xDkkn2Dw/a0QN129S1xJvQQGProa3wcPCQgLEZ8sKbDvHq9Fu5pAvuImNglq7V6fEXXzIhf6e2F1IQyT/MMjzyWIZ2OyCjeXwk8qBYei2yv9EDovZ011iecH2nRnplg5f9HkRPtg6ewWjp/iPTErnFaHAPn2OdlLqGAyYFByF+DvRWpkMtR+AIfb92Gvw1kaf5TqYbq+znCCwSBX9Ux1AqnQy4EicxHKqQZpl1LuZGj5JuowofNLva3Krv5SzMMdTKOi81LTDDs3tvPyVTg/k5Fhqo29+W0S4QHYHP0M6u+RVmD5eVCtQ6UA4UZKV7UW8Y00W+CX7AwKVi9nFAk5Kqvcq/5pgH4f9bW/kqm0PsiHDrJiVt1rHkwHzuslVg8+iqSdFU9dRirmeN5rPCSeRs5Y5IhE06bBdeG/YsKxxeMR8VTV16I/twl9XE8hGNGju940JL9aP4qTDPOCWa8PLO8TI8XmNJ6S81lNSQUGT2kLqHHpigKqU719cvQGqul4qwpOq3xpQenuzFxY4Y4R1UwCMj0/fWdOeWiskzGitWiVovAmSTou0DXkCweeFWX2iT2mvwAS2NONww8IcoO0tfGqWP78K/qiXuEYgPBa8O0JRR8XxtbjWa8l6FFRluDk3un/botiSTl0N2zmAsksqR1N1f7kzR2+D3DZIqynGuEEGvx5X0hLs3erfqq/9+cXAnym5pbdM/BPXHFN2HgJ40lvLq01fxIlV39Lnx99o783dRxMVTp5nUU5iKWpziLkL2UKFVjyaarH6C+mzGnYxo4bNdj3y8spxheji4aLcbVTAgAPkdxEl0GETm1bhr1V4PwatKb0isdlXLaJDji1YUUf206CPqyShBpi21aAGIpP39Td8=
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