/nAghhp8TUa9fO+JyuEn9qPzJsQGIuSo3Mz9usBI1xXnDaiW4IDRCM4BjAQsevRAA6we2WYQuZkxJpZ1+grZ8rtg2Y9bsnmGahoKA+gd3yw2+OxRNvPKM9dUa6Dch+krKKLcq4Nj+pkYDRcNONw+YajszYqYLWNzgSCFqLmDRCaXOqqanW3ooEHizxK1bX66TmgRk5e5EjagbgzfsBBsULkRlEaQ0htcY50vDoSunY/rcXs+3mxIgY1r39ePwWwtVxe+SPseQ/6nh4H7PY2TS/oGY0DmqsjYpePogfqtUP5xwLb60QPytJ4jwj7oyclixzMaTrpdTzbPKVjmZUBb1TUUMx/fcdItpwurWEBXADlFjGnLgna55a/ZswP76hcUBnaQ+rRBRYyq3DhbyEGkUl7gxXF2gi8ZRu7jUfihDE3HvyhFUH+gw3fDKeTyMU8c1cOExPYHFdd+n7Igjk9lfGHZ9MKSHsEnfARknEcLnux05iykxDjYaBKW/gatYQubtVOKMUrYE2jKJkPvGXgHyQuIMCCsQgsH2feDs6xx9ifVttU9pj5rcaBRWnASRrpVdYlxH4Rvblz21zoIw8BCXBKxZFfj1y7azzoCVreF7t0349WrlOa9OO/SKesd8ZDZLFS5NeGRJN2XDx+2R15gYR8UqUdAW84pCjGLygk59Chy4lsRxEXRSWEkghZIQM3WIDJntcZa+gP1G64b0P0Z7QFb1bG274R/B5tKO0jCqECVo+FFfL+sjkIYo3z8xWEVveUCbGZWoztKtOMCre7Dgesmjaon7bMnhWw2waDmb7vz3Z4zg6uv7T+T2EozBqs7OInphAW7HWOTY7aSGWe3AWya84rFf2S2uP1rjrlNeZESpduOefhe56amgW9S3rfv5rGg1idPhS06TPJJ1f6vPUpdHKV3zbMOSx96MK73h3Dkxa2xPnot7+QzPzvReictoNn+IRzol10t72qzk0acEoHtl1nEdqO7Q0q9fwZYrANKys6RwlwsBwKFCOUb69fvQmF/3y9ODrgHbb+fdXC3Qa72h01zSmDGyN8TjC64tAy7jQRVkJFAPIPlsfXqmW8dOieb15wG9yfdfTzE2pYD0Wk+fdAvnPB2Droax0nkIdTiEJltwxTpL2oJ/JUc2GWy1blNe+zel+4JcK3vemzvGe6J1xrp2BJB3RAu0EbMNEP9MDpF8txQmK/OKFBe1+1eY+wF4c+oE5KBeHrL1A5ZV4f8ndwfO43075zcbzKxvnrgimATGWyZllGg0+EmtJJbjvH2lreqr/Y7w8CJJuuRLA1QoikvI13fwWuzTzqVEaSVy0Eh0jlAv5oPv6TLWGHEkGdzsF57DJ0WKV8fOuREezdofJJW926zUC3LIyM=
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