d+YWvM6+uf5uWtasfDW5001J9Tw+/ot3zBHb2H/wBR4W3obc5t38BWxIz3l6aK9xclhrnNvk9o6Zwye4BEsuMSYitz49il+VH9WvkYCW8n3bdNFzvHOru2blMepxYGJe4Gq8gPvdI3I/g9baSHETZ4r87E3CYrxS/zK+yYXvkuLEIhWlJxvdZ2nDra/syq2Qx10tW6aTPxS7J0cohtMwUTw9G83i/l9bbN6wkHfwQogvZPkgdX0jSna2Mpvyz7/8D+GsXm+HimTE/nLEBpgOeGsjQhQiWsAKT7Ti/2oOmUr17LvYcqPDOqq4oy/B5jkChcEXOgMxo6uJdlx/f+NZrqZucH2/Iaa7QA+H4nPmZJDaqfp+dgjCCxagO+4vc4dmOpw1gOvqD8K8SgyXnzWi51IkJXJaFS5BWIcbUfbyUQNU7uIISIz8IN8Uqrqm/Q/9whJwK4XQMJ5GP9UaZbH/vsnWMfUHgogHHbzgYK6Ln8CggaaA4btYLAgdu+T2zOTBvyKfohmOxlTrZ2quZrmw56MormCmJJ3/EBbG2aS1Gy5dzWMxIGg4OXhBMG50eLg+CIrVZ0cZq8E+QNd8OJFjv6zMXdMydVY2tP2QrDUJ32ZR5nrEWmODRXozADBruAqHoHZSxIwMBgOgHbHT0KBAMxuXxQa7XmPwP3qP6we/6fxnmyK+8meuVHc3cpObVagZUsbTj0r4/wJ35TFiRByZWKSNWHcFBcXTkbzN/2DFCDRjSkzeddVEPOdxh1l5YcWpnbVQM7mpbF/E9Dmy+IgVs7N9YUkEr1xJK8yefPIfiat3hgbT9pGJyn4rzJ7xZkshDwgM6DJ910xuwL7YtyLs3PmU+SA25keLmA6GGFvCrOpK8AqTPzWFUstsMLsCg24oFHdL2oh03AEgQlv/B7NOWOp9gEt9qMQQPCT/51hZTVaaprm8cPAML5IdXdMTSTb8+GjeLGPiGnfIws8DCM1woqztTtGLg16CYCifbP9t19Ibih/s8N37BQQ9bW/1NNY7twaUBzrueUqkQNAVZ6e2NmyNypRUbSP8zGdfhj5v/YOphLjdEwZs6a7zJfPF/R+HTvJcoNrmMIvLvkJ7fyvE5bcEJHkuvhHiXbSnmT+2yU2CMu8PceOdT4maxk2qMHi4syuTwCRB2rUeT4UO/63Xq1s2eS5AM1PYcmQ/j2DEDcma05WFD+qMi+kTTogBLWcrSpot7fO4wGyCJkZzA5dZ7SnDXbaGpMwGVvXdq0eQEOW5cfLWSsQKPtfdw6M94uLT6lJFZb5l/YqFvw2DB9w6YFtmWtrHnlNwOZ3hiHLHb71uvB2WGXr4kGD8HXzs0GZSurQ3fzEJBWPJa8alfTQkdrSnCI0gRFdqDTjCibg=
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