哥见过最长的sql语句

select
        accusation0_.accusation_id as accusation1_2_12_,
        accusation0_.bId as bId2_12_,
        accusation0_.rId as rId2_12_,
        accusation0_.reason as reason2_12_,
        accusation0_.reportId as reportId2_12_,
        accusation0_.report_msg as report4_2_12_,
        accusation0_.state as state2_12_,
        accusation0_.time as time2_12_,
        member1_.member_id as member1_19_0_,
        member1_.attestation as attesta17_19_0_,
        member1_.automatism as automatism19_0_,
        member1_.buyDist as buyDist19_0_,
        member1_.buyIntegral as buyInteg4_19_0_,
        member1_.corner as corner19_0_,
        member1_.email as email19_0_,
        member1_.gender as gender19_0_,
        member1_.grade as grade19_0_,
        member1_.image as image19_0_,
        member1_.leaveMsgAuto as leaveMs18_19_0_,
        member1_.myStores as myStores19_0_,
        member1_.password as password19_0_,
        member1_.realname as realname19_0_,
        member1_.regTime as regTime19_0_,
        member1_.type as type19_0_,
        member1_.username as username19_0_,
        member1_.venderDist as venderDist19_0_,
        member1_.venderIntegral as venderI15_19_0_,
        member1_.visible as visible19_0_,
        attestatio2_.attestation_id as attestat1_5_1_,
        attestatio2_.badness as badness5_1_,
        attestatio2_.card as card5_1_,
        attestatio2_.cardAtte as cardAtte5_1_,
        attestatio2_.deposit as deposit5_1_,
        attestatio2_.depositMoney as depositM6_5_1_,
        attestatio2_.email as email5_1_,
        attestatio2_.emailAtte as emailAtte5_1_,
        attestatio2_.identi as identi5_1_,
        attestatio2_.identityAtte as identit10_5_1_,
        attestatio2_.phone as phone5_1_,
        attestatio2_.phoneAtte as phoneAtte5_1_,
        attestatio2_.service as service5_1_,
        buyerappra3_.bappMember as bappMember14_,
        buyerappra3_.id as id14_,
        buyerappra3_.id as id28_2_,
        buyerappra3_.appMember as appMember28_2_,
        buyerappra3_.bappMember as bappMember28_2_,
        buyerappra3_.buyerOrvender as buyerOrv2_28_2_,
        buyerappra3_.content as content28_2_,
        buyerappra3_.dateTime as dateTime28_2_,
        buyerappra3_.product as product28_2_,
        buyerappra3_.sort as sort28_2_,
        buyerappra3_.tender as tender28_2_,
        buyerorder4_.buyUser as buyUser15_,
        buyerorder4_.id as id15_,
        buyerorder4_.id as id14_3_,
        buyerorder4_.buyUser as buyUser14_3_,
        buyerorder4_.createDate as createDate14_3_,
        buyerorder4_.deliverFee as deliverFee14_3_,
        buyerorder4_.note as note14_3_,
        buyerorder4_.number as number14_3_,
        buyerorder4_.orderDeliverInfo as orderDe13_14_3_,
        buyerorder4_.payablefee as payablefee14_3_,
        buyerorder4_.paymentWay as paymentWay14_3_,
        buyerorder4_.price as price14_3_,
        buyerorder4_.productTotalPrice as productT9_14_3_,
        buyerorder4_.seller as seller14_3_,
        buyerorder4_.state as state14_3_,
        buyerorder4_.tender as tender14_3_,
        buyerorder4_.totalPrice as totalPrice14_3_,
        contactinf5_.member as member16_,
        contactinf5_.contactId as contactId16_,
        contactinf5_.contactId as contactId10_4_,
        contactinf5_.address as address10_4_,
        contactinf5_.area as area10_4_,
        contactinf5_.country as country10_4_,
        contactinf5_.email as email10_4_,
        contactinf5_.member as member10_4_,
        contactinf5_.other as other10_4_,
        contactinf5_.plane as plane10_4_,
        contactinf5_.postalcode as postalcode10_4_,
        contactinf5_.province as province10_4_,
        contactinf5_.qq as qq10_4_,
        contactinf5_.telePhone as telePhone10_4_,
        leavemsgau6_.leaveMsgAuto_id as leaveMsg1_11_5_,
        leavemsgau6_.goodsPrice as goodsPrice11_5_,
        leavemsgau6_.sendDate as sendDate11_5_,
        leavemsgau6_.sendImage as sendImage11_5_,
        leavemsgau6_.sendTitle as sendTitle11_5_,
        messageset7_.member as member17_,
        messageset7_.message_id as message1_17_,
        messageset7_.message_id as message1_29_6_,
        messageset7_.content as content29_6_,
        messageset7_.createtime as createtime29_6_,
        messageset7_.member as member29_6_,
        messageset7_.msgGrade as msgGrade29_6_,
        messageset7_.productInfo as productI6_29_6_,
        storesinfo8_.storesInfo_id as storesInfo1_9_7_,
        storesinfo8_.affiche as affiche9_7_,
        storesinfo8_.integral as integral9_7_,
        storesinfo8_.sellerType as sellerType9_7_,
        storesinfo8_.setup as setup9_7_,
        storesinfo8_.shopName as shopName9_7_,
        storesinfo8_.templet as templet9_7_,
        r_accusati9_.rId as rId18_,
        r_accusati9_.accusation_id as accusation1_18_,
        r_accusati9_.accusation_id as accusation1_2_8_,
        r_accusati9_.bId as bId2_8_,
        r_accusati9_.rId as rId2_8_,
        r_accusati9_.reason as reason2_8_,
        r_accusati9_.reportId as reportId2_8_,
        r_accusati9_.report_msg as report4_2_8_,
        r_accusati9_.state as state2_8_,
        r_accusati9_.time as time2_8_,
        sellerappr10_.appMember as appMember19_,
        sellerappr10_.id as id19_,
        sellerappr10_.id as id28_9_,
        sellerappr10_.appMember as appMember28_9_,
        sellerappr10_.bappMember as bappMember28_9_,
        sellerappr10_.buyerOrvender as buyerOrv2_28_9_,
        sellerappr10_.content as content28_9_,
        sellerappr10_.dateTime as dateTime28_9_,
        sellerappr10_.product as product28_9_,
        sellerappr10_.sort as sort28_9_,
        sellerappr10_.tender as tender28_9_,
        sellerorde11_.seller as seller20_,
        sellerorde11_.id as id20_,
        sellerorde11_.id as id14_10_,
        sellerorde11_.buyUser as buyUser14_10_,
        sellerorde11_.createDate as createDate14_10_,
        sellerorde11_.deliverFee as deliverFee14_10_,
        sellerorde11_.note as note14_10_,
        sellerorde11_.number as number14_10_,
        sellerorde11_.orderDeliverInfo as orderDe13_14_10_,
        sellerorde11_.payablefee as payablefee14_10_,
        sellerorde11_.paymentWay as paymentWay14_10_,
        sellerorde11_.price as price14_10_,
        sellerorde11_.productTotalPrice as productT9_14_10_,
        sellerorde11_.seller as seller14_10_,
        sellerorde11_.state as state14_10_,
        sellerorde11_.tender as tender14_10_,
        sellerorde11_.totalPrice as totalPrice14_10_,
        memberrole12_.bb_memberRole as bb1_27_11_,
        memberrole12_.parent as parent27_11_,
        memberrole12_.typeName as typeName27_11_
    from
        bb_accusation accusation0_
    left outer join
        bb_member member1_
            on accusation0_.bId=member1_.member_id
    left outer join
        bb_attestation attestatio2_
            on member1_.attestation=attestatio2_.attestation_id
    left outer join
        bb_appraise buyerappra3_
            on member1_.member_id=buyerappra3_.bappMember
    left outer join
        bb_order buyerorder4_
            on member1_.member_id=buyerorder4_.buyUser
    left outer join
        bb_contactInfo contactinf5_
            on member1_.member_id=contactinf5_.member
    left outer join
        bb_LeaveMsgAuto leavemsgau6_
            on member1_.leaveMsgAuto=leavemsgau6_.leaveMsgAuto_id
    left outer join
        bb_message messageset7_
            on member1_.member_id=messageset7_.member
    left outer join
        bb_storesInfo storesinfo8_
            on member1_.myStores=storesinfo8_.storesInfo_id
    left outer join
        bb_accusation r_accusati9_
            on member1_.member_id=r_accusati9_.rId
    left outer join
        bb_appraise sellerappr10_
            on member1_.member_id=sellerappr10_.appMember
    left outer join
        bb_order sellerorde11_
            on member1_.member_id=sellerorde11_.seller
    left outer join
        bb_memberRole memberrole12_
            on member1_.type=memberrole12_.bb_memberRole
    where
        accusation0_.accusation_id=?