UyRDWK9THN0p/xjQMJZCCp7L+iY4fdnoEoB86X1KPM/AmSUPlti9Vb5fRGe4Rq96vpKO9p2aXIthc3RnUS1Xw26yQblK0Idlxfvt7d3MHZdolCup5LmfrqmtmWVuKwZ2pdafzUBVKyzrnOJ3mjafuy/MpAVdBW/gTIDfl9njRudp1hkLUODwjrb56zyze/pv3wLsGbOUlRHNDLDhutMNxpt33GkeXY4kihXzCgDuJpEJokh2cY+PjIe7VVbtkNkNYGiLh1BEE7OaOpKcJMJpAT3tJFAs9Hcl5rSpxRsFMqQi7Nf+2PMfzGd2tWGziBFVkHx28t2htXy9vlQ1chQPuuiPnvD1tjlAaT6kDWtYFSsF2XP59j+92QtKYEL8feu3bNcYwMoMymyMUvnQO99v9I7IKWXYpBTGfCO3Apr+b1XY7B9rKKr3nhh2SjHqvN14PVi12QJ6GlBkaAEoXFwbY7/9c4IeMFhGiOteyDtaVwhwdF3GHwxYbk+e5wt149eZntwOUs2TTl5YZo9qRURclh0hrvUbXOhD57f9UasZ8aomXDEkZiaPAmbo4Hy63lYZrmkQtSm5H/uuG3YNmDdMnVjS6E8Yj1hUt7VefiNQ9LooxwteTG74eulqSEq/t6kIRpHkqVX1DS0UdEbcIRQb9/oBYXZ4n5baoblMIDIegwaNTQTcckG7q8eOAvC6eHouk0eAXyvW9wBXeA7rM7QwVnJod0L4+Njm9xUOilYp5TgYlEOrvVctIP7SbX3JjY9AB2V+gypAn2cZAszjmvovrqJvcmib1Jd/p6/JrZNPhqdiZCrAynBsP0GKxjRFQKKBi4qFv5e+6Ac/wgaK+r8Sk1nW9qoop9k10Xm4+6/gyUSeX2/5XxuHU+OTETc45ydgAumiV3mDNcu2vwZtWpCp4bkpQpuPL/oaZfjoty2Uo3mGebZ/7CX8RL9N/Qq2AkRJUIIxp0e2DUFsNpg0xhydjMD1Z375iY68zP7rFLvYSZ07BGCEr8ya9bqnX51tuXDG2Zmafh6r1hK190KATsi2XU3qzJJmJD6BCLWPDI9unE/pfAVVp5qgPMo7YGNHteor7PjVYCfDIuzjwHTV396QzKc3NrMfPYbLX0j/3+D1nllYrmFlb7eHNvpG3HaKUo9P6L/ZRiOuml8JaQwdDw3VMLlg0pj4MTo2hHStLVKsrMQ4NPBhC1AvykWSSXfh7WZbIH9/+exu0+n2eWXHrS5K4VwGaX8onHLKmrlaqVuG3Q8G/g2DvqHYt4wYWnxpQxl848xZKb4bQCWrkLdLxtL99iJMS9navYEQzE2d4PZA0PdDUQstGsyHrLPSBCpP2MKF7OGH2zc9fq4SKbrxqvCM5gq+jbuYolH7nA02ncPa/P3dmynGs9DPoCXVOjvrPmyRqkfxcE4vLQbdmgCOpG+78xIfaiEcYL/v7vPHEjBmAKg95bN6/E3AKsvAstQ3flJuQJiKzoXAA2MCH00A6jC9k9ygZSSFNyaPr8j6/QiPL0H6K1DB8sgdO5VfiW3v1SVkdk7kswDqx/L+FjwFQZpiBLpDuGUnlWkeTWg/2Jl4zdhhjmKHx4TECd054QYEZOJh2yuns+itvtjBGokrRqolPOVdUNFuMRQMAZ5uqvfKVHzG79Z5CcLPswcoHtGl3wCKgXmtLWmuyku5t+xYEtSDRH72IqQxm/wSf+rg8aY48yO94PrO8rn3Zg4FE2A=
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 (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' 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
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100