cikzv6o9NwRV/ZWSDwTHHypH1SQb10k4jR8P6ukm3EPd1uqUVKXBePog/ychqtXCrvIpjTMYtj1SVFkfXmcrrqlf6So91uVlmhIiMi1KoykJW+ixv5oDBIpX5nRfzFjppMF5W09jNX443OpbllLCNuSARhe+D3mSmp2UJFgYjaV80AOeF+56mI4HgUUo9cbLfwZW8OK8Sqgbua92Lcn3bjAqIaKNiY5sJH67irQseYcuLT+HAWCz+y1ANW0rDaybwflPLvOthd0wUTCget6m4u3qUNCjEVi9mxjQz+vp4SKj2ON3fm23CMAz1eKjMCJFalzuNEpVuhq/Urdgoz+VnDIcBkVDoL4VFv8PkghprPW2j1M/XClnKrRlAzep0crmff4JcdhxoIU95VuWzisD6m3LKKZRxy13HEfDtAMdtMGGP0mc3rs+4nUJQMZDxvDXh8j7mYrAmIurOl+nX6Hw9khQxUV/Xvrewou1wu2PsYfV2b+pH7l7OkNZlBiBqKZONKl0a1MuF6tpA0wYLaWkDP69CguCbd4Nz8xYvaDnH9NPdgEniWtq9iLDgWt5pz0SjuRF3D3E57Afz6zkm0GUQyFgo1GqMzqywjyADl7Jm5XuifVCM20EAX1xYz/zwCIsOtLklNBPf2wCuGkVEw397xJfp6KZXbPhny0Cp1dTMrn7Mz6Ly5eV/a1pFP462FTlRAbuRpZwEE4cqN3rG6/D5UBF29me9Lm+1VkWOxUbbySYxCp5VlEbXIr1yQH5FQnnN22eGRPJhC+j0M3bzIYLh0WdvUtVMtrVl4C97eZwz5HBGPsS8AGiUH5dd0WYzENMfBtwK4PopHuVwurEVhiX68lyemuKRfhFR3UZLZZaUjg6Ch2rwZn0TTMHSzMRBGVX3rSmEN5kC87nbk2Nsuo2RK5GWc8A3y5yKMgu5l01hFqbREXcI58riW6xxL/r+Ryy7GqHsFmbpqQV+f4DqLPcd89y0+fu1877HL3hiJgAkQkSNKJ6WPwILyd+HUHj9H4GHuO5ObybQGk4YuEElv3aK5tD4sMD+2Ld0ztSq30ezGfF5ImPgkp/CGysqK3icIfzwZxuoRZc0vB4F2xZZoszJCiYLxY6uaFspbyHdiw0aJ5bjgYaXLmJU2YJEnM9K3+cQFSq3k/UZg+MMWZtyqreH51xdu0RGziB20uvOq9XJOkAdXvK+GYdne9z+jhlRPpem+HbxVczi7FoJS/giFMSg7JMS91xsm7UGQc0cszQZXoJMq9fEXwHwqgX5cAHfaokB7hl8lexSMzPaHRgZRQpOhoTcwQYW3vq3s//e2V7cLtfALAiSrGMKzk296cY8DCy0y5KeZKNJO/P2vee+kYhY1qq2CosFb2f5fYl68o=
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