fP2Xca8YlP+pWyH8drahw6OLlirI9uuQxSfHU5tyP3CwX8ory5z9+z40oex7xdr7knHWtTuZ8ciIZ9vxCj6MtpoqbvEm5aHs8eyByHTuBoIGBPAZMfRheWGGL3PjJrXc1SQHkiNwpu3zrvsYWYHEU37D+gl6eQCuBUICrpvF6TQaZVtafUWmJvb/x7cjwvpMhryXiu1IqHXEC+hdwS0Bkr1mPt3gQ2EGiCxhdJZ3PVe+z925fo/+8aAr43DSO6oLjbVdN0PASH8QSKnlcLsvH+egCieNbfcBAhnI/0BuCwtOfe6pQBEWvhiJGt+JPUqn9C9D2ZMU49wjVrUflDzS7H347csfmP6fv8O7G2UFcGWmqVJWq5yLQjPimwGmEiBCHJMOeykB0aKjABXF7IT3FHV0VVHsp7vKEz+yErxfG45cBicnum0UCq/u/1YRiF2yce9DJicPNy0P7mRBx/Gp+W0Kwlx6LyIihwvFYjfIp5q/ToRd3YHMct6UyVeC2hYT1I4f7tGjVaP1WrpK4HAGFpkSTarNGq83FNPSD1jLNSO/cZi5lZKoIx31j/BAi3Qr62Ot9oejJFnSoZZbUn0pkzuVVEwZEjJs8K7lhnlhED3dnrpgRaZvRSmZSgCKWsZl8+py8Vdh+ySnhLaOnxGhKxQeltm9cMyLmXap7UjncL5TH3WQDMmRISJVPhuKbuvQCTTrmdQEdv+rDOZqGrskgcVhu9v4CgD9CplqBuzHsk9WRghoQhaLjQGprhjyiAfMjf+P+QUu1EE9ov1kAO1XppEahVPc3ESCd7ZJdxXW0hAdaiDT/nrOq9KlEbZpYCMA//pWJCr0MX/fy5zAu39zf9saKM5TFYDnkWv6UCsVQutcKQj09116CZmCMKNe/w/7GhllYixuqfgsKM4Q5mJRT79TXhITAAUib3GCqYBLx58gqo0ZbvNPSscL6LDjzTFYz6uyeUx/B4a2eqrMSNTCvOZ48P3N75z5OqqoIPDaBQ6WbSFXZgt/haprJH3isIbKi6sbgTxUa9+9t0KvcqsSOKCyFOCtItjnOTj9NB/Yr5Eq4qma6fzD7bdxoxBDECSF9cw4bvT/Cpt9X7Jf5UTQ4EAZgoa8Fz9M82jW2j0OpioUqUxB2L2/1TfN9YpaaNDsKXgVxeWLM+fzliP9fftZ9UbsBfh1sUvMh43immZb3VqOToK0Yp8a3sNSQSzEUhrHcfIHXrxSQjsVwcXYrEYp608uKJbGQTaD4q15tx79P34x4jdNUzf92TvITFirYK2uAmOQBro0I6OnB4PU3OyZd95TALjINd0rltrmE00XPhtNr3B3K2SWu8nimyF/egbeie1UKD19CZUCanvmSTeSqRy7FIaDwyoM9PQ3cfo=
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