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"