OGPhE413C59VRmld6qY58tlctzI55Fn1J1DWNsDRZn7xZgEp4m9/MULkySLtgtjT5VvOtdxpWA5FQaamW2gExOMPlFOwsjtCOR9L5Rq2APbudM94I0MVnUgTWMfyNQKITXZLCuEyyVXOH72HSOyu7p41kSA/l9jMh3FuOPeftp+5TvFgY1IK/7JitRQanH07VbIr/M0K+HwHLeXkjp6YB2SS192Un1ghzMLJhTBh8rYh+4OiTKFNF0Lpwj+r2faO+sK95HptJpKIS9jReX+wxQpLx6sHaUfrAqNfDQ6/ZNkNDhRAG7yS6+ROStgj7JbeKuduXfwNcnjJttwPGkOZk+tIHSRcwuXNsgzqKOQbhM5wfe6fFDTL+/I2KoZ20rCa2yLkH9cUKqBjucE2lfMPjRDm5Iwe5pNUydVmGjlfXDXE7K2diZIfFZUxVOIEqQeIMO+o2MoRABKCxJyBPjJ9R5aJw2VwYQ0KLBCOSZJ3WNnNh0AczN/kc0pxMdhY0w1dqvWWZb66C0yxXZ1DsRKBkwt+j5t4zNzQKUI/4fg7Lkr3dNJagIhGnX3NZFiMnzFgnJfBPh54odmhJqZqLiqMSdVHR4SqVq6LyRaq2sVWjuGRJIHKELn1s7bLv8uYcozarZj4aHzUx2LGCAI651Uj6HWqMJ+m0fuFVdcYff2UXiFxTBVbI+AoSjdM7wLOdUAL4t0h08TITygnNUZDR5uQZfsEkm7H9xSk8vqw9EvOM+sVtodFP9O6lAp2g7wXB2IXrAPFX2wey8axCB46xM9nlIjmfC8L40Xc9aTM7id+e8viCeEYQxcCKrVc8JaKwbnTInPNyp2/L7qEnHTNwhZ28uQlEvnB6aT9mZUkbRCK3P3S8GCBokj0+ZvBlnGdrsd+FxTlPGnwJlr0pSc8b6R0GPS8VH+2T61YzB8ZQDrp/hiJpAighB3KLt3vMYrjP5gsNmXPJl680eWijRY706Qt9sQnJmggoeBsnFu1xffxGpjLRUZsvz7FWrgleT8PNOWSkJS0k90HM5y7+NfoK6x47yyjZArmmCep1voOW6unL/I1Qu+rVUchvkp6Elb/FuvfiDAaJdVL+aIsZQACOt/70AYgM8NlevLbhz+188nMr+kXAkUYhZepehlGag7awHdeonqU1Y1qQGlzIYA4noRwH9xOimqANiq0FFFcs/jimlCuFi6fwDGaBR6LmH63zPZnHmfbxSeHDFPcq2E/TWGTv4IVmbLJU3MHN90vtjDU9K+cElz2CsfHK/nc27GIqopk99lSoXYxj9beqU/CqE7tDmXhwoYRyHd7aViwbNeeeftT0X1mLFUse1V0uk4y/0HjRS+RK7dGbchZ78NgJkV47QqYmeC8ijxBFGin82M=
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