s+iiwfypsdMIl5TrV/a7o4s+WO7aAfRMWkJdytay/Qb45WK6edO8NL/kyocEXEj0YcfT9dqnnZZF4PKLdSDFVAzV8S6B9PRo99+8/maZN1ysmY+p2Wb6E85thFekJb94H9W1kR0UFbI0bVSU3tt067ylvwlZ7Jj+DSoRcy1IhQG1C9QFj/UtFZnaTShUtlqVQW1LW9osNkOUmba8642pTc5dKwioYSi4qvClCwwV/X76fUxwvbpNSGdY0S31ajR0wLCPTN8HnBJ7yLBP6YsSVFZdn5XzfYf7VSQfV3uSix/t0O5lRVKCU/s6CG59Y6hT6jIaxjGEOgH+apJZfnRlPBzWuc1jvnvxBiiC2E9pSPePPc9MdzIiWO1pe4QqvbHkLMPH36Fr+eiZCFgUzegoI6R/j/n7FwDzq+UqUzGWaPKT9Gwo0JMqeRjq/KAqNea+c2GTpoAZqwwPj+AIF1vw6+kGTSy4+ofFLWdGQ0WTaNOQvOGUJ8YPEVHe22q3rMcdV2NYQ7jb0Laib1DjyQhd4TrRk5g4g5MXmmBi2z+Y5aU5LdWCeNE5hMBVKoweRfDB6RD1rbmsIdUFhuvrlDpH26PRcRp3cftNN0uYVrb9fi/38TSAqxBScVvbyZho2jJWTBCI8YgRksXBZC2HrpZP/kAwTkgey+CDhzUSE3oGR9zka9JiIpgwdQWRnfhvBew4fJZRe3a8PpTOdM/ufrHNgGggFOtsS6SZRw41u7iyT/yBMDpf9liFFWO8aFZy6weg6/whtRfnlSWsD1I0FKCqDkJZaqdzTXGjTS1wAdiMUWIKJrSTnkp1je/H58IdrehJvYNEouXCvfomlssS4UH6L7dpj9RdLfhM2XU5cqAKy1/uYVJxY35UuJBUFGD9px6F4CJRA14dIwT6jsdCetGI46mGOpT1R/jS81l405ZauYbJSDAcA1cIyVHnbJROD67ddhg0kEboaN49NXIBcTQLA17asOA81h0GUvi10G85GGMH8xrMf89ymuBkcbQcg6mYrL90obFXteiHfW1JgroIhle7dFYbvagBEGaPAlUd2vOcFm8bk70U7u6Yk7TJtHge9QtLwiW9/A1se7b5UkSD6f1KXsg0ztE6bNTXTrGHrm/tNJFKExfYrxy3ebRvuFTyNJLZCoCglj4Ss+RSKCfxptAVPei7t95W7YWqdf+FQJemTmuU4e/sNfInrzQyGAjfdrR1kqj1x+2Lbd7qjEjV15VbMHvzYvn18R6n2CJ/4t8JWyehrnrnZOcK5Tnhc7Nllw+m/s4puMWU9L/iQ5D7g85P9GXWqWR1Lahq/di7xbtbyWghgu8EA5LCE1+5Oz4+ZE/73T54E3uHnqERPlS9BLDcPf6rhAwHzswwa7k=
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