dTTvj4RGpvWj/BZezyXQjskBkgap9ebC++V33bTSkxQEWB4PS7488FKq2l2eXrBcbcxX5SE3CKFeCz2+iDXyt5YFpNsqTq6mnKz/9/nJcy7d7nBGbKobM8Ln+NeYLfS9zBIZUg/UtNVLg/iAizc+8C+KcdSaVj8Tp069b+Y91EmZNLj/8otKcGpZKJPQEsCls4PuewNVXOe7pjHEgzctYGiBD3ths82WO2b/PgPJ3ZDEnmtVZRCvFbch4uDz88Yc+GiQsXF2GZXXiI6Ens0nIT4jdELsc2VxGG5962ep7x9gp2cNN1pgpWd08M+pVsgYPHAGmljq+AfMYObyX/aOvDyOaLRXFlygzT8FutSaxfAFk7cGo04DMxKcif0xJxFdLDEidUd88I/I1uzKXHnJafn4M+H+0c37VRVaOunivzni4TP9yd/Iz0noPYAm32g1w5d1lV50WsuAQFzSEahGMbFnRGDGDwsIShc+3+C5LFGppQGyahfmzL43HWCcHUfZJWx0a2e/bfEENabGD3UDjIja4gkKRnYRUcUrDJAkMigJtFVxslsN0nHEZf4ON193k8GQVZSMaOJtiTpDVsAGICAaA8gbb5HEg2LS7n0r3/k7uDbqRJawySjO1TK+NCQ1NKMMIlUnApR3d2YXi2fPzailQkyEVuT9EY6kh6dYESFKT6YGDyBBCSJyncGVBuI3Zkv1Htht14ZKb9AX7t7LkkMBmRPAQ7Mx85JlgsWSszldFOj1etUHUpEEBXR69dsTAZ3lZWlh4ekKUUzqCrMwLBVNqboJ8m8Pt42l1Aa/Of6KZWMfaIv9i15Vsku/mUPGiluWIKeGeM/i9UWGeYRFFlSpyqGE3S3ojJLys0gZFnB19psbkLVeQ6k7/z6chtJ53meeXCYHeRaMlKNFGZum0EL4EAVUaz0PrllhgXy4By50uDyZB/cdOq08EcNLPwId3wtlWgf1e0OI2jaxnUc0/fySbmNQGMaulWnuYn7AKiuGPgNlE++43XRyjgLPQVQ+7hpdLyFKFa6qp5CucbgMl5ZSMMkfKsThHD6u53ITX2dYv0P261MhO35l2DRxPMNa2QGURNJHKoAS7tT21ru+mg8fwcfMS0sXIPaUo0UO5YwZOkYU+p8S2goqJGB7/eJKFPV8fScoxSby9Z/CSMNHj7xpgisE92L6oBW86G/dVna9TQE37VhoQD1N8Vaa2jjPSXFB82jk4GD84j0/3Y3bswhO5epxNeUJzQs3mHnn6h+pvuINtOiTsd3Js+j7X1vL9i3tE3IYavJ4UqDrdEuOHXQ7aHTaZrj1GS4wzmo5BF2v1h8p9zQuD6wVrXa4ucyxaBCtrwTGtgVlZuvmHlucIWW0+68/mtQDeX+x1MU=
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