ylZco8bZYA487o/quMd3H2XahFoZFTRIt/A5YSAYQ52hv0O/kgofHPFo94h8lh5n2yfmeYeqLudx2fXnXtXkfzjF3usY53007oJY3KxcGw7PFBS9HxJSQ3bh1J2kptb//gNstAmuUhv17d6I2Z26J6mMepl6OEuFQ3XpasUKKKjQDIF4nagU2wQR2CnnoMSuKArZFwAhx441lfvKnnTy9/AhJyhyaMPRBnpaRI0hz/seSZSoqZI049iU/lSPCevRWqyGl48h1x1VEUHOQLpzcW5Yi10DKcejTVgz/VzUhMIBnCDo2VwwJ/aXzkxmLmqdzwvTLj0W5xc3WZ2pV4RS4Y4I5tcipNEasCLUwTtMS0NIsVjTuWLSC0ZocIsxo04zpw0rCo23xUKQJ0icVcR2o6zUE7lx8wh5Po+kzi6TO7RX0HxMNJEauRpXLpT9scoV0f2IWi2bkJvktVC4eoCQ6vLgXXNnx4fEdpoqvgBzZ1F2JHoC4mxsYEfv9H7z7HBMAegvV7WL4mGRdf/Rk739oMEwdx1i3LkFIY7/pu0P6bjE9uEWMupqnZj0P621R5UGaNumUGZJGZ9AwYnWhDV6z7nkGsA4dVw/nVzqMP3yaxefB2QYR2nvuF/lsX6Az6XweJ9bY07NfuiLaPbdYAu1FpJLigbIDIXy3FJw5nYWqe0cq4NfR5b86dDOjei1jD5nigiIr/UJSfTbVe4WMCDJSwQzyo5O6U4+uRDZ2ccXIzweNPYe3B6N9RA2wSGD2r9To2dZ1jKjmn++Qqbmf1u2kmPL+AtS+6Zeq1xEydAaMcw0jrNWIUA37RXXaM/n6S2ty/CkmVEriEfL2mLbyh7TJLO8vqrYYUTNSmFyCt52JJUycLwnbeqaWeoKMznZLXzPcC+OmQpzRsIWyy5cbz6EnDqVFH4IvYm7kTmD3ImtyD5eBkKkY+wJFbwec+oLK0y+1Os49kh22Qfki6j6Dj6ZlnAhXWv+rF4HRKb9LNdoFDv1qK6HtBHVpIcVgcTRGMr9alG0/HPfhuP1iBZ5pRebT0WxrG5Osa5Nxsoxpm09OSZgNhifYzTXFWkDTlTCwO4C1qMzuaIEUP33IGT4L8+dTKutfprBCDYMn6A885d+hsOd+9TKbtS+Ra5+3SAL+4Qk9j4X7Yi7qfB9WmJQw7bhZtGrZ1nYqvLU4Ze8PA4TF/M85fAty5C1zPl1iuNP1U3nnTkmFG+1W8YqsgwGu8LZ2Bsax2myeZk026g0v9qX3Z1NzmKtM9beV65h6+JkNHZjY5ZJ52BVHM0Nt/ZNnLd+TR7JNBTDNTQREP9PK/WUzihDjMtoz31zI/83Iix5MybhmWVKuUj/e0GtpCROnYDAUugm6/DtFkC858aMekk=
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