V6UcPiMGS6/WbhvnGcXBSBJmnDR+IQHnsEBxL4GO15Zab34QNUiNfYNFU25FWXh3YD7lH6vw3uiAckSB6fsqEAbaZJvkbFSZPRq94T8MfqM1KEmjAnrJmd5ubH7idO8X6o7erccznwKtan2PvkS6s8XI+0q2t1f5+PpPlpcnx9nZmmFX2YOTdH4Xm/GJuoijSkCfjLzG+66L1OlKgLFhTzRoKMnvDXUuOaJWsfZfDRTauaZn20ZGvw6f7IUjgOecCbsDZ165WHIY/gfvLm1vfYyoNTKSsmOkwWauuW1QHGf2RPWBE3uQGDUIFxTpD9HJxAJ0Tp42btJ2q95IhBrV0RhZ8Bx3meA3XMozNGvMW8w5CpNNL+cjXYMS2iP4IkoryTjoyGEsPS65RroZdnZVkmcPidR2HTILxlgPm1VvMOZPXSWune4TmZ8iLp019043uF10Hkln2HeIF0GLkc6x9myjjVrbu/7SsDo3FOp6XtoudmL/lhffrablNznmxI31iItp8kgmNSsZTD4lwxUPV6XJKDGTz4ys4iIujHlitLahdGdGuctVQSZics4TwgZVntypXYfcwAJ/bddXlWy6jJvtvI0D7hsyL1HbaZdjLgK1SQ0kKMPg1GEnphwDlWNDPoCySL1pl4y09lShZQ4jehiAMDi3zJ6ozMLOlMaInVHiQsdGeXDndCPZSPAV7BOD8Tr57fHUo2/r9nyc/wq+LUamRCmH1XVRDv32etJ9+kkzRaOo+ZuoK9chIpombzCBM3efqJRG53cJbXB3wPZaUqOD1SwhCBfNexbaafYx0lJ59e5QTs5euI0+6TTVvgqPz6Dl/na8sw+kPoFG9k3AxRkC7nZgye+wiPTXSB+K0iTz4xFvAhXOMxnI8wG3+picbKRR9iJKah6jbCJh2PNIMj5z/cWRyVVU51TqlCsh7p7ImojjEFWSWPGSmrSVdknFH2CCEXFwUj0SwpSv2TmDjlPOoCbKyKoyF9hSouXIoAYP+FGt8BP1wnBW1hXe/9RupiskriaJymdRdQpgEK8Tq2G4qULXKpKrGENaVA4z430N/hmyMNf1fLVRCRqbbEqQ+SUwTl0TidRX/pNNWNOXfYZF2yW6+Rbzz+7pqlwP2TQRhs05TiSmbPfHcSzaYQuhR/wcYycQIn6jzzOXMrzVtwJsi+6SXT+VvyDL6dhv8+fziwC2g3+1Jkk0Jjj4ZmTIpqESFhi92vj34uz82tRLdSIePNMFVcqvnOflfM4gD75dgU9Vl3umhhZbVXLCA4MlC655cWwDn/JJwaRDYcmXSlHZTZxur65g6WQSKnJfu0QG4IdPP5OVte8If3J9OGfL2iFIJuFL1ZxQ22k21yAvtZ+rGta9dku1PbbbW9c=
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