lWMY7ASKrCWlkSkY9XM6O2tYp1qsJOUycmmiQ/9vGePTup7MsvckcqJxvXu4vkrKk8yhRQkZyl2X/MDRWKklUF8o7+GVN7ZcgFQnc3cz1CQT9fx3zTtXtGQxFrblh40Z2utBRv0p+yuWbavOakWnNYS7nwo89y5zZyPuW9cSbuADAT5QGE7JxzKRA9zVr1HcliFu9YAZn/3o4AIH9RnnNaBv9L1xxQwAJakWBEsSfu0hTehjr9MiOtCWDYNKQhxtkbQAT+amHna0jx3Ex5xKWckZuea0dYOrXDaS2nFXtdQEISBTp8xS5P6N26qZSvUTmjqEe9ApaUsl4yDgQ4ozzSRbuRqEHvSSLQUgSUfr7RzXFiNBHf8XQjTHlQi/VuqYbU/CoYo3pvftUdLEbqVLCzG0uSYI4Ar3+qZ2MYSHHwIJK2rnix3PNWDhQaea4PBhnhPGdwR7vZ9DqOZkVFhjOqbCqb2KNdjQdtPOSv1BnBy6y0DkjHHpQlSBYe6vNugQ+I5z1nJK/9hj/Wg5NwWWrB59JkthBFnVA1xi3dcqkoHj8Yv/GS7L3nrL8uQmRQLJVefn3EYjodMnUj7G81sckKADGzp5Qog+SyqPkmoKsjhgqQv8Qe2PYFbHwkb3/SXmUD1mE0rOnWVcUSVXzbtdpqWpiUQJHEYS1kStZPWJyvw0DxpKZEbBY9JQY5f8/lFxYVIjO0IUxn7yHv3oRQmk3DrdLhvoTJDs/+Chyf/FS79T6oqGBARlsfCGT+PuBUtxusxVjQ8j/rTFV991/OiIF2pHsTXOzMtrdN9ReGKZ04eeddjHylCaTeyeZ+eNsWeChhRaFv70BuV9p2Fwz4gdB4xIbYZllD2SPHSp+l5nIvkAyL5DXknxKVrqIMtwXL06AwOOfb7Vt8WPLqD8IeGnTCIhDZ1ViUL8lUZe+g+K90LcHf1pu2AOIHjRtgf7ugRQAP8foDp0zuQx8ArX2VF1zDGzg4WlV66GXdD5LVOHg/V9oYxSay0N17msZYRMsJhRytMEsD40rXo5lLb0UsAITjWkoQPS7HRbpz4zm30dbuFJHl1+sOdDFGrlfDIrPqB911Koa7Ae/FyAW4D79rHdTrPVsfHGBnjnlNLwkx3c7sENNxgmtCiqr/mTW1/RPkPOBxAqEju8c43HJMinFxg/WXwF/RODunfcykWzd8j8y2Li7TZsk/K5KbbM9RPXB1jWOtKYLR8jzQOhuCC/cptGBzMlO7wJ+B0vyWfucWqbwjdi1cJr2cOERWQ3ILOIiT2s7aUB2fZ/dbXCtWwD9AP8bhyZY933k270kHPVLdxZ8K59gP9i68h7wNIuRB/0Dp35YzNKf6pE8ALotpK8mGLxrntlciKu3ltYxpsXEj8=
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