3gLeePQRZUeYRWjvf1PViRtCcwCXTPLN0KrKX6L5v2jgJB3/zIBz9BWHJR0tvs6sZaBu8Lj4IdezCYEGTU7dpl+PBb8gJNgzbRk14thOpBo2DpgG77VN5nBvq8I1HnvFOHIRvqUDhdRXTgnoXqijVH12cihQANBlB6VO+Juv665f5+0M4AtoM9BL96LOgwUA75zIO3DCiQ/jan+G3EyHDXueLvwW/DJFdypPoGwysqn7ayxKddhMRYA1q3e1YxHtDuh8FDq+u4u+8oVub70/awN40llDxSfiCgdYdw1R+ek/KW7RKwk+yBzUu/9Yt66ByH9nzYPfUO0TUV3sscSZPfii4zrMajo9H8e2hTl8zoQnN6Zgk8eUJ5j/29xrroGS5n0qwdP0a0ktdXsP8pI6ttCZ75/LH8z9CGbcnuMNPRac2AfJskozAUPhRkqK0SNRf1S3kZDFmH74vgMch1n11sqqsUaYHWd+tgP9ZeJQqNjoP5ni+3/h2q78GYCZn1H7DXu+QP/V5pQTi6RYusCAJoheRRfQoSNCwGzQb0KYNwjPiGDGwvBCM7cyUc1qji5TtCOVv2vJKpHi7Mv5i7oZgi4/99vZlj/9l1fg867uy87GvWRkzSna+rZe/X40ODbH7VW+7mcPZT7BzQiuCr3qB+noR72aDTchmVybVeKsigE1u2DKH0BlGSoUqNZpdtp910oqNjw/jv7evBuLTTWqvJ6j4NCom/rrGJH728n5lMBlYaZ48/TanHO15dr8wYFOFyXmWKYKxGlWNjzVzluM890XVushGWLKtkoD+uvkAk31cVxJE5yYnip830r/Ee0Tv1y+bmdLnNeU2L9DCR8EBPYeZ6x4SBAdB40x+mZx47k/f9T/2dNAMWRO2fYEN5oVOJb9mp4T9IzSUF35/BHwuVZotPrn6064KbxbZc3lSpMZzjJs33aka+lawvwtmbpNOBxaoDrLXZ7PHUBalsMkcKHumKe4Kznpumaj2BbXNUDhwqyg4yxMBjZi/S1Vwj8qmGnwys8fuglH9ipDlU+3MQnC6dYqMh/fVrvIzZpyRhUi/JkLm09UvLL8cERoP7re9TL361iZZGcmc5Ry4sZjMtigXVSGBtOxQjEwsRA5UxA75P2+mPV+Skx+KOQ1qhI/g3nICWmYSd4lHZyHprZQVWZAzpit/V8uuG0skrCb5P5EAhet/arulQXxR+ZvSCyDA7Rc6uym72crdNEFRF9PF395HDhWyBMWyTMIub+iGqS7rdA2n/bZibfFtR0uPz4C/gjzTHlqw+erENMi+raXBr1Ssq+MCqUcohxh4nZi1+5n7bIiaSXxtZZS9rqvixQk1VBj3ovpAOWAvfocsBPjeWzYD7xhsKZNlN8XcbQ=
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