22bv+qZVm77aCFGOC72wHOMxSu5Tt1gitcFEuR6/FXAS09gNttHBUd0GQQq0weggjma3rqOiFCaHESqmUQPQKW26q9tcts7YSmm3kEvnQ5vtiYipQJBHnogB1GGgs+sPM9T/LhqKc37ZL7o9kBYXQ5rnAuafj2lXE/gITJsPcscDyrtLay0GksskIqMRs/b7rlvsznd/XgjThz2Jv1zPt+z2m+DZJXM85vTZtfg0K/IZ9NcXYoI/8W5/lrwuh8t8fPwV0vmlEev8w20izZY78f7DoBvGtLlypUw2zKvuxJYrbqOKiSggya953DE75g4TBdvDnNC7soStjggzz0Vy2dSu0MDzNOJ33ZTF6y/9umjabVqhpXB0nHpCtb0WXcXKu3oWvZsJjuVZzEVE7lghUHpXbOykD5/TH1AjwfaSQqxZW0EBsgjZSLBmNTDcNF7g8owToPngI7AiQsiaToGmQrdVaC/hLtuP4FwHl0m0g/Ol+s+vODZBR2cRr47GnwPD1rl/PWWCrpqbJBUUkjkvYVeEWWO1PCoNoKUo4tDu7h9su5+NoPUaTX8mGI1PpSPxKAiV6qYH8oZoT2NypJq0BnZJmLaUknnXE+hJduBjyuZRVHehFwk+PDsHpOMTwPsQTDQmsmfBdj2+pbQNKA3XlrpFjEdiWEOpKY+/QubVkhyeEswNkf3NthaQfJ3LTMVnD6I6TEobhokcaeZ/KLsyiT91MNNEL8TgY0TBuFpK0L2dYyvTkRAGW8HTzhqf4oc0KzVeRUAF/noHe9NZ+5Vmdhoin21pzr3fUboDXfCxVc9c9Cu2SAp81EQTY6Og/pe88lDeDz5nhrAb+t2Z0erCVSLnpB4R64Xvy8d56Xv0FUfLrJ3vt8KJ2wU3XGEroaUBz6N+PNNHZ/WvO8MIc+iWUlEfT0fo0lmMilWN2FbK+PqUDmmqIWTHWuxBny8yRUDx3Zx7MoXriF2B6WwBoHW/WLX6ozaticguN4cWtBHw+ivHGUsr7SGUzz4czkcNegpuqeYjeKjF16z83jgl2ziXmHrxXdZYSoS8WxtAHrw6cbWbEUl/V+Qo+tSE5xYHNKePZDY7hPLxxM8+LaFWU0hu7YOw8C+heAjiIBvcgDPCHF4FXlhDEE9qPSttlcWZXNRX0Q+mD493C25x/XEPJqWwIscJthO0tnExArpT6wAaEJ4invv04T1xn31/fBRM3QJzh+nPf1dCrzFENXBgeMRccWtB4NWLnZqaq98MaZcQltDLV2MW6y/36mCwyfqB86igX9gMy3Pg3pllD4ak90xl6wW1IB0tOf3k2Q0D2jM4KtDcI3UhOivn6Ndi9ySYsS2R43rZ3F5fSg+i703vpNVIL4aM8aIqnxX5HE9KHSA=
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