SELECT versioncontrol_item_revisions.item_revision_id AS item_revision_id, versioncontrol_item_revisions.path AS versioncontrol_item_revisions_path, versioncontrol_repositories.vcs AS versioncontrol_r
SELECT versioncontrol_item_revisions.item_revision_id AS item_revision_id, versioncontrol_item_revisions.path AS versioncontrol_item_revisions_path, versioncontrol_repositories.vcs AS versioncontrol_r
SELECT o.author_uid AS uid, MIN(o.date)AS first_commit, MAX(o.date)AS last_commit, COUNT(o.vc_op_id)AS commits, CASE WHEN uid = 0 THEN go.author_name WHEN uid != 0 THEN u.name END AS name FROM{ver