AFjyUqUFjoHKI/QW5otPglBJAYe9fvdwk2Zufr+tRAfpkU2akVq1AGgV9YDKXM0j/VMghqvB12snUkjBNSX2TD8S6H9C/JSsWkRpep+KeQJJKsJ+Xctohz7SR0tFhnMiH1Cy6eppyuif1PUWyczEWTtF1WiMDG/0bLdsNiF//htp9z/SCyhw2yt3e8E9ESZ8+WPL1yEIVaKwtwKfyVJNr3FrcLhHn+rtTtFixnjp1BymVKcIplFCjjsCWfeeqwPayc5Y5rY+InsmIQnxTQBaWuLKwJGIboPkoArdAWq5L6e716h6xO6vJYGijecnbWvIy/R+BvFkowibjFykMQnOAuM+jL/OFvUVjfbh0cRctY81lIKByx4Y69UWQrn35MrlZHmreJUvW/LhGgvMMlr+McriGuLeKfE4AJuMH9eAoC9ILCdhfoFTiXrktZ3KYemycel776sgpmChTO+LgQpXMu5Y7czyuW2Stzo645l79cqvk2PDKErw3fB0jT6MqUhSn6xz+wINT+3DV2MFDWX/XiQmVDRZIxMt3J2U46oGZdo7/9C5Cu6eforPRkXi25BtBiwyNBPPGBW6fEegU+9wdggCW2OngtGf3WEHWBdLane7hzTUd16z8oqb6DsGKYci1r/O9BK8CeFLNwS4OdtcMSqJZTqTtlDujvsgXdng05lB+BnAVJ2fkds+2eBs+dgHY90GX29nDcs4ZAT0XawffZHz1yGr/O25Hd7SKDM+NfFTindrc1TVjsOCVCAuZ4r5Xv1rI2XD14TUGRwDQaiwWHTV12PQPXASHLJXZPqY9h9UuoaIvjbTPbJMZwgOKP8ZH2BoG+fWyi3zq2j2HgkJ2/av1EBujcvvnEIA086AWZFQMpvH6mjAZ6f7vz2F2aip8ENSxBEXEd66nDfDsDYIrkxFLamHDM2HdhAN6oti6x6Hf0cZO05jmNUXcfJvXbTBSSJECR99RYWmNvSgH4IqGP4AjnDVrKUgms783aB50Xmk+pYvIMhn+MwpyE6CsNN/Xk4m1OH31RYNYgAX8zpz+odu4Edm8AIre0R6f13sutby0rOSw0JHZ+6PVPT/Zrn4fMv1X4W8kmq+JEJvuJQQaga/DLjNi18hEkKFXLOtD4Mu4UZJVEERth7M+J/DfnNb7Xv+PFxWBOit1iFGKNSqTKS/WhjlBKgMxvoGzEFdXe1rjpOaWrKsCrF+GJxlpLE9hsQHN/k+9ZQJREf1w8SmNbzpq8yvB6wXb+1fKeqcU+wU4XCMVIkB4LqKT6Tcrm8iKFQTRDnYM/GND+tqswN8LuDtiM2hxboUmYq0IHF4zdk8fIPmw2wMGY3d0GKfYRiuuMhLnhNTxng+NAqp/pd0rc+QBOA0WdU6ueC+IKI=
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