表管理(数据类型、创建/修改表、添加/修改/删除数据、数据查询) 1.Oracle表的管理_表的创建、数据的添加、修改、删除、查询、分组与排序、多-优快云博客

?表名和列名的命名规则：
?必须以字母开头；
?长度不能超过30个字符；
?不能使用oracle的保留字；
?只能使用如下字符：A-Z, a-z, 0-9, $, # 等。
?Oracle支持的数据类型：
?字符型
char 定长最大2000个字符

char(10)----'小韩' 前四个字符放'小韩'，后添加6个空格补全。(查询效率高)

varchar2(20) 变长最大4000个字符

vachar2(10)----'小韩' oracle分配四个字符，这样可以节省空间。

clob(character large object的缩写) 字符型大对象最大4G

?数字型
number ---范围：负的10的38次方----10的38次方； ---可以表示整数，也可以表示小数

eg：number(5,2) ---表示一个小数有5位有效数， 2位小数；范围：-999.99 -- 999.99

number(5) --- 表示一个五位整数；范围： -99999 -- 99999

?日期类型
date --- 包含年月日和时分秒

timestamp --- oracle9i对date数据类型的扩展，精确到毫秒级的。

?图片
blob --- 二进制数据，可以存放图片/声音 4G

注意：存放图片/声音时，一般在数据库中存放路径，除非要求安全性特别高。

?创建表
?create table 表名(列名列类型，...);
查看表的结构： desc 表名；

?修改表
?添加一个字段：
sql>alter table 表名 add (列名，列类型)；

?修改字段的长度
sql>alter table student modify (列名，列类型);

?修改字段的类型/名字(不能有数据)
sql>alter table student modify (列名，列类型);

?删除一个字段(一般不建议此操作)
sql>alter table student drop column 列名;

?修改表的名字
sql>rename 表名 to 新表名;

?删除表
sql>drop table 表名;

?表查询(后面再说)
?插入数据
?所有字段都插入
insert into 表名 values(一条记录);

提示：Oracle中默认的日期格式是：'DD_MON(eg：5月)-YY/YYYY';

更改日期的默认格式：alter session set nls_date_format = 'yyyy-mm-dd';

?插入部分字段
insert into 表名(列1，列2，列3，...) values(值1，值2，值3，...)；

?插入空值
insert into 表名(列1，列2，列3，...) values(值1，null(空值)，值3，...)；

?更新数据
?改一个或多个字段
update student set 列名1 = 实际值1，列名2 = 实际值2，... where 列名 ='预提供值';

?修改含有null值的数据
?删除数据
?delete from 表名； --- 删除所有记录，表结构还在，写日志，可以恢复，速度慢。
恢复数据 --- a.设置保存点：savepoint 点名称； b.回滚到保存点： rollback to 点名称；

?drop table 表名； --- 删除表的结构和数据
?delete from 表名 where 列名='值'； --- 删除一条记录。
?truncate table 表名; --- 删除表中的所有记录，表结构还在，不写日志，无法恢复，速度快。
2.Oracle表的基本查询

?简单的查询语句
?查看表结构：
desc 表名;

?查询所有列：
select * from 表名;

tips: 1.set timing on/off; ---开启时间消耗的开关;

2.表的列名大小写不区分，记录的值大小写时区分的。

?查询指定列：
select 指定的列名 from 表名;

?取消重复行：
select distinct 列名1，列名2，... from 表名;

?使用算数表达式： + - * /
?使用列的别名(空格或 as)：表的别名不用as，用空格
select ename(列名) "姓名(别名)", sal*12 as "年收入(别名)" from emp(表名);

当使用的别名中包含大小写、空格、特殊字符时，那么就需要双引号("")而不是单引号将其括起来；经常给表达式一个有意义的别名。

?如何处理null值：
使用nvl函数来处理: nvl(列名，0) --- 若记录对应的列为null，则列的值为0，否则为列的实际值。

?如何连接字符串(||): 字符串用单引号('')括起来。
eg：select ename || 'is a ' || job from emp;

?使用where子句的查询：
eg：日期在1982年1月1日以后：time>'1-1月-1982';sal在2000到2500之间： sal>2000 and sal<2500;

?查询条件：
1、比较运算符： <、 >、 <=、 >=、 <>/!、 =

2、使用逻辑操作符：OR AND NOT

3、其它运算符：

LIKE和NOT LIKE操作符： %：任意0到多个字符； _：表示任意单个字符； NOT LIKE/LIKE '匹配字符串' [ESCAPE '换码字符'] eg:like '%\_A%' ESCAPE '\';

IN()和NOT IN()：确定离散范围。 --- where 列名 in (列值1，列值2，列值3，...);

BETWEEN a AND b NOT BETWEEN a AND b: 确定连续范围。

IS NULL 和NOT IS NULL：测试是否为空

注意事项：

1.在where子句中使用数字值时，既可以使用单引号也可以不使用；使用字符串值、日期值时都必须使用单引号。并且字符串值时大小写敏感的，日期值是格式敏感的。

2.日期值的默认格式是DD-MM-YY，否则必须用TO_DATE函数转换。

?使用order by语句
order by 列名1 ASC(升序)，列名2 DESC(降序)；

注意：可以对多列进行排序；order by子句必须是最后一个子句；可以使用列的别名、列的位置进行排序；用于排序的列也可以不是查询的列（有distinct不行）；

eg:select 列名1，列名2 as "别名"，... from 表名 order by "别名" ASC；

?分页查询(三种方式) 速度：法二>法一>法三
法一：rownum分页: rownum --行页码 eg: 记录：6--10

a.做一个子查询，并看做是一个内嵌视图； select * from 表；

b.显示rownum[oracle分配的]； select a1.*，rownum rn from (select * from 表) a1;

c.显示行号小于10的记录；select a1.*，rownum rn from (select * from 表) as a1 where rownum<=10;

d.显示行号大于6的记录； select * from (select a1.*，rownumrn rn from (select * from 表) as a1 where rownum<=10) where rn>6;

解释：1.只查询部分列信息时，只需修改最里层表的指定列信息即可。

2.排序：只需最里层表的列信息排序即可，另外分组等也只需改动最里层表的列信息即可。

3.步骤a,b,c里的rownum、rn等的位置不能变动。

法二：根据ROWID来分：

select * from 表名 where rowid in

(select rid from

(select rownum rn, rid from

(select rowid rid,cid from 表名 order by cid desc)

where rownum<10000)

where rn>9980)

order by desc;

法三：按分析函数来分：

select * from (select t.*, row_number() over(order by cid desc) rk from 表名 t) where rk<10000 and rk>9980

3.Oracle表复杂查询

?数据分组
?分组函数：
max--列或表达式的最大值(数据最大、时间最晚)，<--> min，

avg--列或表达式的平均值， sum--列或表达式的合计值

count--返回记录行的行数

variance --列或表达式的方差； stddev --列或表达式的标准差

注意：1.当在where中，列与分组函数比较查询时，可用子查询解决此问题。

2.分组函数只能出现在查询列表、having、order by子句中，绝对不能出现在where子句和group by子句中；

3.在选择列表中同时包含列、表达式和分组函数，那么这些列和表达式都必须出现在group by子句中，否子就会出错；

4.如果在select语句中同时包含有group by, having, order by, 那么他们的顺序是group by, having, order by；

5.除count(*)外，其它分组函数，包括count(列名)都会忽略列为NULL的列；

6.函数(distinct/all 列名)

?group by 和 having
group by --- 用于对查询的结果分组统计；

分组方法：可以对一列或多列进行分组；使用rollup和cube生成横向和纵向的统计结果。

having子句 --- 用于限制分组显示结果，组筛选--只显示满足条件的组；

1.having子句必须和group by子句一起使用，但group by子句可以自己使用。

eg：select ..... from 表名 where 条件 group by 列名1,列名2，...having 组筛选；

?连接查询
多表查询---基于两个或两个以上的表或视图的查询。笛卡尔集规定：多表查询的条件至少是表的个数-1(避免出现笛卡尔连接)；

?多个不同表的查询
select a表的列1，...，b表的列1，... from a表，b表，... where a.列=b.列 AND 其它条件等 order by 列

