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=?