1nGUVuAM7JyCTBVQ1AjU8gXhFHIhv0gnRv7hFclmPKKgYsZbg13tPJewpHFV9pkQGqC3ekXIivu0GSKX4G0FD1OQAKgmXM/jEoXAxSfRwobYUiCYssdCCdAsccx+RoMZEfKgewkpuzHAJ7qmP3EPKUIXyadNk+jnYDyJYp1dtJAJzOx/HWq2iD4ziG5tzeoWl0FumHi9AYAKAYM13A9ggCW5QCtX3TBqEXrQuEOI3pvrxze+l7zuQPvMcBBswbkt4lrE2Jq/SevAXeo0qN7jVVP2bhb5JUYiBz659xjU7FjnOx42OEEXhXvTKQQ1UTuDKX/iuNUjYz/gE/AiP0Z8CmI4B9G+mSrG1v/pYD0Xa+06GPPzAiKaqUlIOmdi8v1/92EWUJOURZ/tLkIRw4EqsJUD6IeTnQiPw7xviYgRnVQQszAOmHmCtPszYgS0qCDY3hq+lYTY3YB4sCie2mCBAwbmsbXjtRx6pu7RTe5pgbXLADkce+Mmf8YyPrPPxVMVHQglKDFNhZB0gSC8ZM7u9syRad1K5V2HHd05oOtWacNd8u8TM4tv/5M2AMkR6iTHZLMzfMVNCg6BDTvIwqEM/luWPCMrRGki/O9JPx1M94tdOpS0hMO636b2Ug7r0ZXx/b52OZgqDUpxCHkcq/SNZNwlHvAl/eZ0AhxA5Gd09wJ5OIs1TrYACfG03Wc567BrZtxkYQgh9MMcjI6tTFsvfsZ8qB0NXkmv01f5XmkE1ZaJXYnf0AGN5DkJ2mwBNXI/O7ke3NOwsMjTWv4FWNOUkfthCMT9jhKUzXqIsqyw29TLtJova2FrC7C7LjXLElmBN7rqmFimf9xGbFDzE21nT+75OT2f/tJopRblX1QAuoqDMPF/wHq9E6lwtYx/yDD2BjdnjEb2vmfK9Q9qeBU8jCQhoMZGnNMo1jPsK5/J//pDfJF1RH6lzIU2S9ZJHjMv4B7+Ya7oBSZmAqz/DRA/qSR3dyyKVlqGYWcs8r3Oba3ay1c4aZyZYLUTJc5HeFjmNhopHDt3no0E4geKwVLvdtdATYICInxECJRnlwz3SK/NoByZjoou/nIwvqR4ZrAJBJAT+5WaQ5mtB3C2akp5GHhxmOLn29i15ZJwx9Ag2u2CGJxXmgvdppyIOaZdmEakjHFdQxFAqZN+npK2KZ2t/LhA4drq112j9O3TH83WLTjqQHMgX+Nmf6gBIxt52iRWFl1IVDumHvoNMLxoNy+CFSV57C7mrae0Fd8PYy/U0LhzMsABZEm1UeAF7T2dSRZ2fBgUNHB6xzo7jtcYjP9lGj+HUdiChewM58ODCBJcATdX4m0MyoRcUx5cbfDeeGhXUoYL7yAF7TcQjdN0iRMN7ytxzlXSmimqFzFokNM=
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