class io.ebeaninternal.server.query.CQueryBuilderRawSql
  minor version: 0
  major version: 59
  flags: flags: (0x0020) ACC_SUPER
  this_class: io.ebeaninternal.server.query.CQueryBuilderRawSql
  super_class: java.lang.Object
{
  private final io.ebean.config.dbplatform.SqlLimiter sqlLimiter;
    descriptor: Lio/ebean/config/dbplatform/SqlLimiter;
    flags: (0x0012) ACC_PRIVATE, ACC_FINAL

  private final io.ebean.config.dbplatform.DatabasePlatform dbPlatform;
    descriptor: Lio/ebean/config/dbplatform/DatabasePlatform;
    flags: (0x0012) ACC_PRIVATE, ACC_FINAL

  void <init>(io.ebean.config.dbplatform.SqlLimiter, io.ebean.config.dbplatform.DatabasePlatform);
    descriptor: (Lio/ebean/config/dbplatform/SqlLimiter;Lio/ebean/config/dbplatform/DatabasePlatform;)V
    flags: (0x0000) 
    Code:
      stack=2, locals=3, args_size=3
        start local 0 // io.ebeaninternal.server.query.CQueryBuilderRawSql this
        start local 1 // io.ebean.config.dbplatform.SqlLimiter sqlLimiter
        start local 2 // io.ebean.config.dbplatform.DatabasePlatform dbPlatform
         0: .line 19
            aload 0 /* this */
            invokespecial java.lang.Object.<init>:()V
         1: .line 20
            aload 0 /* this */
            aload 1 /* sqlLimiter */
            putfield io.ebeaninternal.server.query.CQueryBuilderRawSql.sqlLimiter:Lio/ebean/config/dbplatform/SqlLimiter;
         2: .line 21
            aload 0 /* this */
            aload 2 /* dbPlatform */
            putfield io.ebeaninternal.server.query.CQueryBuilderRawSql.dbPlatform:Lio/ebean/config/dbplatform/DatabasePlatform;
         3: .line 22
            return
        end local 2 // io.ebean.config.dbplatform.DatabasePlatform dbPlatform
        end local 1 // io.ebean.config.dbplatform.SqlLimiter sqlLimiter
        end local 0 // io.ebeaninternal.server.query.CQueryBuilderRawSql this
      LocalVariableTable:
        Start  End  Slot        Name  Signature
            0    4     0        this  Lio/ebeaninternal/server/query/CQueryBuilderRawSql;
            0    4     1  sqlLimiter  Lio/ebean/config/dbplatform/SqlLimiter;
            0    4     2  dbPlatform  Lio/ebean/config/dbplatform/DatabasePlatform;
    MethodParameters:
            Name  Flags
      sqlLimiter  
      dbPlatform  

  io.ebean.config.dbplatform.SqlLimitResponse buildSql(io.ebeaninternal.server.core.OrmQueryRequest<?>, io.ebeaninternal.server.query.CQueryPredicates, io.ebeaninternal.server.rawsql.SpiRawSql$Sql);
    descriptor: (Lio/ebeaninternal/server/core/OrmQueryRequest;Lio/ebeaninternal/server/query/CQueryPredicates;Lio/ebeaninternal/server/rawsql/SpiRawSql$Sql;)Lio/ebean/config/dbplatform/SqlLimitResponse;
    flags: (0x0000) 
    Code:
      stack=8, locals=8, args_size=4
        start local 0 // io.ebeaninternal.server.query.CQueryBuilderRawSql this
        start local 1 // io.ebeaninternal.server.core.OrmQueryRequest request
        start local 2 // io.ebeaninternal.server.query.CQueryPredicates predicates
        start local 3 // io.ebeaninternal.server.rawsql.SpiRawSql$Sql rsql
         0: .line 29
            aload 3 /* rsql */
            ifnonnull 2
         1: .line 31
            new io.ebean.config.dbplatform.SqlLimitResponse
            dup
            ldc "--ResultSetBasedRawSql"
            invokespecial io.ebean.config.dbplatform.SqlLimitResponse.<init>:(Ljava/lang/String;)V
            areturn
         2: .line 34
      StackMap locals:
      StackMap stack:
            aload 3 /* rsql */
            invokevirtual io.ebeaninternal.server.rawsql.SpiRawSql$Sql.isParsed:()Z
            ifne 8
         3: .line 35
            aload 3 /* rsql */
            invokevirtual io.ebeaninternal.server.rawsql.SpiRawSql$Sql.getUnparsedSql:()Ljava/lang/String;
            astore 4 /* sql */
        start local 4 // java.lang.String sql
         4: .line 36
            aload 1 /* request */
            invokevirtual io.ebeaninternal.server.core.OrmQueryRequest.getQuery:()Lio/ebeaninternal/api/SpiQuery;
            invokeinterface io.ebeaninternal.api.SpiQuery.getBindParams:()Lio/ebeaninternal/api/BindParams;
            astore 5 /* bindParams */
        start local 5 // io.ebeaninternal.api.BindParams bindParams
         5: .line 37
            aload 5 /* bindParams */
            ifnull 7
            aload 5 /* bindParams */
            invokevirtual io.ebeaninternal.api.BindParams.requiresNamedParamsPrepare:()Z
            ifeq 7
         6: .line 39
            aload 5 /* bindParams */
            aload 4 /* sql */
            invokestatic io.ebeaninternal.server.util.BindParamsParser.parse:(Lio/ebeaninternal/api/BindParams;Ljava/lang/String;)Ljava/lang/String;
            astore 4 /* sql */
         7: .line 41
      StackMap locals: java.lang.String io.ebeaninternal.api.BindParams
      StackMap stack:
            new io.ebean.config.dbplatform.SqlLimitResponse
            dup
            aload 4 /* sql */
            invokespecial io.ebean.config.dbplatform.SqlLimitResponse.<init>:(Ljava/lang/String;)V
            areturn
        end local 5 // io.ebeaninternal.api.BindParams bindParams
        end local 4 // java.lang.String sql
         8: .line 44
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            aload 2 /* predicates */
            aload 3 /* rsql */
            invokevirtual io.ebeaninternal.server.query.CQueryBuilderRawSql.getOrderBy:(Lio/ebeaninternal/server/query/CQueryPredicates;Lio/ebeaninternal/server/rawsql/SpiRawSql$Sql;)Ljava/lang/String;
            astore 4 /* orderBy */
        start local 4 // java.lang.String orderBy
         9: .line 47
            aload 0 /* this */
            aload 4 /* orderBy */
            aload 1 /* request */
            aload 2 /* predicates */
            aload 3 /* rsql */
            invokevirtual io.ebeaninternal.server.query.CQueryBuilderRawSql.buildMainQuery:(Ljava/lang/String;Lio/ebeaninternal/server/core/OrmQueryRequest;Lio/ebeaninternal/server/query/CQueryPredicates;Lio/ebeaninternal/server/rawsql/SpiRawSql$Sql;)Ljava/lang/String;
            astore 5 /* sql */
        start local 5 // java.lang.String sql
        10: .line 49
            aload 1 /* request */
            invokevirtual io.ebeaninternal.server.core.OrmQueryRequest.getQuery:()Lio/ebeaninternal/api/SpiQuery;
            astore 6 /* query */
        start local 6 // io.ebeaninternal.api.SpiQuery query
        11: .line 50
            aload 6 /* query */
            invokeinterface io.ebeaninternal.api.SpiQuery.hasMaxRowsOrFirstRow:()Z
            ifeq 16
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilderRawSql.sqlLimiter:Lio/ebean/config/dbplatform/SqlLimiter;
            ifnull 16
        12: .line 52
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilderRawSql.sqlLimiter:Lio/ebean/config/dbplatform/SqlLimiter;
        13: new io.ebeaninternal.server.querydefn.OrmQueryLimitRequest
            dup
            aload 5 /* sql */
            aload 4 /* orderBy */
            aload 6 /* query */
            aload 0 /* this */
            getfield io.ebeaninternal.server.query.CQueryBuilderRawSql.dbPlatform:Lio/ebean/config/dbplatform/DatabasePlatform;
            aload 3 /* rsql */
            invokevirtual io.ebeaninternal.server.rawsql.SpiRawSql$Sql.isDistinct:()Z
            ifne 14
            aload 6 /* query */
            invokeinterface io.ebeaninternal.api.SpiQuery.isDistinct:()Z
            ifne 14
            iconst_0
            goto 15
      StackMap locals: io.ebeaninternal.server.query.CQueryBuilderRawSql io.ebeaninternal.server.core.OrmQueryRequest io.ebeaninternal.server.query.CQueryPredicates io.ebeaninternal.server.rawsql.SpiRawSql$Sql java.lang.String java.lang.String io.ebeaninternal.api.SpiQuery
      StackMap stack: io.ebean.config.dbplatform.SqlLimiter new 13 new 13 java.lang.String java.lang.String io.ebeaninternal.api.SpiQuery io.ebean.config.dbplatform.DatabasePlatform
        14: iconst_1
      StackMap locals: io.ebeaninternal.server.query.CQueryBuilderRawSql io.ebeaninternal.server.core.OrmQueryRequest io.ebeaninternal.server.query.CQueryPredicates io.ebeaninternal.server.rawsql.SpiRawSql$Sql java.lang.String java.lang.String io.ebeaninternal.api.SpiQuery
      StackMap stack: io.ebean.config.dbplatform.SqlLimiter new 13 new 13 java.lang.String java.lang.String io.ebeaninternal.api.SpiQuery io.ebean.config.dbplatform.DatabasePlatform int
        15: invokespecial io.ebeaninternal.server.querydefn.OrmQueryLimitRequest.<init>:(Ljava/lang/String;Ljava/lang/String;Lio/ebeaninternal/api/SpiQuery;Lio/ebean/config/dbplatform/DatabasePlatform;Z)V
            invokeinterface io.ebean.config.dbplatform.SqlLimiter.limit:(Lio/ebean/config/dbplatform/SqlLimitRequest;)Lio/ebean/config/dbplatform/SqlLimitResponse;
            areturn
        16: .line 56
      StackMap locals:
      StackMap stack:
            new java.lang.StringBuilder
            dup
            ldc "select "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 3 /* rsql */
            invokevirtual io.ebeaninternal.server.rawsql.SpiRawSql$Sql.isDistinct:()Z
            ifeq 17
            ldc "distinct "
            goto 18
      StackMap locals:
      StackMap stack: java.lang.StringBuilder
        17: ldc ""
      StackMap locals: io.ebeaninternal.server.query.CQueryBuilderRawSql io.ebeaninternal.server.core.OrmQueryRequest io.ebeaninternal.server.query.CQueryPredicates io.ebeaninternal.server.rawsql.SpiRawSql$Sql java.lang.String java.lang.String io.ebeaninternal.api.SpiQuery
      StackMap stack: java.lang.StringBuilder java.lang.String
        18: invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            astore 7 /* prefix */
        start local 7 // java.lang.String prefix
        19: .line 57
            new java.lang.StringBuilder
            dup
            aload 7 /* prefix */
            invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 5 /* sql */
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            astore 5 /* sql */
        20: .line 58
            new io.ebean.config.dbplatform.SqlLimitResponse
            dup
            aload 5 /* sql */
            invokespecial io.ebean.config.dbplatform.SqlLimitResponse.<init>:(Ljava/lang/String;)V
            areturn
        end local 7 // java.lang.String prefix
        end local 6 // io.ebeaninternal.api.SpiQuery query
        end local 5 // java.lang.String sql
        end local 4 // java.lang.String orderBy
        end local 3 // io.ebeaninternal.server.rawsql.SpiRawSql$Sql rsql
        end local 2 // io.ebeaninternal.server.query.CQueryPredicates predicates
        end local 1 // io.ebeaninternal.server.core.OrmQueryRequest request
        end local 0 // io.ebeaninternal.server.query.CQueryBuilderRawSql this
      LocalVariableTable:
        Start  End  Slot        Name  Signature
            0   21     0        this  Lio/ebeaninternal/server/query/CQueryBuilderRawSql;
            0   21     1     request  Lio/ebeaninternal/server/core/OrmQueryRequest<*>;
            0   21     2  predicates  Lio/ebeaninternal/server/query/CQueryPredicates;
            0   21     3        rsql  Lio/ebeaninternal/server/rawsql/SpiRawSql$Sql;
            4    8     4         sql  Ljava/lang/String;
            5    8     5  bindParams  Lio/ebeaninternal/api/BindParams;
            9   21     4     orderBy  Ljava/lang/String;
           10   21     5         sql  Ljava/lang/String;
           11   21     6       query  Lio/ebeaninternal/api/SpiQuery<*>;
           19   21     7      prefix  Ljava/lang/String;
    Signature: (Lio/ebeaninternal/server/core/OrmQueryRequest<*>;Lio/ebeaninternal/server/query/CQueryPredicates;Lio/ebeaninternal/server/rawsql/SpiRawSql$Sql;)Lio/ebean/config/dbplatform/SqlLimitResponse;
    MethodParameters:
            Name  Flags
      request     
      predicates  
      rsql        

  private java.lang.String buildMainQuery(java.lang.String, io.ebeaninternal.server.core.OrmQueryRequest<?>, io.ebeaninternal.server.query.CQueryPredicates, io.ebeaninternal.server.rawsql.SpiRawSql$Sql);
    descriptor: (Ljava/lang/String;Lio/ebeaninternal/server/core/OrmQueryRequest;Lio/ebeaninternal/server/query/CQueryPredicates;Lio/ebeaninternal/server/rawsql/SpiRawSql$Sql;)Ljava/lang/String;
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=3, locals=12, args_size=5
        start local 0 // io.ebeaninternal.server.query.CQueryBuilderRawSql this
        start local 1 // java.lang.String orderBy
        start local 2 // io.ebeaninternal.server.core.OrmQueryRequest request
        start local 3 // io.ebeaninternal.server.query.CQueryPredicates predicates
        start local 4 // io.ebeaninternal.server.rawsql.SpiRawSql$Sql sql
         0: .line 64
            new java.lang.StringBuilder
            dup
            invokespecial java.lang.StringBuilder.<init>:()V
            astore 5 /* sb */
        start local 5 // java.lang.StringBuilder sb
         1: .line 65
            aload 5 /* sb */
            aload 4 /* sql */
            invokevirtual io.ebeaninternal.server.rawsql.SpiRawSql$Sql.getPreFrom:()Ljava/lang/String;
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         2: .line 66
            aload 5 /* sb */
            ldc " "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         3: .line 68
            aload 4 /* sql */
            invokevirtual io.ebeaninternal.server.rawsql.SpiRawSql$Sql.getPreWhere:()Ljava/lang/String;
            astore 6 /* s */
        start local 6 // java.lang.String s
         4: .line 69
            aload 2 /* request */
            invokevirtual io.ebeaninternal.server.core.OrmQueryRequest.getQuery:()Lio/ebeaninternal/api/SpiQuery;
            invokeinterface io.ebeaninternal.api.SpiQuery.getBindParams:()Lio/ebeaninternal/api/BindParams;
            astore 7 /* bindParams */
        start local 7 // io.ebeaninternal.api.BindParams bindParams
         5: .line 70
            aload 7 /* bindParams */
            ifnull 7
            aload 7 /* bindParams */
            invokevirtual io.ebeaninternal.api.BindParams.requiresNamedParamsPrepare:()Z
            ifeq 7
         6: .line 74
            aload 7 /* bindParams */
            aload 6 /* s */
            invokestatic io.ebeaninternal.server.util.BindParamsParser.parse:(Lio/ebeaninternal/api/BindParams;Ljava/lang/String;)Ljava/lang/String;
            astore 6 /* s */
         7: .line 76
      StackMap locals: java.lang.StringBuilder java.lang.String io.ebeaninternal.api.BindParams
      StackMap stack:
            aload 5 /* sb */
            aload 6 /* s */
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         8: .line 77
            aload 5 /* sb */
            ldc " "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
         9: .line 79
            aconst_null
            astore 8 /* dynamicWhere */
        start local 8 // java.lang.String dynamicWhere
        10: .line 80
            aload 2 /* request */
            invokevirtual io.ebeaninternal.server.core.OrmQueryRequest.getQuery:()Lio/ebeaninternal/api/SpiQuery;
            invokeinterface io.ebeaninternal.api.SpiQuery.getId:()Ljava/lang/Object;
            ifnull 13
        11: .line 85
            aload 2 /* request */
            invokevirtual io.ebeaninternal.server.core.OrmQueryRequest.getBeanDescriptor:()Lio/ebeaninternal/server/deploy/BeanDescriptor;
            astore 9 /* descriptor */
        start local 9 // io.ebeaninternal.server.deploy.BeanDescriptor descriptor
        12: .line 88
            aload 9 /* descriptor */
            aconst_null
            invokevirtual io.ebeaninternal.server.deploy.BeanDescriptor.getIdBinderIdSql:(Ljava/lang/String;)Ljava/lang/String;
            astore 8 /* dynamicWhere */
        end local 9 // io.ebeaninternal.server.deploy.BeanDescriptor descriptor
        13: .line 91
      StackMap locals: java.lang.String
      StackMap stack:
            aload 3 /* predicates */
            invokevirtual io.ebeaninternal.server.query.CQueryPredicates.getDbWhere:()Ljava/lang/String;
            astore 9 /* dbWhere */
        start local 9 // java.lang.String dbWhere
        14: .line 92
            aload 0 /* this */
            aload 9 /* dbWhere */
            invokevirtual io.ebeaninternal.server.query.CQueryBuilderRawSql.hasValue:(Ljava/lang/String;)Z
            ifeq 19
        15: .line 93
            aload 8 /* dynamicWhere */
            ifnonnull 18
        16: .line 94
            aload 9 /* dbWhere */
            astore 8 /* dynamicWhere */
        17: .line 95
            goto 19
        18: .line 96
      StackMap locals: java.lang.String
      StackMap stack:
            new java.lang.StringBuilder
            dup
            aload 8 /* dynamicWhere */
            invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            ldc " and "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            aload 9 /* dbWhere */
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            astore 8 /* dynamicWhere */
        19: .line 100
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            aload 8 /* dynamicWhere */
            invokevirtual io.ebeaninternal.server.query.CQueryBuilderRawSql.hasValue:(Ljava/lang/String;)Z
            ifeq 26
        20: .line 101
            aload 4 /* sql */
            invokevirtual io.ebeaninternal.server.rawsql.SpiRawSql$Sql.isAndWhereExpr:()Z
            ifeq 23
        21: .line 102
            aload 5 /* sb */
            ldc " and "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        22: .line 103
            goto 24
        23: .line 104
      StackMap locals:
      StackMap stack:
            aload 5 /* sb */
            ldc " where "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        24: .line 106
      StackMap locals:
      StackMap stack:
            aload 5 /* sb */
            aload 8 /* dynamicWhere */
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        25: .line 107
            aload 5 /* sb */
            ldc " "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        26: .line 110
      StackMap locals:
      StackMap stack:
            aload 4 /* sql */
            invokevirtual io.ebeaninternal.server.rawsql.SpiRawSql$Sql.getPreHaving:()Ljava/lang/String;
            astore 10 /* preHaving */
        start local 10 // java.lang.String preHaving
        27: .line 111
            aload 0 /* this */
            aload 10 /* preHaving */
            invokevirtual io.ebeaninternal.server.query.CQueryBuilderRawSql.hasValue:(Ljava/lang/String;)Z
            ifeq 30
        28: .line 112
            aload 5 /* sb */
            aload 10 /* preHaving */
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        29: .line 113
            aload 5 /* sb */
            ldc " "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        30: .line 116
      StackMap locals: java.lang.String
      StackMap stack:
            aload 3 /* predicates */
            invokevirtual io.ebeaninternal.server.query.CQueryPredicates.getDbHaving:()Ljava/lang/String;
            astore 11 /* dbHaving */
        start local 11 // java.lang.String dbHaving
        31: .line 117
            aload 0 /* this */
            aload 11 /* dbHaving */
            invokevirtual io.ebeaninternal.server.query.CQueryBuilderRawSql.hasValue:(Ljava/lang/String;)Z
            ifeq 39
        32: .line 118
            aload 5 /* sb */
            ldc " "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        33: .line 119
            aload 4 /* sql */
            invokevirtual io.ebeaninternal.server.rawsql.SpiRawSql$Sql.isAndHavingExpr:()Z
            ifeq 36
        34: .line 120
            aload 5 /* sb */
            ldc "and "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        35: .line 121
            goto 37
        36: .line 122
      StackMap locals: java.lang.String
      StackMap stack:
            aload 5 /* sb */
            ldc "having "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        37: .line 124
      StackMap locals:
      StackMap stack:
            aload 5 /* sb */
            aload 11 /* dbHaving */
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        38: .line 125
            aload 5 /* sb */
            ldc " "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        39: .line 128
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            aload 1 /* orderBy */
            invokevirtual io.ebeaninternal.server.query.CQueryBuilderRawSql.hasValue:(Ljava/lang/String;)Z
            ifeq 41
        40: .line 129
            aload 5 /* sb */
            ldc " "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            aload 4 /* sql */
            invokevirtual io.ebeaninternal.server.rawsql.SpiRawSql$Sql.getOrderByPrefix:()Ljava/lang/String;
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            ldc " "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            aload 1 /* orderBy */
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            pop
        41: .line 132
      StackMap locals:
      StackMap stack:
            aload 5 /* sb */
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            invokevirtual java.lang.String.trim:()Ljava/lang/String;
            areturn
        end local 11 // java.lang.String dbHaving
        end local 10 // java.lang.String preHaving
        end local 9 // java.lang.String dbWhere
        end local 8 // java.lang.String dynamicWhere
        end local 7 // io.ebeaninternal.api.BindParams bindParams
        end local 6 // java.lang.String s
        end local 5 // java.lang.StringBuilder sb
        end local 4 // io.ebeaninternal.server.rawsql.SpiRawSql$Sql sql
        end local 3 // io.ebeaninternal.server.query.CQueryPredicates predicates
        end local 2 // io.ebeaninternal.server.core.OrmQueryRequest request
        end local 1 // java.lang.String orderBy
        end local 0 // io.ebeaninternal.server.query.CQueryBuilderRawSql this
      LocalVariableTable:
        Start  End  Slot          Name  Signature
            0   42     0          this  Lio/ebeaninternal/server/query/CQueryBuilderRawSql;
            0   42     1       orderBy  Ljava/lang/String;
            0   42     2       request  Lio/ebeaninternal/server/core/OrmQueryRequest<*>;
            0   42     3    predicates  Lio/ebeaninternal/server/query/CQueryPredicates;
            0   42     4           sql  Lio/ebeaninternal/server/rawsql/SpiRawSql$Sql;
            1   42     5            sb  Ljava/lang/StringBuilder;
            4   42     6             s  Ljava/lang/String;
            5   42     7    bindParams  Lio/ebeaninternal/api/BindParams;
           10   42     8  dynamicWhere  Ljava/lang/String;
           12   13     9    descriptor  Lio/ebeaninternal/server/deploy/BeanDescriptor<*>;
           14   42     9       dbWhere  Ljava/lang/String;
           27   42    10     preHaving  Ljava/lang/String;
           31   42    11      dbHaving  Ljava/lang/String;
    Signature: (Ljava/lang/String;Lio/ebeaninternal/server/core/OrmQueryRequest<*>;Lio/ebeaninternal/server/query/CQueryPredicates;Lio/ebeaninternal/server/rawsql/SpiRawSql$Sql;)Ljava/lang/String;
    MethodParameters:
            Name  Flags
      orderBy     
      request     
      predicates  
      sql         

  private boolean hasValue(java.lang.String);
    descriptor: (Ljava/lang/String;)Z
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=1, locals=2, args_size=2
        start local 0 // io.ebeaninternal.server.query.CQueryBuilderRawSql this
        start local 1 // java.lang.String s
         0: .line 136
            aload 1 /* s */
            ifnull 1
            aload 1 /* s */
            invokevirtual java.lang.String.isEmpty:()Z
            ifne 1
            iconst_1
            ireturn
      StackMap locals:
      StackMap stack:
         1: iconst_0
            ireturn
        end local 1 // java.lang.String s
        end local 0 // io.ebeaninternal.server.query.CQueryBuilderRawSql this
      LocalVariableTable:
        Start  End  Slot  Name  Signature
            0    2     0  this  Lio/ebeaninternal/server/query/CQueryBuilderRawSql;
            0    2     1     s  Ljava/lang/String;
    MethodParameters:
      Name  Flags
      s     

  private java.lang.String getOrderBy(io.ebeaninternal.server.query.CQueryPredicates, io.ebeaninternal.server.rawsql.SpiRawSql$Sql);
    descriptor: (Lio/ebeaninternal/server/query/CQueryPredicates;Lio/ebeaninternal/server/rawsql/SpiRawSql$Sql;)Ljava/lang/String;
    flags: (0x0002) ACC_PRIVATE
    Code:
      stack=1, locals=4, args_size=3
        start local 0 // io.ebeaninternal.server.query.CQueryBuilderRawSql this
        start local 1 // io.ebeaninternal.server.query.CQueryPredicates predicates
        start local 2 // io.ebeaninternal.server.rawsql.SpiRawSql$Sql sql
         0: .line 140
            aload 1 /* predicates */
            invokevirtual io.ebeaninternal.server.query.CQueryPredicates.getDbOrderBy:()Ljava/lang/String;
            astore 3 /* orderBy */
        start local 3 // java.lang.String orderBy
         1: .line 141
            aload 3 /* orderBy */
            ifnull 3
         2: .line 142
            aload 3 /* orderBy */
            areturn
         3: .line 144
      StackMap locals: java.lang.String
      StackMap stack:
            aload 2 /* sql */
            invokevirtual io.ebeaninternal.server.rawsql.SpiRawSql$Sql.getOrderBy:()Ljava/lang/String;
            areturn
        end local 3 // java.lang.String orderBy
        end local 2 // io.ebeaninternal.server.rawsql.SpiRawSql$Sql sql
        end local 1 // io.ebeaninternal.server.query.CQueryPredicates predicates
        end local 0 // io.ebeaninternal.server.query.CQueryBuilderRawSql this
      LocalVariableTable:
        Start  End  Slot        Name  Signature
            0    4     0        this  Lio/ebeaninternal/server/query/CQueryBuilderRawSql;
            0    4     1  predicates  Lio/ebeaninternal/server/query/CQueryPredicates;
            0    4     2         sql  Lio/ebeaninternal/server/rawsql/SpiRawSql$Sql;
            1    4     3     orderBy  Ljava/lang/String;
    MethodParameters:
            Name  Flags
      predicates  
      sql         
}
SourceFile: "CQueryBuilderRawSql.java"
InnerClasses:
  public final Sql = io.ebeaninternal.server.rawsql.SpiRawSql$Sql of io.ebeaninternal.server.rawsql.SpiRawSql