JYTmlmSMzuvuStBh2jfcG2019I6aM2k/aRrKUs+ZaNbQBwVKveMiyeskUIp1diC0CdoEReQaArWxzx6sBXIIB65VCo0w0Q6iBxXiokb7jDBo2agvyDXcb1yM+Nswx57Gp3elpC5AY9Qla2gXW374DwDLglIE+aDCZXkKmkB2Xi48/kKhXny2BtEQZ6vCasvzilqMP6lirWtU6wS9tyt/M0ZDe74xvtiFNKW8Y3MXXSibKZjoTW2CZffA/rMExD1k0mT06NGL7ef8kpnlH+w1we9OI84Kfv2jdRyCl+r41P3k1VLOvHNxpa217fa1I+nNgoPfv5H76mEAozBBUEo14tWzeIc1aABhyCF+fLtwW1rPWlxhP5akbJx168W6kxvW4XH/qP7I6Rrdmu7NAdLhgT9aOV7yLVbXQlZlpgZgVBensfn7BT4dbvBgVgPkopVm+HJQzumzkidm+tZtTPLIpN/rR/lnH4mM9rAw4c2pY7ZoPkLbyw2CI5owGk1ksrRlMGsPxBDvGScLzhDh1T/PURLaby3PgbbYXWNoYF/bnHgAz2kBI3N6MkAqJxOFZrMOKGofkYuXBjoStgRkAbtZTd/QqORvzR4CBcakbzGaJkySinWIGl2rW6vCfr1dzwPVN1Pwbjq9O5Fbtwj6E3W3dFxWvCa28CmtI4dhiFqtZptaEzPVjTSh7Ucc22HkJDQtLHYNz5UEt7N8yV90i8EeTuJhbzNrZhoOLd98BOuID+ACWjCi4iTPd1W0ArIUaaCyPqsMz7QIbCsWUFhNKmHSNve/eMU2eDmv4sh1sSzN3k3IZGw7XIBc0Qz1u1le+g92zLcKwzLjbobFAlHtxA8DWokrObnXX5pF26jkZ7rV6du23+8mmdx27SahsZkvBjBVu0IHMV5pBqst2PGOBiQ7BSNcMZbW6U2/nK6Z4JA11ROeMkM9rOHMFV5xYH3v0c2JY/VaGc/WBoiDLQB4WR03DiV6tYzOaeUaa752WQTUP2hWL7ueOUMIPD6s1Qjc681WzOHdJdBCH6uogR/KwXQPLVQTv4d5R06gzBISgL5I+Q546ToH49u3FPyI0agPqFLq7MC/pWCyZWXTh05G3zMwlBPuMF+B07TO89QwmE0JYivj1DFFNIDxUxMuD3tmfT/Ipx38CP6HhJTEgrg1H7pt4u0nX5XVcnmYoHinuKl2ZxMaT2Gi/yOMccVXsQhmPjesCMxaJYtUyYKze2yKPlgzCP5jZu6w2hzDmvOEn/4+pbrJQxgWIrMGxW6TTGgm5T0vBvKgt5xYJLOBrfJe1eBoMoSUsOkwSSb92RSVdvAxtwjRTxVEB37esgPCa/cUNAXeunKtwfdnkgMygp/bt+HYyTiH/cBxPSeKPpEzgJU=
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