H4rLcUnWTbmJBV2oQx6qLZD6D0JbogeimdD2yepM9LxjYYu7ncooqQ8VnscuNoe54D18NKC1N4ONoj2rsrA6eL7Kwgqj5iewABp5wuI2s9Zcckixmv9gLvOJOm5g/cr8wscQ79IMEEPdEn5D/ODgMuJFJMwRHtYN+ryq5u6nd9uGq6KWB3BRfkLSWKBbLZPy4IcAc+LOX6fMHpf7EHI07FaAoc7qRyRm10zTFq9ycu7oGitEF7UyILrQQVLR2ngZsBAlcPfS/2b8PeUQAVHoZ23AX7VJX3m9CtXl2YBBbVm3cyxLDFcpQ/c7cQ3XptEkQSz5R+Q5QqRwBDyAhX3C21ShAGzbDbMB0tqQhl5+34fiJryF0D/I2436KosD5ff3uGqnqbp0+l51eQJE8ZgHwo3rsY+Julny4EBqNmCkCSisS2RJyjwXJ3TY+iHmafWd8BjZq7LLgsaVUWqxqly3qTZfdBX55nkjdAx2Qxf3mr6Soejp8p0+/kMs/LLQ13C2RrX6HOt2vErP+8ncyIBc3dpiuRThWSA9msSip4wUJy7SASBhDuKez40j99g/xBcHOdKdIbD3nEwn2wJyacYe5PRqDI3SmOZfJZ0eat3VtUyZLKNGeJ+7lt70a1NB0dxwj8iVYiX5mw98r56zFpVKSj4QJn/im7EejITuPAR1JrJUcyPf1I43Jbi671Y6SGyvnzBQWazm7WS4Tfg0jss/vZmHzYmgnOuTTEOBcyC25yRTLAOAnnimkoivuQv9rWZGb34dFu5FDWl777nmZGGyAhf0Vjyxyhgw/nVPc5uxR0nQk+6aD/JSpq8JjivetUd40WffoBqZ83gOStWNwK3kvphifDCGFKSkjyfNDdYStQ/mW4otvblkOm0tfb0/LTcGvb0sOfuhFPJeeRlfktI4XOCZpaMU07gh4aCm9rm7WzMBYj/AeS6xprawLY1j2m1Id3RkzwoUhYnL687I+bkZIRf09tLLCcxg5yO5DR3FYIfBvnWjbtW+ObPcloBeG/7gX79K7z9bzTURksDBpc3BB2D19/Tz5vl8+cQurqwpUuZJFM8wwhAzpzDxWvSRHhyd4yiNah4mltVezt6U6MkYVAV3ZMzPZBd3PIL3ojTyoIzydoK85RXeOw6n2YGJ+mPxM8LiTRdL7LMitho2N+0AmCzjyQn8Rdny9pL2KlKdZoU15CV356tyt33W2TQVtnVqRo8p+3eX/fhBH+1yul/di6Gfs5AT3jzMnymo3LwaTeTRHiuQr0RGZyXByGK64uFOBaZURZjvLxwMjbhABAd8cb3Mg17UNl7rL90C/VdeT0TtrJ1HK4cIWZDZFx66d3OlWLAeryp5gTJIpr8ix3MHgtAPvN6snRQRDPIBJtQ=
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