m/4EVok/3t/kUnIFJ5VsQmZJSJihFtgvsBVwtEsXbYO/6vHj8MWe90dd5cjlDxZ/4Wzq6ta+9NYvVJz7mxHLIETk9uRD1kwVKhf1/n69w5tLu5S8zOq7zLQaSBjj8Z4sP852pOyz3nfABtlr72FtafaQOb7A+3s5cM2rdJ9RBJJgjwnPafTCMtZiCeIw0DGlyyJFC4wcTaLh2OI6u/ABNpS29h9pIWoJ/ZUgkDplIRqeTFE4dfzyp2hyXZQm2b0g9xLsIiTZ7CFYmVQPBZUNqp529ixRCVZ+YjPJ+iNQn45+/95B6Og2lJRKMlvS+i2gdHq/iQr0lv0CYOiYh/w3/os7mMD41JtW0RKQD30vHI05Jpi/AWtbuSGaRtETyyBMXsQYpygEA5Z3wdA88JbfurgKkR95Bagn/WNdP9RnHg77mKVehGIbBy2IeQfj5D+P6dG9mDTXmi7/81rSOWNicJuCO0fqkHG/wlEpZDPaaUjya/JrEvc5kkAfEjETBrPWg84HgnLOWEbjU/IkBaJQtnOhVOgPOo7EWzvA0CdoqwLbYRXHuDfeH8IZWQRN1ICzt14Szmf96ZMjIntULAO4ePnplDMeYyxCcJx6zNvqUWanTNGNfJK9vC8fyxSZlgdU1dk0pk9mB8z+xfm21QlvFG7NsNB05x1vy3l5r4/BoY/rHInCyxi5reeXmV/v4d05TLQC2DlVVxhroQf6K6PbFD2c5zbbHS+LESS9x/3yQhmtInhp8i8s6i3tCGizcozwVUSruK1NdqamSyGKXbOcjzLpcf+TKqx4ZauL2WC4ZGcl+TbUytXSbECVmH3YKsNP6m2Tj0dEnD5z7k1a+tZbVs6n3FNXorMnjUQw0qEikVHZZmTzakII5SoyO8A4PZ32KcU1QAeNHk+2tohb/XbOrcpAtQ8S+/wBL5elDpw7cCvIJqKeX3K1ZzY9nUaAJKOuHoHxhzGRRfG+tuqeM8Vxl+tyyUvn7eZ7GjmIzZpf8Jzql9+ttKFgaIrIa6yClURJrstCaQuoWKSkIbSws+Ypt5/rBcLnSOE2Q4xl/RBACu0qQkyznfXoHaOaH92Ro7AePdpb31UkkrfiBt77CllIPe6escJWR9puDzoco/Hjxp97YnVoFJ7Ew60Olwqc+uXfI0G/q/H9Zlb58o4iicFbkbTSsUxuzKoDA1Uy71Zk2KZVtRTyXiehl35ROI4du/sv1kzYXHj6WKgGTkBKL54ydKX9CDovm/h2mMPQuHAhPmQRjjJ9LX6LCElMR+qSwEcKqdre5r/l7ggAuAD84XXWjBcMK6aGkg2/ckIl0P4KbEs3al8gscEntQxLMpqdqlevFYfVdpA2Uj7cUvKFzQS8yqfAJ8Myx5pbe1XLC88=
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