D1g8b1p083ZBjxr03NEqyvT1VGgBilB5C/eUXzkOXJDCViS7oe2Yf7Pq1uQaA57CnH9jIDDgSfqGyyMV34cs2275qhpNukuqPK0BjnJdJoN0/5UW8rVKShpnuGU4LNPZQnOImSCE7LJpHP2b2BYlYkuZ4zYEYUCrrG0HbjbSw885IIHuFJi6ItCb4kaU4Q4x0HwuhNKHjPMsf4kQkkcgBEFm3miytGIUxf8Puh8KtH+vTrbD+uvdxuqBQBuaXeECe+1fdwTm/AyxSb5mvXF6UJR+p/lRszXmsKxHE6X7RGFWjVAC6wQLLx0VCA03RXy9PalJ7vlv9BuzqP2dZbvzyYHdTEhp2czWlffXXCbjH8dYhVZN3fbnnBIi3uJOf7L1mz7gCpt3vzfIxh6wTxTuXrCweAoPg5Xg2zv0ljYU5LftMTt8Okkh5hbVZ0m4KdhSg2ZiyM62homYOgk0pZnIX+JdUaUdUAgkXn3LNH1r8UwnJKyM76lFCsFCR9mS0rkt7keJ+g1+Cv/Ev6+Z4nnsFypp9PKFN8VNpqbfvqIE264m7z+Oyya4QZ9E+TwszikCR3TYUkTwx48qDY8YU+GaXL4zJ6BxF2aJMICSag84v6qeoZ1+oFo1hl4nb4e0m1h3+4+wfdS2TFPSNvo7j92ziYC7pB7Nf/w4itkAQPTtjRxNt7kMde19YibzjmWp+ORDi7fu1nC7NmiA0W9DYMlhhQq5SXww0gJFk3AGOr+kA4xNKpGzae/XOkdAMh/LpB2aK2FWvgUT5R2JEGGw48V+R1c3uMrqMWjcNeP+9zUibcQ9SMT1mC8sML9iMu7YZKXq55ZfXADUA0r4RUIU6aSjo0O+cOAgy0EGjJ6jI/Mqds2DwFOdsuLdCmzvMrehCFqfjmUQv9lrPWSeaKyjG2OxbWLOyhRe83SkLpBpDFr1TMQDIB89Jba2Xqhnf7STx/np4KHaghsMsIWDdf6/SePH25u4o2TPKtjWosHTkjvkwsgE3usPc67Se9/fTDOCdtfIiXNpO/hEJeAJWE2eBqqCDG7NqBt1I3U6/yfQpyK4AlOHeqPbrr9gHhgxIkS4JDuDZsE8GmTlrb2RWLuUZAEz5CUXFYe2Wd30szfMvTimqXTu4eVSVuJZNjzLWAzeQneQ1jHQE/jC6i17Eh2hHp9DwxeWhq3zmBs/ZuxODCAmtS0hWoWUfl9nh7xs2fYBFavs67PwkGyfo5Khto6ieYDUC3g44fRtz+qv4qwCccbPps3g+AKcMusxWFkj6gpykaGZH9zXpEeRQES9ZNaArSNSHXp6HMP46Tr4iDtwMaZu/iSvRg3zVWK+RwargNYpMf0TQ8eRkVyMM3h51klA8Q8JaXdwdivLDSZWYC2Npd0=
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