slRNMs+01P3fQqX4AByY4GAILJh14kdJSxJLp8o8QdU3HN7wZVuPqHRyFz/yYJTdRQpcoqhO3dxFNtGKe0RvPUyFS2P+8Tdanu9toivP3EY422lWCUPKlVORkIytT0ws/aN3l0MK8uCpUCT451w7TBZH2c68X9z8brf5tktyhWDHTXFLep69M1AfZKDdJfjC5lRY+O/76MVf+VgKMYFyShBnXU8TDmvpkGP0Gjc8cgI4vxFtY8ghlJv5Vnf7CcUbv0UnhaiFuXQGtJWJ2EVb6eO+tC5tkC3VTn8NZiOz5oiQDMJm2ykRnpw8QHqerXqeBGt28oiOV8RB2JfO3h0plZxVwMPt4oHAJqWtyzz4HAUfRGNnpnUIA+dPUq5x9Ya/MyRMCd0dlMwm7UpVaKO+LJVY7R8bCE6ea1agVmhpFrwvNf81r3CwV3hEPfilocfuQc0cUOQGEYJzyTv/fQhzzc8untjddrtjubVePUBbVifZQnuqb0qsP9yvAU8o7LKbiNBqAUH+emlr13aqNK1fD17/TnZvLQJQAOwaO5R90zEPy/GGpbX0IwFSC9I/LfSqB7ncz2NT6PXN6+AP5OVTQzd5wU/bz/oDhd0f6SpTtWEs8YlNdxryCWjhectQd6b/nAbAuGRv5Y2nagIwQxq+E+BZfFN8880/sG6uHWZw5BA6eIh2Qo1PrDYjHNsFiIGBcBluRWoOVFPR8RRrkuccvP5eVFfWZUMQamnwxWnfnZvOYQWtpjGVblihwLltwSpmP2xMgUDUpj7CJwRBjCJ7p0uMa/uj93M9M/MCIWkul0+c5mSPLJ6TNrflRofrX7E0/UVY4TmfMYnnfsVJ3Lg5l+ePgiOg8m8ojQXlX/VxhcisIiKDRDg2p5v0tQpREps6h+WE76wbi0IOkwlHulYre6uMhqqdrB+PHAe8qyhmNDBAW8/JdBs3MGobMazOpFxLBf+CsNflPmfvvOaRcecsUkoRjdWwtRqfFdYzr9+WD3DQ1qij4uMSE6sqzmklQPD/aIyHQX6Yw6yAMYegBhmnkp+4dkHMA6fBC/GwjQYYsMPhlEjenxjJGlNVl1lHhFzQd87gkQN56SSCw/hbP0JSXuX7efX3NIanhJ6c9RIzeyOIWyTh+1pxndMrkYC+1KpFI6JMIc9md7uGXeDUnclQVt25yDyzUy84c/mEcI9KBKWfqkms2f9szTGD4bdMr/662/gjFvnW9FU0AaPNEN71xTk78dKPvVWkBv0xTjtcXVW9g9A1rQb6fX572loCwGPPvNRB97V7kaL4bFyxp4gl2IjHy9g3Q+bMM7utdk3MVjvgxjQarYTIrr20/M8bu+ZYvWSveY+Yb9n1A+PJUtniQ0YHW1jUgf7iAf+rBtQ=
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