O6BYtsX82Si6xFmslOhPFNSaLgWfQCRkEvubSg9OKEXeyoMJNXXafMvlhS/QQN8K0Zjvk9nroRp1hGdeAb5uuvGWEck7TLwd0+x5UnzOv7eahFrp+ma/pUxGaa50TSmQwwmjwBTfTmGrDk7mbQN2IElFOJuztmGCLJW4oQlk89bLG3ideh5elP0gbCVj3MeFlef7OW2uapz5pUBhXYkW0SIjjXAtrqDNL3LZ8CnT9RTgsGw7x4S0dMFJJ0PCDurCVOQC1UaVhk0QQR5SSqtyY25bSM+vMRmzvCTB36Z8CZeCOs2VoEsSa6qK+4MESkup65RNXrBZ5liftSxLXolU3e/F6pn4UzZ/V7361oZ7a0bIvG+6WXHH/ylMg8xIO2FbxP3pnjTrU31VeokTJDjH9wO4LMcZKo3liWn4KKQeUZkSlihXcYaRgvc6vM5nJVF9qmoWcMltZDPN1OqfF4lj+KZsu4IfBZCzpqDtF8PjCmhrfuH4sUqwreLn+SsQ4QLrcdQ80Ljk9OZFUIHUDipx5htVHukfvlt1jM8A65P2AzmB+njprg4S7XUh1FLh+GWhoIN7Xt51XXK8GFDM3D3HW6oDSqZIfKFl1Oz4wTlrzjEYCOcvHpbI+mGh0gjhicff1VfDQR9y/XsTS4rdJIN2U+QXIpBxSUV2ocpj4lGN/dUVcEMQfki9Qyykxpkh0P1V22yqlBvHcnTDyjnQMD8J1vgkYZOYlPovudLPg5B/x+/ZlSvcXsP3S9Io9cVEZgdoitG99CFf3usZnOc3mQj72O5XL8WuUWStcz5LPGfIoONpY7LJ1KvJuVxACdsGHy25UkiVXRPYt8ypOfDgju5HVmZgN1fg2ncc9g+3et1UnkJah85rQCDlgRt5TzsxHo+Mva+heR/cf5QF2GEbvYJVHq9ShSQcy9ZzHn09qNFwL9nfivZ3yBQCslJKlct7be++p1GVPIAHoClPukRzDgBUo1jzd7+EQqDmuBLrrj3mDHazaepUJcqhH+/qTGG0opuu+6dbUldp5ggBks0XCcw8qWZC0CeYscrajUOjeOgVHtUjljZzoFv3b4NzRb01ghhPTCLBKQQ0HcYsDYCbrJGWproG+v9mjqMIdReFAF+ImX9Gi4k1gbpMW8N/y4weFIZuL39CUhS/QAYUk1JLbARuc2v7YxAnq3SY/V1PTQDYE5AvRKNCI96rbScAAhXw1sE6+7tqKWc3YOZ3hPXTc/j2v6fKYP57+0qpgDySJ/da8zlkd4wbY+NIV5/hSHoi/6XmSjE4kUXRg/cOPeyNePiRr4ne9euVd0kVXZlmLFQIX8rHsWcDIHDyY4093+hhb7mjz9ttaNzpgOS/Igk6ywFlA6F9vs0FT9liyyPiIXY=
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