ppif2/Ob01GgTSzT7uUvZpKqVI/n1K7YLsOI2hSQN3g55Cim23EAZ5xztS7z0x+pR82rKrJ35Nc6E8V+fiHDGRkIx0IFgJTdrVuSry8fs0Iht4KVp0trUmTnibjar5mK9kheJtZWBiqA2ShtKTHyrpIBKTOKjpSzmS3VsDT2HdtPTvjgtpdPjRi82eQQMRY6wUYoQgI9sglSEtMeXbnzCJ+mtdxhkK3J1MwFYcZc9//kPYnMMCPaluE5wjsqBFHTihHvHMWvQinEFDoCWTmnM92AEW2jJFjm3+7SZaS/nBuMFcnRZoT7EYi4ioLvCPWjQMznui95ht6nUhjbP07w75ftm4rvGc2vHHAmuAtoci/Gx1K9HFV2+I9JxK4WVCmU5hcWt4dSXv0loJkI/lti4jYNJtJ+Ch9xJ5WlNGaYwJO7OURLrlCdZh9ro8wFXPtlUNv+ausIG1BVMtg5wVflGr0PAUMF5dSMwgxj7EDenPaW+p1bziseVpl6CRcfkKWJ1AkXFZgCTjrDUQdzB81izaaOEVoRAvT8ZOPvufWTvVCM/j2O10x206OLD4Ms9cVU+q6Et/3dqcSRIu8GFeLxMbY9XakwxjwjhGqKd8V9IaxEySXnlXXBs58iLP0C2aUZYs6Vhwa7tuctgaggzw1fO+sUxy+y6PCzYdCvQUBOsz8mfPe+uIxviIWLWjRDu4pXv188wdRhQ4+QbN1Qnc6AgEbchhF0R0SFUO6kw0uUcOEKIVRt8geMWrhQLgz+cZLppARFftmvfkbQESzXmCda+m5HASRJ+oe4CJcbSa88+nComv6rpx/6y4E1DKI0FRyOLZM1Ma+KLgFuxKQPBCtRn1vVy3m22qIaMYESiqSYLOON8pTR1y7kOD+mDgCiZ49QgAloV/mwsoHeKpjXJrUhNrvNkp2Ao6q7hgdtHjIO99k4plYQXCTN7zudzOADvzmBzmXKUWd5xayaZ+MUqOhnr7y0bIsuS3S3hv3HVvSxi6RVOLFlkQKDXMqtp+ibXyxBMtHaub5XBLxvlnr2/x4jpm2arFro0szvsKug3JsUKeYHyWMyAOdyoA1alSlSWZ/NNXct0cc3r7hEBMgtyu3aEVRw2eAC0S3XeldpIdYhs1WrVDKSlrNQITo0pEH3uu1mIV3SgaN05ssdWhHOqKfAfotA78zY5dnCdSNRBcKIZ2tsavX950YAjxZXRr32SBfw+aWUTuwdy+yydPOcWGbW6LAzHCMp/orBqbG4ATmVqdf8gzCcCicCqnMW7ArjgLWi6SVZqACzURT4BxcMjEX2MdWr/+pvjkU7twLusnxycU9Xf+HbL2liARuCzut6xKVlDQ8eDaj++cunNKbuH2+Qq4qEhXGgm6bQHy6+oKs=
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