Synnefo

SELECT DISTINCT n.path, v.serial, v.node, v.hash, v.size, v.type,
v.source, v.mtime, v.muser, v.uuid, v.checksum, v.cluster FROM nodes AS
n, versions AS v WHERE v.serial = (SELECT max(versions.serial) AS max_1
FROM versions WHERE versions.node = v.node) AND v.cluster != 2 AND
v.node IN (SELECT nodes.node FROM nodes WHERE nodes.parent = 182) AND
n.node = v.node AND n.path > E'user@fqdn/alpha' AND n.path <
E'user@fqdn/beta' ORDER BY n.path LIMIT 10000;