/D0K5QqgUBGtvPvZUcXvn/uduFXFUxZkh/nGmJAi6nWQzSsV3S7WdHk5roFt88iC5acK+uH3no8bx/NoAMCZDlAzOgJrjYlyYlno8Jd90jfl/fLCOFOxbiIveCxjCOxU6l6RKtZZLe9B0GASGsAi6kbeHbCZgfzBukxa0Rr5Gq2g9EW9TSMXIVyc8bkUUObG8ntlm/i0Rk4O4Dbmkl9QFoRPwdc5mc/hPTqewvfFKWPh722agxOSOXlktGa+uBFhfWPdGcNrUYIL5DmiTpsa5i87C2/aDUQLTVUhqXF8kZxDWgTdTKGEP/XxBHzbETAQl9qDNoFJQ/Qc3mnAEYTYXf7t4/LxJmHoWi8QMQI019ti7ig3HMrwHEBeClJWq8SkAjejpaTSHdcWt6qFxi0KPWGQUQFYEYQKQhdU5H4FDHN9MF/eu0I0+YzjhevGJFZtspPgXwGmNJtZjMl8ohsHhz2CmfkDgQNZS+YO33FDMIHk+hq3uRrmGYo52wDw9zVyRua4k0E8mPIySxkgRLnUbtsPdXc4YJ4zZmrcO8HadjdbhtSIMR4mGD+v7t7nW1uQhoy5Ihnd/MAIC5sem+1qXlt9QwGCM6i++eTAwf645TugOkR78HQTKhtkGElRNVPeDURyVbcnz53RzbI0iuOEaW7ujLxXeSNnRoZCSYUMK5S7Od4UI1IQZgqjNwlldMcwy6QRoqdPpmhGz5T4II/J3Hrz4hwovbXSgaET+JKXQEOnWlzX8CVwIxGESwX2IZh8pDdNHrvsygsqPnF3XfU3Kt4SsTehrPBOBogwkbs92N8TyvmuzsKU6XJq+ePYz5O1FykH2gH0et83LeBOhR3+EqmG0EEjyXUFxj8ISwa66mvJ+j9re8EpmBvF7O8ojgdt+IvwXqhkfHMYC4Y60+9fzTvSuuCMxdA4KyCCpFjXJh/8a2/I3Hn8hmNruYqYsSd4cq6Eo0qEWQEFc8munDK/J3XqOGfN+AlAnNIWsgd49/g8DaHfVZL01VSzOP3J/2yjhhgedHrlylktx4t7qQJ9griMYFps+H0P8mddyPCaXHq3YMmvVZ3t6bIHwYu+wqRgzkoEKz7cqev1emLZxcQEiYSNlXTln4YiFXXvK6pnYP/IPYkmBE7y6JM5FP+li1kvmRcycmIhVhsZrtMyQses3ku/9DmjTIX0JgY8AVe44RCx5OiR397oye75ZO4YMJ+KMFwjtY/9lsUao7qWh3+rM8ZSuBenZEgCIcUmkqDaBZscf5wYmmAC/n2dCVPnJuDcz/o2JRBaJCHmFmuWa2+ZcQ5V3H8XUDKL4XLEpYIN00TZA+mV07K0USEHhQNbTRw/guhb5xzlwaNGYotAnwRF9zj+0MLmBDNbI4yZ1k4=
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