JAy+FBP+BpBIp2fpaA50htLT1DyG0yWOpS23nxczm4TAuT7QxQIK0va7ndjkJn+CDf2UjrPRQs/25leT7oqhfbIGldUJemxkGKN3j8HZMwghTzLOnAxE8GdTT6zFIsGF8XacOSSi8vVoMjojPpVNT8y37294E76GvxBWx1vraxOB+fzhu/8Qthu4SIqsjnXKRMzKdTBwThterGgusJfdnWdPl0vkGEJHfQvb6W33nUXnXZyZB7xy0f3+zjw2KWrjzdVdaxvzffg4/mFrmbDCGI8QlSNqKQ2OjFm5wzQDzocWMgt0iElsFWcUKihaIBgtx5EHmqASq5EMBvM+LnFnMAOkFwLq7/9lJe91vV9obTtMGZyI/QDn4i/BL2qHVxBsJRkDv0aUrJZDNtMyBpt2vw92XAC3pJPUnii8f+AhjQ0VDtx6+PSF9B6JR9H42gCMWMZrPSLXYvWAC4hLNjr4BrxRSLSEtxBQr3QIVaLQVKLug2BY9WN+IiOwio/ZYx3TOFQ9TaD/Pm/dditTDp4YbBisNixRjjkLljpgBrMsNthf+9mbVMF2mPyhQJRkL9D/D/KVBV7ULLnXAyAApnakqli3Ihs6+O+tXakapDjCdjCA9DGm+Mx2BKDPPaa0ebCx9VrLHwrhWx8w8upUgPYnivdFnPcpGLvWI/WDx1DBOXuogdBx5kZ46fGt13d91vRn0St5dpAMYyeH2GpaMN7A/GNJYXbXwtph38gw4hEgnnoX2v/8avLP6vyV6f2WgJexZc9hmT0AuX8hl16eUupM/pAonp+v5Cwn8bOTPSmNpoyHgGqOJb+q2H4rGPSahLbFj7pCcSGrX0PLhBAWFz2WYQartg2W6mKwNU10ZP1OtwO37RqJaPv8uyVXe5v9YhIAzMCCr7HdvfP11+RTYhDp4FnbcXOGbz8DplDXTQpKpRJCto6tAjM7IlBLnBoY+9ELojYxWS0QaLN3fiCRwwuBlH1JDDC7kIcKEEcjNsiXLzThLvRA2NnEVOXHEi5XL2qElCWygPYih0g9uNW9D4cmfI+mcv+gDTW1OGC94dGKDU+QYA5f0CQ52cb0H49DM1hXVkd2Mw7l+Nd/KC1sulk6t/qUpsqHmx5CzYIVXxXRrOikxSNVhyE9L8GqbiZAAfiyTs72CLuV42lhYophHIyw84mtgXLvawImI/oXlmiPcX2iouJoRhe9ciU8Qw0x+BGEctL7cYenXgx4wMyEUTYRHzPAjwdXh0MS9qzo1s1z83Hop9xK+SAV8j/kkHRrwhIGq0cGc5ZQwLZ2EaRUyR9ndd0BGalgm392+vGXh/Ml89Y+TXUaOa/f0v8rDUqnPmuAqM8DnCEMHjcFkXB8h/ajEVwOcqfBh1+wMtaIPfM=
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