HipfvUy234Tq+5T5QYBc398nZ/ulzdOAWYMmA/Sb32N5sb3B8+CfWKslaQ3FrIgdvWZ1WOrx7yXf7eFVPByfMlmJDPDt0lDIGfKcZi4LokgteBupbiKpIpnqX2a2hrThxZ6YbJhQCBu9u7JrCYXTsHHZDaRXfivwL7pkD7hXXsVLnW1ouGZ+N8ngaRavwBjQ//NrRBtSSgrGsE+vkALFj4YaoSZsvngoDgQuNpfsfyL35NuvGi6Lq8/G2xAkWY/4PStvuJs4xVb92bh1aJsZ1ULIAn61JtB/ZVnxwI46MPT5FPbgDffj3ARu24vft+9sz3eBqT9pPZMIn13SdijI0IRTWJdge0vbPc03QEKRfYvbvaqPfuem33G0w7vaDQgnkDb1qYf4pbzrhLhN7xlb7le02uSFmz9E5rK7afcS5pIlEhlUBYMUirF+Z2td810fQA0ubJDlGE52MXzFsJ1fDhLCLBptFQg3FDVhvBFjMXM36ZYsJQeV5eZLXf8+T5hSSC+UlWGaJR5WNQVu10ECK8Lu96WwuF+fvWdi2G90o2zlv6uzRDRipG5oRziLTKfVG7FHMCtIZEwMBmMh9m5MtmPVChONL3Aa7vSdN5i4LN8+o9r35nNAd49+m6A/7Qneg4pqkmjIY+8ao9C+VkCnQzuPAU65oZIYPtzfcdXrCfwjSZPFZSgqlJaQVq0mo/FxNso3lxuOC5hhIpcUX3n1JFVIEG12TqDhgkjrGHjGMG+24JajnIZ9Oj9On731fJ/GaoQDK5jG1V/puYQhId0qnTAW2FTmoxqUspZSWTDt6s+uRZ+BkJOdFno8gezZYh6i5YiSzQ3b8xpDV6aEIFvA8KVWFxKavpTQjwXuANrvXGGjnkEX16597GocjcSlHAbq52Upp0JPgkQR3uup81Itn+/UvSMNnnRQ3BIP9581L+T5R4Ec7BPcoLN5CgKo1zLq38UvTJs2T0QcCWPsClauxc8LsjPp43+BBjTbQFwt0ylYZs6pUa1NaurDuRyqzk2Ay5q5n3TimdcISGWou6yFVRt743Kg7w9ccU9vudYwpyjMOhwke9pobWMqyrWNdk3OjldhVw7lqPQj2eeJaVawUNkCuSrkDLOPXOJbmkVydp2FuPvKT70ds8CK/HXXlwy5B3Chg2CMtfLaofKztgvxOoB5Xvdfl52lQHw6MQC8/eym6Ko4vsqO3PsKPnmHzQB7+ZMmeMLkdNwkUKEpAWL+4ANDv+hwA5mhBwzf/PJgO+/YahNYAZdE36Ot8YWGhhDAquUOp+A6nFQT7rjtf4T9W/1etdzupkeDrNOTi3/GzlR9Igc8bmhE2PhehL4bOhGs0q/edHK5mm/RcID2C3DIl+Uz++mPj/vM6V6+jfo=
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