Kezxi+Kvm1LpfUSucHqgBYbLyKcwrvy5jJ2CN2fEnPq/6F1oHe7qdNVbHTI178etoFnv6gyMJ34j+0iXcjXlHAzKujg4xRzvmhzbTSYMcnBJNiA3eVI1NilvOT/elFP1nF7cVh3/zjAz3uvVtr7PXQq3MdIs1Pjyd+14KQfD5ij8LC6hdfyJ4mPK4f8T3BJBByhaEyzTFJFozILwgIE7kMXlRZYeQo+Yve5oNYxRCVGGkOj0vK5CGkvTtrOKR4ECIYhFQxvQSlxg4fwqXrNhVKO2NFqnLsjH8r5CaRf1+4uNnWGvLOLPuEgxl+P+6uU01DdFxh7e32kIS0AOtFurs8HBQfX+zNMRtXSD1JILeBQNb/oPcKRsu7/tg1kfFhRtOGjG6BfnCR0uyyrLgy9qF2jm//qi7/rfdNOgsAtq3v7DDA+QMw0WF1ZLteW5wHR/+R3+jCGUw+oYnbZoEmpbcm9gy4JVXBbLyrpmd12rI/Ji80sJWvlejGDAd90FIKWeqZyhbYMG4pt6AiWh6klCwwNk5964YKSIlhdT7DMBjUueFQqVtWBVxdRiw5UP0dsqujaY365zeu65YILRfdIaG//2Ss3t5So4I+qlgnLBIFKea829hMyKfeebXDViiNAE0csWVr+MyIDIbbTU/p/8w9Plyxv+5rrZqAD7QSG8h0Dz50B2vqYeSGJv31jbNU0KrBZtILahSHNcJMVwq0gNxjqLSzvxvKLSmBDsxvhVNE0sCW53LA4rHnp197tIpNsxpRz0vVei7D9VspX+IKw/+WU0p/vz9rqCV8T9Wdk8i73U6eEtvzh+70Qk+7UBrPF4pr0bdEgGWtZUZb1TQMTy899/6lFQT+GCP5DmAfSHyW6E4KaUNEvC7HzCiL7qR4VLvvyP5IOHB1MH7w8712PKurOg6Aa2g+UUrsHk4+q3Lvinr/CoaCoqRqJ2UnVCNs8pC4t1IpL91WM3QgR83fqcdXydRKxUMD0Ccq46mSHtexvttw2tkn3gsJgPFJeyCdAAaL0ch0p/kJe/TqOpuSdZzXsKwNqB4zaE49ti7Du3O8N1/eH0SXwP3u2eEeMjyRcXmlDCUE2h1xRHmKE+7bIyZJJJ93b8ykjRmaZhOEUKShpc9rI5+Mf4Gt3EoHm1CqaPnlihH0eT1OJRshCN1tbIhN42Gmplx8EN6g5owhZTJso7kYg876SDZkRzJTmTtOzp2V0VjtieKOoW4o3e/kU2YPO9ktc73hRHFTTgAZEqh4rqwgK6y6TLbq/cE/6HACNdkigXP7ItUKqyN6PFbHGBfvUfBJufuTHd+5Tmqfkx6zuyAND9Tck0Cb8BwrLYFklkmsdUubUIJoZkmsh8bkdtB7lw9z2fgVFEK4UXi6I=
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