8kE9plgYq8Mwzu8Y8/rVxhIRYmhBSEwvvw7Sqa3XZd9rmDtiXsUU1GTWXdQs8QG9wrnId+X6MsAGcAmme3RTILx8kVr/NetTGQiBuuqP2y5rVdu3CtoyVYBRLM6repgQg5t1/DUgZXzH+QVWt/FUym17ULNP2jxxKKoDZ0CrZadtc1pyIAv9AAGztSgJkC/sAq6Aypf+M9j3FrbUoNnuWPhy+jnO3LxzydhzKC62YAn5I9mv99xHNG85sM9owAzGgRigIuvQ7RJigmE5UKZ5TPMgARzxhDvqquc8GIrDiXbBem2aDYDAaUCqy8/pgPBvRHCFWDc1/268hXmtrnLr9h4zxnZGshnql4ivnE5DxRMJEJjsMaCN3Dc4iJxSFz09/F5Re3E3zczuZ/6pQfodm2Zk3ZuVdivslfPaxbSyB2BoznNFate1L07G0Q55wfhBoO6vOTzC15nEh68szYjaJvHeukaevjBm/dpdQJJoRRZVWvUWLPkEuKpqizOUwW81GUXum6zmgUrph1GRg2aManoX2U1+0sG6a26gG19OAzrCNFSjSo0pDcUS9HOFzheTKnN11I/EKclYu/ntoG8s/cKhRMMxBnW/XC5mhi1QfcTs7UBAZSmANih0PEHzvlYhv1P/2/IXyE6yqqY0jajEEz9TI8A1c03puS1xIdPyPhp2U4GPs4zrYaaNOu5iNMZM7QCo8YoQ6CfWm6PeVSehTmji0sVDGtvsmtmplaUkHdmVVgmavBR894eKgDdplLAp6GiXTLi37MQ5snYiTrSPDbpA4dU7+7ng0Y2r94q1cB9KVy6PpJomxscgSNmJf+QCA27bQplvTnP3X87/nmTVHTYJYa/ISRqv4nl8SCatEYQjR+CRJNrhHOviBn2fJRFRAYrL5QtmlXLb/10DtUME50bwVJAKycRggq3QK/HKN8f/erAyIWb2P88spcFkhcSU3ALxnWVc3jEYzhPQsLIakqKxeIEX7h3CZ/4JRb2G6PXVMu+vujuWe5Mog+o0ZWq92fcGQ5RPmafKDyFKvZygDMrI0ZBQE/kto+icCB3spc5/CXkUosfTbXf2KqtmSfDcz9x430zsBtyS/u7tUozmvR9WjZJ87zJMGBBB5WO1/74+xrJLIGUy/QLnqZJTttLkRe02RM12Q54ikERHpqoxdhw5PbqSSBomV0tjMWynKSRLws1o+bwHRko75aiQ4E/HGn9v7V7ejsUxZU5GsAsDKUy4sWUacXKA8B3KafoUvI7u1OojywQ4AzucgZTebr2NiHYtfUMgIquB87P6cfyPkreDJICxoudl5kpeTHcgK1B4tcuhhVqyPeqjdskymRUgNCjeiesmVt3FHxuk24tL7VFqsY36j1/VMEgk574=
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