LeN2m9/F01DZ0y4V2aWVC4KeEarhOge5G991CrJnLCOwL8KwGqOOUIDvvGc8zTICToCHGdMjSM+t1ytCunIyBn/TDbpFVoju9LBkfCqZm0PRywN9m7tTw9qV+QLzIKgb4cQ2LLqLQRREnxyn/ZUrtMgdQuezRoJqdbQoRbyoMKgsAsa6udevSOMW4cIi0hg/tZ4047fu2dNTpNarWpbS3XOyBzKBnt/U3lc9nOhipupzI97YHw99WUKkk2jQebm24cVrRJ0pQto+tEdUYxALtUNbzRNzy3nWn5nrtRRcXn4imNYfuzInb65JTYMB/qMAlcNRTF3cWWT3lapF3C3OxoPFTWT51wmd2SRAC5lwfgL38355rJDToJKpe4rfRAjTvrlhjkXXdX4oYvgFLl3uLZU2kytTfqk2m9cljqFWOTB2JNrGAkshpCEp6E4eR+WjRoIWBkMUdGICkbX4QzHrRshkTqvpB5X2WmeL482Wm7adf+UqxuM0JGoQmYEhFNBwbENfTb9aZAF2PoLh5ygEn2zp1GmR+tjnNQnp4YJYCipx6HIq652DN/ZO5FdU3DageLHj0EPfbxwV0Ux/mdhrZ+xQm07gHnZY9TYmkeLPLe1iVUrcdaJ9/9M5UQFRR3MVK4cL6Z1qT/90bmmtEoOeriSFEsQu4/ZQYXn3PBwKF3BvzyjEHQcrPbBk1hnv/P1eHrtDZJqvlA9Uldpke900cgJPJd21Pt05++tBb8SxO3JmIbYwCPE1h8G1PV5d/avb26Nx2pSgNhrZMuN9hb3fG3Blppi7FQC7RaZpPiGnq8mOqxrIXEcYx9FIAMlU1FDmbzFT3QlJenMWZ4u+OfrFUQBh313ehuDJfk0iBcuOL1fGjML5y5LkOfgbqksEn+1LQuwou3T1bOQGjG/Uo+MWQJ7B/FnXTZzZMPvapFwByVFbpcMZVsSI3KSG4UGJCkW78rozwhcfo4a3LUkl/EUiShxr2QCrW7wPo0N9u7Hr899jzPNBNzgaOvQ1io1odXF2ISMy/pmRfI4x6ZLg9lRqkcTPBx7H9c6dCg+is3oh6hFm6F8tCKu590H3mTOQ7CU92GGyA+3DLVbm3oednE0IsDpLNviO/pcVUWRFB7S0h2kHRGMlxE/odURyC3z0k+p9AaAnP2GEU+A2dZTLS0LPyL3RZA+1/d/Y4in4RZXr6JK/LrJWxMSkRiDp8AyVmKATc0RJ/ycTDiyC8FbWVsLOUtgIJTy1FmayJmbpjqeZHR/X/S9pSM6GRHPqQ/OFoRIl6xBEAkmyR02iw6advZmchSo9x+SRCHBHqrEeJq/nVqNDgnaW61Jv7bl8cKlftazQeDAsoHU4x3eybmynnQ/5UwCLHDhQfUswapV1V/A=
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