isXCDKCVs6g+TwB0t+cOlDm5y4XDznfkEoGAz2WOcOhhcQDFch+3bxE6XdfDvifekYlGHBup9wfZTq7x+5q885JUrFRjqlf1blzM+dQSWJhqPReeTH4UcIfIbfeRePdKSq28gWPyb0Xne9DW0JeqAOlbHYs4YcGcbYg45wFzzjarBgNQHLRaFm5KHFzONZM3bBLBChr+OosMNKXvl95iHpGeNDpN168eiAggeNCxa5FDZ659cXsGE1hOFT11kVhH96/pZU3Fr3wu5uSIKyVVX69PmrssyvewTr/+zTIiv+yBj5RcFNKon5bhsWpVaSRBxRByubsiJnC1rioAVhEKbbJfb3rsGnl1h+xSlHtJI21Q9ZpKjLiMAeL5AVY9qApIsiLCR/U6C+5q90obhzNEPhiP4htdU7uURLChmRfUaEZ6Hplq2ltE9ygZJCz6gaxRYjXjTLy+16QYosL3QtvbF85CoyZlsMmaPJP/9WNJzQkqnNdVLkwFXd/Q/t0W3WujFYOxOIZCKlCMXOtWDFd0Te1y9qmiglV+cGX+B4TKO8ZmClP/k16+nJlQIQ4NZa1avBdzuYiUneZf3JDf99RenhqXov/r9eMonj03UK7pqgRi3xAWFSJsBw8t5M2qpWJU8eYm/1qqWk7jpHJYJ7URJAS+gTdKSaeXmOWJRd03yJ2AFKgb4X0eNLpdEvbJEeQuiLz2hDk7DjxmoCXUUPP4lGXkyKmQ6VJbmwG2sghwVx43YAiYZPnRy0N3w6Gsn9PnjhZBE0q7etjCSQNcp0tA6ogKft1wO1rMv62WPiWr9VRObRk3Ajnei8dNU1wz5tVQVsPlVU5F2VWcBzSSt0EoCPjNaqRwpj3zuNaPGKXaTjdytUL3+peWuay27AybwqG6UrXh9jSMkN6z0muAgvs+NyIxSK633HMW0aX5l5YVjMHLFPZvA08TxQNaicw8Z3e8f/T3cnXWRW9t7VEDm6Ud16W/dsfCWPDoJ4huq3iiZwiVKRkuy2J2u2jMjIMxR5BDZNQntBghcjJIwZMXrG2Kjy3j5xgz2k8q7FqwxY5GjJ7oY4syyc18giwwzHNNTAVXKh6cz+tUpIKZFlVYiT3z2UAa2nLdjgEZKvt2tiihPJkkMp6Ey8dxFVOa6HEsIQkcb2CRXbTSxFQxD4/GOdnsoCGcdTsD1DY0Ayeun/3YikZVmTZ4i2e4cHrXgT87rmxjotWnoyC4SQWCJOil1e5RCfZxmRRq8NOT4ZOeUzAs0e5yP9/7vJoeZ8CWGrnS2wlfVRgDSa/980yXa/jnADpJnoeoHtGHalOw/p0CcPYPVLr0FU/Hp9c7yQ5OsL65yYAPy/5A8qnXb7jaumv8OhrvGXnRDcbPfOR7/ja7iWw=
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