WikiMapper/WikiViz — pull request #25 by matseng (2014-02-20 01:38:44+00:00)
Title: Created small example url database

Get all children of url_id = 1:

SELECT *
FROM urls JOIN url_to_url
USING (url_id)
WHERE url_id = 1;

--
Get all parents of url_id = 1:

SELECT *
FROM urls JOIN url_to_url
USING (url_id)
WHERE child_id = 1;