Index: lams_contentrepository/db/sql/useful.sql =================================================================== RCS file: /usr/local/cvsroot/lams_contentrepository/db/sql/useful.sql,v diff -u -r1.2 -r1.3 --- lams_contentrepository/db/sql/useful.sql 21 Mar 2006 04:57:22 -0000 1.2 +++ lams_contentrepository/db/sql/useful.sql 11 May 2016 07:29:19 -0000 1.3 @@ -1,5 +1,5 @@ --- CVS ID: $Id$ + -- 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