-- CVS ID: $Id: useful.sql,v 1.2 2006/03/21 04:57:22 fmalikoff Exp $

-- List all nodes, their versions and properties
select * from lams_cr_node node
       left join lams_cr_node_version nv on node.node_id = nv.node_id
       left join lams_cr_node_version_property nvp on nvp.nv_id = nv.nv_id
order by node.workspace_id, node.node_id
