TpxIBVzESyzV3OwP5Oo9qizwu5e81X5spNdFLxBNcMb+/mewthbY55j1I+vP0UA21tUSZZaQ3HzzNGEmrgR8UARdmXcZeb9wutliMGNWBwJ/iKVVmP6BKeD9IybeL/zvWpVhNsjFMgYQb3zIOvC4frmY1QWwF/n2ZXub8tEwAmAXQ7oxYkGuC37mn85cmCaye+EkKdEtDugnJhro4NQvGn9+vTr1OQDXQDiwPc0q7/H3NCekgXDX955o/YHaIdfiNgmgZjgNmDKTw2UdjlGNFRezMLH3Y/5zk2/k9wteBWzbq6/7cZ+l+0gwXY3UwdGknrDx3KlRFCWIXdzfE4MPgquGAWUCSiJl2FhgCwBMrT+4d/u9HHsJNChd4yshmORD8+x9J3wrWBQTop1adY+hv5kHiI/68LsYtSUXHJaR46BUC1poyNQ+SG2YKusAFTvwqm3NIfyRD9RFMubt4TGMfUcn+o73rIhnECBJLymaz0ooFyM6ZCR4IAXDjH55KE5SUUaC4LtT18BK3rNMh0dtpXB7QSYwpQXmsl2V5ya//P4kn9Zc8OJWvS2s4mNJdfjOo8TQlZCTbFbvLJwPeMB7bYnMgxsgnshjPyx0ujXm2dD9qY8tRMAbsOuN+KQc4VjfH4UnRtheYK70dHmRmp51snckHd2396GYmtnAe0Jc8M9vrwUTrow/iZlbYgVcCD0EmrH3BahBVr/42DDVr05wUgPzbi7Z3OBzkpy1OfcsaJ74xWUDN++Dc+3ER77SSz7r6HIkNsV8rYDjWQIwpqGvtXzIn52gXxDl4a3t+RclSGVRjok90Aut4nWqqESUm9HNGdrxC1MhxJneraN+W7ObuQHxnyQjfbw/7uNvtsRKCCuEdbILeAo+rFEaDsoPEz7CK8cOpS/ZHV2lnPrqZWDssmnIX4a9o5bu8eGxmDU9xDFlTRikQRNrjPdDBXjA2z/YfJKThtdH6a2vzTZ4KHtwU5hy+05QDXCy+m1Y7BP+73KpF7B5NIX7dzs3pNSzAWsCUl3iI1qudEuOq7sGIF0Y0zEPq+Nm02573LxvbFZdDN1q7ZksG42tyGHOHXrrN4lNhILmguVFjMea/7SAhA9ljeyshETstHwQ+p1Pg4bZY8PBo2w6oJLa3VGecdTCeAdcfcImamT6KCwowKt3KGhAz9nLdrfXt732Ub0AcMmTV4Rg/OYrDBlbX2XbCofxXZj9yvdt6cHiHdT7fyb1p/+AzAboOXndCjxkN3tsfx8R7Ub6XafX2B105QfPkYNEW8zugdDQJ+R/4WijpjCeBmOY0RrhCfIFeGVg0J9dM5Vd4quWRGvjqIt+v+vkgI9tw8OL1GJwXdO8ABb6Ta810Cn8freIx7n1dAGj3ROekKo=
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