3d1CTGvMkh/P5tMEdfYxrdyQEAR+ctSY1YpT10Ac1mFB4FaL9AeGAC68vXW+PJKQX9CPoihfWx1XEhVYkf0WWzyb2JTbUzAyHxIwLRmwuCUrV39kJS2o/zkFxoKA+047GKj4FOxV3SCg9P+nRlLRR8ylMEWV2NOOFFEhk5HpPKmRdXxS942M3kfSIhNxbODzRMeaaAGXcx4qjuaHAJPs5l+QY/cFO1qc/8UXdZ2CBn+btJ1f2szHdIfO6lw6VkbbtGbWfAcUuXcKrgRmHIPGu0kYNbUO+o8CF/Ei74B3yA3iS4dTYk4fhi1EMfBuc7OhwbCE+7iw3J2uTD6qZexO408l8AEw9D9VRabpa98OpYoe8Xa6cXkKJuNnL4oKph8TcpespBrLtUdJ7TnSlnk9I6pouBc5+qE6rSL4CRrFQlJIl/akj4RgLoWBiUQui4zs7EvK2mjLht7E3gBXs+0TfHUmTx0GXHjlDF+Lm0B+gdkJmARqDrvu01PBXbN1vd21uj0GT1yDLRtWu4ZDwq6QVN3mILsPaBSwnDoRbvQ98ii6uaqxSThKUuEtHPE1KLiOrPikudlmE9u5Fj8SUPYke2pNnmOG+Tg3717BfRPYhFosgn81Zq7Vp6+MX9diptCzxZRBBQ8w3pUqAMCpvxjUzdrMu6Le02l85qOSlLy84e8mlyka67IBVxKqIL8ZFNTm/rzOaSkOGwODGj79oj4vzG5jVDNAb8WBYUv62nGMid5wGunTkD7U7bPJyyFBHN+Wx/F6Y84JPmtdc2pvBFhUwQpVFeBkYILE1yNR9iv0X6Zw7CjOIU12HfAfas2V464fKzNvCUVpW9O/9dEk1ftZe4KhU9zBo5iw8vCPEc6hHBmpMBDTGT6DfaUHEtOouFZzPKsEU6/BdemyFqD8IF6ZDM7k3w6ZCXGlpQqaYu6SFTgJxuMkZH6Czus4JXOy89Ti0DZ/Apia3OkpQj9aqivNDbUYZjGhWMEa0mx3hGDuOax41IL4NFkPN577ME4cTJAp/ftihja6Xhh2ktI15E4va0DeBDPv0XQQu3JLQwDck5xsOwuHJGzGpJpkAkHGaI0iH2wC0WDkwC7P4j6pkP6b93C2bFZz9RE3B2VBQQZjJAfnz5KLnoThU+iVxzROtChTTqYzqiGAh8xpmb1Es0hFxrpP4/Hpx4xeLZ4s+DUhrVwv889YAwCYsdwKOuNIxhWX7aXNNJx10t+GtPcxnqLRNxngq6l+/xgVb4ZFnwfb0IAaw0I5yYhwvHM4OrfbxIItT2dpSKvh57cxkNMgNvYNM9o8+vKmqdyJyiPu0ykNuqYBvCCcntBUD5rsyQUR0pXkc6TEMNo9iZRWTgETYUkRLTQteCzsfajT53kiqlE=
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