`

哥见过最长的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=?

分享到:
评论

相关推荐

    sql语句万能生成器,sql语句,sql语句生成

    SQL语句是数据库操作的核心,它用于查询、插入、更新和删除数据,是任何数据库管理系统中的基础工具。在IT行业中,编写SQL语句是一项必备技能,但手动编写和调试SQL语句可能会耗费大量时间和精力,尤其在处理复杂...

    Oracle Sql语句转换成Mysql Sql语句

    当需要将一个基于Oracle SQL的应用程序迁移到MySQL环境时,就需要进行SQL语句的转换工作。本项目提供了一个Java源码工具,能够帮助用户便捷地将Oracle SQL语句转换为MySQL SQL语句。 Oracle SQL与MySQL SQL的主要...

    sql语句说明sql语句说明sql语句说明.zip

    sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明sql语句说明...

    Java打印漂亮的SQL语句(被格式化的SQL语句)

    在Java编程中,调试SQL语句是开发过程中的常见任务,尤其当面对复杂且冗长的查询时。为了提高效率并使SQL语句更易于理解和分析,格式化SQL语句显得尤为重要。标题提及的"Java打印漂亮的SQL语句(被格式化的SQL语句)...

    PB脚本中SQL语句写法与SQL中语句写法对照

    PB脚本中SQL语句写法与SQL中语句写法对照 PB脚本中SQL语句写法与SQL中语句写法对照是非常重要的知识点,因为PB脚本和SQL语言在写法和应用中有所不同。本文将对PB脚本中SQL语句写法和SQL中语句写法进行对比和分析。 ...

    sql语句sql语句sql语句sql语句.txt

    sql语句sql语句sql语句sql语句sql语句

    sql语句范例 全面掌握SQL语句

    全面掌握SQL语句 详细的SQL语句介绍 详细的SQL语句介绍 详细的SQL语句介绍 详细的SQL语句介绍

    完成超长SQL语句执行前拆分

    在使用Visual Basic (简称VB)进行数据库操作时,可能会遇到因为SQL语句过长而导致无法正常执行的问题。这种情况下,即使该SQL语句可以在SQL Server的查询分析器中成功运行,但在VB程序中却会因为长度限制而失败。...

    oracle监听执行sql语句

    其中`v$session`包含了所有活动会话的信息,而`v$sqlarea`则存储了最近执行过的SQL语句的元数据。通过`a.sql_address = b.address`这个条件,可以将两者关联起来,进而得到每个会话正在执行的具体SQL语句。 2. **按...

    非常好用的SQL Server 抓取SQL语句工具HOOK

    非常好用的SQL Server 抓取SQL语句工具HOOK 非常好用的SQL Server 抓取SQL语句工具HOOK 非常好用的SQL Server 抓取SQL语句工具HOOK 非常好用的SQL Server 抓取SQL语句工具HOOK

    SQL 执行超长语句

    ### SQL执行超长语句详解 在数据库管理与开发过程中,编写SQL语句是必不可少的一环。有时,我们可能会遇到需要执行非常长的SQL语句的情况。这些超长语句可能由于包含大量的条件、子查询或是数据量较大等原因而变得...

    查看LINQ生成SQL语句的几种方法

    在实际开发中,有时我们需要了解LINQ查询是如何转换为SQL语句的,以便于调试和优化性能。以下将详细介绍几种查看LINQ生成SQL语句的方法。 1. **Debug.WriteLine()** 在使用LINQ查询时,可以利用`Debug.WriteLine()...

    SQL语句最优化

    SQL语句最优化SQL语句最优化SQL语句最优化SQL语句最优化

    arcgis中的sql语句

    ### ArcGIS中的SQL语句详解 #### 一、SQL在ArcGIS中的角色与应用 SQL,全称为Structured Query Language,即结构化查询语言,是专为数据库设计的一种标准语言,用于管理和操作数据库中的数据。在ArcGIS环境中,SQL...

    存储过程中怎么动态执行sql语句

    ### 动态执行SQL语句在Oracle中的应用 #### 标题解读 “存储过程中怎么动态执行SQL语句”这一标题表明文章将介绍如何在Oracle数据库的存储过程中编写能够动态执行的SQL语句。动态SQL是指在运行时才能确定其具体内容...

    动态拼接sql语句工具类,拼接where后面语句

    动态拼接sql语句工具类,拼接where后面语句 配合原生jdbc仿动态sql注入 if (ObjectUtil.isNotEmpty(maxLat)&&ObjectUtil.isNotEmpty(minLat)){ sqlParamList.add(new SqlParam("lat",minLat, SqlOpEnum.GE)); ...

    sql经典语句,汇集常见的sql语句

    sql经典语句,汇集常见的sql语句。 sql经典语句,汇集常见的sql语句。 sql经典语句,汇集常见的sql语句。

    XML查询语句转换成SQL语句的实现.pdf

    XML 查询语句转换成 SQL 语句的实现 本文主要讨论将 XML 查询语句转换成 SQL 语句的实现。XML 已经成为 Internet 上数据交换的事实标准,特别是在 Web 数据挖掘技术中,对数据源的结构化需求导致人们对 XML 文档的...

    泛微系统SQL语句大全

    SQL的聚合函数如`COUNT`、`AVG`、`MIN`、`MAX`可用来计算完成任务的数量、平均处理时间、最短和最长耗时等,进而进行排名。 4. **自定义需求SQL**: - 自定义需求可能涵盖各种特定场景,如报表生成、数据统计、...

Global site tag (gtag.js) - Google Analytics