Zylw+fdbtf30C9H6PUKdeFvvEwAlNNenhK8neD9zYfW9LIQ10QKvqS77mPdAFbAdoIzOjfGF56rztL+cOdwEXth+Wn5uhx18NCEnLXBjW6aYqXZ8ccFyMtZg59nz34LQ7IsYwaYPC1xTts2a7mndrrUDxJMPkdOZV9Khw8veMSnr0AEzWNMKqsflQ+dVo0ptPpQHBGfo5neJ6vhhnsfMyyGrXLUMe25iy93LSMutUPfM2XgtuSXF3/+33VZIWNV5KBkKsUQxISNsU8vY29u6zecsrRhOx0qYMCgntPDIB7VpPpJMPs0zBPChFefRXEPV+Qk8TEHI3tq1RlfPJK+rvRsVQ5LL7tlbAmcEp47kIzyEJdvevVTK8kafS9ZQfwJ3FH5hswqbKvRLLsOsUCogwFanJD5IYcEw2mOddpocP9xr92uY4fLFPHvBF5e3VhdVGjvs80+bM29SzaFUShVjRFd/dE2VxlG0MD4FgNRNnOTDUx9rcKnb2kpfm4//krUku8OwoH+Xjliwev7E5r7AaEpdfr9qYsfJF9OWKutpBECEAhc/3LrgY0H8BW/L0klxLFi5cj2R7yfIsATdWNX8F96Hp2ikwDgR3/qKSL+wodJ19LF45jv3Ozjig2jJGl9tSSrY9iquTgwxyzpLUy4DYGVS07ZrdD8Y8OzBn7Jd1gMV3EXxYrALlZ361Acc5mqI9YUHjiEBv3IEUlHpflzcqBf2/8MFkLhNYq84izbiWQSKt80aYv+PP4I0nS8NRwPc5dweYj6T2RZ5tTdpeY7q8tB9VwcGLUQ3rcEV/NDYHpi7pfBeGMg8w7FY9VCHx8OXDzhYZ2yLPQOBVgkXLpA6xDdFdAtQRi80GYM41jloH93NB3eACmabnrJ6Pp+e1AbzMDwqvAJdythwhnTRj3DVlUHi4ZSoVC5jdof6qn11SekcHzR6mh4l/Pr4DdmCQ+LEJobjY5JoKqeiamijiq+QjvwJZrn2urE1ik2uAdkL0uzSLDXCQ3oBu7Q8Ia+zePRkJ5tufVhVlAVqVwmoFZX7CZqIWRVtdJH15J7mxpyX00rXObsPMOgRH6Cz3misM81ARikBCvha2Eq2AJxeiLLoX7B9wSRSmryT1PbGKP/ic7CTIkPyvuW12KI1PQ8R5usRms5JBE7V0VtskSrG2uSIdnh00KprC0ufXIbb0Ovaz40AtU82FBswQz5GHfuETpzt6of2KXOiWfwS3R6oEsvNpYw198roFSuwMK03i0GbUgdpYOab4MqUjk22qFzLSLoxZLz31Yc+BkaRheiB/kXPIi4LEoHM7cVMxvAMbZ21zjINrA2E80Mf9Q37gK7hWt4ZMS9/RNaGRKj7tfDn9tKeirSBZ25gZa5fsO5IGOk=
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