iXLcTLJdyoCdh61h/JtNO5XWe2RnJb+3CTH12ATplGcixll8YbwcpY6XpMR3Sw5p48s/z82JBiUT0jr8dNR6R/r0mbwGGywNR/n/mMlewP2noLDCKjeFP+EnvwtOiBnSpQD4EsMuCz2GbkEub3XPavrv46xl78jV1URUInyV+5AQRWL3mXuX7WlGIagEyEvFzJBQcnHXTJHiIFw0YJkzaMuDLWBtrrO6+jCGDNTB+mrM4JeEkaOLpcJ/nxw3yN6ymKEQJYiWJZ4YdITV9Tebj0p2zyVYQIzqDmv8Uf3nuhFeu9JCeD4cMZkKE4OKSbflPC4uwe3xWNu9z+JuNz4ifiYJVIywJPniNdlwgNt6SqrDMZUpcYPcwP3rOitL7Gn9R7spnYmD33UqqbRxxsoSGUMSCFh7sFXLXG/NIABX4nBWRkArthXhlWng8Xs2Pi2oWF5npaioIlM47SyccvAseoa+i98+KNULbVz+Uf6DdIa62nRFyki6Dm1FnyTbpBXFon7d+cBmzedd6kAgjBplZg8pWJ8UQAB2hk1LBmUREJBQOB/wGzuiU/6s1hR50NpvZMQt0oy7qvsb8u2X88ZU/b+b96XcagUZj9DvabzbsE2mTsG8Q9yT5HOBKOcoHFzjtnkX/weG3GTwvKngz5Ds37FadQjOvRG4/WYefPSuuAyaZLhulSdtOWYOBKtM5Eb/rJFvLBXpm+BsZSFs4JG9wa+iN23ihZ6maxlkXcwJJbe3DaBPMh1uOZfKnBc9c2hluZ5D0nDNXHuZUKjWZVNwp1ouGBaqpHJyeG1kXU5Jzi7kVcb99v6n2l0Hxo9SURMScB4nBF18H86OA97INWxbOGXXWg9FE9EMDytfmllIBOK0G3vudW4mdGLcXwCNu3l18r2F6thzUPCxMTCArnilhbRPG5/adNC/LLcP8NY4JzxCeic4C+gRU6cjW0V1Kdi+luiXMROKtUyrXcpQZUxmFhyXcOY5JgYEW7G0CZNa5y5IAZ3YnGaERxh46I5j2ahKa17BcwszVIEfjXQYY2GQ3Eux/R4sczYXlCe+UzAsWnIA+VI45Mve+ZlFX94U08oNC89MAp3gZhUK4V7FtIa5OxsP/94VipjnwJXEQuY5tCgBN3p05w/cvdJ1YmyCUOWC6Yaa/Urkyyms5XcBY1e4xAe/6CLtd3AnoTNRG6q7d6VJlcy5RP+IZaXFM0yEybCBUAz5Zrr/y2a/ljoKS95ajp0oEZl7O352e0gdzn53P3QcW1yUjnKO8EL+eP1PdJE7l1NX6fr+hBAeXk1drbd25BXVo2kyBslKG/7ySrocaM71O+Mzj1TrN8SKdb2TwQdOuA50rc107GN68HP9rn7MUQXjqkZkjfAib3CVnNg=
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