?自连接 ---- 在同一张表的连接查询。
---- 做法：将一个表赋予两个不同的别名，其它的和多个不同表的查询一致；

?集合查询
为合并多个select语句的结果，可以使用集合操作符union、union all、intersect、minus。但注意：不同结果集的列个数和对应数据类型匹配(长度可不同); 不同结果集的列的名称可不同，采用第一个结果集的列名称；只能有一个order by子句；

?union
该操作符用于取得两个结果集的并集，使用时，会自动去掉结果集中的重复行。select ...from .. union select ... order by 列名；

?union all
该操作符用于取得两个结果集的并集，使用时，不会去掉结果集中的重复行，并且不会排序。用法类似。

?intersect
该操作符用于取得两个结果集的交集。用法类似。

?minus
使用该操作符，取得两个结果集的差集，它只会显示存在于第一个集合但是不存在于第二个集合中的结果集。用法类似。

?子查询 --- 指嵌入在其它sql语句中的select语句，也叫嵌套查询。
?单列子查询：
--- 单行子查询：只返回一行数据的子查询语句；

①可以放在Select语句的where子句、having语句、from子句中；

②运算符： =、 >、 <、 >=、 <=、 <>

--- 多行子查询：返回多行数据的子查询；

①运算符：IN、NOT IN、EXISTS、NOT EXISTS、ANY和ALL(ANY和ALL必须和比较运算符结合使用)

②in 和 exists区别：in 是把外表和内表作hash join，而exists是对外表作loop，每次loop再对内表进行查询。如果查询的两个表大小相当，那么用in和exists差别不大。如果两个表中一个较小，一个是大表，则子查询表大的用exists，子查询表小的用in；

③not in 和not exists 的区别：如果查询语句使用了not in 那么内外表都进行全表扫描，没有用到索引；而not extsts 的子查询依然能用到表上的索引。所以无论哪个表大，用not exists都比not in要快。尽量不要使用not in子句。使用minus 子句都比not in 子句快，虽然使用minus子句要进行两次查询：

④在多行子查询中使用all操作符； eg：sal>all(select sal ...)-- sal比右边的所有的都大用max也可以

⑤在多行子查询中使用any操作符： eg：sal>any(select sal ...)-- sal中存在比右边的大用min也可以

?多列子查询：
---指查询返回多个列数据的子查询语句；可以成对比较，也可以非成对比较。

单行：select * from 表名 where (列1，列2，...)=（select 列1，列2，... from 表名）；

多行：用IN

tips：数据库的执行是从右到左。

?相关子查询：引用了父查询中某些表或列的子查询；
?标量子查询：只返回单行单列的数据。
?在from子句中使用子查询
逻辑---a.查询出各个部门的平均工资和部门号；表 a2

b.把上一步的查询结果看做是一张子表(内嵌视图)；（select ... from ...) a1 --不能用as

c.用上述两张表a2，a1 进行多表查询

总结：挡在from子句中使用子查询时，该子查询会被作为一个视图来对待，因此也叫内嵌视图，当在from子句中使用子查询时，必修给予子查询指定别名(不能用as指定别名)。

?在DDL、DML语句中使用子查询
?在DDL语句中使用子查询
在create table语句中使用子查询：

create table 表名(列名1,列名2,...) as select 列名1,列名2,... from 表名 where ...；

create table 表名 as select * from 表名 where ...;

在create view中使用子查询：

create or replace view 视图名 as select ...;

?在DML语句中使用子查询
在update中使用子查询：

update 表名 set (...)=(select ... from ...) where 列名=(select ... from ...);

在delete中使用子查询：

delete from 表名 where 列名=/in (select ... from ...where...);

在insert中使用子查询：

插入全部列：insert into 表名 select .....

插入部分列：insert into 表名(部分列) select ...; 部分列中一定要有主键列和NOT NULL列

4.创建新的数据库

?法一：使用DataBase Configuration Assistant创建/删除/配置数据库
?法二：可以手工步骤直接创建

