tEXkVUEFfrPFN8Nlw76pVwQT+ltNC2/bEm8xTwWn8YcGBA9Z7NDK4vMLpd/AvRVAS+/qsiqcz5X/zzjYnRN+VVDdehHP7FFPIsRb65OwznYXrxNcs4COIIR6Ri7kjPVu5ilY6L4kNSjC5AqOfeudfBzF3Xkeu2iBAHPnv841kFz+FwHvYmQ5CxPJwD14cBHKW6gp+Ii64eXwYWIhL3bEsHeNxaHRhlJOFh3RCXMi+QOM6jZCcc8qCY9w893fjjQAp0q2T6OoShlkS9GQFEr2QK5TVxw92PZtxIKGmgozh6r0n7bPriPHalf66eFhyc1Qt6kWqfm6PTmVek2Nn5NlcWg3vI0hNKmGfXR6Rb+Y/zmmL/d1RNSGgH5P5yt4gT0CFPzTYpfsXRlhDGvX17qHtyF5znkeHPXsCb8JGlxQ5iDxikaHTVDoWp/vR2xVrQYbi+XvtJDYS1yamF9cNFIRjlkZZeE16XAYwxxIJfJ65/QOYwotUYYC0Gf5H+f7DmAU7cHoEeVzEEkldHjJ1ZxCpJCtzhTJ4twaVXMZ21B+sTd35/ZdzLJVc00ReIw4xsQMgktPSVnBDVn3nOzkfacukof23bkRmrsBEkuJMNM9ewY9xIj8HfSUK44kIunQOtUmwkeidIPqLonkb6xhAD9yOfbCmuIxQgBI80fLCd3NzLmFJZSGLn7f6udUe2aw9lYAD2VsbW5S1bEdW1JUY1Caw7wMzCIgOIkPlM6B3h0geg9sKndYS6Y8yMIQuOjd9ij/qeApicWeCKfjf1zWvPxDj5gR0KqqnReGEX7q24hYYLNndcnw4fAi0ppOBggoxHO8cCy3EyYyw1IwNZb9M/X36IYLEXINYY4gfSioYRkabF8GHPWmPAURgfed3LrIBftDsjA7TS1V0sqnj5Y2oLrVZNa56uMw3d/zjnhg72RsNeCgOveI2NeMUf4DmRRYJ07ko+c3lbTXK0cB6jUCAwjMi3cpOmvdQTTJ7PyYybBu4blqDCRVlY/ddK7MhJQZmBZd+4nR/UGZGkOcBHDDWJ8KVfxqKFsuLiL2nkOJWKz9FSu694FtNcLeALXtmygAoLESV9/OhZbzctDrFbxcFhTGP5K5b9wlYFbAh3/i1+QIuz3Uf634eq2Obh9BfJ95ODmKf6w94fLQrVv2+wscViNm2B7ACx9ILBJugzQjV2uC1FqXLBTMnwbFZ1PyWC6W097A/J5vOIaCDWAMTb0TNxzNXwMwaOLiCUNtmjRbIeiHR9IRlzvo1L0Ah+d7KFHJbUUKGylw0SUw0X/5iR71uMp2hl3peOdMIpLfgO2uOuAiFdwuysIwOuHa3Vu54CBL8esA0bAPk/B812Y8i+g7ZLYWeZrRItapug0rUqj9QMw=
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