C5+khIbBCfGFEKuvzMqgtPViHt8WFaRr86LtCUA629q7YkpXPe3MwHL3NhOrIqWm7if5vXhPtxiBcptIANViHWYttZu+qmUArF23gTvHiYRCWC94EA6ZrtZ3gBP53oeU5a4Q0crfSmlI6Vc3oGs+ZK2ZcUlaFS1pJfdLyNbz5leyLH0vXkGn+cLmUXNYcas7wKbqZXSlT0YzZm2krA6/DfO1bmyc0KGUyDerGlG6LW8HV3B7dvqVmXlP7ppO7zpf4ul8dwh2WZyZBNweRpfhwSj6vPGkK0jq0UrScdTcCy+GakXbTdgtreE41VKJRKBI5cazmnU+HKXNU23t7XjZ0AJEvIgQUW/0fcc34doZQojaeEOGuxUkaeEVE/sM0b8cXsfSw9zIRemGEhc0h/sBnnNfflgcIfegHoj/igHNiNwALB0gkH6iT9MQU4Y9ksHNK22fkBXHQhNU8LdglLs6KiHtox28MdE14J51Fmfz6f0jenGNMuG365idg1wbTFWBhMp/9WRE1Zkx/DQ6/144wBkYUuOSoxFhxzq8jUse2WonQ6JHjLUiTeZh5VEkkYYrFqZVNF4XM7VsiGou2dYYd1ADatymJ8z9mJOBlMjyvRN8ZdkT90ugTWlsSRykvfvm6wy79LsHJfGRruqkNM1tRvPT1Hjn4oKroLsQREojgqbNt+Wh1bCfUMTxhu8y4GpgLkABuAvdpQwN30AOJWCtX/v3tK68V/5T6PglobFtJxGEe0OM25+UjPUhGOnM1++Q10jeeDEKNNc3kqFnMZyV4buSrOnZe0gr3zNAmuRM2TKZlRQWpzfjpCIsqKl7jqaQT/4b+yCw9bAilupiveayrQDOTNQiUkza16GdmExCqmkEHI2JTOrGUFbFJ8l6wyH4R7BUnLgIzwsc9WCXweGHGFfWpC0bN5M9VHT9YuALKj6gzsA7+A2ahmo5Ge7C1wwMCkflfjF2yuU3AAF7GsJQid95xolju0sdfCjD7sOUn0Pv1kdKpB/JNp1laI5jUAw8nh+owMgUjAlcHw41pGpGMAQlsxfavdJSCt8drk0jL0ipOOLLxI+zmlg0/dgbA2U6mNy5cArPPfuwxa7tMbpPkGnluk6EEb8KxNBJfe/CWOBtgaXyKVE3fzX/uDzYX/ahjLTP3sdEGpiAaSXTDf6kvpYne1RXNfQyIjB6yR34MBwYdyfRWy/AcCeQO8kFZGhopXk6iC97Gv1vj/iUQh85a+IYgBKqaLjmK1p0sA/hwiZK7EDIbsyjbWiMFe1mGFORtozMZA+ZGx6wESs6HJnphpYkJgqD9LkIWXyNppbwTOxfmEW/W0VbwOBRzvy6op6LLVI2MWpXMErHL4sIjmVBJC+meE0gF18rTRP426E=
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