WCx45j9rUqOaTFExO+gqRgIf0sJii5XGiOGKr13dApwDI7QwIXrEaTaV5Me3lAsXS6lstdWOpANtuvXCXY8VACp3NIU+aS60x2vqxIFlDOrL7k3h2RSQlCiEZTtzi5DGthSOG700qZ+1st1EcMgWFUwv5BpkkmSqWe+vT2Z+AwfN7HsbsiZ++mlZzyc17t0ks+/n89e9pKcctX52bz21EQWuaYVzjkg4KtftZod71Ev4PcMB7Dy5HkGGH9bnml57uYP/cr/q+Bv4y2VryQbhAGOgoUi/Kk0Nd8d0fB5umFmKMYqqOAz0RHSW+AhrMN6Q86mSpjfoM4LkvKT6vQcesXWjQ8i3cIhjfkGcAXxHI4OqdmVLnl8wNDlEPno1xSnCI2zeeXnipDKgpJBbL5t4olCScQbBaMEjCCQW33f9HvSOjPBh3UvB/4I7DG5WGHkoE5yCCQ3/2P+3Xr3Y000NJFoFaJp1dxLMIFnxQmxt4I+mP9gqK0IirggXQzFVPxNkxpnIHo/r3Ff1Bkux0B9Th6P0Hmihaiyrp7kjLHjxpPNqelqXWAgcVqEWnkaE56nK+DIjBDarOW06hDQoi02MEZ28lr5zE1TCnIXYEBxDJKXN8hh2pO1IDxgXAbvWIqIAsRIa97zLWs1HsR/VemPn30jS/UMP3xp/i+t/pbIUeEsSPfdVENOuetY4eJbKdSS7ZUh8/+XTxsPjV7EDLrbVPLoKo6WqIJ2D2kSs+1gbdVvFXDRLFkIj4PEUzPlvQwpdkcmzG/iMvh/tM4EC+1/B9aCmdSiBIWM8+2CJuSG1XoRDQgsnfZeNidlOuXnxNqEubWMoX3YVCF+E5kqDbxkXZkmn5XdfdTdKTJP1fhXzk5cjgKdpGg5O+d3RR2WC+KSMzDxpnskCETZPiup0njKh5DbxNHpkQKRjH2vZEpVQPicIrg1j0Yi+71CWb8ibjeWVwZhiSnUFsKzvI8DEiU0KILSunBZ+CLdAKB5BsnZMLnxa3pnnD914PTDkgiRGaR3WETAOaPiCxOvdLPoR4lOPlLDl+VNBlWR5wZoktHlyTAo5jWdaoGTE9+f3239OqLRcBPEEnn0YajyfU7Djx582Y/+V9zxSWlKZ1dmjKMSstCiRWufwULPbUF6g/DuUSF87C6BPyng4JZ6XLMYSa2fuAmmD2ZZiR2/a50qpWFhcAsWMukwhUzDqEMO2fL6Zh8Wj1MSq4vFNoYSOTWQMBBWDO3EWHNG18FOWC8Rib2F8t1GMxSZLekiJ51IxqGfevcrTgQ1ufUD5/L/st9cZONY/dpwzG0RTi43stmi0LQGppNYjR3Nw2+/QXVCdTP3NuMZ0mJPoTNsoYTQW8+CMAOBTWCR8CItHnl/LLh1HCeI=
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