sWD2c/lvly9r/RPomx0OCy/jvfyZ1m5L6NZnnoGVArwu4XSups7Tl0jq6G5lA9/UMV5QR/rFhdVxAoUCvR/zq18gGzf6g07HFfJBl4+fN5ZPC+Tkg6xAaehFEZl7HHQ8liZZ+GZfJnPo5gu651JK/UCWtElRNZni0a0GfI1m6id8iw1IvVCaumWH/vzLjKi/LRaZ9QvUhxf+++UGSg+sjZspJKmbWp3a8tcAuBGObUIli6gCclyv+89PSGOHBZ12XLwbCQTSeXL8NGtFjGMsnvAYWRBiiEUZz2cEjwW3wc97KiydUvLrKiWDg8pDrnhryu1AAdlfBx3TseUZnENNVhYm4Ep/P7aWUqCye2HTpBnsGp5CMQqUoK3kd2drq0SR4M31LypDuIYFLsDeXaKyAd6WunJ4M7Eb35zgU1YCwqZYki5qs5h1njVRQaQCJqV0fOwYbgs6wjCOI7STy2ZPZpJUUxLrhsBo+r+mNO0VCIL4hdHannbAB74wiKXE62qglwb/ql6CIFmDAY2IY0X3fEv3gOmlWnxdK4IS/ORrwq0cRZCnVZQzfMxcBnRiTeCSkLLUquwh6DALHxq1K8vj9YG1w42yODKDC7Krm5gl2moIMNXnlc0nsO1m9Unzj8hQyuTG0mwWU2lsFW9evi82sLJs2cgPQ0mh/5APT+FgQ/aOwlqpNIeNQ8Fy+B2G8YUqKs5gqX4o5e3KrQHS/F1Urm9zG3/J9fywbaDim4GSTZAjRnAW66MeQyrwifkN8K/Aa+5zLtgho6lxNjIeQLBCQR4iSFdaF0oG1MKL/j/mXoEtq76aFuc57NuuMKiG6OKcSTeFJdJtiol3XVjQZ8emqZNru7M/jX+z96VU1eyiydMEVNilPoKFLFj2DXT44Nd29Q3Nsaf2Wxbk5ARi8vDkijBmaamAzjU51z9UqEtXDbFPlLHACcIX+9KnjYn+NJ+Gjie1b2sIvxCS9IW6kjpz8fLAy5AqUhwYv00u2v4eFsj0RWgg1XTME8JGXWrMHnW2dvCrSy8lc7QjbZsfp3+lNzFCL8zW1OefEngBfd+yi+0JpjLUVjcAiPaFOBIhojg3TLosDibn1hxIzhA4la/as2Bz0ilu8KbLOnIfC6eDZiryOw3iOcEbpqNq+pw9T87XN/O2MO9JcvXr4eoafm4rsiINIF4rPyU1jlZ7r7ftwT6bmHzDlpWPFmQXy0VPrpEqZUaQLPcHeW8Jn4Cx7kXrqYQT4fqUKb35TXMbCaomsrL1ybEAfWAcKXtNO/PSp5koMjVL0Dr/UkEi9msz3LagMOw8zU56PaKhuWhkniKrdNMJdU1qb5E7uD53j2lvtWTJJyLyft6YHb/B/LBg+fhX44yaZtnVKE9msRhOyTo=
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