yAM6vr6Czj221szEs8OvQ5IZ4tNYUM8+TJ64KYRRhpxko++zgBRgIHJtD7JlrE3fm1NGpQeOgfGDhlyzSv0Bs1xI7xakRN5Pfy7ISylE1X974W3BgYgxzPfgCVhSauntuQx5qx7qxxPkF0cupjeJy7FE3YTulJPR0pvNQNO5JeTrfc2j3OBpx2UC/PHuSTDmd7IZ1VPaYW5TLycxtjqJmVuTwN61nEAkcCG/tbOOTtlACD8nuzSEQcw2HWAVZgLM6t/Z/SZVBwkLEebdXOe6ncQvvPrKy3Qap1h3ZqXYtCUQX/9IcSt1RZelSgSYcnMGdfH7r0FV1SWJJl7k0ac2gliXEb80HDqqpazvhHq4M5RehN+9nFHY5X3C0rwHsH+edi67DPE70pm+NOZdOiVPf4XzexOTMM3980gjKJPFFLnJaxF0GunhkRVhaAxY/ms9Ilx0coR6Tn9HcCrMlNUD91CvZkLA7zO8ofPXQqGNIbjr59fgKFc1C3SIsaiY8GWZe5e4xvrB2X3JSk4uzwcnz/6rW96SfDkN1Yro4XY/o9g7ILvwekgoIBphUF4PmWAZlcc6iHHKdSFajh2+xzQY7uQK3WHgNE291AkDFKNqPNG9DNoHyRIbS2UnBSxBXNvUCI9HLOBl+ZR9QwDQlmh8iuOhpA8Uk/1isx0jw52VwZSAlYA0xFHkvNZNWuDBurLrXgruXzEHLWZLJ8WBM5/APMSCSuLFwGV4ZC19dJq0fXBTxp1ytBZnqiG1Hw+joJxRxG2T8wcuDZmXNNpv9LfZddQ/jAwHEmJsResAx7CUNzCGM89WhG2Z+Hr3Ar9nGrcBTCQOrbDXY9O6VFyl/ywvS6Ot+tmhUA2ePC1qbgZ+QzWZuE0vviKUGA2IkB8F3HJ3ZrDKWU34io4Y1KBm5OqdtJNpaarEOrRxchzXPSZq52DbMQY1zkLEB9hRV1Xhd2Tv2fg3iGj18GNJgysQtv0RowEAswiGS+W5MjSMaRuQmAHR7/YnnBGdKlYJOCTByoEL2DGhj1yi1DxMTgEVJHMcs0+Ltp0NNbI/El+ac4zETP/hnHEk5/Rj2lxDaVyYCB65pWRK6EmMR69lS55tPanDmkVqvZgxVsn3qIqs2QeFPCmgsqLAoaYGuGnXE9YP/VNUVs6vWWOM2XyL9sJFVCzjMYmPWnKlxx0VQncteFR6HLMwb/HuuQpisqdWT7Lw1amFJmbArc/bGHMz4Zv8Cjb8jtwfdopHu/m0CCMteyRdHAkUjkxO4peQgt12aAbJX12vQDkeaKJCcYg3QoQsZytvJ8hY1CaCUZwO3Z/kAJ5/jKozs3m82AeIMY4+KDkGkvpa2fTOuShtEKbUNrnCnjv2n4bK7xWiL23kF81h2zI=
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