hDT1AZ0J+KXBG9PQAAxaEoWlSgsOBcVLfO07rnphWDG7E2izj2dF2zSJXfkj20PFpcOUaMHLV6E4I7+xpMspHB4IpLTIUm5dpKqgOjd4yLIBgs3G72euB5sVIpMJ1XHPKxdMHvE+9TBZ5np6NFuJo/dpssmfm5pT8i6XRBr+/tHwSqu6TmWBKhcRFFyrmHw3z1Zbj1jcTHVNxvWan01rO7Mo9aApu9HMOVSdkJiz/EWY2Uh6Ao0gQeFKd/T0saVSg3dWh85IjhfzAb9I3RPS/SBnFA3j/x7ravehIO1rTCpDJO28ybObn2qrjDRCUrbzPrG5Pg3M3pOg2qQrk8Ux1ogjR9YGGDhQG5jyRlHnLedKXsAU428yFVyUV980K2SUCN1n++qlpq6dXu1DwM2mE0Do2yjQs8oO+fylX1JAesna2YEoKJ+CNdYu9DO2kk2pVY227lfav//rkzoKreelnbzE16AIZdPyHerH0gi/4qUAj8NOD9lB3QcuemD/gejalmy0KxBaNmGU+OIFSFcFyVo0R048VPQflZUd5i4NtLR91s+qWD5lSIeI74ue6gK5srx1XKoUygQtameQXf02v/9Hkoyj27FACIFg8alpslp4uPqJqPtWzsnPxzSg1H+S93I8ZtVMAFxSRFF6Teis/98NDkvF4l0G5N1HpzabEMupwlIEZdIdlM6qoBQ7B+M5hLzdkwPwzm2vyiZ/nZW8F9vBAxQ7uHNWLI/ZMz0hqM2krdEk2Wf6UaFz0ioiYaDd+eiJYGpMeRnVmNxxv/k2VhwiAHPoEGt27u7DXOP31gFWSiKd/3HkaivqpsHPtEt8wDY8wmxlTev9LJCIFoa2iyk1FIouoMbGJGDoIOnldhsGdnuLaeUb1yfB+OnxKJO1NncKAPXlXXNrbKFbNbmEeM+RLWATydknjNgORYbeij/hBhaIGat58m0ZTCpYue+hFHTOFH7H6MVcg2ffOf1uFApT/iz9f7GfrWNQ0QsDw5rzkNsyIUQU//yXd6BdwG3nuiQa2kRDjw+WT4VNEDOVvf7aLBt5Jtrz49gsptMMkpIJlUXisFEOc2o3NpDufyIvn5BJ2QKw94KDd8+x1FcPsCU1G4NebswoQzgsMpdOSd/gfubc0YzJmehpFdmiabNl8HZCXpaRQLbfsce2Pc3jSWsR72qTEr2/9haGE3zXQPPI5e7YFHEOlU0E35VOaAhlVY3O8XIxkYIMKQYpz3wXgNwe1GZSN07g9lKWR5B+bt4mT6Hk/dLDm7y9GlL/iRu7bWgCxWbDoqt/N7ZuPBBXjiyFX4Dia8xjh88Ngb6gKVkZuxUNHzPc1kClFkBftffX9dlW15WHXWvp8pQ2mk9WPsrRwuHoYDGmePMrmss=
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