YtTq4rAo33RaMH1iE+2PojyEvzvSS7amslzaoTyB1dkzJlBpwQNhvlvjTDF28Evn2mTi0vfUfgxpPX5AI35SSSeeDsRXsBWvoPVJb/1yluemuGMfEJ+2jqmP/OgSUb/4YzMTKbQ/TfWXsqipoN0SOJzWF4ZXJ5sg7KfEXU2cCieGLlopGmalPf+YscKe7gOA4c5q/gQ5Kw+bQH5feP2eClK62aOrwOvHUum8u1lSr8dHuZzXtM1MJrylRWPPkxoy689PUNAm1qkh/EYt+O02y84ofWfEWfInrjdK+5qNRyuA/gGL69sS1X8tXIORt3lc6WvLjoZgAujSYobdo3WWe/ofuLcwpoRddDJap/YlhKG4J72RWXA4JPoPbd4mgWqvZmWkIfx3meJjWgeEGy7+KVcRSTVEOwBDvLF6PUv7bc3I7YY0DinY36wBk4wPW8/L8MouVHy0M0opuF9ppNRCiQmr/ESvWGpeyhhbB/kTfQo+P4DceQPFy41EqrdYJw4vYCz1c9L1kHQ6XByKRz/k//XOx/Dy9whEW7X6YmDNdQqeoKcEKoxoEvrTQIr2AaCWoQh69cx1R9RuyOOr1NONZbFjUuDU/bM1evBOsq7FJNhwHfQo88tXQ+L1BMVoUiJOryiJnUTCr0e2bCmoC1Bohvh0FFu/zB0N48v1D9haLUTK3C97WmfqYdkHVSizxkn+K1gjlLFZ0p66rTLx3NLgQoECW4rn/2R3hwbhn3Jio/Adxdck7jnYy67gw5vcoKMk+8DlujPjRqY84UTSHWDviwRNrk4mqmhr7X+vI2+Q10hWgdyoBN8rT6rMgz1wNEhdWhIFkONTSl2PExSYMl4Y9HMHDoAQJtYVlVvG5eyl/IJUFIR7qTTtx+uQTggX8BGbWjYXB1kvTsmZ6J4bZcNoumKJJhKz8wzxja+tHwqBfMuow2U8A0PTr7pGbevql42eK2aYbGpsz+pXKMAEL9P8X93o5G9ZjDv9GMCRKKJeIyEzHqFUyeImuS6v/O+Z9ABkOz3JP6z8pa8lxa1XRoHbPIhWyo2VkXKc4HoX8fEPFPrIrImOEjFIIC3LxUurbkwgCGdhgWSyn7LdgDPZz8m6986ApF4cb50V5figkk+9ZTO9iFNj31abj1eRibPX2sE44FEMUPhRR/X5GR3jIQGAFuv8pbeiop/csq9HfpWdz1mcTc7UJX9ZYBOhTLHYfZzBZmYzysgexeGDsVovt05dhl4AV/3vqq08o7AjEjdCaRxCvjNYFOqmMiB0AKZECMFZT9z787HPKl7kvJo7vdROfzSqYpP7dbqd+yBDoVwlgAZBFKLHFa02UF0IZ56ASwMrnf0T+jRMzod6+18bo0cTFnGXq2lT7CZ8N+eoOfk=
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