ysq9fA0Ee4yWFt0IAYFgmk87BnBltBriAiCICg0HLNZCmOdMd+UH1BA3KmNdcUglYCgQL0JZmkMAVXh4UYrMdIKFTv/H4YvQg5AqhMp72bo+ISi5npRBHEhRTOzvq27QSUqz8q5aVuwJM4vfOvHZEx9+iUgYBd35bi1BUJXDryO1YYVNv+fjTOsNAxxUs8Kf5/EYJvgXLzC/qDfWxLgFEj23L4+pZvEbq47s8S51aGvef+MDNmrsuncm1Xr0ielAn6cOO9uEkATNe8chu7ejPWhpOyPDclH/9qreSoX9ET7dQ7eHpTOmTY5dGXO5RjtpDTKpNdNTao3SMKS3eAkWMRTomby+iW3XHWT9+3EMf9ut/IZ3+JCfRBKkLCiVMY+4wAHG7HQcyDP+o6pF+TTV4a+h6nAP6lYA5frsvbTd5KWAHcUbPl/rRRV1DVgnZVsIru9jKLLw6/ynnWbTVoQqpOTeBLru3bu5TNoNdCzZpa/NVTIym3ZSh0ZipLaiEzvX+wrhb93TE1bG59OpzUcGSpURKfmG7G2iERFbYCwA3M8ge41tSaDER11tjciiQdJYSRhY1AhS13B6AW+rbAvk4u/LntaogpprTnt1uSq6tUo49VFRsSOy6BgDnsnt+lSsJfieNLFgBNfIOyzlCYVMPwL8VSFPXLhN+uuWj23NlyjasC6w9GJVNxgGssardm+1atl/UVTifxxCWjYLOH7NID6WxuQMzuIU87GosfLLsfbzLnPL+sa/o8X0pmj3nwTN0CG22ihvTs8W1DAObHtmGENLuZvTmJjHou4VGurw5KkpZF+bVpuodbGRGRhlcifnsgsBROqotwgw6kt1EeP9S510nEIsbrm8x0n5ZZ4eXk7Mohpn52nXz7OdBBxtQe4Us9K9Qsj0YPoKlJ4XlHZ3T8MYMEUp8fATFa0cdZYyGKWT1bUou5/kzUsE7i8t7WdUPpD6G+OqbVEmFRClTGxA9wbDUDia2FbtlM1RRCM+9Csmajs9Cvl3kJh8LABslF2/S2SrCgVNKDvj5sVtg96t45aUutoRnf8ony96Vgd9vgL8UWe1T03uBxlklC/rQsCuqCkaJ9yFD3xgOen6Ln4ocw1QWvUFr5jkyoGOEmkaG3idGv/zxVp+KG+Cfa4b52STFxcfg9FkD+ePlqKoCgMyfp14n08rhBPlDosJmMHZd7bV4jEOQh02e2IBWK2CBFeGlDPjqiHsgFyiF/7DOgeMoSU89aoIsF73Z1L+ydBdgqJok4V5ZSzHPzXVbPYIzGGzwIZ0WentaGW6A4zANpafEfZ9+WKYlqDUPzUZUzpFUiiEZbKgdaV9WDPE2Yb1RdTLTh9L2QUxdbKozVr78qnQ9kczif4iNBqsKsS+h+I=
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