http://www.douban.com/people/98117230/
http://www.douban.com/people/98118368/
http://www.douban.com/people/98118439/
http://www.douban.com/people/98118289/
http://www.douban.com/people/98117218/
http://www.douban.com/people/98118298/
http://www.douban.com/people/98118272/
http://www.douban.com/people/98118430/
http://www.douban.com/people/98117141/
http://www.douban.com/people/98118310/
http://www.douban.com/people/98117162/
http://www.douban.com/people/98117163/
http://www.douban.com/people/98118397/
http://www.douban.com/people/98117090/
http://www.douban.com/people/98118400/
http://www.douban.com/people/98117025/
http://www.douban.com/people/98118231/
http://www.douban.com/people/98117208/
http://www.douban.com/people/98117109/
http://www.douban.com/people/98117177/
http://www.douban.com/people/98118304/
http://www.douban.com/people/98117106/
http://www.douban.com/people/98116986/
http://www.douban.com/people/98118376/
http://www.douban.com/people/98116926/
http://www.douban.com/people/98117022/
http://www.douban.com/people/98118346/
http://www.douban.com/people/98116978/
http://www.douban.com/people/98116855/
http://www.douban.com/people/98118327/
http://www.douban.com/people/98116839/
http://www.douban.com/people/98116941/
http://www.douban.com/people/98116817/
http://www.douban.com/people/98118193/
http://www.douban.com/people/98116881/
http://www.douban.com/people/98118127/
http://www.douban.com/people/98118082/
http://www.douban.com/people/98116837/
http://www.douban.com/people/98117133/
http://www.douban.com/people/98118163/
http://www.douban.com/people/98118142/
http://www.douban.com/people/98118074/
http://www.douban.com/people/98116846/
http://www.douban.com/people/98116901/
http://www.douban.com/people/98117075/
http://www.douban.com/people/98117044/
http://www.douban.com/people/98118034/
http://www.douban.com/people/98117970/
http://www.douban.com/people/98117012/
http://www.douban.com/people/98118017/
http://www.douban.com/people/98117918/
http://www.douban.com/people/98118392/
http://www.douban.com/people/98117850/
http://www.douban.com/people/98117953/
http://www.douban.com/people/98116893/
http://www.douban.com/people/98118047/
http://www.douban.com/people/98117872/
http://www.douban.com/people/98117942/
http://www.douban.com/people/98117801/
http://www.douban.com/people/98117859/
http://www.douban.com/people/98117754/
http://www.douban.com/people/98117765/
http://www.douban.com/people/98117971/
http://www.douban.com/people/98117892/
http://www.douban.com/people/98117718/
http://www.douban.com/people/98117775/
http://www.douban.com/people/98117731/
http://www.douban.com/people/98117704/
http://www.douban.com/people/98117696/
http://www.douban.com/people/98117750/
http://www.douban.com/people/98117778/
http://www.douban.com/people/98117804/
http://www.douban.com/people/98117923/
http://www.douban.com/people/98118067/
http://www.douban.com/people/98117588/
http://www.douban.com/people/98117557/
http://www.douban.com/people/98117674/
http://www.douban.com/people/98117602/
http://www.douban.com/people/98117498/
http://www.douban.com/people/98117545/
http://www.douban.com/people/98116965/
http://www.douban.com/people/98117479/
http://www.douban.com/people/98137208/
http://www.douban.com/people/98117421/
http://www.douban.com/people/98117729/
http://www.douban.com/people/98117439/
http://www.douban.com/people/98117376/
http://www.douban.com/people/98117593/
http://www.douban.com/people/98117360/
http://www.douban.com/people/98117454/
http://www.douban.com/people/98117639/
http://www.douban.com/people/98117928/
http://www.douban.com/people/98137213/
http://www.douban.com/people/98117474/
http://www.douban.com/people/98117478/
http://www.douban.com/people/98117539/
http://www.douban.com/people/98116787/
http://www.douban.com/people/98116625/
http://www.douban.com/people/98116780/
http://www.douban.com/people/98116688/
http://www.douban.com/people/98116654/
http://www.douban.com/people/98117314/
http://www.douban.com/people/98116700/
http://www.douban.com/people/98118179/
http://www.douban.com/people/98116565/
http://www.douban.com/people/98116562/
http://www.douban.com/people/98116608/
http://www.douban.com/people/98116623/
http://www.douban.com/people/98116543/
http://www.douban.com/people/98116563/
http://www.douban.com/people/98116778/
http://www.douban.com/people/98116607/
http://www.douban.com/people/98116471/
http://www.douban.com/people/98116495/
http://www.douban.com/people/98118014/
http://www.douban.com/people/98116429/
http://www.douban.com/people/98116415/
http://www.douban.com/people/98117666/
http://www.douban.com/people/98116418/
http://www.douban.com/people/98116396/
http://www.douban.com/people/98117394/
http://www.douban.com/people/98116430/
http://www.douban.com/people/98116499/
http://www.douban.com/people/98116661/
http://www.douban.com/people/98116331/
http://www.douban.com/people/98116454/
http://www.douban.com/people/98116305/
http://www.douban.com/people/98116261/
http://www.douban.com/people/98116421/
http://www.douban.com/people/98116448/
http://www.douban.com/people/98116162/
http://www.douban.com/people/98116349/
http://www.douban.com/people/98117320/
http://www.douban.com/people/98116229/
http://www.douban.com/people/98116357/
http://www.douban.com/people/98116041/
http://www.douban.com/people/98116186/
http://www.douban.com/people/98116025/
http://www.douban.com/people/98116014/
http://www.douban.com/people/98116128/
http://www.douban.com/people/98116005/
http://www.douban.com/people/98116072/
http://www.douban.com/people/98117516/
http://www.douban.com/people/98116212/
http://www.douban.com/people/98116002/
http://www.douban.com/people/98116298/
http://www.douban.com/people/98116371/
http://www.douban.com/people/98116016/
http://www.douban.com/people/98116036/
http://www.douban.com/people/98115951/
http://www.douban.com/people/98116069/
http://www.douban.com/people/98115963/
http://www.douban.com/people/98115885/
http://www.douban.com/people/98115864/
http://www.douban.com/people/98115850/
http://www.douban.com/people/98115794/
http://www.douban.com/people/98115981/
http://www.douban.com/people/98115811/
http://www.douban.com/people/98117312/
http://www.douban.com/people/98115857/
http://www.douban.com/people/98115751/
http://www.douban.com/people/98115827/
http://www.douban.com/people/98116180/
http://www.douban.com/people/98115713/
http://www.douban.com/people/98115883/
http://www.douban.com/people/98115968/
http://www.douban.com/people/98115703/
http://www.douban.com/people/98115698/
http://www.douban.com/people/98115659/
http://www.douban.com/people/98116076/
http://www.douban.com/people/98115484/
http://www.douban.com/people/98115523/
http://www.douban.com/people/98115538/
http://www.douban.com/people/98115461/
http://www.douban.com/people/98137350/
http://www.douban.com/people/98115620/
http://www.douban.com/people/98115678/
http://www.douban.com/people/98115463/
http://www.douban.com/people/98115666/
http://www.douban.com/people/98115896/
http://www.douban.com/people/98115416/
http://www.douban.com/people/98115525/
http://www.douban.com/people/98115598/
http://www.douban.com/people/98115346/
http://www.douban.com/people/98115764/
http://www.douban.com/people/98099124/
http://www.douban.com/people/98099131/
http://www.douban.com/people/98115797/
http://www.douban.com/people/98115481/
http://www.douban.com/people/98099154/
http://www.douban.com/people/98099128/
http://www.douban.com/people/98115629/
http://www.douban.com/people/98099086/
http://www.douban.com/people/98099101/
http://www.douban.com/people/98099090/
http://www.douban.com/people/98115389/
http://www.douban.com/people/98116293/
http://www.douban.com/people/98099038/
http://www.douban.com/people/98099050/
http://www.douban.com/people/98115429/
http://www.douban.com/people/98099002/
http://www.douban.com/people/98098968/
http://www.douban.com/people/98099055/
http://www.douban.com/people/98098951/
http://www.douban.com/people/98115431/
http://www.douban.com/people/98099088/
http://www.douban.com/people/98099013/
http://www.douban.com/people/98098926/
http://www.douban.com/people/98098950/
http://www.douban.com/people/98099047/
http://www.douban.com/people/98098924/
http://www.douban.com/people/98098931/
http://www.douban.com/people/98115982/
http://www.douban.com/people/98098887/
http://www.douban.com/people/98103348/
http://www.douban.com/people/98098909/
http://www.douban.com/people/98098957/
http://www.douban.com/people/98098880/
http://www.douban.com/people/98098869/
http://www.douban.com/people/98099030/
http://www.douban.com/people/98097146/
http://www.douban.com/people/98097127/
http://www.douban.com/people/98115517/
http://www.douban.com/people/98097113/
http://www.douban.com/people/98098942/
http://www.douban.com/people/98097124/
http://www.douban.com/people/98097096/
http://www.douban.com/people/98097070/
http://www.douban.com/people/98097142/
http://www.douban.com/people/98098925/
http://www.douban.com/people/98115680/
http://www.douban.com/people/98097181/
http://www.douban.com/people/98097044/
http://www.douban.com/people/98096985/
http://www.douban.com/people/98096963/
http://www.douban.com/people/98097058/
http://www.douban.com/people/98099012/
http://www.douban.com/people/98096957/
http://www.douban.com/people/98097060/
http://www.douban.com/people/98098905/
http://www.douban.com/people/98096948/
http://www.douban.com/people/98097061/
http://www.douban.com/people/98098891/
http://www.douban.com/people/98096892/
http://www.douban.com/people/98099104/
http://www.douban.com/people/98097021/
http://www.douban.com/people/98096942/
http://www.douban.com/people/98096867/
http://www.douban.com/people/98096907/
http://www.douban.com/people/98096941/
http://www.douban.com/people/98096855/
http://www.douban.com/people/98096919/
http://www.douban.com/people/98098980/
http://www.douban.com/people/98098840/
http://www.douban.com/people/98098776/
http://www.douban.com/people/98098862/
http://www.douban.com/people/98096977/
http://www.douban.com/people/98098764/
http://www.douban.com/people/98098836/
http://www.douban.com/people/98141626/
http://www.douban.com/people/98097022/
http://www.douban.com/people/98096888/
http://www.douban.com/people/98097151/
http://www.douban.com/people/98098814/
http://www.douban.com/people/98098721/
http://www.douban.com/people/98098703/
http://www.douban.com/people/98097074/
http://www.douban.com/people/98098787/
http://www.douban.com/people/98098771/
http://www.douban.com/people/98096860/
http://www.douban.com/people/98096863/
http://www.douban.com/people/98098753/
http://www.douban.com/people/98098708/
http://www.douban.com/people/98098684/
http://www.douban.com/people/98098656/
http://www.douban.com/people/98098622/
http://www.douban.com/people/98096836/
http://www.douban.com/people/98098612/
http://www.douban.com/people/98098812/
http://www.douban.com/people/98098620/
http://www.douban.com/people/98098728/
http://www.douban.com/people/98098606/
http://www.douban.com/people/98098669/
http://www.douban.com/people/98098565/
http://www.douban.com/people/98098597/
http://www.douban.com/people/98098668/
http://www.douban.com/people/98098575/
http://www.douban.com/people/98098655/
http://www.douban.com/people/98098521/
http://www.douban.com/people/98098574/
http://www.douban.com/people/98098515/
http://www.douban.com/people/98098609/
http://www.douban.com/people/98098518/
http://www.douban.com/people/98098510/
http://www.douban.com/people/98098763/
http://www.douban.com/people/98098817/
http://www.douban.com/people/98098559/
http://www.douban.com/people/98098563/
http://www.douban.com/people/98098463/
http://www.douban.com/people/98098513/
http://www.douban.com/people/98098402/
http://www.douban.com/people/98098662/
http://www.douban.com/people/98098569/
http://www.douban.com/people/98098466/
http://www.douban.com/people/98098438/
http://www.douban.com/people/98098329/
http://www.douban.com/people/98098689/
http://www.douban.com/people/98098464/
http://www.douban.com/people/98098482/
http://www.douban.com/people/98098561/
http://www.douban.com/people/98098358/
http://www.douban.com/people/98098367/
http://www.douban.com/people/98098312/
http://www.douban.com/people/98098384/
http://www.douban.com/people/98098593/
http://www.douban.com/people/98098314/
http://www.douban.com/people/98098324/
http://www.douban.com/people/98098426/
http://www.douban.com/people/98098217/
http://www.douban.com/people/98098211/
http://www.douban.com/people/98098283/
http://www.douban.com/people/98098237/
http://www.douban.com/people/98098184/
http://www.douban.com/people/98098274/
http://www.douban.com/people/98098159/
http://www.douban.com/people/98098238/
http://www.douban.com/people/98098428/
http://www.douban.com/people/98098089/
http://www.douban.com/people/98098114/
http://www.douban.com/people/98098085/
http://www.douban.com/people/98098421/
http://www.douban.com/people/98098181/
http://www.douban.com/people/98098069/
http://www.douban.com/people/98098027/
http://www.douban.com/people/98098115/
http://www.douban.com/people/98098187/
http://www.douban.com/people/98098375/
http://www.douban.com/people/98098097/
http://www.douban.com/people/98097941/
http://www.douban.com/people/98097987/
http://www.douban.com/people/98097949/
http://www.douban.com/people/98097931/
http://www.douban.com/people/98098064/
http://www.douban.com/people/98097906/
http://www.douban.com/people/98097979/
http://www.douban.com/people/98097859/
http://www.douban.com/people/98098019/
http://www.douban.com/people/98098228/
http://www.douban.com/people/98097854/
http://www.douban.com/people/98097810/
http://www.douban.com/people/98098233/
http://www.douban.com/people/98097833/
http://www.douban.com/people/98098017/
http://www.douban.com/people/98097865/
http://www.douban.com/people/98097858/
http://www.douban.com/people/98097780/
http://www.douban.com/people/98097971/
http://www.douban.com/people/98098284/
http://www.douban.com/people/98097792/
http://www.douban.com/people/98097796/
http://www.douban.com/people/98098323/
http://www.douban.com/people/98097753/
http://www.douban.com/people/98097756/
http://www.douban.com/people/98097789/
http://www.douban.com/people/98097732/
http://www.douban.com/people/98097702/
http://www.douban.com/people/98098262/
http://www.douban.com/people/98097741/
http://www.douban.com/people/98097804/
http://www.douban.com/people/98097706/
http://www.douban.com/people/98097657/
http://www.douban.com/people/98097634/
http://www.douban.com/people/98097663/
http://www.douban.com/people/98097572/
http://www.douban.com/people/98097745/
http://www.douban.com/people/98097601/
http://www.douban.com/people/98097638/
http://www.douban.com/people/98097660/
http://www.douban.com/people/98097595/
http://www.douban.com/people/98097545/
http://www.douban.com/people/98097564/
http://www.douban.com/people/98097489/
http://www.douban.com/people/98097524/
http://www.douban.com/people/98097621/
http://www.douban.com/people/98097519/
http://www.douban.com/people/98138907/
http://www.douban.com/people/98097483/
http://www.douban.com/people/98098461/
http://www.douban.com/people/98097522/
http://www.douban.com/people/98097713/
http://www.douban.com/people/98097417/
http://www.douban.com/people/98097382/
http://www.douban.com/people/98097558/
http://www.douban.com/people/98097420/
http://www.douban.com/people/98097546/
http://www.douban.com/people/98097339/
http://www.douban.com/people/98097461/
http://www.douban.com/people/98097431/
http://www.douban.com/people/98097299/
http://www.douban.com/people/98098011/
http://www.douban.com/people/98097317/
http://www.douban.com/people/98097391/
http://www.douban.com/people/98097749/
http://www.douban.com/people/98097295/
http://www.douban.com/people/98097286/
http://www.douban.com/people/98097209/
http://www.douban.com/people/98097368/
http://www.douban.com/people/98097285/
http://www.douban.com/people/98097320/
http://www.douban.com/people/98097460/
http://www.douban.com/people/98096829/
http://www.douban.com/people/98096818/
http://www.douban.com/people/98096803/
http://www.douban.com/people/98097245/
http://www.douban.com/people/98096759/
http://www.douban.com/people/98097323/
http://www.douban.com/people/98096800/
http://www.douban.com/people/98096817/
http://www.douban.com/people/98097341/
http://www.douban.com/people/98096715/
http://www.douban.com/people/98096789/
http://www.douban.com/people/98096743/
http://www.douban.com/people/98097242/
http://www.douban.com/people/98097184/
http://www.douban.com/people/98096688/
http://www.douban.com/people/98096669/
http://www.douban.com/people/98097254/
http://www.douban.com/people/98096683/
http://www.douban.com/people/98096710/
http://www.douban.com/people/98096660/
http://www.douban.com/people/98096619/
http://www.douban.com/people/98097353/
http://www.douban.com/people/98096609/
http://www.douban.com/people/98097229/
http://www.douban.com/people/98097309/
http://www.douban.com/people/98096696/
http://www.douban.com/people/98096758/
http://www.douban.com/people/98097204/
http://www.douban.com/people/98096765/
http://www.douban.com/people/98096546/
http://www.douban.com/people/98096709/
http://www.douban.com/people/98096499/
http://www.douban.com/people/98096651/
http://www.douban.com/people/98096558/
http://www.douban.com/people/98096339/
http://www.douban.com/people/98096485/
http://www.douban.com/people/98096573/
http://www.douban.com/people/98095767/
http://www.douban.com/people/98096589/
http://www.douban.com/people/98095774/
http://www.douban.com/people/98095730/
http://www.douban.com/people/98097196/
http://www.douban.com/people/98095681/
http://www.douban.com/people/98095696/
http://www.douban.com/people/98095697/
http://www.douban.com/people/98095743/
http://www.douban.com/people/98095627/
http://www.douban.com/people/98096650/
http://www.douban.com/people/98096521/
http://www.douban.com/people/98095674/
http://www.douban.com/people/98095740/
http://www.douban.com/people/98096614/
http://www.douban.com/people/98095680/
http://www.douban.com/people/98096491/
http://www.douban.com/people/98095611/
http://www.douban.com/people/98096462/
http://www.douban.com/people/98095716/
http://www.douban.com/people/98095565/
http://www.douban.com/people/98095717/
http://www.douban.com/people/98095796/
http://www.douban.com/people/98141265/
http://www.douban.com/people/98096736/
http://www.douban.com/people/98095570/
http://www.douban.com/people/98138414/
http://www.douban.com/people/98138500/
http://www.douban.com/people/98095487/
http://www.douban.com/people/98095513/
http://www.douban.com/people/98095679/
http://www.douban.com/people/98095595/
http://www.douban.com/people/98096443/
http://www.douban.com/people/98096630/
http://www.douban.com/people/98095537/
http://www.douban.com/people/98095522/
http://www.douban.com/people/98095503/
http://www.douban.com/people/98096461/
http://www.douban.com/people/98096384/
http://www.douban.com/people/98096347/
http://www.douban.com/people/98096415/
http://www.douban.com/people/98096314/
http://www.douban.com/people/98140795/
http://www.douban.com/people/98096353/
http://www.douban.com/people/98096318/
http://www.douban.com/people/98095582/
http://www.douban.com/people/98096543/
http://www.douban.com/people/98096271/
http://www.douban.com/people/98096276/
http://www.douban.com/people/98096359/
http://www.douban.com/people/98096282/
http://www.douban.com/people/98096322/
http://www.douban.com/people/98096223/
http://www.douban.com/people/98096241/
http://www.douban.com/people/98096218/
http://www.douban.com/people/98096410/
http://www.douban.com/people/98096174/
http://www.douban.com/people/98096173/
http://www.douban.com/people/98096150/
http://www.douban.com/people/98096144/
http://www.douban.com/people/98096156/
http://www.douban.com/people/98096154/
http://www.douban.com/people/98096235/
http://www.douban.com/people/98096115/
http://www.douban.com/people/98096265/
http://www.douban.com/people/98096294/
http://www.douban.com/people/98096079/
http://www.douban.com/people/98096040/
http://www.douban.com/people/98096092/
http://www.douban.com/people/98096125/
http://www.douban.com/people/98096077/
http://www.douban.com/people/98096260/
http://www.douban.com/people/98096084/
http://www.douban.com/people/98096113/
http://www.douban.com/people/98096311/
http://www.douban.com/people/98096220/
http://www.douban.com/people/98096026/
http://www.douban.com/people/98095973/
http://www.douban.com/people/98095997/
http://www.douban.com/people/98096034/
http://www.douban.com/people/98096268/
http://www.douban.com/people/98095989/
http://www.douban.com/people/98096031/
http://www.douban.com/people/98095988/
http://www.douban.com/people/98095922/
http://www.douban.com/people/98095934/
http://www.douban.com/people/98095905/
http://www.douban.com/people/98095895/
http://www.douban.com/people/98096336/
http://www.douban.com/people/98096020/
http://www.douban.com/people/98096023/
http://www.douban.com/people/98095874/
http://www.douban.com/people/98095912/
http://www.douban.com/people/98095901/
http://www.douban.com/people/98096213/
http://www.douban.com/people/98095954/
http://www.douban.com/people/98095941/
http://www.douban.com/people/98095821/
http://www.douban.com/people/98096009/
http://www.douban.com/people/98095404/
http://www.douban.com/people/98095360/
http://www.douban.com/people/98138404/
http://www.douban.com/people/98095904/
http://www.douban.com/people/98095402/
http://www.douban.com/people/98095808/
http://www.douban.com/people/98095278/
http://www.douban.com/people/98095970/
http://www.douban.com/people/98095283/
http://www.douban.com/people/98095842/
http://www.douban.com/people/98095963/
http://www.douban.com/people/98138400/
http://www.douban.com/people/98095288/
http://www.douban.com/people/98095261/
http://www.douban.com/people/98095412/
http://www.douban.com/people/98096436/
http://www.douban.com/people/98095136/
http://www.douban.com/people/98095202/
http://www.douban.com/people/98095300/
http://www.douban.com/people/98095832/
http://www.douban.com/people/98095231/
http://www.douban.com/people/98095164/
http://www.douban.com/people/98095158/
http://www.douban.com/people/98095833/
http://www.douban.com/people/98095129/
http://www.douban.com/people/98095198/
http://www.douban.com/people/98096446/
http://www.douban.com/people/98095107/
http://www.douban.com/people/98095036/
http://www.douban.com/people/98095026/
http://www.douban.com/people/98095000/
http://www.douban.com/people/98095142/
http://www.douban.com/people/98095272/
http://www.douban.com/people/98095089/
http://www.douban.com/people/98095098/
http://www.douban.com/people/98094902/
http://www.douban.com/people/98138397/
http://www.douban.com/people/98095159/
http://www.douban.com/people/98095171/
http://www.douban.com/people/98095368/
http://www.douban.com/people/98096205/
http://www.douban.com/people/98094947/
http://www.douban.com/people/98094757/
http://www.douban.com/people/98094944/
http://www.douban.com/people/98094921/
http://www.douban.com/people/98094804/
http://www.douban.com/people/98094834/
http://www.douban.com/people/98094715/
http://www.douban.com/people/98094945/
http://www.douban.com/people/98094684/
http://www.douban.com/people/98094774/
http://www.douban.com/people/98094830/
http://www.douban.com/people/98094896/
http://www.douban.com/people/98095108/
http://www.douban.com/people/98095125/
http://www.douban.com/people/98095020/
http://www.douban.com/people/98094864/
http://www.douban.com/people/98094622/
http://www.douban.com/people/98138440/
http://www.douban.com/people/98094643/
http://www.douban.com/people/98094546/
http://www.douban.com/people/98094642/
http://www.douban.com/people/98094535/
http://www.douban.com/people/98138329/
http://www.douban.com/people/98094663/
http://www.douban.com/people/98092570/
http://www.douban.com/people/98094483/
http://www.douban.com/people/98094581/
http://www.douban.com/people/98092609/
http://www.douban.com/people/98094747/
http://www.douban.com/people/98094517/
http://www.douban.com/people/98092623/
http://www.douban.com/people/98092566/
http://www.douban.com/people/98138380/
http://www.douban.com/people/98094670/
http://www.douban.com/people/98094449/
http://www.douban.com/people/98094817/
http://www.douban.com/people/98094557/
http://www.douban.com/people/98092427/
http://www.douban.com/people/98092438/
http://www.douban.com/people/98092598/
http://www.douban.com/people/98092377/
http://www.douban.com/people/98092489/
http://www.douban.com/people/98092483/
http://www.douban.com/people/98092319/
http://www.douban.com/people/98092444/
http://www.douban.com/people/98092323/
http://www.douban.com/people/98092505/
http://www.douban.com/people/98092281/
http://www.douban.com/people/98092558/
http://www.douban.com/people/98092237/
http://www.douban.com/people/98138184/
http://www.douban.com/people/98092364/
http://www.douban.com/people/98092217/
http://www.douban.com/people/98092361/
http://www.douban.com/people/98092516/
http://www.douban.com/people/98092326/
http://www.douban.com/people/98092363/
http://www.douban.com/people/98092280/
http://www.douban.com/people/98094345/
http://www.douban.com/people/98094359/
http://www.douban.com/people/98094448/
http://www.douban.com/people/98092435/
http://www.douban.com/people/98092262/
http://www.douban.com/people/98094326/
http://www.douban.com/people/98092295/
http://www.douban.com/people/98094254/
http://www.douban.com/people/98092229/
http://www.douban.com/people/98094355/
http://www.douban.com/people/98094307/
http://www.douban.com/people/98092294/
http://www.douban.com/people/98094215/
http://www.douban.com/people/98094260/
http://www.douban.com/people/98094277/
http://www.douban.com/people/98094398/
http://www.douban.com/people/98094308/
http://www.douban.com/people/98094367/
http://www.douban.com/people/98138464/
http://www.douban.com/people/98094386/
http://www.douban.com/people/98094187/
http://www.douban.com/people/98094073/
http://www.douban.com/people/98094093/
http://www.douban.com/people/98094019/
http://www.douban.com/people/98094185/
http://www.douban.com/people/98094252/
http://www.douban.com/people/98093962/
http://www.douban.com/people/98093985/
http://www.douban.com/people/98094240/
http://www.douban.com/people/98094043/
http://www.douban.com/people/98093958/
http://www.douban.com/people/98094025/
http://www.douban.com/people/98094160/
http://www.douban.com/people/98094302/
http://www.douban.com/people/98093934/
http://www.douban.com/people/98094335/
http://www.douban.com/people/98093912/
http://www.douban.com/people/98094404/
http://www.douban.com/people/98093902/
http://www.douban.com/people/98093893/
http://www.douban.com/people/98093879/
http://www.douban.com/people/98138405/
http://www.douban.com/people/98093821/
http://www.douban.com/people/98093795/
http://www.douban.com/people/98093855/
http://www.douban.com/people/98093842/
http://www.douban.com/people/98093787/
http://www.douban.com/people/98093992/
http://www.douban.com/people/98093770/
http://www.douban.com/people/98094134/
http://www.douban.com/people/98094114/
http://www.douban.com/people/98093721/
http://www.douban.com/people/98093786/
http://www.douban.com/people/98093691/
http://www.douban.com/people/98093665/
http://www.douban.com/people/98094227/
http://www.douban.com/people/98093733/
http://www.douban.com/people/98093788/
http://www.douban.com/people/98093645/
http://www.douban.com/people/98093574/
http://www.douban.com/people/98093663/
http://www.douban.com/people/98093680/
http://www.douban.com/people/98138323/
http://www.douban.com/people/98093565/
http://www.douban.com/people/98138341/
http://www.douban.com/people/98093483/
http://www.douban.com/people/98093567/
http://www.douban.com/people/98093998/
http://www.douban.com/people/98093913/
http://www.douban.com/people/98093621/
http://www.douban.com/people/98093506/
http://www.douban.com/people/98093566/
http://www.douban.com/people/98093748/
http://www.douban.com/people/98093417/
http://www.douban.com/people/98093478/
http://www.douban.com/people/98093333/
http://www.douban.com/people/98093476/
http://www.douban.com/people/98093606/
http://www.douban.com/people/98093330/
http://www.douban.com/people/98138835/
http://www.douban.com/people/98093428/
http://www.douban.com/people/98141574/
http://www.douban.com/people/98138370/
http://www.douban.com/people/98093422/
http://www.douban.com/people/98093598/
http://www.douban.com/people/98093193/
http://www.douban.com/people/98093471/
http://www.douban.com/people/98093318/
http://www.douban.com/people/98093328/
http://www.douban.com/people/98093474/
http://www.douban.com/people/98093382/
http://www.douban.com/people/98138374/
http://www.douban.com/people/98093274/
http://www.douban.com/people/98093123/
http://www.douban.com/people/98093984/
http://www.douban.com/people/98093267/
http://www.douban.com/people/98093120/
http://www.douban.com/people/98093083/
http://www.douban.com/people/98141247/
http://www.douban.com/people/98093408/
http://www.douban.com/people/98093041/
http://www.douban.com/people/98138294/
http://www.douban.com/people/98093007/
http://www.douban.com/people/98093124/
http://www.douban.com/people/98093020/
http://www.douban.com/people/98138284/
http://www.douban.com/people/98093058/
http://www.douban.com/people/98093062/
http://www.douban.com/people/98092951/
http://www.douban.com/people/98093175/
http://www.douban.com/people/98092968/
http://www.douban.com/people/98093110/
http://www.douban.com/people/98092888/
http://www.douban.com/people/98092977/
http://www.douban.com/people/98093553/
http://www.douban.com/people/98092884/
http://www.douban.com/people/98092804/
http://www.douban.com/people/98092814/
http://www.douban.com/people/98092944/
http://www.douban.com/people/98092855/
http://www.douban.com/people/98092791/
http://www.douban.com/people/98092904/
http://www.douban.com/people/98092937/
http://www.douban.com/people/98092768/
http://www.douban.com/people/98093100/
http://www.douban.com/people/98092690/
http://www.douban.com/people/98092743/
http://www.douban.com/people/98092976/
http://www.douban.com/people/98093142/
http://www.douban.com/people/98092706/
http://www.douban.com/people/98092681/
http://www.douban.com/people/98138281/
http://www.douban.com/people/98093178/
http://www.douban.com/people/98092202/
http://www.douban.com/people/98092203/
http://www.douban.com/people/98093072/
http://www.douban.com/people/98092120/
http://www.douban.com/people/98092096/
http://www.douban.com/people/98138244/
http://www.douban.com/people/98092106/
http://www.douban.com/people/98092072/
http://www.douban.com/people/98092163/
http://www.douban.com/people/98092660/
http://www.douban.com/people/98092054/
http://www.douban.com/people/98092686/
http://www.douban.com/people/98091990/
http://www.douban.com/people/98091969/
http://www.douban.com/people/98092119/
http://www.douban.com/people/98092720/
http://www.douban.com/people/98091973/
http://www.douban.com/people/98091960/
http://www.douban.com/people/98092015/
http://www.douban.com/people/98138171/
http://www.douban.com/people/98091936/
http://www.douban.com/people/98091932/
http://www.douban.com/people/98138139/
http://www.douban.com/people/98092196/
http://www.douban.com/people/98091765/
http://www.douban.com/people/98091746/
http://www.douban.com/people/98091745/
http://www.douban.com/people/98138224/
http://www.douban.com/people/98091730/
http://www.douban.com/people/98091865/
http://www.douban.com/people/98092095/
http://www.douban.com/people/98092684/
http://www.douban.com/people/98091690/
http://www.douban.com/people/98091676/
http://www.douban.com/people/98091769/
http://www.douban.com/people/98091831/
http://www.douban.com/people/98141234/
http://www.douban.com/people/98091620/
http://www.douban.com/people/98092935/
http://www.douban.com/people/98091665/
http://www.douban.com/people/98091900/
http://www.douban.com/people/98091617/
http://www.douban.com/people/98092784/
http://www.douban.com/people/98091568/
http://www.douban.com/people/98138335/
http://www.douban.com/people/98091651/
http://www.douban.com/people/98091509/
http://www.douban.com/people/98091584/
http://www.douban.com/people/98091878/
http://www.douban.com/people/98141223/
http://www.douban.com/people/98091588/
http://www.douban.com/people/98091447/
http://www.douban.com/people/98092972/
http://www.douban.com/people/98138131/
http://www.douban.com/people/98091466/
http://www.douban.com/people/98091540/
http://www.douban.com/people/98091423/
http://www.douban.com/people/98091401/
http://www.douban.com/people/98091467/
http://www.douban.com/people/98091279/
http://www.douban.com/people/98091284/
http://www.douban.com/people/98091366/
http://www.douban.com/people/98138166/
http://www.douban.com/people/98091427/
http://www.douban.com/people/98091250/
http://www.douban.com/people/98141602/
http://www.douban.com/people/98091725/
http://www.douban.com/people/98091221/
http://www.douban.com/people/98091256/
http://www.douban.com/people/98091252/
http://www.douban.com/people/98091258/
http://www.douban.com/people/98091184/
http://www.douban.com/people/98091164/
http://www.douban.com/people/98091119/
http://www.douban.com/people/98091216/
http://www.douban.com/people/98091339/
http://www.douban.com/people/98091084/
http://www.douban.com/people/98091140/
http://www.douban.com/people/98091061/
http://www.douban.com/people/98091054/
http://www.douban.com/people/98091144/
http://www.douban.com/people/98091133/
http://www.douban.com/people/98091204/
http://www.douban.com/people/98090994/
http://www.douban.com/people/98091032/
http://www.douban.com/people/98138134/
http://www.douban.com/people/98091715/
http://www.douban.com/people/98091281/
http://www.douban.com/people/98090969/
http://www.douban.com/people/98091324/
http://www.douban.com/people/98090946/
http://www.douban.com/people/98091006/
http://www.douban.com/people/98091581/
http://www.douban.com/people/98090907/
http://www.douban.com/people/98090905/
http://www.douban.com/people/98090896/
http://www.douban.com/people/98138110/
http://www.douban.com/people/98091029/
http://www.douban.com/people/98090976/
http://www.douban.com/people/98090758/
http://www.douban.com/people/98090790/
http://www.douban.com/people/98090799/
http://www.douban.com/people/98138811/
http://www.douban.com/people/98091194/
http://www.douban.com/people/98090855/
http://www.douban.com/people/98090686/
http://www.douban.com/people/98090608/
http://www.douban.com/people/98090664/
http://www.douban.com/people/98092878/
http://www.douban.com/people/98090614/
http://www.douban.com/people/98090925/
http://www.douban.com/people/98090689/
http://www.douban.com/people/98090568/
http://www.douban.com/people/98090734/
http://www.douban.com/people/98141206/
http://www.douban.com/people/98090656/
http://www.douban.com/people/98090574/
http://www.douban.com/people/98090545/
http://www.douban.com/people/98090839/
http://www.douban.com/people/98091497/
http://www.douban.com/people/98090578/
http://www.douban.com/people/98090604/
http://www.douban.com/people/98090522/
http://www.douban.com/people/98090492/
http://www.douban.com/people/98090500/
http://www.douban.com/people/98090533/
http://www.douban.com/people/98091415/
http://www.douban.com/people/98138128/
http://www.douban.com/people/98090470/
http://www.douban.com/people/98138073/
http://www.douban.com/people/98090832/
http://www.douban.com/people/98090380/
http://www.douban.com/people/98090420/
http://www.douban.com/people/98090422/
http://www.douban.com/people/98090416/
http://www.douban.com/people/98090434/
http://www.douban.com/people/98090355/
http://www.douban.com/people/98090460/
http://www.douban.com/people/98138813/
http://www.douban.com/people/98090484/
http://www.douban.com/people/98090549/
http://www.douban.com/people/98090392/
http://www.douban.com/people/98138836/
http://www.douban.com/people/98090322/
http://www.douban.com/people/98138798/
http://www.douban.com/people/98090045/

