MnYRiTy1pDRtJbXHN4a2kpAbtFmUWcfezvB2D1SLeMu4gJttc/lkh4NnJQ4B6hrvGBPM8NwtKXXJPAo56j6GHlX2zK8cw09vWx/6xShEa1j5hDHzfzr0+fgGCTPAZS4YZghW8u16gDEqGg59ZXQ8IvjRNXUwZmj1TvgbIui1N+XgPXbKl0hEjwDlyuxv5MDtkhrD3/ImK68xQQ2mdtdIkZAWSJaxnuh+3/cWUXU2vRHuSpjzLWhmoBlpalyHHTsDAMhAs/iISD0PghqbAGTS+iW1nlp3af5pJOnjcvTmzDHxbwLzBgSrmx3xcZPHaNDKu0dM036kaW+J75BadCqzWNvbGuUg4999RcU6OxPZIroK3n0xsrpyk+/kCgdVIY8TPr0o2QmThQVdbWghIGus4+4/CXVNswB3YDdO6FW/t8uWV5wbKbxNvXe7q+ynrA0Dpgm618Hiba4nQbDBH94RSLPdQvw5nv4Zx6wdzpJWcJj/hoCE1TlYSu14hPUdu5gO0ZfsNKDr9JSk/L3fd6Ngoyk3KUSNPQ3LrfdA+WgbVpmkY8TlXGc0GKSKUGR1rHxIYz2FYjLCQ9i8P2CjOGjyXL8ObfO04OFbNoRjtZXc1kLp/zBZjnsqNLPNT79jlmmi77rZFiaxyTKkB/npIJKwgNS4Vn7nCpvsvq9P65AKtk51xLjDaEXuU/gRLsIdiFe3fz2aEFAlTddWwt2toP8o3S/0NUC4Qh76uvIxoy1Y/mKL3/XJ8EEs9nh74tBYj95d/kwvtYs9432yNXKtYT3PE9WrbImg6CJLYxSnJVIlKun1l3PWDuRFi7lnmDGs1eFiUgSiZYF4AaF4cQH5995sxzFCv8eGOqTv3RwDbytJaU7yRWDXg1KkUpFLH45JKJuWQ29FE8fykbm+mgIXnBRFi6Ammg0CieIj75RYE6egQ4DnkhAHefBRtV4B8OweumcH2rvML59YNsL+/8ulKVOgmDYV9pqVENO6HyB2xn+y09F7+VgqA5Q7pY2XlJAizWn/gs5sEg/axGONC4cR9QvG1PIRmg9tG3s6hI+kiUqcV9yoq5ubDEvhwHEyh5/xqOQ20OWG0NLXXnXgctk0oPuVv4c+B/C+2vEvc7X2F4nF4R58hM7WW/wAF1msqm3rkMUbYZVy9WEw2qob3FeuWvuX3cHfU/lPc7vDAIImT4mPTLfsyY18AtVuH2VruoSo+X5LLr2XBU2+ZP13qKqJ++4IrGzMk4yaQYwkPjCYrvOoXr4ECGmr8JDr3bubuvy6t2llcA8sCbQOzEH3RDdP84DKebboFqLEBUJOtrkb58agbNp+Cd+LA6883u183E9BkCHzbRfG5FdVKiUvOkSy/iGiwSymDR2YZi6b+BqImL0=
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