QC2ZKQymnw2gyAlUVt4FflgUvMKDhgwsig2tr8/X0OZiSOkQ+MDNhZLTgDJLYKvsTXUuhCI0BEiNzBgSn3l00cY74cEMRIkRt52RyCR+JJRJvtvGgcjDkO5JEOhB4hhZY19d3lMpWoMIT+5U/MIQex2CHsUvDq8COb7AYBIuncMef1FA5gD70wlNoyC0B3Ys8a+63u1x6VxLjQik39XR7E/5sFc1TMLTt4MatVw1Ohoy+gtWTM6Pz3EBWsTX98X56oFDYkic5LuUQhOpeN08kJd5+o7g8GR+m9C3WaklQ8orUjKIIUMVCHuEklRTp4fiGQlV+lK9nQ6HOF3sIci5W9rW5PHS+EA/Yz6E7JCXWIfG4y9TlQtrE9qyPHTLeM/lbqQNpzzlckAXxuBHKuhoJXmn9Z6bf5a6xHMkjDdZAkTfi0aWqiIN8mMvCuw2RYlE6ghEuDmVOaMVHYG7ScpsH4DXCgMcVw6D7KNwPjBhGKdERxQVIFeG+2Jt8fiIjJKH5UzhRUYZfJNlvFuWN7zGgnEblwX48z8Q4tUSABnmWmF4GKC5ARxbWA76bJ0gg5blLJmT7L6KjP+rr6ZaqaGieSYzjYapDYA0Xt4UZ5QjHdf5Z7YfpaNN3TJv/n/i+/y9z+QDItz9TsujxsbNnj9FFPEbEPmOywocrDPOLSpx8MbdrmyKewU6O5/bvZ+Md5XDfhmNKSmqQAug319a0W9uBGQOSF1TXv5S70tPP1Kbln+TrXI/Q3YjEC+A0HEJcfHpN3ipkVBQ9cxueNFpmLLXclZNTx+lXt6vr2MMPR0ps1ll9USjML+mdl/CswPEoRXAaodgviJCdHAaf7AqPRgO9LP36p4o/gnoCMzn1wfIu4n4lhi7oFtNdosR42BIqR0F/6BqW8g/WDsUVIbcnkwuAEwO6TZYNr6YjNFJ0IVFJ/kO/3sFKA1K8DTYo2ijbmbVrjpG3qPaMgC0ciaPpyOWK1yQAeA3n5CMcbm8leuRdI+q47JZktiATLTbDIgRatB62TaTrx4on7BEfjwCgMypuBNdoz0Q++64C6sSVIDMKgz33dRegXDfMfKpmtpTgr6B4BfDAJ14qn3zOPosWEKDDY5a58GDW2HAXj7eUdcwpZ0+wrECu/shSjNwf+zTw07IJ0rot0MetmbGrho9rLfz/fNUmavT/q3EEYtEHnod52R+fzEFuGz3GVAQEQA7jSgiHxVQ+K7RwmeEcdBea99HzO+B9eCDxdEsh7FmQe/n+qw6azKfL2j0Rp2rR/MOdFfrrdpo/HPQKa48HlKXCeB7LdqrMzci7fM7Ly/UhhXQSKDiAccr+8/0GGdUHaQghG+I8zGHav95ANkIrdpDdR37EjGM3Rkp/FhYJEnn7F8=
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