bin/sql

   1
   2 SELECT
   3 "result1_0_3" as "result1_4",
   4 "result1_1_3" as "result2_4",
   5 "result1_2_3" as "result3_4",
   6 "result1_3_3" as "result4_4",
   7 "result1_4_3" as "result5_4",
   8 "result1_5_3" as "result6_4",
   9 "result1_6_3" as "result7_4",
  10 "result2_1_3" as "result8_4"
  11 FROM (SELECT
  12       *
  13       FROM (SELECT *
  14             FROM
  15             (SELECT
  16              "id0_1" as "result1_0_3",
  17              "typename1_1" as "result1_1_3",
  18              "user_id2_1" as "result1_2_3",
  19              "parent_id3_1" as "result1_3_3",
  20              "name4_1" as "result1_4_3",
  21              "date5_1" as "result1_5_3",
  22              "hyperdata6_1" as "result1_6_3",
  23              *
  24              FROM (SELECT
  25                    *
  26                    FROM (SELECT
  27                          "id" as "id0_1",
  28                          "typename" as "typename1_1",
  29                          "user_id" as "user_id2_1",
  30                          "parent_id" as "parent_id3_1",
  31                          "name" as "name4_1",
  32                          "date" as "date5_1",
  33                          "hyperdata" as "hyperdata6_1"
  34                          FROM "nodes" as "T1") as "T1") as "T1") as "T1"
  35             LEFT OUTER JOIN
  36             (SELECT
  37              "node1_id0_2" as "result2_0_3",
  38              "node2_id1_2" as "result2_1_3",
  39              "score2_2" as "result2_2_3",
  40              "category3_2" as "result2_3_3",
  41              *
  42              FROM (SELECT
  43                    *
  44                    FROM (SELECT
  45                          "node1_id" as "node1_id0_2",
  46                          "node2_id" as "node2_id1_2",
  47                          "score" as "score2_2",
  48                          "category" as "category3_2"
  49                          FROM "nodes_nodes" as "T1") as "T1") as "T1") as "T2"
  50             ON
  51             ("node1_id0_2") = ("id0_1")) as "T1"
  52       WHERE (("result1_1_3") = (CAST(22 AS integer)))) as "T1"