WUBMFjFH3TbaXWUtFpYnoEKLNvyp43ddqLvEBuFaYDzO3jFl4JBWmVgF95ZOgt+y1BZQKC1pwKZCzwCzH9uT44n0lG80/v5x787uVFqUQYk0Q/2UyrnHsb1l9wGauX3e1g+OE1FhkBS6wuWtAP2o+YcihQy19Dnvc09h6upk3nJneRE5eqAfKLeGfenb30c38TkVLQVsn8QzNOJwdO/R7UN8cwuvNmmsJeacw6e0erbrb8lphgXFgMmVJwwLzg45SkBgJGNrgcfyfW8geZxaYpLxA5kBWezbdBR4BhSB0RacbDvaNPraYhZqLFDogG42m7J/2MvG3HnLppMKBZGShcAzhUdvf5USp3xxlBxdUOnaYsfesSXFtBvZMHYugqiqlzYEnU0Bt4yjOJyuTREErHSZunUF2jT4+diy/IibJVwcjJFk8e4PIQnC37sxZ0nFs3LeJTYf06hUwaDbDuJoc5sTv0T6Hxcumxk2WPnqYIvAMW9JdZhfiQOXk/0dxEYmV1i0iZQbeeM/p6Vap6cDTmscM6qTKD7O0VB5Q81jpORufLNMX7+/HoPe6uZjz4DxF6KNXD57ZB6oYc2YICQWlrZuNQ5Xy2MxcNdEYm5UuQMXjyTl+Vw1G2ihADy/S2YA0MXs07D6yvBea5uCykRnlKwSVZ/ycqxOsiuTF/XFuAdf3CGT+wDc8G7XWHCLF7t3+ptv3ComJwDCIx8Dvf+YF7P32SLibdqWkzipZsd1riUy7lSxhsHwWMAgRnrweFpgD/980uGWLNZ+M/dCkmzWEtFpfaj/eKIxqV58fbOsF9HvvefXR+0NsS/rVKAlSb2TjMHiUE+ag+ps8Tzlth8DjhCDJFhXXAUJyxCVPoP7LHB5RXXEg4nWQNFz966ltM+ow8DLraDl+whQg5tnYJ2RoD5BWoLNyfwFz/cQXielC+zw9dDiL+zbIEmPQY1YPepbQZz6gKbAVs9F9rPu8uDFADuBvDxzBnJmYknXLiNnxnVrGY2LT3293Gt4dI7hutsi//je7Uq2SqSO2iQ9jSkM//xbcGP1IeYBD5zD4yzCGwOuAF0arj+teeCh2+P6oEKs9Wd5CDNGwKVphdY0Opm58jKpgodlKkl1UYZOIzRSR4AfUbsmsVtXfObrqS3s1TRaTvbYdPaT66FvHbugtE5djATfAQhHkCv/hC4l/HHHfGrZWkwfZx7nKkjTnZWExpFSmXL2lSNg9Ua1v2YkLuMxwOAEvk8J3CE+aX2de2FrpdmRO6bpy8pPxcxpfSCWTBcnYoOXw7vCbK7HY1HeBRfiOlXHpcrDHShCb9Cfx75lN+bMB9AlJ+74ho8Gl6Rqt11mg64agLe8ecuPQ37YPzgmwHEPN01vkHQfcxUaxyI=
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