UmiXrh3qMbFD2eLdbF01Y4JVEA0s9Tf+eRzGLcZeFBjIk4oLPy4Ncf8y/SuKMtR1DKOu3TQif8SdIG6gZFVLVcNts5ggesW3bFnxRcQEUo4R7VYAVjYLILygZcJ7UUyEumBgrvm5DCrabcbCDE6g+nmNxugiNTpGrHNIH9AISuSH6lnrexm1kxFY0XxuOSHpU3ocdWdRCXA+QLqeROKSgchSZmttpNq3aelcDltvZU4t6KT9jsJNxGPLMM7vNArzsQnbqEXFeRLNGy3X9QmjcQtJ5v41uCSVT/Of2yU2JOPss/4tFReUcOfFA/mPMxi+durASNQSiErCI+xC3wgFk2pvlEqGAoJeBGMPLi7fVDQPz/K3cvBMwyMSHZZuQ+nxnGFKwCGtBaWPF6j52my8E15joFH0S9ML2aaReNLiX2laeNPeFflh+cNcBq7/PyRIEjvp4ABucYv+PKGfNSPTq1V3fKbAbXZSytNtjqb+cuIJ8AUlhmxSbdkunpwQGCAmDCpaUwrwelJpjEE+b6gR/rzhsWhfAxGMsYlBXLH00EHh2j0MClhBr7vX1rGdo4G6JbaxCXMv9yVH9teRl7LajpYAagTazeWCDwz/niir3ZgXCdwuJWslZ29PbtTR4ZpfZCOM05PdC8IlgFrP/PMtdNVBC0VpT3zZX0J85tD9uFuKhEJgS0JwytG66wsD9BVg35MLwt5d+IGVYO+otTIois0JegIb0j66btY5mkl4MDVQiVATttO4OXNWHjxRBG3a0PVgTeFavV/YV+O22Sl/GqIRe794YPZBlEAPUdiMJPYhdPG4iWR1oR8PY/dXDWAyIYVrF8A2NKq+Ek+9mMSGjgNKRRSlflzPPkWTG1XFAw8speMUmhO0yMsOnt2TRqJ2dop9SBEHU90RgKSWYGOeke8o9gz5VeSmvWM5HL60tgDf9qtT6wDngwmiwdkFS7Mf48ENZHjo39meaC6hsp2RGGE8AUc399ii54Ufe/XQwTxUuyDowsI4GgnBu1ifd24NEQrR6JTopa42JCZwjOyMdsbqX1JX+YjU6v60IKUjj+AiD51AHr9x2BMhfWGgKYZvP7s4v7ttmjz7DYQESqfS3o1yfpQrR5rsQXl4WfcAezElGf3AxFz1CtqcuoTbAf2yV7bDMeuYjUuQ/e05etwVJkAXMsdTSYXBy7cfKjg0wVwI7bjOyzdjEueDl2WBJjFZ8LkX85f6yQBoNFxAXbb9k0KFpBapdIB2T5z0gs5uqDTooj7+v6/uSVKNZGcWBX7Nayz1Fmv5F6fGRZFIJvUo+LOV5qslpLnp/PT8J9PNw3Qdht3kWUBXHwMxre8PlJz02A8YGCGqDUz+Zqt/0Yb30E8xjS2umvDaTudOicM=
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