jCy5D36i2csGgmQbR9Ln/R0vq5P38Y0idmU+39iGEygnnAOkMaFOAJX2kJ98kXsGfcDRI04FjHla+OjVCyNuIVyRlRJS4fQpKhn1/aPpt8SYGYvhk04p8HoIKxBegIy9fl/tjHSixuTkqJVCzifaOyrNf9T0d6hNz6lE+74dl+ckNk/heaAyksK/wO5f212in+7Oa19aa6RuYJ7Ryar9LcKOfF12od/DxfEjfuSkrbNnzZPlNaiXeVsudaSgQ0NQ8oWRT3cXMPcOO18LI+8bEDUJZOFuYN7pE/fZiddC+GEgyus13v1mY8ddIQaY7m7EQhJLNDeIT5iiacOmpQyMGh84iq0eghCNbnLOzV4E45AL3pxHRmyZEB/zljeUyQcNdLtmdMkvgLahrBdgxaamQQHz0TeJVJF5gphL5wpWyrf5y65KcHMX4ia4O4K05XRnU+MsaVHssvklRueqA81hp1//VzfglsB21xLugdKepc7UNTwlMFpb5f423FHwrYXrpc/CWbvA51x+FSsKAt/YWBRkCl50I00pcdWv4mBw8MCSI9t7nI4hvcTOErcWaw5XSqMA/Swun16LyeJE1BLyTwVnbykVPLVORAqhuXUTNQSnRLxyz6P0YaLc7Mu46BqUgiNYFy+Ftuhdf4irZ++rp0hcrt3AsE8bPgfgJ8bEd6LBOkgid1cZRkpBsE3ejRslOeTArfH0qE/jo3ZOPy+UzWKyH1ji9JsT2ytryHowhLqKUcx2nhZbLiJCV+ex7VHAWp64zj0qkkrcb2zatDNwnXbrxLJDgs5w7dS2NKCkycyQKYV52yzNZI2fGqkLgC/rdJi7vphVKYxdNjEb98Y4ihM0R9hp+UKobCaT55MaB1tOgN3qEK/xdIf43MLv2YC/uyoRlov3np+gMOEPrmIujLeb7FgiKRIloWyxN9YjEZFPWZVHLA/i8MYeEoUGVUTe8rhNOMCajz9CmFgHeCu4gymNpLNFi2q8cRP9kDU6gmn7lTSJVW+e67KuMn82ljG2U6kBFOO2anFi7MVg1zMxbITdHPEcpz7aZKxGkwRCCbqm5t5hZ2CzTTuFycV02Fci15d8UnNer6yfgf2aZg4drL+3xXsyx7++QcwAIeFpEmHLTQ/jYl1eUf8jcyKoG2gB/E3WWUMgCWVruTpW9D4TyG+YJ+3qMCoP9Pu5d3kM2v5Kj6W3A0sRal1bHepFKXAuYM42w6u8ulZBU3w+ydRZCCMrFinyeHCuGnOPmYArT94FTjps5UteRTMJ+Zk4C87e+VL8ZLey4BpsKPrnC5w6SBeD8APIk2yyhTQTXXl+mAQ7+0vPeEU0fKtou00Z+QKxw5mgMI8AIGKLgIEMVEEQpkqWuCRoMwDPri7oM/k=
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