ToyisY6ypgdzFRLMaYeJ5byEWDFW5izkzGWnzbiPYq8cDgFhNMNDFtjDpqS23niUYdNvTmJRuKJeafJ+vWjbFbbQ/9zOsVazmrmCZB8sNhAeeKRikycKVV+VQPvwbBMUF6sp6S6pNrqdrDeOLBBMJG+dY6tcSveWtEligetdrLmzR4SCaZlib/lt6ya2thWHV/+zxFdLdEQsvv4ZCmF0aCyxzXVbJrqiSmV+wYqAjbM2LBIu5oIuwBlrpqVvTgv4Sv3SlpQpkl3LBByCij9TKmufcwV+j778OFD8ucJM+ExMkh3TvTxS4uHMfIm59Z9+zCMKMd0mTCTIgtkb6UgoVZiOCX5IlzwJg6iIMhWzzmSTCNEMllo6Xo1um1P5oGvIYWCozYa7D+QegS6/FVwGDqS7KaB2Ka7aKp2qHuaBIaJnl8nUjcHhWPBVC9MRBDtEtoF9DX/18be+dm8+NXwHGJxfyqMb2ZN5p7jzY/wAhE0z1T7gOdxtDQ1hfxAgBk0j/uFIknepOoRq8J/p8hQZ4HAAzugpad8sYF/Si6Tsbc7V3GpNkUdjUAqalFl8xLvdRK/czypsDwpfAWgPAuivB5otCLqqXJ1WWBLATV0th6JmcRkLFKG8ZoG79CWR/w69sQhgpR+gKFA2jiIRiyB4bY2HK7VXYJ247Rl4cX6poACobSFHKenTDaoE/0ML7OdON+PhIRUSLKDFasjw+SdnznuZuOnXo03M9t34/myDb2DRdaOtWjYeKi+hdif/a9NYI0pD95jm3JC9LZtabFyt0ig8g4CrBj1eRstFOs7UOVH0cUdfpzDt7Y5ZWCLwIqqRImssYjaDova8Dh5Rt7VgCEgok2t96OphuM0ZM2dtDwLryRO3HlFuqZRqx4GPg+XXmFKpTraDXFQ9XzpGzHzOICoCn+tqBbyptawIZKzvDcaK9U6ou3q90GuuALU6XsE/2XCMbeFdFuMfYJx9quE1kgtEpRuoJOyBQFd9/ZnVY8z7BSoP39oXt8dm9u3KJZLLwZxVzlZchydU7AEp3xuISKl/oxqFFFt9hUrZQN+FPK8lhThB+OEGfsKmgDzKOk067Q08LilnudX8+4q2FM2zOj2dKq7TeRzEWsav+C+7MD5QjKCYECjGhSDWSC44wbdDw5FMwJtuXfI8lbpg1ex2We6uhTQbqKn0rUEEcOB4eW6CKCTvs6efvo0BPCoGKeLSDd9QlnLROLerUWzCVOBUh5Eg+DQpKjCIuAYxC2v4x3VWS4i7vP5C3OufeQRNBbWYtab5mnnVaoqPdWEkCe6KCetpvwxniAg8AHFL5kDI0Ibz3UaIhbqQOvS5rbZpKRnz4BlZQaHI6xVXtvEt+0fmQylja1tTJKNZDLeKdBU=
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