3yn4R6FEbHF/24WQvc6PYJ8+XX5BVbZP+x5uyqUyr7gUeJqdQPeH2Y26WUw2WXNMHpzAvoA8R2N7QNBx8u4fC4s1tFvomP2s4VISTICw3z9HbbMwEqF2j78cU3grtJt0MxFZw9U4SoPnFr9xwJTfa9C++rIhJKNZo+SXyK/Ibsm7ejghDm2ifoFhSYJQaJ6HiZyV336QFqZJ2nyVu/RRJzoaeubSny+u+ZkVNvqHVvUg9JcuCap5W+MGcQ4XQETCazdm31lw/rsGhIyfaHcXSWgVQQFiRhjEA1eiA8sfHPS6ezEvIup4nXPFjFw9gjEptB/Pker6fgpTqjKpRZjS2lnCZndfZ1wuxCaKcC1okzP6SIrwNvRHIFOint28DkG/Eje1a/EnFjh71tOyW/zxv2TVFm3GPkvXOrc0bvVA9jOrq/BPCGFk2X42UDYcVUICJ0rTAxhn1MmgkDVc+CFElc/bVX+VQnyl6Qe4CpZAwyoUSrIKNQD3WbhkbO2isH+D1pgLDaFdPdnnMvoIAwjI9xKmbRt4bbSmmr3b3vT/pU8sxRvN5o+veLzGAyBPYm6zQa4ZfPsKxrLiSar/ssl8IrBoL0r3pCIs407oLplaC9liQwMr4eoRqNW8ruuqcWkserluTjv6fvzxvc/E3QeckIFJPD2ajuWwDL6qQ5w33u3qr5Ym/NIw0DGaPZM1LILSTfEOo8ns5QMxxDWH4gl19io2AkYAAaMmPF4EoYZx1WOJO7+se6kqcn8ZRmL6dUXxhUl8jRDskLHQDTs9EjZ0bD+VOnAC3UJS2//XL6Sz4l7BvffcOgzBMNMSX3baTmMAb2QnqSjnGNxLFNdAR0q4P5iNleGvmDM8J1KLHH5koOlQlcJ6jfyXc2EPW4Yn8vZGgBuJQkO+22ShGP+tRYMDtjVxO5VWs/FKEidMBZmxzVNeUFrrpoJwOetX9FYaxmqrKANsfEsZPiwr+I3ytIY3owjttcY27tFbpW/hfFosrSZ7ovmXqmaQQnThxiJ8e2S/7b+LGetGJGTw8hN9E3fRKEy8MkxBbvxzZjug2oFsdm1s6Drg4HbHcMzoBWQ/Lz4WZ7Eq6v9bDH1PA1qg2bRrxBUYv4ntCRMaZaroU0nePRxF//k3Eh/dyhx2GoMaBg5n9BT0XwO34yOMEcmJbPgfOraXc0OH+P/+8YvZMWFWuAf76TXFXeX+eA/zcan+i9kj+wHGHCgmtjIYpRxB7MFxFsCpAvgQybNFs7XG+67bku96vcwlW+SKb3kUqI62WXEyBvYBNkDeNVNsom361mktmywB8ujlA/NK2f22ZIPSqb05+w0q6fyqU2lqU45B3yLPqN3hxtOEgO5wcX67sfmAw/zsbdL3XWODdJdpA08=
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