gistfile1.txt

bq nkStmtList:
  bq nkStmtList:
    bq nkSelect:
      bq nkSelectColumns:
        bq nkSelectPair:
          bq nkCall:
            bq "COUNT"
            bq "*"
          bq "count"
        bq nkSelectPair:
          bq "link_0"
        bq nkSelectPair:
          bq "link_1"
      bq nkFrom:
        bq nkFromItemPair:
          bq nkSelect:
            bq nkSelectColumns:
              bq nkSelectPair:
                bq "viaField"
              bq nkSelectPair:
                bq nkCall:
                  bq "IF"
                  bq nkInfix:
                    bq "is"
                    bq "min_ts_0"
                    bq nkPrefix:
                      bq "NOT"
                      bq "NULL"
                  bq nkIntegerLit, "1"
                  bq nkIntegerLit, "0"
                bq "link_0"

gistfile2.txt

     newNode(nkSelect, @[
        newNode(nkSelectColumns, @[
          newNode(nkSelectPair, @[
            newNode(nkCall, @[
              newNode(nkIdent, "COUNT"),
              newNode(nkIdent, "*")
            ]),
            newNode(nkIdent, "count")
          ]),
          newNode(nkSelectPair, @[
            newNode(nkIdent, "link_0")
          ]),
          newNode(nkSelectPair, @[
            newNode(nkIdent, "link_1")
          ])
        ]),
        newNode(nkFrom, @[
          newNode(nkFromItemPair, @[
            newNode(nkSelect, @[
              newNode(nkSelectColumns, @[
                newNode(nkSelectPair, @[
                  newNode(nkIdent, "viaField")
                ]),
                newNode(nkSelectPair, @[
                  newNode(nkCall, @[
                    newNode(nkIdent, "IF"),
                    newNode(nkInfix, @[
                      newNode(nkIdent, "is"),
                      newNode(nkIdent, "min_ts_0"),
                      newNode(nkPrefix, @[
                        newNode(nkIdent, "NOT"),
                        newNode(nkIdent, "NULL")
                      ])
                    ]),
                    newNode(nkIntegerLit, "1"),
                    newNode(nkIntegerLit, "0")
                  ]),
                  newNode(nkIdent, "link_0")
                ]),
                newNode(nkSelectPair, @[
                  newNode(nkCall, @[
                    newNode(nkIdent, "IF"),
                    newNode(nkInfix, @[
                      newNode(nkIdent, "and"),
                      newNode(nkInfix, @[
                        newNode(nkIdent, "and"),
                        newNode(nkInfix, @[
                          newNode(nkIdent, "is"),
                          newNode(nkIdent, "min_ts_0"),
                          newNode(nkPrefix, @[
                            newNode(nkIdent, "NOT"),
                            newNode(nkIdent, "NULL")
                          ])
                        ]),