HvKlzxbUrq+VDX70Tc6A1+YBJXkWSvamfABjR1ZvhMfgn6meqPki3+sfVy3ImfrOQsVqZzD7DN2VTuaKCx9ifRFzo2pL0L9bIsv6iibjv7ub2bUqqAoA77nsKJGoZVMNcE/JmOShVuhUXpKCv47h953sJwsKwlehUVgUVYU/YvE7LYrZRCz4qj3PrVrDim5vS3uyYFPfVdxoV1433h44+9o+7PtsUQ1j6Gab5WCKxIA6979yDqwjraZjnENMW4NajVPbEUxcNRAWOXB0VqxQgZPzDKqkXm/iS+64DOeQ7kpvHsShEwZ80GblMcNjmydm1Zk/cP3bE9JpKe9vN4XMkveP2nFr3IdWktFRwklDjaVW5k4JjEvFxApuNmzwvIeoMAaIwJT4r+kmQ4uhuJMVhAAZINgwTjhe7pvz8Y5fN1o4iUnIsI/zWKqaS7cWdrElUt3Y6LiE6F9YlAvaoNlLUtpD0Y/O54+T6ks9dWfz/0IzraQAJn3iiB74Rjjwvt9p+LqosZhu/BQhQAS1JZPi9vcbyTScfJp2Le89oqBpIvS+rVqQiv8aoROTUiGBIXwKjWVSrQIFdmZiL1ql8zTGQOPucwVOfCmhjp1fIW/XStuarVliZSn3S+BRsuLWgueuMas1Kj/B5TQhgb7gkYgKyyZdu+oTx1SchQx3uC6UZ6CEzKbtsi2mENeta4D4b/oJwhRxq+lMHeeWfpxRBmpq3/OgRXwiSrlq7R0UZWwymOP75n/QbT7LJh9OXeAc84ufG+KK19l/rYrmgsy2gWHI5LODz7VVj44/a7gIWhWqVVf8KbTIe1lxSGwEi1wur+B24QXmDM8yQMFWXd8UCFrxIgGOzJpLydsuFJdzdODau5wX/7wtgubRx4BAeGA3txRRVEbBIuMn2JByQYj6NgUzMvBMv3Wcw6vCoz0lKdZTd+LXkCITpV0YxYD3BDczycpUxYPCARphlcZgA5OEVSSHMmbWQvOtXQH3zJtE6+JGCqOKDlnInZA+fx7rtDQB5G/aKWDFHYB10tLvcT4kDCPSGeos9BURq4JJA1N1MiKXWLoAles+gIrVUYrHktjSlnFeryxbX8C13ku92OJjkveAujtH6AFYK1EWNt6Tf5aASam42VyUFL3F53U/VUXAa8Y3CedRhU9TxiqrOGvyKE2kqEMB8mcp+oDBnxK35tIz7FSsqF+hOopSB3qYkk+74miWVUmwE7Y991FcqVZ8aLngR1rsLFaZm4MH87U1M5rQ/bE9wfIDb4XGBTxr10mpJ0SHQmn8gzK5DS2e/BkgEaIUHu7qpMEqa1dTn3KE2Yrep867UFEtCcTna74tpbI7vsRd6T1nwTOgnSsexEdTZtxLPHLRfrRbrICOWF/QKvY=
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