nWqpsHfF5qKO2QJCUntDJB9X3x3z5huHqjDqfkbh+O6P3Bn6D6gPJQE8vGocoyDisdu06KMAaeUq8GmEsp+dLLuLGmWMjb+ByrORIgs9ZByT2jCv0kwaq8JAlIX9sLsDisSGm1wgdQFQp4I+ay3A2IBfJJfx8oCCVRmQl1K9bdgnhQqfxf7qEWmgCye2zXVXFQo5KZ4+prMXVGDOebXSp8vEfICG3iebd7re1//vY3PaGfzYUPteUA4V+2PF8LgzYtLgBuy6uhiGzvVx3XaRuU3/lfu6hAj8Qz2L5R+Ov+ZjBdxrHwpvuR2hB46nE0Pti4JPdIoNHbFeJbHUpMGN+oepDR5BvkuFsWSV1ccg+MWtqoQdPlJpF8OZ0pgpy/wXKG1mRhicaZXRzVNX3Kx8UMGUprVNZYXPC9c0xerpdMRJHsINEuJDg3G4iFmUsgBFsY/lDUtSFx96yc54sdewWlTluSPSugrpbbn+KxStFelX0rLj8nMF/XHyGjK+z7MPEib0qD8iFJ4kSqMkxhOjzNCNmFcwxszlBc4r3ZLKesxgJTD4SE3Ee/tfOMMxs4Pqb+QNm+3btcXSOOxxehH1013mlZa9wwnGkuz3OqmTI6a4nGdz0R4D/zQFoWSYS5YaCEB6fJajU8XVefdWyto1ZFcNaE8Xtx39gP/eEeM1k6Qx16Vr0KewG99rmfYF8qlbrwItFzOIJsFzYO4nCgMdv3u3Q+QNr2KNEOctFUKfgYCawSLr2DkEmP64meLh87as2KKETCGqSBJYxFM1dz9aNr8Z7hgAEV337ZSbkyclb0EcbU1qq/IDLa5k9p+8fzpmXB+xcCuxAhNDocQkBSKs+FqeaJAyGNBCKrHp6d4cyr+WV0Z266rQfF1kDD1JT7sX0Z/pmWFBARb0Npw8J/GiJkkvH+snsVZQLRpbRyazWO6q/5G26C/orpCgrdvIIjt2LQcbMRHkxMKr0L3a7IKTqdRuSPzSrwN1uYhePXG2MG7hkS0IQmD/TAdiLHO3Madw9/91BSEncKTcFxcqh7PCCYmNFcBJl9D3Cl3sZPsfejmrg/LzvuSspONNroZb4uSfZIERgFsChcLsDhZS4/2oc6slUEMRiyg/JBvENxCPesxy8GTkJrfrTehW/i6fPsS2H1ibQmVzLLAWDP2gmLRlsrPHQW1OzcFbzz2ZtfMejT5aeJ9+SC744ebrPKYbOQFTMxs8z+dyDVXEdOY0rBnuZNXcq8Cy4MgyxIZ70fy9P2mwz5+ULdod2Cixtiy/G3cj8B8mp5U8DXX+bP/awpj0xPxE9A43DpY4d7PWJOZ7N651+00+QwBEIVar5+DwYHQDs5vasXNt4ZvHgoKIkBhbClsLUnCNOsdmGgH9fuo=
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