FU4TtHwdYuqOfzbl9MWmoisTNFnOcUhdC2zw6trdOgrhQGiG1pnJR2egiQ8KrVWMdxNlPgd9HyskzMl8bUXzumsDznWER5yUDYrHngUp9A2ZicFkxak15UV36BgvoFpPU/kMTAGsGxD+kmcUyNv0aaIsmbf2RH1azyxbsqRZBvtXMTv7J+3Cwptbh4ZJ4XXvSZieZkSSgwYNldqQhgKdFLRrcT3v/v6jmcebtD0Va2twh3FDF0ohgiLIadujz/2WEa7NaxvaFrU0Po8Cq2TYB7iMJKQ/YP1WIkjwWLV8wH2wmLdw2T+AM7hI6WrtEljUGG3CZ9tfPTEacCQWqvCZG7ROl1S15N5W8NcVjs3VPjCUv34gAhnTF4TRrdDrTC1Heu3Y6j40CxgbaFI5wicyTN2RHcFTLGAtfN0zn7WCAFWmFyEM4Cn1Dy/ne/I8qbSCjOkQ3lRnvmQ3I5Qv4GeMtxLdstNaK2vbKCO5MeTD9KuLDDYtOGQC17QVoDMP1oxR73cO8NT/H/yqgOM4m602RECTIoSmelw3tEqHzKDwj9D11FnAiXYh3cntIj2hcsNdkn/MMHpWFL6GAbtxwV+eufm8ocqiAwBtV0Px84rtTR5XUY90B/7KYu8v6DCCmttZWGs+3svWylDlvShLeU9MhDjAX59Ibi5KRy/u/DFsEcGSQPWmy3IyebZJLb46haTuGpYHjfuRjrKdUEpKVZUC0I5p53wx/opJhza8McHhHDgzqz+JOdhwoO16B1FNWMM74uyQK7TynWvLtpkxjgIaFaq8Yv7Lxln8035USq5kNpIeSU1m13DfzwVVHncWIz0C9IoW31cIwHMUFRB02hLxnVuFZJk01anR7wkxe1/WXqITOfbF6YarvAqAX174TxwweaZcB0PewMi/PnSPL85HBSAL7NDLvQe5+4adQJMtdB58HAeR6ngYF9hfQjteFfNRX3p4PGqSobYTU8kNfgEirlK+BfQXj26FbRl70aJgIPCkdiljafjVpKP+PxGX98aecTcSuJyALF66QQXfSASFgwiFHKqpcdYqysCM4Y5f78M/WdG8EIyvdP3zNRzN4yxp+D8QIqjHCWvwlKv2olu9ZYjIaLxR7DLQNdrUNOyuT0XRcbotSoDl+GL0V1QWbxc4/TFkJOPdzY4c0RIsH14DKUeSTFgKaHE9zt1B6ilLtNHoRKjBIryjaiKA2menPSPJlYY53RBbC1DyDkvnKa8lBTvDNAowjCdn580qKTDpCmF37k5eJkyJEQs4yj68JGBHV5/fABmOsoaeQZu98MU88rsHcXqdsKWpdyLAavWubJXqILcy0n9v2eRfiXEEAnX1BitCOwOfg8eDOT96OB/+WszT/rT9MBfw2yHm47I=
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