TXOVxUlChlPIrgmLDjxpPiB0dWeP4FAAvUYFaBmgjx7Ge7GtEhPXVPQaeGXihZbiwpVvZIyq+UHUgT4HFABQJGPT6X1Rn9LMVJiJJLqucKI0BlomqYhMaxSMuNKB7xlgs4aKJ5Ph6JI0X5nyliPnZVXmuIpEsyjW2k4fOlCyJt94rmvAZWd0/1v4/BvDcOySzbkFdSceWz02zTbgm1VIWP32SNjXxmw7CC7GOMtKWDI1tSHP7PQ0YwOHSWTNrbzgksZ9/ibUUW7wWzDLBztkMvdQ0d7pAhC5ibzI0IlNhiYPuquMeA1Cq+oUUFhntx+WPrCKJXlOBWihm9DcOHv4QOaucdAChS9P9iHTSzSQxbv56tLoZAm1+siybbgqL1TdQ1YZ91lp0CcOH5pVd55GLgcC+o8zLevronk+p6sv/miydAJkgO9sQOS2YWgz/CvfPwFGksEJgyl3g2S/Bm00Ck3dhPn2G2k/Nc25M9U0CCEYCuyL5pUKSmEMnSqnascHFtqtsNskLC2gkjP5ZcW0tf8b+31/zsft5rf7MBR6j+CuJHjgoAmeZpGiJ6mdCkw7fr0eFG6ZjnsLlsKkj6dAPv9Yn0Dtsv6zPXsKz3KbtPX3D73swMJq8nUDFBpyfUPlRXqEcF/8bbkFmB5KCS0XeTC3tWJFzkIa5H+ZXNE7sOUvxlEt+HsVGPtsj0b8eTKu8lHv+Ipsq3/SJaQsCzL/dsFPHX1rXaleLb2sXwR2wIr+OhSN/UGLfHBxZbzhffxcXCIf1SyzovGSuATN6VgJtOZioDxjvx0KFrp47Sc3qOdm91oZVjLFOqK9K+tm6ptRJZYySl+6z6C+mKJFwUStrTL4KFxQsid1xsjqFfPHXO5lWB8/T6i6pOW/QuOfRFomaInnlKui4zPbWl7yqnrU7Av81zcy058eYGQS/YUVMtzRoE2qWllCjfqSwk3D6Vlkpg+exwB1k9PNuhkMKcSGcfr/kLi86K82uurFA5rfKMGHW9BA54xiOKKBGYLOLlsjCsv3CfeJS6s28D5LE0FkrRgE96+lzf3HBJbTktJs1g58CxdsI+23tv8ym3i/aUJi8uwi8AWNV/BQjY2McZT4HOaP0nQj8i2kq+K0NrTvwE0VQuG6Ll36Kl7jE4HiaVXOleC4qcPF+16HOgCIy8aPf9CaZi5iU4DUhodhYnkEeZ4aBYyqwCkIGxWnoE5lbUsoYLXwU6RkOq0zcU6UUbizUsUgUUTK4/UK/vsNVHPlF7wFV1LMCBzWKlUJ/n5CrURuglO0VeSl5V5dQO6+AoDNJJ6ojyo0DjhQOuFBtPkFDjJzsMbaqTCesc7b0POer8BzVluqgME1eaAnqwZ0bfIYNMW8Gt3MlGb87INZtZ0=
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