http://www.douban.com/people/98138128/
http://www.douban.com/people/98090689/
http://www.douban.com/people/98138811/
http://www.douban.com/people/98090623/
http://www.douban.com/people/98090656/
http://www.douban.com/people/98090578/
http://www.douban.com/people/98090734/
http://www.douban.com/people/98090614/
http://www.douban.com/people/98090767/
http://www.douban.com/people/98090790/
http://www.douban.com/people/98138073/
http://www.douban.com/people/98090574/
http://www.douban.com/people/98090533/
http://www.douban.com/people/98090758/
http://www.douban.com/people/98090522/
http://www.douban.com/people/98090545/
http://www.douban.com/people/98090608/
http://www.douban.com/people/98090604/
http://www.douban.com/people/98090492/
http://www.douban.com/people/98090664/
http://www.douban.com/people/98090419/
http://www.douban.com/people/98090379/
http://www.douban.com/people/98090799/
http://www.douban.com/people/98090434/
http://www.douban.com/people/98090460/
http://www.douban.com/people/98090470/
http://www.douban.com/people/98090500/
http://www.douban.com/people/98090555/
http://www.douban.com/people/98090549/
http://www.douban.com/people/98090292/
http://www.douban.com/people/98090420/
http://www.douban.com/people/98090322/
http://www.douban.com/people/98090392/
http://www.douban.com/people/98090364/
http://www.douban.com/people/98090568/
http://www.douban.com/people/98090416/
http://www.douban.com/people/98090422/
http://www.douban.com/people/98090077/
http://www.douban.com/people/98090110/
http://www.douban.com/people/98090326/
http://www.douban.com/people/98138815/
http://www.douban.com/people/98090484/
http://www.douban.com/people/98090380/
http://www.douban.com/people/98089920/
http://www.douban.com/people/98090003/
http://www.douban.com/people/98089874/
http://www.douban.com/people/98089858/
http://www.douban.com/people/98090045/
http://www.douban.com/people/98089881/
http://www.douban.com/people/98090312/
http://www.douban.com/people/98089854/
http://www.douban.com/people/98089787/
http://www.douban.com/people/98089714/
http://www.douban.com/people/98138836/
http://www.douban.com/people/98090366/
http://www.douban.com/people/98138813/
http://www.douban.com/people/98089631/
http://www.douban.com/people/98090251/
http://www.douban.com/people/98090832/
http://www.douban.com/people/98089702/
http://www.douban.com/people/98089689/
http://www.douban.com/people/98138798/
http://www.douban.com/people/98089519/
http://www.douban.com/people/98089480/
http://www.douban.com/people/98089388/
http://www.douban.com/people/98089621/
http://www.douban.com/people/98089314/
http://www.douban.com/people/98089635/
http://www.douban.com/people/98089347/
http://www.douban.com/people/98089354/
http://www.douban.com/people/98090019/
http://www.douban.com/people/98089510/
http://www.douban.com/people/98090355/
http://www.douban.com/people/98089569/
http://www.douban.com/people/98089279/
http://www.douban.com/people/98089165/
http://www.douban.com/people/98089423/
http://www.douban.com/people/98089134/
http://www.douban.com/people/98089355/
http://www.douban.com/people/98089132/
http://www.douban.com/people/98089136/
http://www.douban.com/people/98089040/
http://www.douban.com/people/98089256/
http://www.douban.com/people/98088923/
http://www.douban.com/people/98089038/
http://www.douban.com/people/98089754/
http://www.douban.com/people/98088924/
http://www.douban.com/people/98089199/
http://www.douban.com/people/98088957/
http://www.douban.com/people/98088849/
http://www.douban.com/people/98088821/
http://www.douban.com/people/98088910/
http://www.douban.com/people/98088704/
http://www.douban.com/people/98089092/
http://www.douban.com/people/98088702/
http://www.douban.com/people/98090686/
http://www.douban.com/people/98089287/
http://www.douban.com/people/98088531/
http://www.douban.com/people/98089085/
http://www.douban.com/people/98089016/
http://www.douban.com/people/98088866/
http://www.douban.com/people/98088513/
http://www.douban.com/people/98088820/
http://www.douban.com/people/98088597/
http://www.douban.com/people/98088719/
http://www.douban.com/people/98088569/
http://www.douban.com/people/98088478/
http://www.douban.com/people/98089488/
http://www.douban.com/people/98088469/
http://www.douban.com/people/98088440/
http://www.douban.com/people/98088398/
http://www.douban.com/people/98088381/
http://www.douban.com/people/98088418/
http://www.douban.com/people/98088942/
http://www.douban.com/people/98088684/
http://www.douban.com/people/98088291/
http://www.douban.com/people/98088437/
http://www.douban.com/people/98089627/
http://www.douban.com/people/98088258/
http://www.douban.com/people/98089170/
http://www.douban.com/people/98088201/
http://www.douban.com/people/98088322/
http://www.douban.com/people/98088178/
http://www.douban.com/people/98088287/
http://www.douban.com/people/98089213/
http://www.douban.com/people/98088163/
http://www.douban.com/people/98088476/
http://www.douban.com/people/98089228/
http://www.douban.com/people/98088254/
http://www.douban.com/people/98088112/
http://www.douban.com/people/98088330/
http://www.douban.com/people/98088172/
http://www.douban.com/people/98088156/
http://www.douban.com/people/98088140/
http://www.douban.com/people/98088245/
http://www.douban.com/people/98088196/
http://www.douban.com/people/98088289/
http://www.douban.com/people/98088100/
http://www.douban.com/people/98088472/
http://www.douban.com/people/98087939/
http://www.douban.com/people/98088260/
http://www.douban.com/people/98141440/
http://www.douban.com/people/98087998/
http://www.douban.com/people/98087990/
http://www.douban.com/people/98087951/
http://www.douban.com/people/98087854/
http://www.douban.com/people/98087993/
http://www.douban.com/people/98088162/
http://www.douban.com/people/98088141/
http://www.douban.com/people/98087920/
http://www.douban.com/people/98087778/
http://www.douban.com/people/98087716/
http://www.douban.com/people/98087909/
http://www.douban.com/people/98087771/
http://www.douban.com/people/98087812/
http://www.douban.com/people/98087730/
http://www.douban.com/people/98087890/
http://www.douban.com/people/98087648/
http://www.douban.com/people/98087500/
http://www.douban.com/people/98087568/
http://www.douban.com/people/98087857/
http://www.douban.com/people/98087831/
http://www.douban.com/people/98087406/
http://www.douban.com/people/98140690/
http://www.douban.com/people/98138115/
http://www.douban.com/people/98087298/
http://www.douban.com/people/98138442/
http://www.douban.com/people/98087216/
http://www.douban.com/people/98087359/
http://www.douban.com/people/98087197/
http://www.douban.com/people/98087825/
http://www.douban.com/people/98087995/
http://www.douban.com/people/98087297/
http://www.douban.com/people/98087828/
http://www.douban.com/people/98087214/
http://www.douban.com/people/98087141/
http://www.douban.com/people/98087075/
http://www.douban.com/people/98086969/
http://www.douban.com/people/98087437/
http://www.douban.com/people/98087012/
http://www.douban.com/people/98087071/
http://www.douban.com/people/98086998/
http://www.douban.com/people/98087441/
http://www.douban.com/people/98087097/
http://www.douban.com/people/98086868/
http://www.douban.com/people/98086955/
http://www.douban.com/people/98086876/
http://www.douban.com/people/98086772/
http://www.douban.com/people/98086759/
http://www.douban.com/people/98086747/
http://www.douban.com/people/98086783/
http://www.douban.com/people/98086640/
http://www.douban.com/people/98086916/
http://www.douban.com/people/98086668/
http://www.douban.com/people/98087265/
http://www.douban.com/people/98087618/
http://www.douban.com/people/98086933/
http://www.douban.com/people/98087846/
http://www.douban.com/people/98086614/
http://www.douban.com/people/98087128/
http://www.douban.com/people/98086787/
http://www.douban.com/people/98138799/
http://www.douban.com/people/98086494/
http://www.douban.com/people/98086425/
http://www.douban.com/people/98086703/
http://www.douban.com/people/98087864/
http://www.douban.com/people/98086489/
http://www.douban.com/people/98086514/
http://www.douban.com/people/98086622/
http://www.douban.com/people/98086239/
http://www.douban.com/people/98088826/
http://www.douban.com/people/98086453/
http://www.douban.com/people/98086111/
http://www.douban.com/people/98086437/
http://www.douban.com/people/98086125/
http://www.douban.com/people/98086088/
http://www.douban.com/people/98086131/
http://www.douban.com/people/98086132/
http://www.douban.com/people/98086336/
http://www.douban.com/people/98086071/
http://www.douban.com/people/98086323/
http://www.douban.com/people/98086085/
http://www.douban.com/people/98087431/
http://www.douban.com/people/98086064/
http://www.douban.com/people/98086006/
http://www.douban.com/people/98086770/
http://www.douban.com/people/98086619/
http://www.douban.com/people/98086360/
http://www.douban.com/people/98086411/
http://www.douban.com/people/98085928/
http://www.douban.com/people/98086022/
http://www.douban.com/people/98086389/
http://www.douban.com/people/98087319/
http://www.douban.com/people/98085957/
http://www.douban.com/people/98087544/
http://www.douban.com/people/98086258/
http://www.douban.com/people/98086141/
http://www.douban.com/people/98086337/

