/* A test node */
DECLARE @nodeid int
SET @nodeid = 
  (SELECT top(1) nodeid FROM name 
   WHERE lower(name) = 'another brick in the wall (part 2)'
     AND nodetype = 't')

/* Info about a node*/
SELECT * FROM node WHERE nodeid = @nodeid

/* Name of a node */
SELECT name FROM name WHERE nodeid = @nodeid

/* The creator of a node */
SELECT creatorid, name
FROM name, creator
WHERE creator.nodeid = @nodeid
  AND creator.creatorid = name.nodeid

/* All properties of a node */
SELECT * FROM property WHERE nodeid = @nodeid

/* All properties of a node with name of property */
SELECT nodeid, propid, property.proptypeid, name 
FROM property, proptype 
WHERE nodeid = @nodeid
  AND property.proptypeid = proptype.proptypeid

/* All attributes of a node with name of property */
SELECT nodeid, propid, name 
FROM attribute, proptype 
WHERE nodeid = @nodeid
  AND attribute.proptypeid = proptype.proptypeid

/* All tags of a node, with name of tag */
SELECT name.nodeid, name
FROM name, tag
WHERE tag.nodeid = @nodeid
  AND tagid = name.nodeid

/* All tracks of a creator/project node */
DECLARE @creatorid int
SET @creatorid = 
  (SELECT creatorid FROM creator WHERE nodeid = @nodeid)

SELECT name.nodeid, name
FROM name, creator
WHERE creator.creatorid = @creatorid
  AND creator.nodeid = name.nodeid
  AND name.nodetype = 't'
ORDER by name;