vWtFBafhWTyPn4MnjOZOQnzUOBz/1cKsbzrN7PCHSHmrXGW3lebkZ2aNF5HJYNY5N4SCtdhnNbOVG0EILaDt6XWHqdGR5Dc10nje4IgFxuZvZ6SBe8m+OPC5F3XsUze1NoVYRX4irkDlSh2UG/yuOHHUNmpuSoOngZ2EKhQ3Ft5iXl7QKiLPsdAwneANfHLxrHn3ccB0BxCMOOSNI0cjhBpkd+4aUtxygAyOhdG4KBbBAATWs0L1wNwSlzSCw8cd0mmbQJpMvdw3BqHMEp3Z4dKraW8vzYGpA3OzjdhGjm4RTog2uJH0WP7eNoxSjG9V6mcf1f2FeGsUkJBqr0HD5W0Z/NiiY3NzbEaiMLJYJqnLuZznIW+j9wdwFHtgtf8N+AoQdyNfeK+8ek3LG9h9bB98kbvQZ16hnSArjdJFeZ6rYiGoQV2kUSDytTM2vPBGoTnQ6uAHaeR4O2pLrIJMs2zYQSwfTXrmMg4UHl+CzmEpbthIWBgxZ06o8Cnh5tT69Kcr1DTY//viSTouOBY0s13cuaNX1mvtG7WuhBvA0Cm1HeC6DeTo8NrCBy/L9F2sKnyUtL+u/QiCSivVQHvghI51Iyjr9gEcfVFlMUHLSEnZkLWL6KvmW2I780kY+vRf5RMliFapx8/w/FTmvRe/8WQKhusAJK6XNfPowflkZOtfYZZ0vdsoJM7xh6LKv0LQNdJtljtFscN4E1pxKrzTf8g8v/TaAc180HsR2LkgW1xzC+XqYcwARrN4FnkShRUOF+mVja8JZ06baXJSaC5vTc0cyie6/dDxlTYDFQTkET+1MIQ8I1SuvOK/3hoEhXaWkcHiAAWlb1acCgJzQ0tpQbZgDipdbJxtvnLhhnRgF41awNlJiA11JI84MqMiLRHoLzO7nBhVD+r2wBHljRS4Y07F+XndMC/jv2Josyw2NgYfOYcC5/XmDkK8IAz3aUiNDpsx0zIWSRsqbEV9w3LLgb40wEYRGrr6/Uq+SGu4xHom6Q/zn/aw8rvUYlsj6xHnoYpAOCVrRpkc3ikiCqX5pkg+Aia137MHKD5s5+VgkYngWEVb7rrPJx32iUdW93HDNEgzZjeBZU+eD23EE337wji4pEAL40f8AqTIDTbGSreiizmZDFSQ5ZHoV1N2di2Up8qCThAJ6wQFgPIpZKSCZ5ofVFhdCyktS3XWRrLTPjNLVnoUJIO0SeBYlW2WjDH5woMqzbj09LyoA3OFyYuI1p8jaKOd0OV66Rt+uTdhe44GrYafwDeixqt3tE6oirr+nCg6rSzvLAwXg+dqPr4ebV4DBVCkjUMQ8M3kyMntSeBtWlBVjj6BV/4mix/3dhotEBaXwTG2l0JLGQV16a+qnpTBCCTgpZZMprRlpFc=
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