RHyE6soCUZbJnhdWhqyz1RqsvrkbCavIRAdmxiNHhjPqh2w84fg2tGRoepdBcMXS4TSG8Afbd65L3eBrEm0p1H6VEKi3XB8u1aCuJSDeLHpndWtQulIAPjLeEmDOAnd6e+KSmHr8d68aKBLTf+UJWoFGSYBYg1eCHWuV9ALzLvkjRrcHzMD0UGz/IG6iOMv8BJAkRRdKxydO98YAMUtJVka6byqfCmDIsgMJKtnkH/kaXAclR8sMX/M4tB56I4iCDGUaeMKRHCT51TYVTdAPqXq/3yC7OuqNTcmxYG41nrQEDzkzt88Jd5d5XRISL8wv86M9dHco1wKM+PA8JBhZR3QrrW5UTjdKnTj/mjQMz9tj7MusYXKG+EFx8//iTWnTUPhdaRXN3hMjCKyGNKLvvJVJFL+FTdchMg74wRkMyZ5qI4SyJg/EHQt7dl+s7eaa2/Ku4T47NNqUjHjvrynGb75bzCaUuGVYoYud3EdLmL1N8rdWvRVtuuJaDI7DW2TI1aFZJCP5vKbShGBuPqKoYrs33vptEiJ+I5JG+fLEe3TnUiHlVVNZu4FEcZzu7VK/j8EmEdQtaiBYgp58yOYSGj1EbNEtIOz3YZtHcUl+utgwdGwfj2QFR3xgaubM7n2RrwWroWGsYyUnwWl4Hc5IAP7VjGyjW3u6VRUstyzsn2RwJKhrJPeYWWcJ6tbK7k3N40I8UyG02GvSBCyXaruZmKkZKp7sXx9w4j++zxCatYZF5ppegc+sAZ3pCz/lTnBdQjrkbxdIp/RDsKkNXWu9YxMHVaAei1P2T1ygG59h3Nnk3G9QJxkzLkSH0Ly4gaBz7SJeAh9dtP9/mWIe7riXvhWilCXP62lEmbBJCwMRb94n3lp9Hj/yZyjriezVucAhNlcN7dBZbeDDLEMKAj0zR1U+Zw9mp7PiJLm5wreiJZxpkuUrvMqrS6FavZQ6FApf8mQI0ZCyxzkNvg212xogHu6XJVcR1//dEC41fODGgqk9v94faqEpqJUg+7AfH4xFHXw3sq7xUJ/MUdi9XqGjMms0cNruZ5ZLXoGUQXdf8H4pHMFnskh/DPN6QL87+gHrO+qYszqF9/a+zO+3ZCoHzoinIo7OYsDocTWQBcGq9e+UAg/zPUsgIWu+/m1y0iKSMqud6a2yGso/XoRcz1L1zZF5R4QxveFgfISNxrx54WsNOz8Ugsc3nUTHFFsbIwGMo2H3/eiMxbhIizAio9SZbwXG/uBzQR9p1QBahMzDq/UN1oROnvbHIW4a+0sAbo52GREiWDKs+L364OZfF/OIUDEim2l9FVIJnerX3CG7yS6xVEv7xzSHmekuNCjeEf8xovcP1Cox0nnIZdA9LTgdCAb0Xe5UwC0MnzyHylppSjjolZHkH0lZJ63lrL28VTLAlCp44T3SovdBG7fut0aAccwLhZ/QkSllH68GHQ6C5Y+zd2aZwD6ZqJkixj9roKJz95vM6u1UIP0jt8QsuwzIUWNoaO3VI4i+T9oURhwNqVAHUG421UeXI/0RR0srgeWb3Btu/VxCN2DmlcxzzjgZMPVzzU5ENKV4F3QfPUT4IBDVaLILiokmEhVgiLNl4voeFkBKWSdYbsmHClHoByELrpdxevvIoJGFuBJ718p+asic8lC8tMtl8xUu3KrrY/7T7lnPkeGENUrwE2N0XafKOWSG/byZjbk9XzVz15PktQ3EKDEDfjta8hbpdLc=
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 (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' 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
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100