7L25UdqNE0MJ62V6J7+sfHpOjaMHl7ddJx4vKXOSHqstS1dPMhU/q0yFvWM467acHRHa+54lrtIXG8qQCKA2uV8rWTzb5oJA7pKcPS4JQepy2IoSjVW0e0cUEINBuJVNScqEPmRScSC+jFcouZbr2dApbzVG2fHqUIqAJGDkihn9GA3Vw00VT+V7Af2fYuYl30rfEVz/s8wvXdiUV82ri+gjeFfYxRUKTkKcB9ltwyCAVSn+hRkZptfgIpfI7/UK1u51o+EBEg3xULhldyJ3SaU+JOicTOh4KgDDJrmCN8Dg41Ctg7MPgtMqoKo+1gHWomvLqc4yD3VchQVtS1KmioHE2ZY7RruRkGN3pBRbuKQd39UA9q+KUQFa9bV5m0jWn+ytV14AhITXnA22hxPIHhpqeARlHxkNj8QtRz4Y9TYCQFZSsU2Q23EQQxAHMDd+rU9hzBuwvpe+ECvoInL2fiWIRv6PVULlArHVaDRtCHZB0pdv8K5hLOp+h7rorUJlO8t8ggUQYLJMUOuISaTr2Ia/NfVfYR/eR4lzLKEvzHLoExjSpBcthwGASmEzdrvn9BIFjQUU6aY77NYxDbxanCVNngF9Mrw5AGES2jaVw5L5WcJ8edrIIVakbesqElKLKiBZhFrDgYsh34CCtp0waWaa634P9zH51gNeENDiilFR8mWSz4ZMoLtmQorpkq+0VrHFq4W844eEGth7G/tCL0wE+cb8DkQVd+fkvFVxxPVLqKBP7q5XkfiRJgilBdoBt9TGZh7lUE5k6Xy1zPvPGYqnrPswZv/nVdgF8XxtC2RrYY4FsvvoJOdtYPP3s2EndqApClC/A8HGNtMKEe2hw74FBetfMmx3bL34wzFpmxBeJGMFPAs/Qh4DxlEgWaGHu4Zc0pbpkYaSgljL8ub8DWMyDqhfilWgu4mtEXmmS3ARm64fJL5MStfxH9nB2At7makQ0uDhqXf+WTAO3GpSC0nroHSfJtJcB9qqfmlpJpMEmKxU29M8VDrVcY8u5tNnYgrGaXrSTmVbS6NLmZ6rPK/3/rdhHvFkSZGUeSCHf+zR73EB1ZvIw5+tQGK4LJ7rVvBrlAkhhix6Viykdz6aEn/oYjLsO0C6lBlt4fWEQ5qoJGPFoPAxFpLNhvmuIiEHgFM3KIpYScnDxkl5WWpWoJAiE2wGCs2T070h0uw5FOsSn8nLhA3QbgvqQShsuad0iH4WINQPL1DglVOE0MHRtwcXmruA73F6oGA6gEUizcuUrT5ZPZvq2ijohdjLtxj7r7TuJEfRpJAeEwN/e4sYmc3ZLkxH3Ra8fxssQ11ZF5rJy7uh9M7WM1Ls5hSt9/vX3nffpvdf4jy/+6K+6tMBRNTZ0VMXBOy2eMPQkNY=
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