V85cU+lsDK/afbmk2o80ctJJpfykhpmT+7ka4bcQSafzD1o5t8Tg2i04caeil4jE0qgfVCUVl4Qtqw3qsiW91nwDmPWOJ82C9X4JOXK4f4US+pVVvonwnsCEApWnNosuzphwMkSg0+V+1AIViQHsarkPGs5LwFVQmeWHE0Kb7+ojBeenfQhVOJb7ha2TShIAAWsrhduHpuQlWg6Xzx1uIU8Un2TGuXGBFj/qJBqBObIEexysmiogsXLOy6dDD7r5xgOvDFE/70yzkHS2yjRbiRN8iSPrISRElP0h389IBebZskqCD4WMz2KEA4MyVzHsJ4FLFwhFOeDOQ/evsHXb2VWWbdMQ35w+7WG6KL0SS2HR0n1T8cWU8PKlaMa4zACAAKeMpPNHZ1yakrV7mApReYjcPp5mj7A9RMIQxE/mqyCS10HkMbHG/XOgdtqFcc4Ah95aOiFpY/m1P6os9s+GCdO315aP2EVfoDh0mH/tj86SbQXpyPRiH8yXKFzB2Fax5Zm8iYv2TxY0e3gKcP2kzA/O4oBHmuRTQwPYPC7vrTI0o73dbWGlFXegh7QPSkB0DWwjzoW8TMtSh/+oxyCrf66i1bKkH9pxkaL64Uwawk+XZutMcD7wWU9cjLCAr70gDqjINMgddyk7NYloZvOJrE7t3vn1k75F9cGUu41OPQrXqL3vUx3KN8JXLu3dZxVxKdME+N+CWOWTAHQz/86Jak/vNIfVcBYmiuXH3o3JkrEnIJLIuUeip0jDbkxc3mBpy0UUtGihKzd/DK1/sPVzA2qEd6CZud4nyFPve3BipyHFHaB508ztyitwT32Ocnr4tRepPu6Oc+roQyOVfScWJwH3a03fes2bKVXHl6C0CrR9Fr3jpapvRArOj8t0/QmAIxD8oeMxQ/WjXVqM+Y07G+KvtGb6wmxxvB4ErQ53fgH6iYms8uZjnkzMq27Dqv41cHLd4yD316/mnb9s+dr2uwy6kd8mdhQp9JZwq1FdTFcNYD9HJwMfmlvp+WR6EMn5gKhCpJlAxxEtKvEMS9I9vMCQiMv7PzWeb5a51ZjjyFrMdFF4f25Az0gBnXktmSzhs64TdGCAx6evMureDhpsizGQ4A8UgjpthE5fBS+0uItoc7dwPoEkZ/0IHmoK/Gc0dpXvbkgrikpuVVZF0uAIr04K029X2hXo86Royh6rF36NR27PGzl4X+r9XI7herUKr6dNY66ZfYVLHccnM2xjgQC1fgFOO7hB9SWBw7BvWuNskadj+z6HVmQc6dYYdourSYhP7SEV8u/+LgYWRKlbiGa4I2uBDhOxRBZJeXvfRm1lDrdkUCYDDmhJMzl0HSlEeJ7e0p2V69AQz0M3SQKpdcTaHQWLz8kZC+Lf3jg=
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