WHERE tag.tagname='sym-' || branch.name
     AND tagxref.tagid=tag.tagid
     AND tagxref.tagtype>0
     AND event.objid=tagxref.rid
     AND blob.rid=event.objid
     AND event.type GLOB 'ci'
     GROUP BY branch.name
     -- ORDER BY event.mtime DESC
     -- LIMIT 2
)
SELECT * FROM latestByBranch
ORDER BY ts DESC
;
</pre></nowiki>
<h2>Recursion Example</h2>