6/IO5zT6Ahowdrm38JE+A65canqA0rcx4IPODpk0viI7TRuRhhuGrPfpfTj78WjmodjwlP6V2U9N22NP9gHCJ7a2lK2o4ClshE+0TdugjRxZxQM0nV3P4/4xcNwQ8b3Etznwvmw8OJRiRbZrhdbIMMKhj5EXbVEKeKLzVYzZNnvijEx8uVc+ip0jqx3OUE2mO0b67yhbfNM404Vre4hh7MQQse/pjwt3H0TmqAv+k69COEn4uO9UwQiq0YevB/Ek+9Jg4OlRs/qWqcYlCPFwO5xeqpcgi/4Yyg3kqM6yKeZPxxy41SGVLk3cDo5cdzjRCUZ5Wk2uzbRXiuZoTvbfOsnQL7cJ6mxW1p/VymEPfrC/C3U8w0AVBVMIDIZ0asZsWR0IAtxv+zZNd9l2BamMdou0InGKFeAuTlrZPD0CAQeDP9220WC8g3/qHuVU3k/0+JYgwEHb0q22fwxko/JZitHOuyLlh6+uoQCxHnLppYhp2ZnLU3IHkYcZredU6ficZJtWO51CaXIJ8pZwbkqApU9pcVQXOEWmu0Z8nvrOMdokLmENH8hqxqKQp1TO24Q+ri2pwFofyj3HUbkmhBY1VqGSIOgt5+mOXeNETVR3nndkOsUGdlt+z8YLWQFtmf7t6tQvUcWi3sG/NZdHsWdQ66D9G7J9kzQNndbWWKjZgKGPhX749/cKMdUec2WA9pDWvFA9EuHSOfXWkgKEQwE5YriRfYm2MwODf3on24XZf9330UMVpFvnxv1/e11gGF2EEEpKX1wGduj/tPTc/n5A3BlERxHJ3SRIkODf1LCRzTchRHF0ffgrwf29VkYm7TbMLmsyKt0yz4evqtu+LygsSNYB7XQSHHco3uddjsZP4HdXzvjOqnVnpEJQcPoj1SwHNxMh2ho3irk9koEqsA+WbetzlTzrLIk8t7oKSWyWav1gClu79PH3N6onwuYe2a35VVmqmhZKmRWa2CVf82zdD8qPtjEuATPlZh8wm02oVFzLcqNhhwIBlpVufjwG8C8QCgFH4TJ2MA9xWQkOxdzzmohoc9TCsFa2jKok/bOHDUp5rvVR7lmstiEsnELPXcbQRdPA5tA6hMMqlrry3ghhR9eqpm7lywGuwmS/5pwqv/s2Giv1oEzwVRv9Xc26+EFh0Lp0Ol1UoDNhGkeHpMvHmQReBktwNQ6KERezPnWC3HLPui98LKfTwMB212M37Lwii+2ZgIOkHNp7Tn6iyl93CGsSFra/VP2uq/36NJbyV/IRKlrKOpRBaM8l7Piri0y/mh813okrFLcVEnv0dYkjZ0T8xl5EPdumllpJ80jdNQU3GEWtlVW//gqUQQl549Glg+xBNe3j5yOyTq69qXl6ARHiHKPmzP/dXdryIDQ=
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