cculvi1NgHk38SM9OUVvMnwRvnCEfR9HxbFMIDcXRhvfITQcG7LcYhmXy7cerBuH/dtqRfci47kKhDeHrPFCR0WUmgKbjSAeOk/fYstcansQg5X80kipkIDsVaThDNmd02Los+RLm2RuE2theIi9BOX+fxEdR5Fll8p2afqXY1eis/arKFw2DVbqOB4afO6B6zQcJfihbCK0hTQqL1u+V7i2b+yV9UyDXcWJR568PqGLAFwTCHIbM//tloM7h/1pPplwhlwEbCMKR53R+kWfLH3CB3Vl3b9iZUQ234HgnGmuKDqXPnj50qqJneemYBApOB0fLz9jyCgYRXB9jedXl9fVvB0t7l0YuO6pDfl6VDUpn40FRTc4sTa1pAJKy8VlUAxtd+PLQNBkt/dZcvE9Yp9vS6FYtLslU9NQa4wD9qrteaznYyH2KkvwN18qtNm07qFFCNFkyh6UX04m08OPuEjcXdrkAehpIXExupKVXD2vhLJtZVXDXvrweN5EgHbkmdF64b6wkmaYJz0ANBe1WN8uBwGA5LTaZ/NseTYj3KBWX//yT7BvBSmtbqUQ4LL+j0ePTjPGD/z7gXZlmTe1AOMouDCo6g5EZDddPss5p2jVkDzBjjeDfmaeQI317uHpcVsyd/dPcqnhJanVfkTsSS/Se46xDOfkugF3/b3mLzmkbusKoK9wOv0JA14GBP2UiGGyY6DCuBfREWTlTvcn3ohlKLxYoKuyicl2I3JS2ll9uuQvqipWBK96NFusDA1Xk5Sw9S23I0MQw2t44E+yW2XPJ7Y/U2e4FViE+49hQ45FW7YSQcXS6l10wVjWW0q1f3Wdt+estryBFMEvQ2W0tAeDxnpP6nG+8yXGScz2pvgsTZM69xzANvMC/hYLU44CWJ+/byO3STKa1ErmNFUs/Yi0eoCXZQaRi6yUxXE809WMiLrE+6ka84YHTxbjz/hfqSI+eQB8hS/zgmCxF2X3YiLLbJPmq85XnoGC7TR2WOPiAbcqDwcDhPOYWHsNA02GmbYXgKarVk7PT5G+3x5yk39oLIUC0IYXuwUP7a64zrW97Ewz6F2CYmZbXGI2Rqjil7ylgIadOuEek2k0Zg3roi34zfJF61zd1a3LqRMaBsckEXCXopRHTJk0jzl3UVnp2+0eg5HGy38m5IzLthJ+pYlnHQ44Zcp8hj0EuFgoIiuzZU7ltAEExqUw73hYc8r3iYamETgipa+VUm0eXJmWZULlaD65UbQWJvL92DuNWQ/4cgbYMzU8cgrztcQm9rkPxGr6QyqCsFvPE/D5YL7PJ1BHyIK/nzylJG3fXhaQnei78TfOS00qfyaJBFCV28UaXMp+UxpqrDNmgPc6blBxqxP1IFE1OTbRpYxhCU4=
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