AJtzjyvxYhwTakNagGBf0CE8HRbCY6jbQPyXrXINxE1lWmnRFSPN0rIdLMD8TpkBrckbPT96PmeneqSjPjsO3x5bTwDewRvVSCBqD6FkhGlojYXtaIBVkxp/e4Kk7ScFNWGc33juDwBXc/MdDd/lzgdSStf0hkjomIqOcSsSwsIWVBNnXYSS0PUn9H+K8dUU3Wc2SuhY6dTLG4XXQY3vrtgipWab4B8nOeXXnNyUHg+rZcRRPHkqU8ouf+Q99F0sLpbYDb/JA4Tsj/68b5Ow2AX7TZK/J15/LCvgmZoSKUQfKuUKOl7noRketUa6C0brU1kfLdAVghooF44MrBSvQMdxZaBDWL43qVUiwihvEZ7x9PD4n0qWGQ/WuPjXTXbGa6aMB5E7U04OI3NdiEdBNefcSf3mnvP9WReh/db76e83iDCwS+Z0kbAFAAN54RBR8+HqVfcl4PJ6Y3JoUntvApmMkZLYRu/MYET+xQh3gqZkXR5J1uvMt+EP5RegnXcGxsJ49GrIihFZn3xs/Hx6KeZPiOe0LtLrBr3qeUOuvKMAk1urp9h1C8Zi6q58SsOqcumXZZfw8rVsiMte5hrH1IKjEmaIt+lKKDwnCh7B4KPphW2GRkaZus6SHdRXCpCWWFs4VKXKrin2sYNEISgvJzzuvZJsodALQSsgsjXGvDA0pD8Zny7fvye2OUeAN0ZLgUU7F4WL57xh9EhEKi8pY6oP/LDm8ZDpB/1lhof+B1Jm0MD2YV7vgqlGMAQZish2/IhmjBb5TzTsqjAwrrZX5K8aeKz2l8NidhlpBxwdnNEMZ18CI5eVlbMPFuEEKD13+heymnd8EFcfYMow+i37BdbkjDJhf9aoec63KC2UJHs7439367aCrCGiJd+yh/We1tV758yWWXf8BGfsyAMSduldlgmLKu2ELUm/Gc7d3bKo7wnU7oVqIJfX7FXw6u4AZ9i05bPye2Vl3Qb+vXjRRaBM+Nr4xbdZmwsXihuGjgy9cNzomYAwUujaiV/EpcoYRNE+HI9GSHMJwVLjQfezsYKg02Um6xj5QD/D9XTaMK39rjIUdNbkxUj/CsSlURE2vBve4/O9MV2WA/NDJliJ5EClI/5e4iMMpeLl399JdgmVU466VymanDaU7qi1dKnZvK22MilWuqiEMJPLMfKcrB53XFwiBGOKH3GWlpg56wL2875ephbuv9aS+SOUre0NClUJVOPcQfH7W5pBSm5BjhODVyQZwQbFaYkHpD4Y3DVG2MV4R8fSnD9Gv0TKHSRinHldgleZkGo1wrSJNcCJBs0rBgDWiHmkBdyj5GDO77IkVo8TxO3V5kUUzIlqA4tlPQfJ2uOzPin6TlRrwcD6ATRRmkkot5R0Y1mTjyU=
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