SQL

    select
        heeltender0_.heeltender_id as heeltender1_7_36_,
        heeltender0_.note as note7_36_,
        heeltender0_.number as number7_36_,
        heeltender0_.productColor as productC4_7_36_,
        heeltender0_.tender as tender7_36_,
        tender1_.tender_id as tender1_20_0_,
        tender1_.addpens as addpens20_0_,
        tender1_.avaiTime as avaiTime20_0_,
        tender1_.biaoNo as biaoNo20_0_,
        tender1_.checkDate as checkDate20_0_,
        tender1_.clickNum as clickNum20_0_,
        tender1_.date as date20_0_,
        tender1_.defaultImg as defaultImg20_0_,
        tender1_.deliveWay as deliveWay20_0_,
        tender1_.endDate as endDate20_0_,
        tender1_.endvale as endvale20_0_,
        tender1_.heelNum as heelNum20_0_,
        tender1_.note as note20_0_,
        tender1_.num as num20_0_,
        tender1_.peopleNum as peopleNum20_0_,
        tender1_.productColor as product16_20_0_,
        tender1_.quality as quality20_0_,
        tender1_.state as state20_0_,
        tender1_.title as title20_0_,
        tender1_.tname as tname20_0_,
        tender1_.type as type20_0_,
        tender1_.vale as vale20_0_,
        appraise2_.tender as tender38_,
        appraise2_.id as id38_,
        appraise2_.id as id28_1_,
        appraise2_.appMember as appMember28_1_,
        appraise2_.bappMember as bappMember28_1_,
        appraise2_.buyerOrvender as buyerOrv2_28_1_,
        appraise2_.content as content28_1_,
        appraise2_.dateTime as dateTime28_1_,
        appraise2_.product as product28_1_,
        appraise2_.sort as sort28_1_,
        appraise2_.tender as tender28_1_,
        member3_.member_id as member1_19_2_,
        member3_.attestation as attesta17_19_2_,
        member3_.automatism as automatism19_2_,
        member3_.buyDist as buyDist19_2_,
        member3_.buyIntegral as buyInteg4_19_2_,
        member3_.corner as corner19_2_,
        member3_.email as email19_2_,
        member3_.gender as gender19_2_,
        member3_.grade as grade19_2_,
        member3_.image as image19_2_,
        member3_.leaveWordInfo as leaveWo18_19_2_,
        member3_.myStores as myStores19_2_,
        member3_.password as password19_2_,
        member3_.realname as realname19_2_,
        member3_.regTime as regTime19_2_,
        member3_.type as type19_2_,
        member3_.username as username19_2_,
        member3_.venderDist as venderDist19_2_,
        member3_.venderIntegral as venderI15_19_2_,
        member3_.visible as visible19_2_,
        attestatio4_.attestation_id as attestat1_5_3_,
        attestatio4_.badness as badness5_3_,
        attestatio4_.card as card5_3_,
        attestatio4_.cardAtte as cardAtte5_3_,
        attestatio4_.deposit as deposit5_3_,
        attestatio4_.depositMoney as depositM6_5_3_,
        attestatio4_.email as email5_3_,
        attestatio4_.emailAtte as emailAtte5_3_,
        attestatio4_.identi as identi5_3_,
        attestatio4_.identityAtte as identit10_5_3_,
        attestatio4_.phone as phone5_3_,
        attestatio4_.phoneAtte as phoneAtte5_3_,
        attestatio4_.service as service5_3_,
        b_accusati5_.bId as bId39_,
        b_accusati5_.accusation_id as accusation1_39_,
        b_accusati5_.accusation_id as accusation1_2_4_,
        b_accusati5_.bId as bId2_4_,
        b_accusati5_.rId as rId2_4_,
        b_accusati5_.reason as reason2_4_,
        b_accusati5_.reportId as reportId2_4_,
        b_accusati5_.reportMsg as reportMsg2_4_,
        b_accusati5_.state as state2_4_,
        b_accusati5_.time as time2_4_,
        member6_.member_id as member1_19_5_,
        member6_.attestation as attesta17_19_5_,
        member6_.automatism as automatism19_5_,
        member6_.buyDist as buyDist19_5_,
        member6_.buyIntegral as buyInteg4_19_5_,
        member6_.corner as corner19_5_,
        member6_.email as email19_5_,
        member6_.gender as gender19_5_,
        member6_.grade as grade19_5_,
        member6_.image as image19_5_,
        member6_.leaveWordInfo as leaveWo18_19_5_,
        member6_.myStores as myStores19_5_,
        member6_.password as password19_5_,
        member6_.realname as realname19_5_,
        member6_.regTime as regTime19_5_,
        member6_.type as type19_5_,
        member6_.username as username19_5_,
        member6_.venderDist as venderDist19_5_,
        member6_.venderIntegral as venderI15_19_5_,
        member6_.visible as visible19_5_,
        buyerappra7_.bappMember as bappMember40_,
        buyerappra7_.id as id40_,
        buyerappra7_.id as id28_6_,
        buyerappra7_.appMember as appMember28_6_,
        buyerappra7_.bappMember as bappMember28_6_,
        buyerappra7_.buyerOrvender as buyerOrv2_28_6_,
        buyerappra7_.content as content28_6_,
        buyerappra7_.dateTime as dateTime28_6_,
        buyerappra7_.product as product28_6_,
        buyerappra7_.sort as sort28_6_,
        buyerappra7_.tender as tender28_6_,
        productinf8_.productInfo_id as productI1_1_7_,
        productinf8_.clickcount as clickcount1_7_,
        productinf8_.color as color1_7_,
        productinf8_.commend as commend1_7_,
        productinf8_.createdate as createdate1_7_,
        productinf8_.effectdate as effectdate1_7_,
        productinf8_.orderId as orderId1_7_,
        productinf8_.productBrand as productB7_1_7_,
        productinf8_.productBuyexplain as productB8_1_7_,
        productinf8_.productCorner as productC9_1_7_,
        productinf8_.productDefaultImg as product10_1_7_,
        productinf8_.productDescription as product11_1_7_,
        productinf8_.productDriwayBy as product12_1_7_,
        productinf8_.productDriwayPrice as product13_1_7_,
        productinf8_.productGuarantee as product14_1_7_,
        productinf8_.productHasInvoice as product15_1_7_,
        productinf8_.productMarketPrice as product16_1_7_,
        productinf8_.productModel as product17_1_7_,
        productinf8_.productName as product18_1_7_,
        productinf8_.productNo as productNo1_7_,
        productinf8_.productQuality as product20_1_7_,
        productinf8_.productSellPrice as product21_1_7_,
        productinf8_.productVisible as product22_1_7_,
        productinf8_.productWeight as product23_1_7_,
        productinf8_.sellCount as sellCount1_7_,
        productinf8_.shopp as shopp1_7_,
        productinf8_.storeCount as storeCount1_7_,
        productinf8_.type as type1_7_,
        advertisem9_.product as product41_,
        advertisem9_.advertisement_id as advertis1_41_,
        advertisem9_.advertisement_id as advertis1_17_8_,
        advertisem9_.adverId as adverId17_8_,
        advertisem9_.beginTime as beginTime17_8_,
        advertisem9_.clickCount as clickCount17_8_,
        advertisem9_.endTime as endTime17_8_,
        advertisem9_.locality_locality_id as locality6_17_8_,
        advertisem9_.placardTypeId as placardT7_17_8_,
        advertisem9_.product as product17_8_,
        locality10_.locality_id as locality1_4_9_,
        locality10_.advertisement_advertisement_id as advertis3_4_9_,
        locality10_.urlname as urlname4_9_,
        advertisem11_.advertisement_id as advertis1_17_10_,
        advertisem11_.adverId as adverId17_10_,
        advertisem11_.beginTime as beginTime17_10_,
        advertisem11_.clickCount as clickCount17_10_,
        advertisem11_.endTime as endTime17_10_,
        advertisem11_.locality_locality_id as locality6_17_10_,
        advertisem11_.placardTypeId as placardT7_17_10_,
        advertisem11_.product as product17_10_,
        placardtyp12_.id as id21_11_,
        placardtyp12_.type as type21_11_,
        apendix13_.product as product42_,
        apendix13_.appendix_id as appendix1_42_,
        apendix13_.appendix_id as appendix1_13_12_,
        apendix13_.name as name13_12_,
        apendix13_.number as number13_12_,
        apendix13_.product as product13_12_,
        messageset14_.productInfo as productI6_43_,
        messageset14_.message_id as message1_43_,
        messageset14_.message_id as message1_29_13_,
        messageset14_.content as content29_13_,
        messageset14_.createtime as createtime29_13_,
        messageset14_.member as member29_13_,
        messageset14_.msgGrade as msgGrade29_13_,
        messageset14_.productInfo as productI6_29_13_,
        member15_.member_id as member1_19_14_,
        member15_.attestation as attesta17_19_14_,
        member15_.automatism as automatism19_14_,
        member15_.buyDist as buyDist19_14_,
        member15_.buyIntegral as buyInteg4_19_14_,
        member15_.corner as corner19_14_,
        member15_.email as email19_14_,
        member15_.gender as gender19_14_,
        member15_.grade as grade19_14_,
        member15_.image as image19_14_,
        member15_.leaveWordInfo as leaveWo18_19_14_,
        member15_.myStores as myStores19_14_,
        member15_.password as password19_14_,
        member15_.realname as realname19_14_,
        member15_.regTime as regTime19_14_,
        member15_.type as type19_14_,
        member15_.username as username19_14_,
        member15_.venderDist as venderDist19_14_,
        member15_.venderIntegral as venderI15_19_14_,
        member15_.visible as visible19_14_,
        buyerorder16_.buyUser as buyUser44_,
        buyerorder16_.id as id44_,
        buyerorder16_.id as id14_15_,
        buyerorder16_.buyUser as buyUser14_15_,
        buyerorder16_.createDate as createDate14_15_,
        buyerorder16_.deliverFee as deliverFee14_15_,
        buyerorder16_.note as note14_15_,
        buyerorder16_.number as number14_15_,
        buyerorder16_.orderDeliverInfo as orderDe13_14_15_,
        buyerorder16_.payablefee as payablefee14_15_,
        buyerorder16_.paymentWay as paymentWay14_15_,
        buyerorder16_.price as price14_15_,
        buyerorder16_.productTotalPrice as productT9_14_15_,
        buyerorder16_.seller as seller14_15_,
        buyerorder16_.state as state14_15_,
        buyerorder16_.tender as tender14_15_,
        buyerorder16_.totalPrice as totalPrice14_15_,
        orderdeliv17_.deliverid as deliverid25_16_,
        orderdeliv17_.address as address25_16_,
        orderdeliv17_.city as city25_16_,
        orderdeliv17_.country as country25_16_,
        orderdeliv17_.deliverWay as deliverWay25_16_,
        orderdeliv17_.email as email25_16_,
        orderdeliv17_.mobile as mobile25_16_,
        orderdeliv17_.plane as plane25_16_,
        orderdeliv17_.postalcode as postalcode25_16_,
        orderdeliv17_.province as province25_16_,
        orderdeliv17_.recipients as recipients25_16_,
        orderdeliv17_.requirement as require12_25_16_,
        orderdeliv17_.sex as sex25_16_,
        orderdeliv17_.tender as tender25_16_,
        tender18_.tender_id as tender1_20_17_,
        tender18_.addpens as addpens20_17_,
        tender18_.avaiTime as avaiTime20_17_,
        tender18_.biaoNo as biaoNo20_17_,
        tender18_.checkDate as checkDate20_17_,
        tender18_.clickNum as clickNum20_17_,
        tender18_.date as date20_17_,
        tender18_.defaultImg as defaultImg20_17_,
        tender18_.deliveWay as deliveWay20_17_,
        tender18_.endDate as endDate20_17_,
        tender18_.endvale as endvale20_17_,
        tender18_.heelNum as heelNum20_17_,
        tender18_.note as note20_17_,
        tender18_.num as num20_17_,
        tender18_.peopleNum as peopleNum20_17_,
        tender18_.productColor as product16_20_17_,
        tender18_.quality as quality20_17_,
        tender18_.state as state20_17_,
        tender18_.title as title20_17_,
        tender18_.tname as tname20_17_,
        tender18_.type as type20_17_,
        tender18_.vale as vale20_17_,
        images19_.tender as tender45_,
        images19_.tenderimages_id as tenderim1_45_,
        images19_.tenderimages_id as tenderim1_24_18_,
        images19_.filepath as filepath24_18_,
        images19_.tender as tender24_18_,
        images19_.uploadtime as uploadtime24_18_,
        producttyp20_.producttype_id as productt1_3_19_,
        producttyp20_.parent as parent3_19_,
        producttyp20_.parentIs as parentIs3_19_,
        producttyp20_.tname as tname3_19_,
        producttyp20_.visible as visible3_19_,
        brandsset21_.type as type46_,
        brandsset21_.brand_id as brand1_46_,
        brandsset21_.brand_id as brand1_22_20_,
        brandsset21_.name as name22_20_,
        brandsset21_.parent as parent22_20_,
        brandsset21_.type as type22_20_,
        model22_.parent as parent47_,
        model22_.brand_id as brand1_47_,
        model22_.brand_id as brand1_22_21_,
        model22_.name as name22_21_,
        model22_.parent as parent22_21_,
        model22_.type as type22_21_,
        childtypes23_.parent as parent48_,
        childtypes23_.producttype_id as productt1_48_,
        childtypes23_.producttype_id as productt1_3_22_,
        childtypes23_.parent as parent3_22_,
        childtypes23_.parentIs as parentIs3_22_,
        childtypes23_.tname as tname3_22_,
        childtypes23_.visible as visible3_22_,
        productinf24_.type as type49_,
        productinf24_.productInfo_id as productI1_49_,
        productinf24_.productInfo_id as productI1_1_23_,
        productinf24_.clickcount as clickcount1_23_,
        productinf24_.color as color1_23_,
        productinf24_.commend as commend1_23_,
        productinf24_.createdate as createdate1_23_,
        productinf24_.effectdate as effectdate1_23_,
        productinf24_.orderId as orderId1_23_,
        productinf24_.productBrand as productB7_1_23_,
        productinf24_.productBuyexplain as productB8_1_23_,
        productinf24_.productCorner as productC9_1_23_,
        productinf24_.productDefaultImg as product10_1_23_,
        productinf24_.productDescription as product11_1_23_,
        productinf24_.productDriwayBy as product12_1_23_,
        productinf24_.productDriwayPrice as product13_1_23_,
        productinf24_.productGuarantee as product14_1_23_,
        productinf24_.productHasInvoice as product15_1_23_,
        productinf24_.productMarketPrice as product16_1_23_,
        productinf24_.productModel as product17_1_23_,
        productinf24_.productName as product18_1_23_,
        productinf24_.productNo as productNo1_23_,
        productinf24_.productQuality as product20_1_23_,
        productinf24_.productSellPrice as product21_1_23_,
        productinf24_.productVisible as product22_1_23_,
        productinf24_.productWeight as product23_1_23_,
        productinf24_.sellCount as sellCount1_23_,
        productinf24_.shopp as shopp1_23_,
        productinf24_.storeCount as storeCount1_23_,
        productinf24_.type as type1_23_,
        order25_.id as id14_24_,
        order25_.buyUser as buyUser14_24_,
        order25_.createDate as createDate14_24_,
        order25_.deliverFee as deliverFee14_24_,
        order25_.note as note14_24_,
        order25_.number as number14_24_,
        order25_.orderDeliverInfo as orderDe13_14_24_,
        order25_.payablefee as payablefee14_24_,
        order25_.paymentWay as paymentWay14_24_,
        order25_.price as price14_24_,
        order25_.productTotalPrice as productT9_14_24_,
        order25_.seller as seller14_24_,
        order25_.state as state14_24_,
        order25_.tender as tender14_24_,
        order25_.totalPrice as totalPrice14_24_,
        member26_.member_id as member1_19_25_,
        member26_.attestation as attesta17_19_25_,
        member26_.automatism as automatism19_25_,
        member26_.buyDist as buyDist19_25_,
        member26_.buyIntegral as buyInteg4_19_25_,
        member26_.corner as corner19_25_,
        member26_.email as email19_25_,
        member26_.gender as gender19_25_,
        member26_.grade as grade19_25_,
        member26_.image as image19_25_,
        member26_.leaveWordInfo as leaveWo18_19_25_,
        member26_.myStores as myStores19_25_,
        member26_.password as password19_25_,
        member26_.realname as realname19_25_,
        member26_.regTime as regTime19_25_,
        member26_.type as type19_25_,
        member26_.username as username19_25_,
        member26_.venderDist as venderDist19_25_,
        member26_.venderIntegral as venderI15_19_25_,
        member26_.visible as visible19_25_,
        contactinf27_.member as member50_,
        contactinf27_.contactId as contactId50_,
        contactinf27_.contactId as contactId10_26_,
        contactinf27_.address as address10_26_,
        contactinf27_.area as area10_26_,
        contactinf27_.country as country10_26_,
        contactinf27_.email as email10_26_,
        contactinf27_.member as member10_26_,
        contactinf27_.other as other10_26_,
        contactinf27_.plane as plane10_26_,
        contactinf27_.postalcode as postalcode10_26_,
        contactinf27_.province as province10_26_,
        contactinf27_.qq as qq10_26_,
        contactinf27_.telePhone as telePhone10_26_,
        leavemsgau28_.leaveMsgAuto_id as leaveMsg1_11_27_,
        leavemsgau28_.goodsPrice as goodsPrice11_27_,
        leavemsgau28_.sendDate as sendDate11_27_,
        leavemsgau28_.sendImage as sendImage11_27_,
        leavemsgau28_.sendTitle as sendTitle11_27_,
        storesinfo29_.storesInfo_id as storesInfo1_9_28_,
        storesinfo29_.affiche as affiche9_28_,
        storesinfo29_.integral as integral9_28_,
        storesinfo29_.sellerType as sellerType9_28_,
        storesinfo29_.setup as setup9_28_,
        storesinfo29_.shopName as shopName9_28_,
        storesinfo29_.templet as templet9_28_,
        productset30_.shopp as shopp51_,
        productset30_.productInfo_id as productI1_51_,
        productset30_.productInfo_id as productI1_1_29_,
        productset30_.clickcount as clickcount1_29_,
        productset30_.color as color1_29_,
        productset30_.commend as commend1_29_,
        productset30_.createdate as createdate1_29_,
        productset30_.effectdate as effectdate1_29_,
        productset30_.orderId as orderId1_29_,
        productset30_.productBrand as productB7_1_29_,
        productset30_.productBuyexplain as productB8_1_29_,
        productset30_.productCorner as productC9_1_29_,
        productset30_.productDefaultImg as product10_1_29_,
        productset30_.productDescription as product11_1_29_,
        productset30_.productDriwayBy as product12_1_29_,
        productset30_.productDriwayPrice as product13_1_29_,
        productset30_.productGuarantee as product14_1_29_,
        productset30_.productHasInvoice as product15_1_29_,
        productset30_.productMarketPrice as product16_1_29_,
        productset30_.productModel as product17_1_29_,
        productset30_.productName as product18_1_29_,
        productset30_.productNo as productNo1_29_,
        productset30_.productQuality as product20_1_29_,
        productset30_.productSellPrice as product21_1_29_,
        productset30_.productVisible as product22_1_29_,
        productset30_.productWeight as product23_1_29_,
        productset30_.sellCount as sellCount1_29_,
        productset30_.shopp as shopp1_29_,
        productset30_.storeCount as storeCount1_29_,
        productset30_.type as type1_29_,
        productima31_.product as product52_,
        productima31_.images_id as images1_52_,
        productima31_.images_id as images1_26_30_,
        productima31_.filepath as filepath26_30_,
        productima31_.product as product26_30_,
        productima31_.uploadtime as uploadtime26_30_,
        productsor32_.storesInfo as storesInfo53_,
        productsor32_.productsort_id as products1_53_,
        productsor32_.productsort_id as products1_30_31_,
        productsor32_.name as name30_31_,
        productsor32_.storesInfo as storesInfo30_31_,
        templet33_.templet_id as templet1_16_32_,
        templet33_.name as name16_32_,
        memberrole34_.bb_memberRole as bb1_27_33_,
        memberrole34_.parent as parent27_33_,
        memberrole34_.typeName as typeName27_33_,
        children35_.parent as parent54_,
        children35_.bb_memberRole as bb1_54_,
        children35_.bb_memberRole as bb1_27_34_,
        children35_.parent as parent27_34_,
        children35_.typeName as typeName27_34_,
        tender36_.tender_id as tender1_20_35_,
        tender36_.addpens as addpens20_35_,
        tender36_.avaiTime as avaiTime20_35_,
        tender36_.biaoNo as biaoNo20_35_,
        tender36_.checkDate as checkDate20_35_,
        tender36_.clickNum as clickNum20_35_,
        tender36_.date as date20_35_,
        tender36_.defaultImg as defaultImg20_35_,
        tender36_.deliveWay as deliveWay20_35_,
        tender36_.endDate as endDate20_35_,
        tender36_.endvale as endvale20_35_,
        tender36_.heelNum as heelNum20_35_,
        tender36_.note as note20_35_,
        tender36_.num as num20_35_,
        tender36_.peopleNum as peopleNum20_35_,
        tender36_.productColor as product16_20_35_,
        tender36_.quality as quality20_35_,
        tender36_.state as state20_35_,
        tender36_.title as title20_35_,
        tender36_.tname as tname20_35_,
        tender36_.type as type20_35_,
        tender36_.vale as vale20_35_
    from
        bb_healTender heeltender0_
    left outer join
        bb_tender tender1_
            on heeltender0_.tender=tender1_.tender_id
    left outer join
        bb_appraise appraise2_
            on tender1_.tender_id=appraise2_.tender
    left outer join
        bb_member member3_
            on appraise2_.appMember=member3_.member_id
    left outer join
        bb_attestation attestatio4_
            on member3_.attestation=attestatio4_.attestation_id
    left outer join
        bb_accusation b_accusati5_
            on member3_.member_id=b_accusati5_.bId
    left outer join
        bb_member member6_
            on b_accusati5_.rId=member6_.member_id
    left outer join
        bb_appraise buyerappra7_
            on member6_.member_id=buyerappra7_.bappMember
    left outer join
        bb_productInfo productinf8_
            on buyerappra7_.product=productinf8_.productInfo_id
    left outer join
        bb_advertisement advertisem9_
            on productinf8_.productInfo_id=advertisem9_.product
    left outer join
        bb_locality locality10_
            on advertisem9_.locality_locality_id=locality10_.locality_id
    left outer join
        bb_advertisement advertisem11_
            on locality10_.advertisement_advertisement_id=advertisem11_.advertisement_id
    left outer join
        bb_placardType placardtyp12_
            on advertisem11_.placardTypeId=placardtyp12_.id
    left outer join
        bb_appendix apendix13_
            on productinf8_.productInfo_id=apendix13_.product
    left outer join
        bb_message messageset14_
            on productinf8_.productInfo_id=messageset14_.productInfo
    left outer join
        bb_member member15_
            on messageset14_.member=member15_.member_id
    left outer join
        bb_order buyerorder16_
            on member15_.member_id=buyerorder16_.buyUser
    left outer join
        bb_orderDeliverInfo orderdeliv17_
            on buyerorder16_.orderDeliverInfo=orderdeliv17_.deliverid
    left outer join
        bb_tender tender18_
            on orderdeliv17_.tender=tender18_.tender_id
    left outer join
        bb_tenderImages images19_
            on tender18_.tender_id=images19_.tender
    left outer join
        bb_productType producttyp20_
            on tender18_.type=producttyp20_.producttype_id
    left outer join
        bb_brand brandsset21_
            on producttyp20_.producttype_id=brandsset21_.type
    left outer join
        bb_brand model22_
            on brandsset21_.brand_id=model22_.parent
    left outer join
        bb_productType childtypes23_
            on producttyp20_.producttype_id=childtypes23_.parent
    left outer join
        bb_productInfo productinf24_
            on childtypes23_.producttype_id=productinf24_.type
    left outer join
        bb_order order25_
            on productinf24_.orderId=order25_.id
    left outer join
        bb_member member26_
            on order25_.seller=member26_.member_id
    left outer join
        bb_contactInfo contactinf27_
            on member26_.member_id=contactinf27_.member
    left outer join
        bb_LeaveMsgAuto leavemsgau28_
            on member26_.leaveWordInfo=leavemsgau28_.leaveMsgAuto_id
    left outer join
        bb_storesInfo storesinfo29_
            on member26_.myStores=storesinfo29_.storesInfo_id
    left outer join
        bb_productInfo productset30_
            on storesinfo29_.storesInfo_id=productset30_.shopp
    left outer join
        bb_images productima31_
            on productset30_.productInfo_id=productima31_.product
    left outer join
        bb_productSort productsor32_
            on storesinfo29_.storesInfo_id=productsor32_.storesInfo
    left outer join
        bb_templet templet33_
            on storesinfo29_.templet=templet33_.templet_id
    left outer join
        bb_memberRole memberrole34_
            on member26_.type=memberrole34_.bb_memberRole
    left outer join
        bb_memberRole children35_
            on memberrole34_.bb_memberRole=children35_.parent
    left outer join
        bb_tender tender36_
            on order25_.tender=tender36_.tender_id
    where
        heeltender0_.heeltender_id=?