John dataserver

## closure-table-operations.sql
-- Retrieve descendants
-- ====================
-- retrieve descendants of #4
SELECT c.*
  FROM Comments AS c
    JOIN TreePaths AS t ON c.comment_id = t.descendant
 WHERE t.ancestor = 4;


-- Retrieve ancestors
	-- Retrieve descendants
	-- ====================
	-- retrieve descendants of #4
	SELECT c.*
	FROM Comments AS c
	JOIN TreePaths AS t ON c.comment_id = t.descendant
	WHERE t.ancestor = 4;


	-- Retrieve ancestors