5jLgewd8GyYBURvoG9KyIsI/j47cBmR8yK63CR2zCcHtrb4mcrUqnzDSU6Ca1ICBx2/9g1vQP4ODLjb7Fx++vHzewMyWehQdK6TLmUUg6jPp2cXkS4iZ+3Nsg52b00Qnt0mtk1GlpFoy2oTy9VAnnNkcDbWYbS4MTuwDBAwa3n13avsOEgecy45ux9eqaE1AvfCER4jsTc5HyMA0mxpyV/kaNGSe+g801SOQF4io3HqAMJHZ2pdt/gbJC+ie2RaDPqc0hl1wLdOWhjer3vYPAS6kJJoyxAseVvinmX+OnQyBMhE4FjMLJ9SojtEWrCZzCyU0km82Dt86aogxtAqjt77K5p52RSqToYtTd+3flnx5oPjk8SdECIMHgODmHeyue0GrGItz912nwc/oSooCsAqT53kOOjNy+PvsCZycx6vUQBZj/uzXchBD9PZpJrPSCJLEY+PzF88QDkSg2d3zRispAVUsHWWlYDl5jYgrpAGZPrD0U/YzCw1IZyBED8K1iqhZKTCiTb7qtnTf0ph1fjoVgtv+Ag3qZrRd/QRS+qI1+BKOrtIoIvQ3bQbl/c0UmkncLf4RZ0xrvFL6ObXAMxXDTZaAN43q7L/EDRXJlBgcKbIUvwKe80+Lgg54cG/5DISwHJKMdjsV+8OFzsHjAYn2ep9ilaIXY+YHrNOl40Irasvc0WXM6Cl9xuUZlQ6Qx7qym28494hLf+DoglnJ3JnSMr4AGcvr2GywB90xDZB6FSQmkZ/bj8fub9XPAbavb+BAtgyQ6fwLB2xnUrN448XN6V8vedzEORVyeg6J1BllfMopwlw4cD2qGqgtG3h8d2+oWAEpQm0BQ8NofSxRxejiSUtC9FehjAO7GfEbYD3UKqdxMLNI2uztpKv2qyCLxp81aOCSxhmvIMmv/dymy4UnXeQD3PzsiIFkHLHuaTMGj1BdTcvS5nt7UjUS1PP1FRBaRvg+rAcM+Rk//TcPku7EaLfKlYiRS7V2QTIodhK1DDfkYEeLfysRqiYtwQHsFGqHEWLV33NCBVHzBU03D/rQJouft9WYvPYwh6x5FvVgOjkUWivSmudOrWwdYqKYr62DE2e4EqoXDKmB81cHmpxduFtXr5VkEXImaiAyQ9zz3FqZ3c+Ge/A2AekcZesv1UluRS8H1SD8Ha98z56KtFBXMWOj2d0zGgD9u1yOK32BXtqoC40KytSFowujHsvEKft2OS8yh38mVMYqErJZAcrrtwFJ5qURNggIymaS7uarhnu8ayxENIonKWYlWqw/ezsVhiJ8dcLGzLrqWtHyiseowQ0E1C/U8gl8WjNt2DhR5BVGbd6e4TIxn1nd5KZpn6mP7vGofpD6qmTbZQpVHOM/LvImGhqPkVl8ElM=
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