fbnz2D7BitOU0WiusPrxUVVVJUIsfNCqu2HUZ/MrEo0vodDMZMoLU1kYVvoS5VY7NzOINI/cDA48oRBeu4rW1ee17yyMSn1N3AGb/mhE2y97Q3b1cWXcCkoyFKbXtTclxLZzVxOOXnPiU2QWn/7z4f9tA8CcnvKqVW723yfgUWUSC7KWjlckwsR2sdEwmm8ZTC1GsdL8V3Hq61mEHfHRjKbFOFz1uDmPnw2REw4yfp6gIDG0x0BvuSUTFvPSRgH6pibUFAvty/frJMnC/3DiY7UngUy19EzLsucvIjmdMcclRWhOhmQuQSA7DN/qcW9krc22kDj3gUU3Dy9v2XatPT/BjsR2vSr8cXpvstGIKTPgxm5QMB6b2kkcrsg/aViBGbY5aS5cbW8qMCyNp1g4j8qK7PXwidMKHm4+I92EjGJGHEhO1KdfO590HzrlF5f3HpKkNRt8HQc+2Orc1Ph9pY1qWSDzgDeZDVXMhduyuXadqHEwS2nepsQPqJ7oY5agmYoQFb9q2Kcj254q5g7+fYv1drANk5l5bl2gRyWl5oOlJzWGZ9LB5avHghhpJWGleuMlrk1tdtOyZgzZXGGwE81ArZ+GLboKg0pbwq3IZ9IhtclIxbSFzhTHEXKr+1fWkAME8uO2AYB8e45j9IUj3RgcchGB/jY0rYw9pcg7slauoXdihRsuNAgTg3psK5V/DdNl6kNcI4K2Qzn9mcZcs1YPqWTDy/QTAScR2wXwwaLfL82BtG1b819cwDXd/+AoOnTyExOyCqJV5Hxvth+0FlXgtIMWzdbFtrI3OONlhs8pryOOFlh2hy1Hnkh31JHYmYlxHgc5HtjZBVCR+1Dxc1MKaRkDrjB5PQH1XY6aYGsb7KvZy5ziPZBs6iSCywqbY5rohJhyShdXvz5MdIhK0TMVJevCJaijbVPy15BRHTZoSaJ/k01/YCvaKZgIJj4ASl7Vb/uPSFy6CpqsCSVSyWA7Y8hOeDzodV5FzopgmnjN3QBIrjsno4Wub7tGTMmwds7cGq7aSNfYGALJ9Ev48ub0vXOLwaC1+guWzgWd2+qIJ6nbfrSitcUklQsYOc9odH1hDKExkGHoMvFhOXDqJuRp6UN2zGv0W8QhyCRfiRyO4mVqZ8+skqvGal/kWsMYbyvvW4h7TUsLhetjE/kCK9tyFh5W7rHdDTUaDjmsgFU8VJ0djBPdaGIAIWl+dzDOFyHmma4hUZwFbbGcRiZ4uR7ASoDjCHNrjV1ZtE9LMIsjNUS17MSMN+XrBLrHRKCZa1qwihYEiPZLuXfNiP1jQK/nVd3kC3CYe/0rEL4I8EPVYfFuOGI8CVVBOurC7QEW8RYOaCLAopOZdfT64Ecx2FriC/353VFoZoXm4lM=
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