SELECT t.fecha_creacion, t.fecha_ultimo_acceso, t.nombre, t.apellidos, t.email, tl.titulo as division, el.value as estado FROM public_users as t LEFT JOIN div_divisiones_lang as tl ON t.id_division = tl.id_rel LEFT JOIN public_users_estados_lang as el ON t.estado= el.id_rel WHERE tl.lang='es'