v/hwOOck3wp4f5/fCdBqYudpMPXxPyHTYFtD7UgKC9yTsZBvenyEutudGucxOcz8nKIYD/crOnWNQ6p9h0TbKkCp3LGIom7hXDNORkHAcwCgd9TkI2pyPyUW7nUHRb1sZ7GRWpvrvPHjOhDlf58I6+YGDRUfB0n/7fPSOXgBga3Bh3sMrR1aNyOUJB1LfkcZKgxclknF9dQ1fZOPg7mMssWycHdnfwX/RnyJLIZ0uzhQX2Q0DXW56z4sUwThC9vnvY9SbpeCyXDpz2SBNFb+qi8zBq7f+kUMqqKNz52j6oNAA7N0FfYuO7IT6/suox13O1aWb30Kp3emnqZBUf9kJ744sUks8aAa6wCLxq6wV1J0TMjONwyc9Zs3ypFgVXIxb8KrWRv2o7fLlBgU29lk/vQYSBThWh8r6PZuNjuVrIkuLQb1iM1Bj1bNZG6KsmRuUMk1IKW5Pc0s7dP2og1Be85cbFA5Gk1HtwNxmggHfFoVbgIDE6wZihMUWU/gKzQ45Rs2O+59KyCiWcduGW7L80J5um8q0AEyX4m2zoUGgaWv9Ji/bgtzmujSDTX6t265M9BUxipdOY1bpTSEKPiQfKCVYC3/2eZanMBXdf9POHTjBuwuQcI/B5OUpRKXM9jGF+p6OuD2SIGa7p/80QmsAhxTW7arMAp26fz3QmlD+VEOPPHnwHlOPyP4jN5SHWfM6YUJj34BxR2AqmUetORh/rvd8az7qfNEDvH0sPmuiGoMPbGEGGxgpAf81UMVVwFRysLhwf2TJRL3a7lewD2UIIorOHFgqWAeiUO4BlTRmw6iN/JECGngYEIgtrNrBQc2haIriHUEKmClF7530OM5AZAGDRgR0v3pe640zu9YhglB/+J9BP6g4Vi7Dh13M0gE2O9Iv9h+A311hnzehoA6gLOyP7BF7dnqT4EI9OlIZJC/Vrv8I8vFX++3y/mb3UBD4xd+lYPOXwAwoocDJpiqohKT/iF9gJi9fGO2XKH1NqKfmclB5v+h6VArEl7o0jFbIr51FlODuOBVAQFaBPAPpHJcLtb6x22QtLsEqaimHUWRpPhuIT4PKq6b529xde87apj2Bocrbxm8JBM+1EO3OpOGsEBQ/mx68SKErtGTUCq/+YAsvIvX3pCU4Pd1cYoW40KU8TZQ0Y8W+4ttgwoPRkTna7DGwn6hrPJArJJCCplXKqfPnHffkm6FJI/C17kFxPeFYUvGbxvGN3SQe9ZtfDd4m/qZiemyx4Di3FzRNA8eRtbfYBiODxNUnIBY3HDBfBHYI8X+36cwumc7YB2kytSfBs1OIOvA4h3l+pABHf9W2aPvNvh+RXkJ3IbDioUO3nq9AWKi7gQwZaWrK4wMfU3WB/gAoZbAzfTnSB0=
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