yNImFI/Z/9tBui/kvkS+6bSnpy4PUBsNHP6Jg1+P1qp+H69RnoDV1cDlOifcWZpIqc7aMyP7EXRPPXhSY5q9lQil/xSse+5gSrjFG+0+bb5R54ZGaCf7Co1ZHxW1TmrYym+MQEq4G6MJlSuYhPwlaxzl5Pwwj/QKWOSJm4eXnaJ0AtEUcJNuhcvInBgrA9KUslhssif9DZxLfpwP6LRS/6FTSzimfjI/djFkaEuj5MkJMosQKQeJPU0v7SqEvHozO05+Z3tS+PMNgse0dy3WZXK2AfSQMu/W+wVDxTH7nKK5lwdX06QgkaICa0OKZc0MizzBd3kbcxehDsoBdqE7zj/A4APILUlFYxBJSxCVwNK5vuKdyn6I7e9E8XGiwI3xV1qYcGArQYXncOR3xC29NL8Lu2lQwzVyQTD06GdAg6qFnonI+PLcEm+YyL76OifASok9dbJLLej9poSRZgj20EKNqBZJG+zVVBALt8Wr5NHGfcTKZjI9M6aTAVkIKaz7mAgNo02lRZltV3DWOzyg8Ly3UKaCCA0FwtI/V5zLAta+9yQghHYhpN5akRVeGJA2CNSzxYxjPrvVyqlZSTXqI5oTfGExrcfefTIcc2nGwJ+orFlnbP9SrxQP7+qNv65lNAPDumIM2Xd0qebe8dIK9Iy4HZfodKJxu778uuR/wS/nfrVhkn+JACivVAhvr91RaDtxK2823aK8QrCsqHSEddB5BLjeRcfWoLDa+9o4I6eLfRoOcnAREKAyDwxYkC0iANEq/h3TgEPvXozSOPjrwbM8YLo/5RSdxNpQILcCYnvN0xuYkL7N0VXfIJfB0vcQ2rJMzFNyxzNxNwE+PWQ/yb/OOp0d30fdoaq4XDsf304/iUEQpEtR8aCmGHTN1ph6R51eVdZWhK0KiJ0m9MDqbeNc7SaAymlOAXV2dhwF/1uiVZN8yVg7n3JM9END1twTPOSa8OU4JmQ3WZiBUhfEmsjhL4KXXTzDH8XGyvFz/EMPNLfelMNhMoA7QvYf1k+oSEBVguWDPu7iCbgdieGFZOzsyUjqeIRtHKTV0owK8IuzYL0bOR9Bc9HZ1/8BMOvTiLr5yGY5qM0usVXQ7x3Y5W/1W3cmghL2ZHAJljOmZyHpEXVQ5IfUEwZAFbcM21Oy5+S/MAGbA5HHRUC7OVh868Nd/0tgzHtR0VTDF50s9liHJfwBNIOuMhOhMbimHq4flyTdQM04LyFqDculOns5JeG5+1sXXR6GZr+D3lyzU31xom2aSNMR9XwY6+xurS4WFkSnCE82bw/PZ63MwHhczYcHMnc88/sHdfCspOj7uaS3GnHPaMxln+xg63Loeykt26/DfdfXWqg8i6W1LU6mLXrMlBb+mqc/SdHyi/I=
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