jzlH5i/v2OEc/gH+cqA3p/uIh7YhIwxNqoOjb2Iy1sOF9eDFYdJUSHCyxJFkPNKP3qWeWWkZ082iiF82md4hrH1OIWpb64riR3sMbLaJZXnMSjd6EZ+hsHLaz2qeXmXYgbIB2bXAGciAupJsBMgCc5CuZbr1loa/vi+BEpoZHSeyX3LDo8+gvGeGfEs09yczSXjpXrsq4nlaY/gtGqwuMS5x9Y7xacoxdGt1wtqKiSJkEY6D9Y1LGhtcMYReF9XY+hJAx/A6SlwoKqnh+QdGKMeCefbT0+ZnzBfTSor1I8U86+QzWkTxhOfyjzX6rHJVUfDYXsUtyAEzItuO5uu1NCYjxY6hkclXZmifTRsR+BbtSF4E6/qSaLyjk8RxAFhHX3+YTR0HnZnn+7YlBq2DNlrw2HWbflJFseqYWKSU0iCtpsVa2Sew5Cl9lyFNTTilIV5kvLS6wLXlNTZc+qc0AekA7pTb3XJ1Xwkhmo+5uh/2mDPHMAaeAnn5fDeMmdG1Gt3T/j5OCthPUbeQ03cv1FJv7AfwneCfoGfp6jo1ActVVwy5Rw6UWvn/6BiZHpsbbjHMyvNB4WqJVJi7sn8/DHoKFb0rhe+xaApP1qGIXq/3+SNwEdhsx5DN5K+k0y9WPgokQjfqSCOYrFdOz12pVdiCvVLY4nOOElxHpiQcyk2QcEkgkWiDvc0Ym2rua2f9YNj0Dn5zIvckMxMbvfG9VssakKR9+Ct7tM6cT8b4mHDh/tAD5KoXs6zhJiNjgH+7rAZPAAuVNL7lNnLzymcEBINOLf33sh4tQnB7TlPnNKaYUwj3/Ad3DnGxgCVoZCqVCP6sdGAI11xIFdVTtlVbnw0Jwl/2IYMm5AujhTad+eK8nyTozNCFivid6eo2DN603LDgrdNvtpsvJwy0/cZJ21VIFc1lkNw47KWqTKLYeLqdRG7QqUBdBUbYyoeWQqoP1Cf2ZAqFTlC7JTNMX222lzzaOlFH04iuiEPqO79JvbiRiVLj4qOXhI3KgSQyzDivyPwF6s14uxGkSwYWmeIEoV9zlvCj9/zV4gqUUY6ohBu/92hfqu0EO2hIoEUtR5vlTAsBKAUZjTi1PhEVOJeQo9sJWXBUgUnJ2u1Vvzblw161l363nhTzwXYC6z/MNfzWwjYveGGaABxUuM1Nphf9ii3UHjlWzuGvMKB9xw/nSWwxCTRS5dbQGd8jtQ4N+hMz1XKH4u2Y3uhTRMbe93xEsvJ5key5AAxUOl0aXmL4gX1ARYEgaSyqZH+hQh+LvsEkf0+cdPlqG3aoGHKgeQFquiVxpsk2rF3+iX2OSkkQH+QQ8XVxJD4iex2NzjmNrxTebelVMP1YFzsXO2VXl1ITkf8N7rq6QWER+AM4kr8=
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