datetime(a.tm,'localtime') time,
       user,
       substr(comment,0,20)||'...' comment
from blob b, ancestors a
WHERE b.rid=a.rid
;
</pre></nowiki>


<h2>Checkout-vs-repo Overview</h2>

And overview of info similar to that provided by <tt>fossil changes</tt> and similar commands:

<nowiki><pre>
SELECT id,vid,vfile.mrid, deleted, chnged, uuid, size, mtime, pathname
FROM vfile LEFT JOIN blob ON vfile.mrid=blob.rid
WHERE vid=BLOB_RID_OF_CHECKIN_VERSION
and chnged
ORDER BY pathname
</pre></nowiki>





<h2>Recursion Example</h2>

See also: [http://www.sqlite.org/draft/lang_with.html]

The following is adapted from a sqlite mailing list post by Petite Abeille on 20140203, not directly applicable to fossil but which is an interesting example nonetheless and which can certainly be used as a model for generating fossil-related data: