RVk2yds+BND7PKs5cZ8bPfW1WxlaQzRvgDe51bv3dEebQKCxX5ZSqRnSKBUTB2ia6RsnEPCyKURktEgnyZb5f99TNQuKTshZDajj1uAVifb7KOtrHuxLfF5IwXnnTpChl0Aq96hMpXAyqYXuDGv2JVmokczovyrec174+RuXUZV14EJ2WRSbTUMewLPqt0ve2NgjYO9vXw4Dxj2dYbIn3S7eteVzhdDNeUy7o67LqqLEu4AhPKw3Rj+iixcPaMrQKsowXbCZP18JEZUBTZEPfsfaIL3pAfGgxcTruSoBon4/WbcS05BIxPJql+ZjuCMcZRMoBbaqfAHBFuASS17C8Dh+jQ0ngh//ZJRVfCNsAOQLcYcKotaWbKRzeWzF7eAYfYMVFB95D+8j3OBPnk8SsMwLLzEU95KVmuwJFtEip3Ja6r/CnkLRDr5hioQ326M4fnB6iT6fUzwUHpR70y+fE/31KK6XBmdRthDjjhw6/pVrPRej9FFlwkvvveKw+V0TfpRnpth07GANlCKaMV9U38EEBabCtwLcFTKcC0Jmw54Mn8CoC8t10svlLlxYFeIfA9umSbwhAM00KXWu6LSM8onGPkwb8VSnmLjLuhq8p2XuV66kjwR+XfQp4oyYMqVxZ162TephGa5wDVfYCdCXTLtyyRY8X+z1/c49Qd0KSu7x1LnNWgBjCvOiP1AU/8a8UqDofhrAunpYTEBF/nCQJEQgCiKvNgp/RzOYOPEzYvrEuYXEYObugZLiG3aETA/XZkK+L+HCbHGwA8VpnfJJzXXJxZXZduQi6TCcva/Ze566WyvCNgUVJ/fZ7OchvEDicoODz5z6TEo6fh5lPcJxtos1JRNmOWs8hOSVrPO6jtwUaNUA0wcB8LYdb5usiKuzMwSYCsCfvG0HTdIChVXUd5S4EddMmcTSCUhGRSf1DydJKriGo6Y7LnFEAnHqDE2pw4VqMaxt0hbqVEKDm/jp7xuHXsWCvIQhWL2XeSqlTmB8JG9oD3+KF0KIH/Q8nEsjQLpvUK1TODzu6pYc/UKSk+f1btWthvOZQgmu0M0tafWYB801w+GlC66l6hEXvGxFDJe9C4eoGlMz0M9Mo9jEuHWewnj8qhGDgAaeAKbDNnOM9QUGyYZqWkjToObOe7DaGZ13sjXLD8/0QCILlMmVbckABq3FhKur79sa+zGXKTQKyN4cJ/4/g2jvuK6J+3pg4exZub/2W15zAtjqjlpgc/B+gP4ZSh0DI5ab6ar219kh8P6uwuy0yzkwoz77KhsqdR7W+KzeG7C8i4AbfQCJZAZejLIibHrWPL+pcbmFrfdv5DP4uGUOp+89j9xZJrcNSFhJ7R88TC1dbe1/KAAIlpAXFzcSOkDNsrmsJtE=
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