douban.com/people/98670491/
douban.com/people/98670500/
douban.com/people/98670479/
douban.com/people/98670494/
douban.com/people/98670499/
douban.com/people/98670839/
douban.com/people/98670511/
douban.com/people/98670488/
douban.com/people/98670483/
douban.com/people/98670498/
douban.com/people/98670832/
douban.com/people/98670842/
douban.com/people/98670826/
douban.com/people/98670508/
douban.com/people/98670838/
douban.com/people/98670505/
douban.com/people/98670503/
douban.com/people/98670849/
douban.com/people/98670820/
douban.com/people/98670850/
douban.com/people/98670857/
douban.com/people/98670851/
douban.com/people/98670844/
douban.com/people/98670856/
douban.com/people/98670855/
douban.com/people/98670478/
douban.com/people/98670843/
douban.com/people/98670506/
douban.com/people/98670863/
douban.com/people/98670880/
douban.com/people/98670873/
douban.com/people/98670860/
douban.com/people/98670885/
douban.com/people/98670861/
douban.com/people/98670891/
douban.com/people/98670887/
douban.com/people/98670853/
douban.com/people/98670852/
douban.com/people/98670874/
douban.com/people/98670903/
douban.com/people/98670871/
douban.com/people/98670889/
douban.com/people/98670902/
douban.com/people/98670906/
douban.com/people/98670884/
douban.com/people/98670913/
douban.com/people/98670899/
douban.com/people/98670916/
douban.com/people/98670915/
douban.com/people/98670898/
douban.com/people/98670927/
douban.com/people/98670908/
douban.com/people/98670931/
douban.com/people/98670934/
douban.com/people/98670942/
douban.com/people/98670920/
douban.com/people/98670914/
douban.com/people/98670925/
douban.com/people/98670945/
douban.com/people/98670922/
douban.com/people/98670944/
douban.com/people/98670930/
douban.com/people/98670933/
douban.com/people/98670952/
douban.com/people/98670941/
douban.com/people/98670967/
douban.com/people/98670974/
douban.com/people/98670968/
douban.com/people/98670972/
douban.com/people/98670953/
douban.com/people/98670960/
douban.com/people/98670963/
douban.com/people/98670981/
douban.com/people/98670970/
douban.com/people/98670961/
douban.com/people/98670980/
douban.com/people/98670990/
douban.com/people/98670984/
douban.com/people/98670991/
douban.com/people/98671010/
douban.com/people/98671000/
douban.com/people/98671001/
douban.com/people/98670977/
douban.com/people/98670996/
douban.com/people/98670997/
douban.com/people/98671020/
douban.com/people/98671022/
douban.com/people/98671028/
douban.com/people/98670998/
douban.com/people/98671038/
douban.com/people/98671034/
douban.com/people/98671033/
douban.com/people/98671012/
douban.com/people/98670979/
douban.com/people/98671016/
douban.com/people/98671045/
douban.com/people/98671019/
douban.com/people/98671030/
douban.com/people/98671053/
douban.com/people/98671047/
douban.com/people/98671055/
douban.com/people/98671046/
douban.com/people/98671023/
douban.com/people/98671050/
douban.com/people/98671054/
douban.com/people/98671065/
douban.com/people/98670988/
douban.com/people/98671064/
douban.com/people/98671068/
douban.com/people/98671056/
douban.com/people/98671062/
douban.com/people/98671067/
douban.com/people/98671071/
douban.com/people/98671153/
douban.com/people/98671158/
douban.com/people/98671155/
douban.com/people/98671083/
douban.com/people/98671159/
douban.com/people/98671081/
douban.com/people/98671074/
douban.com/people/98671061/
douban.com/people/98671167/
douban.com/people/98671185/
douban.com/people/98671187/
douban.com/people/98671176/
douban.com/people/98671073/
douban.com/people/98671025/
douban.com/people/98671188/
douban.com/people/98671193/
douban.com/people/98671180/
douban.com/people/98671174/
douban.com/people/98671182/
douban.com/people/98671177/
douban.com/people/98671198/
douban.com/people/98671203/
douban.com/people/98671191/
douban.com/people/98671075/
douban.com/people/98671206/
douban.com/people/98671195/
douban.com/people/98671063/
douban.com/people/98671202/
douban.com/people/98671181/
douban.com/people/98671221/
douban.com/people/98671224/
douban.com/people/98671163/
douban.com/people/98671228/
douban.com/people/98671326/
douban.com/people/98671211/
douban.com/people/98671220/
douban.com/people/98671213/
douban.com/people/98671323/
douban.com/people/98671340/
douban.com/people/98671333/
douban.com/people/98671330/
douban.com/people/98671212/
douban.com/people/98671324/
douban.com/people/98671226/
douban.com/people/98671218/
douban.com/people/98671343/
douban.com/people/98671233/
douban.com/people/98671332/
douban.com/people/98671230/
douban.com/people/98671344/
douban.com/people/98671352/
douban.com/people/98671338/
douban.com/people/98671351/
douban.com/people/98671364/
douban.com/people/98671379/
douban.com/people/98671365/
douban.com/people/98671354/
douban.com/people/98671362/
douban.com/people/98671380/
douban.com/people/98671382/
douban.com/people/98671377/
douban.com/people/98671373/
douban.com/people/98671385/
douban.com/people/98671393/
douban.com/people/98671406/
douban.com/people/98671402/
douban.com/people/98671390/
douban.com/people/98671368/
douban.com/people/98671349/
douban.com/people/98671408/
douban.com/people/98671395/
douban.com/people/98671405/
douban.com/people/98671412/
douban.com/people/98671087/
douban.com/people/98671084/
douban.com/people/98671388/
douban.com/people/98671400/
douban.com/people/98671091/
douban.com/people/98671099/
douban.com/people/98671092/
douban.com/people/98671085/
douban.com/people/98671358/
douban.com/people/98671336/
douban.com/people/98671107/
douban.com/people/98671109/
douban.com/people/98671100/
douban.com/people/98671089/
douban.com/people/98671359/
douban.com/people/98671119/
douban.com/people/98671122/
douban.com/people/98671105/
douban.com/people/98671115/
douban.com/people/98671114/
douban.com/people/98671116/
douban.com/people/98671124/
douban.com/people/98671136/
douban.com/people/98671133/
douban.com/people/98671094/
douban.com/people/98671108/
douban.com/people/98671139/
douban.com/people/98671093/
douban.com/people/98671110/
douban.com/people/98671234/
douban.com/people/98671128/
douban.com/people/98671146/
douban.com/people/98671127/
douban.com/people/98671149/
douban.com/people/98671245/
douban.com/people/98671152/
douban.com/people/98671265/
douban.com/people/98671237/
douban.com/people/98671283/
douban.com/people/98671256/
douban.com/people/98671316/
douban.com/people/98671294/
douban.com/people/98671318/
douban.com/people/98671302/
douban.com/people/98671249/
douban.com/people/98671272/
douban.com/people/98671420/
douban.com/people/98671421/
douban.com/people/98671288/