Advertisement
Guest User

Untitled

a guest
Dec 17th, 2018
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.53 KB | None | 0 0
  1. SELECT anon_1.start AS anon_1_start, anon_1."end" AS anon_1_end, anon_1.neighbour_start AS anon_1_neighbour_start, anon_2.neighbour_end AS anon_2_neighbour_end, anon_1.distance AS anon_1_distance, anon_2.distance AS anon_2_distance, anon_1.weight AS anon_1_weight
  2. FROM (SELECT "match".start AS start, "match"."end" AS "end", anon_3.neighbour AS neighbour_start, anon_3.distance AS distance, "match".weight AS weight
  3. FROM "match" JOIN (SELECT anon_4."match" AS "match", anon_4.neighbour AS neighbour, min(anon_4.distance) AS distance
  4. FROM (SELECT anon_5."match" AS "match", anon_5.graph_id AS graph_id, anon_5.neighbour AS neighbour, anon_5.distance AS distance
  5. FROM (SELECT "match".start AS "match", "match".start_graph_id AS graph_id, node.node_id AS neighbour, ? AS distance
  6. FROM "match" JOIN node ON node.node_id = "match".start AND node.graph_id = "match".start_graph_id
  7. WHERE "match".query_id = ? UNION SELECT anon_6."match" AS anon_6_match, anon_6.graph_id AS anon_6_graph_id, anon_6.neighbour AS anon_6_neighbour, anon_6.distance AS anon_6_distance
  8. FROM (SELECT DISTINCT anon_7."match" AS "match", anon_7.graph_id AS graph_id, edge."end" AS neighbour, ? AS distance
  9. FROM (SELECT "match".start AS "match", "match".start_graph_id AS graph_id, node.node_id AS neighbour, ? AS distance
  10. FROM "match" JOIN node ON node.node_id = "match".start AND node.graph_id = "match".start_graph_id
  11. WHERE "match".query_id = ?) AS anon_7 JOIN edge ON edge.start = anon_7.neighbour AND edge.graph_id = anon_7.graph_id UNION SELECT DISTINCT anon_8."match" AS "match", anon_8.graph_id AS graph_id, edge."end" AS neighbour, ? AS distance
  12. FROM (SELECT DISTINCT anon_7."match" AS "match", anon_7.graph_id AS graph_id, edge."end" AS neighbour, ? AS distance
  13. FROM (SELECT "match".start AS "match", "match".start_graph_id AS graph_id, node.node_id AS neighbour, ? AS distance
  14. FROM "match" JOIN node ON node.node_id = "match".start AND node.graph_id = "match".start_graph_id
  15. WHERE "match".query_id = ?) AS anon_7 JOIN edge ON edge.start = anon_7.neighbour AND edge.graph_id = anon_7.graph_id) AS anon_8 JOIN edge ON edge.start = anon_8.neighbour AND edge.graph_id = anon_8.graph_id) AS anon_6) AS anon_5) AS anon_4 GROUP BY anon_4."match", anon_4.neighbour) AS anon_3 ON "match".start = anon_3."match"
  16. WHERE "match".query_id = ?) AS anon_1 LEFT OUTER JOIN (SELECT "match".start AS start, "match"."end" AS "end", neighbour_match.start AS neighbour_start, anon_9.neighbour AS neighbour_end, anon_9.distance AS distance
  17. FROM "match" JOIN (SELECT anon_10."match" AS "match", anon_10.neighbour AS neighbour, min(anon_10.distance) AS distance
  18. FROM (SELECT anon_11."match" AS "match", anon_11.graph_id AS graph_id, anon_11.neighbour AS neighbour, anon_11.distance AS distance
  19. FROM (SELECT "match"."end" AS "match", "match".end_graph_id AS graph_id, node.node_id AS neighbour, ? AS distance
  20. FROM "match" JOIN node ON node.node_id = "match"."end" AND node.graph_id = "match".end_graph_id
  21. WHERE "match".query_id = ? UNION SELECT anon_12."match" AS anon_12_match, anon_12.graph_id AS anon_12_graph_id, anon_12.neighbour AS anon_12_neighbour, anon_12.distance AS anon_12_distance
  22. FROM (SELECT DISTINCT anon_13."match" AS "match", anon_13.graph_id AS graph_id, edge."end" AS neighbour, ? AS distance
  23. FROM (SELECT "match"."end" AS "match", "match".end_graph_id AS graph_id, node.node_id AS neighbour, ? AS distance
  24. FROM "match" JOIN node ON node.node_id = "match"."end" AND node.graph_id = "match".end_graph_id
  25. WHERE "match".query_id = ?) AS anon_13 JOIN edge ON edge.start = anon_13.neighbour AND edge.graph_id = anon_13.graph_id UNION SELECT DISTINCT anon_14."match" AS "match", anon_14.graph_id AS graph_id, edge."end" AS neighbour, ? AS distance
  26. FROM (SELECT DISTINCT anon_13."match" AS "match", anon_13.graph_id AS graph_id, edge."end" AS neighbour, ? AS distance
  27. FROM (SELECT "match"."end" AS "match", "match".end_graph_id AS graph_id, node.node_id AS neighbour, ? AS distance
  28. FROM "match" JOIN node ON node.node_id = "match"."end" AND node.graph_id = "match".end_graph_id
  29. WHERE "match".query_id = ?) AS anon_13 JOIN edge ON edge.start = anon_13.neighbour AND edge.graph_id = anon_13.graph_id) AS anon_14 JOIN edge ON edge.start = anon_14.neighbour AND edge.graph_id = anon_14.graph_id) AS anon_12) AS anon_11) AS anon_10 GROUP BY anon_10."match", anon_10.neighbour) AS anon_9 ON "match"."end" = anon_9."match" JOIN "match" AS neighbour_match ON neighbour_match."end" = anon_9.neighbour) AS anon_2 ON anon_1.start = anon_2.start AND anon_1."end" = anon_2."end" AND anon_1.neighbour_start = anon_2.neighbour_start
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement