ElHsQHl20wOIE/F8juuCmZhhdg19JuC3RXaY2cmd7HYzraOF/a0xL57PbbfAdUR8wf9Ji71QI+egGVYcB6R6YnK++yP1R8AHp1+QBrT2NH3RECzw9uVpQBgizEEp3MMYoprfnNhwjdYAy4gyxGaVt3RZZ3bB1kMrZflUpZDm9s5fwzgLIADCzUGnChaVXAhTsXIBTtQO3N0519S2R/BYq92iWvNSDyTy7eRKfnBUD5ysi0fJLqPJFUvBe8DgvjwPu40rLz2qPpx0v/3qVWOwt1zMUnxA3OLJf1wecdhImwwj4GHPSg2iN9K2qacIIq8Nxn29zYqDFtUV//MjMFaPTPGT1X7KA5Nf3CoN+43XSDhUJWwn/c3fi3oAknVjImAz9x/wHjnJk8WwbxrP0dHhQol/oYSYinGyo9GO+kelpnDuWw+h+JVFcReSLg8c+ScKJZSbVVpBa6gs1OJkAQZs/s1NM7VwlblVmsUN0+mxaOAXSODDaj3/sLwam6ePXZFqbz0cakYxqIFh1hiVByV9xkXvR7LS275F8sk2tjxw57LExxK43RMmHovEgYQMxAhIDD8Z/I/X15Q1/UF0Q40m+rJ5c4Pm8dzfslJXNpgQPltXAyY73jemW7esEGK0ZeYFkLsRLQMp1VIVQm6O+kQKpk/0Tmkn2yJqDONUqvgdHbrmvEyJmhPsnyy97Z+TuFzEMjromsXvwqUerzcjhlUt7HA1MFdExiG2yJh0PVAX2DObBK0tHzrRo6w6Y8yiUbYdpNzmtPwhF6e4r4jFig5ks3gB571P1smlxHaj+aLjS5aRgq1SxO/5BQvnv7FqtyVlmtpPLaIcqDI51YPDCbpqSCkrMMHiO4iyoJ3mVH9DFdYQTEq85DFzqofFLA+1HTeHcMhuNs4zHB1YaXjnuQ4eTRAgDfiEsB3Un+b9XKvSlJP484WXXPZHVtzJjjd8lj6d+59iXlUlThWhuFR22GyQjthXajU+/qjrRfAdczZLDiR19z8HJPq+BJcIvvVZxArrh4zMsRVN05jYKXa0fd1CtxUlMtRz1GPwEEuWpsvzq62c6DKkWHYM9tk6sSO1vqHGubcw06JHm5qYWYYURgIVEHbHEbbmusfyeij95nEQiH8tr/0PqFnKOXt1CtsCXKRwUuHCjVZdsco+GNx56M0FvtfBV+VzyFLStvXGg9fYolX4+9iSHgMZbGeicURySRB+CIqPjWX7BiA1oj09IhwW96BvS8OZWn1GrI4hphvmrfifo6ypfDv5S8IGuu2jzWVOn5EdzjsssxUNtiVQonzRwqIGJdobRuo34JeljFgcrjsHpJvb9mcWPIMjlnFsh3aJrpSMwk7bwhNq2M4sTruYFhq0In3V+JV8gVEwMlw=
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