rb1Cqqn97bEQm4BfYHcriEaiKkRGxpIEfOFXxMuFEYySUi57I4DWvGlQV3TeBp4PeReTD6Q6S+8mHTGqZ6OFFMkkHlEHr55WsidDp3cOCuObwjERhPkH0MjBDMKJxehY5g5rUgdo+EY860ZOtcQ+5IZkeYDDmf9jRqEeecVwSJt0+Aqg/hn5O+5ydmWM8ibd/7ajNQZGwDfT9YJYhqvVXSOJOtFfiW+g0vBDERHbhRfAM34G23kyjzpjMsBjKrf4sVt63rUlAGUAIE1SnCPe5XypM98+04qiAJnV0zN5DPThcN/kaXUVVPjCTqS5Nu8v9nweGph9jykGXuoSycj/B6Dm3rYX8VNSqWXqB7QHavSa1+5nH8N79S+4/DhQvehFfTJcsKhEWmUa66pdn8njm/6nnOzZvay//owQ/REaI11wte96zAEAbV5PotuydTaMgcxCAG9KTVOhjQ82PdrLrfXIkEpqHkh8/3byYwPm612lndITVRihYu6+JftrdpZkktNesJdL5estg4eQOeX8YxbxhqmZesoPiC1k92DFS2jxdRnyG3q74J1bBdNo4+4Cucr465mgRmu7x9JtKIQVEVOukaXmBBmTLuJ1bKKBltN43CLd48I7F6D0Ma48vU2Lhc+C7xXLl09KCLNX4wfs/zmnAFCFrnzr0uzkuNtYWpX5f0IQKlDiZA0ulrDXc3GRP26ICcamWsiCrnjXKnDDawA6hixjGupHh/fUnLbzgbqW/BqVpxptgilZUxkzfSIUKOZ3YPpXCAIAPFY1nU+lO2I3AFumZ1BTq7WZVr3qOAJH40P0tRYtzDm9qw+xPcj2v+elR/vw7uTotU4r5X7fT7/gVLStA/EmSDzyrR4EGMZ1EDfHZ+9dtUINL8rKGieUFIgEo1UxEWFr+ZLwVNDxj7tC9tuiF+IjYcECU29icq9TFdjDOG0yj/to1zzWCYlgzBOTg4zqy1hJ6F/CtocmSNk4bdEg5t0sTE5xu++JQF015HnzjZo8GXXrmrDQE7CDFaIzJh9UXx5KGsZJurc8dmdzFFqh9ZAhd+K0cdFtbZYBy5o1wz8SOOzCgtYyqbOaQiNyFx+8KZk/h+zdd6qEWfiWB8KeujvpiSWBLB+xAr+B8T7hxUZkBO0wuS7Z0GnkTUGV0tTRzSPs/1zjJkkOzkzdKgxVBuR5eJh800y1ZCzFjKYL9WNsNeXBtN5vxTSGndaPPDMAguFFWm5ZhsNjTi4OzOCteFW/4kvoIJraZ3f4mpHl63FHj+RbknDPeNNvDNy6wXDoz3JLIRMFsmrM6gj9WFjHF1WKVvfrUaFaHp1KFDPmU8FgBh7wNz+Itnpa62Z9XasAq57tjlRWoQWnV0iJKrgCNZbj49EiGNc=
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