Posted to tcl by Bradipo at Mon Sep 12 18:34:07 GMT 2016view raw

  1. SELECT
  2. blob.rid AS rid,
  3. uuid,
  4. datetime(event.mtime,toLocal()) AS mDateTime,
  5. coalesce(ecomment,comment)
  6. || ' (user: ' || coalesce(euser,user,'?')
  7. || (SELECT case when length(x)>0 then ' tags: ' || x else '' end
  8. FROM (SELECT group_concat(substr(tagname,5), ', ') AS x
  9. FROM tag, tagxref
  10. WHERE tagname GLOB 'sym-*' AND tag.tagid=tagxref.tagid
  11. AND tagxref.rid=blob.rid AND tagxref.tagtype>0))
  12. || ')' as comment,
  13. (SELECT count(*) FROM plink WHERE pid=blob.rid AND isprim)
  14. AS primPlinkCount,
  15. (SELECT count(*) FROM plink WHERE cid=blob.rid) AS plinkCount,
  16. event.mtime AS mtime,
  17. tagxref.value AS branch
  18. FROM tag CROSS JOIN event CROSS JOIN blob
  19. LEFT JOIN tagxref ON tagxref.tagid=tag.tagid
  20. AND tagxref.tagtype>0
  21. AND tagxref.rid=blob.rid
  22. WHERE blob.rid=event.objid
  23. AND tag.tagname='branch'
  24. AND event.mtime >= julianday('2016-09-02T00:00:00');
  25.