mysql> select
        keyword0_.id as col_0_0_,
        keyword0_.content as col_1_0_,
        keyword0_.type as col_2_0_,
        keyword0_.alarm_level as col_3_0_,
        keyword0_.state as col_4_0_,
        (select
            user1_.name 
        from
            tbl_user user1_ 
        where
            keyword0_.create_user_id=user1_.user_id) as col_5_0_,
        keyword0_.create_time as col_6_0_,
        keyword0_.home_url as col_7_0_,
        (select
            keyword2_.content
        from
            tbl_keyword keyword2_ 
        where
            keyword0_.alarm_level=keyword2_.id 
            and keyword0_.state=keyword2_.state 
            ) as col_8_0_ 
    from
        tbl_keyword keyword0_ 
    where
        keyword0_.state='normal' 
        and keyword0_.type='问题分类子类' and keyword0_.content is not null
    order by
        keyword0_.id desc limit 20;
+----------+--------------+--------------+----------+----------+----------+---------------------+----------+----------+
| col_0_0_ | col_1_0_     | col_2_0_     | col_3_0_ | col_4_0_ | col_5_0_ | col_6_0_            | col_7_0_ | col_8_0_ |
+----------+--------------+--------------+----------+----------+----------+---------------------+----------+----------+
|      283 | dddd         | 问题分类子类 | 116      | normal   | apr-o    | 2012-02-15 09:44:10 |          | 光网升速 |
|      282 | 7.7          | 问题分类子类 | 280      | normal   | apr-o    | 2012-02-14 17:07:44 |          | NULL     |
|      281 | 2.14         | 问题分类子类 | 280      | normal   | apr-o    | 2012-02-14 17:07:36 |          | NULL     |
|      277 | 其他         | 问题分类子类 | 119      | normal   | Happy    | 2012-02-13 11:12:59 | NULL     | 3G质量   |
|      276 | 无线上网问题 | 问题分类子类 | 119      | normal   | Happy    | 2012-02-13 11:12:59 | NULL     | 3G质量   |
|      275 | 信号质量     | 问题分类子类 | 119      | normal   | Happy    | 2012-02-13 11:12:59 | NULL     | 3G质量   |
|      274 | IPTV机顶盒   | 问题分类子类 | 118      | normal   | Happy    | 2012-02-13 11:12:59 | NULL     | 电信设备 |
|      273 | 猫           | 问题分类子类 | 118      | normal   | Happy    | 2012-02-13 11:12:59 | NULL     | 电信设备 |
|      272 | 上网卡       | 问题分类子类 | 112      | normal   | Happy    | 2012-02-13 11:12:59 | NULL     | 电信套餐 |
|      271 | 手机         | 问题分类子类 | 118      | normal   | Happy    | 2012-02-13 11:12:59 | NULL     | 电信设备 |
|      270 | 装维人员服务 | 问题分类子类 | 117      | normal   | Happy    | 2012-02-13 11:12:59 | NULL     | 服务质量 |
|      269 | 营业人员服务 | 问题分类子类 | 117      | normal   | Happy    | 2012-02-13 11:12:59 | NULL     | 服务质量 |
|      268 | 其他         | 问题分类子类 | 116      | normal   | Happy    | 2012-02-13 11:12:59 | NULL     | 光网升速 |
|      267 | 升速异议     | 问题分类子类 | 116      | normal   | Happy    | 2012-02-13 11:12:59 | NULL     | 光网升速 |
|      266 | 光纤到户异议 | 问题分类子类 | 116      | normal   | Happy    | 2012-02-13 11:12:59 | NULL     | 光网升速 |
|      265 | 其他         | 问题分类子类 | 115      | normal   | Happy    | 2012-02-13 11:12:59 | NULL     | 宽带质量 |
|      264 | IPTV业务     | 问题分类子类 | 115      | normal   | Happy    | 2012-02-13 11:12:59 | NULL     | 宽带质量 |
|      263 | 断网         | 问题分类子类 | 115      | normal   | Happy    | 2012-02-13 11:12:59 | NULL     | 宽带质量 |
|      262 | 网速不达标   | 问题分类子类 | 115      | normal   | Happy    | 2012-02-13 11:12:59 | NULL     | 宽带质量 |
|      261 | 签约形式异议 | 问题分类子类 | 114      | normal   | Happy    | 2012-02-13 11:12:59 | NULL     | 业务办理 |
+----------+--------------+--------------+----------+----------+----------+---------------------+----------+----------+

mysql> select
        keyword0_.id as col_0_0_,
        keyword0_.content as col_1_0_,
        keyword0