hZ0zhBh8v3NAW5VNRC1ZAE7EEtiHs/TR3WVofNuELCaw9yvuEvSyNcLD8jGuXNEiXIMODpUNEtL3MlD0rMS8Lnf1MXzXyE1LJRem1amYYoFwLm4voeYUlNHOby9ZdAw3MRacru8B6HsGNQL0K7VkvnofxkUxd5o3z9oEsHDyq1Wgq4bWr8IC3Wq77mbiSexACvgaHPaSQekcdUHgBG/bGjPhoJ5bxoFTpjWJGzcdyHW8kmviSS9bLErPXYIJ0AHzA2qqx2BK4OWx3GSJFxkllOip9f3PpFZxdQXgSpnB7Nwx6a9S63PNo5FtQucjbAIYQ9ssA2cOJqh7j3D36sKCOWAQuGRwDF61wpHDBWTW8oT3576OBQywBYaizZYh+DLHd53onXr8GUf8I46HfR6hImorzJxTfMqWrZPScQd+woKRqPCcMlfk8HCVrI5Ga6QHB/Ie9Dw3jrlPUs4Ua96wxodCAWxR1plzjYeafMNDhzB48dB+T5iuUSYehs35GpL3Y+A0I4Jv6hru2Cq/lAmWtxfsXUKHU14OSPZLCX51aw4Tf7Q+hTlfbdwjys8lb3YZSmf+nEWZH0juk7Yocqds1Ehxvt8S7iaxCMCNvWQThMBpNAj7jGs7m4felD+Gd/X62GeT+GTsoFC/PTFJiv+r4ZN/VNPs6znVhDUd8OXRKuf0CRUODxnuXe709RKr1fcrs9cok/wXr8w6n6MMqjEmmv+6c5I+no7WnGh4xPZjMqWANDevPuu4dzg39g7sy6PmLu1T6SQCpTuQb5Bx7PXgddgou87hN7jgfIlHNtpZXosC/hpoJcOop2hrDXfmgQDPYyK6oUGyBTNwOlH0U0HYd/hEaR620D/YKQG6uvw9+uRvFRRvQD6UF1MRwotJTCFircuqvQ1ilEzTcm/cWXXYF2DDSdOe0pwzYlzu9qjFj1Hw8rh7aAyno33tuszuVjNuu/lWjWuRLa7aRVeuotvK37RopL5OKeoSBz1GQnglU1kiVQQJcm3Ct93uVIVO36m8uSik/oItiGOioneRpjs41NVfBGLeRZIfZqnj7IyAKCl/MH9IRl3v33dBU7oVOZVVl9BdbrCfsSEpTO/znFiwlbAbfoeIQ966rljq79gP0wiC2e2vj5HKLDDPZ0z9LuvlX1C9vSV6WzNgi9EsfZmF8RBuAEfSqtRXjKc0hY3ZFeKfUnnuQCzw3d6Jr0I/WjoJctXSyHUNrLJo6B0zDgUbyn3fZM+0vISsFhqC8bwkCTtj13GLd+cpYAJXv9pplBXZoc6NDL6QI73pA+s0abSlkkV2suB8uyKoEXiCiVuEIPaeaug3jx8Y8bZfbKXeRk1gCJPwg8JZxyYOgqeTK41Be9cuciLmwCQn3Lc23bU=
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