NB: fix civi/dev if necessary (ex: civi/event for event-related punches)
# gitlab-psql
# gitlabhq_production=# select t.id, t.user_id, t.issue_id, t.merge_request_id, concat(concat(to_char(t.Created_at, 'YYYY-MM-DD hh24:mi'), '+', round(cast(time_spent as decimal)/60/60,2), 'h'), ' civi/dev ', CONCAT(n.path, '/', p.path, '#', i.iid), ' ', i.title) as full_entry from timelogs t left join issues i on (i.id = t.issue_id) left join projects p on (p.id = i.project_id) left join namespaces n on (n.id = p.namespace_id) where t.user_id not in (2,11) and t.created_at > '2019-07-09';
id | user_id | issue_id | merge_request_id | full_entry
----+---------+----------+------------------+-----------------------------------------------------------------------------------------------------------------------------------------
54 | 24 | 3312 | | 2019-07-10 15:50+37.00h civi/dev events/civicamp-nyc#5 Attend CiviCamp/Sprint
55 | 24 | 2871 | | 2019-07-10 16:00+0.53h civi/dev dev/drupal#59 deprecate civicrm_engage
56 | 24 | 2871 | | 2019-07-10 16:01+-0.53h civi/dev dev/drupal#59 deprecate civicrm_engage
57 | 24 | 2860 | | 2019-07-10 16:01+0.53h civi/dev dev/drupal#56 Civi 5.12.1 renders Quicksearch unreadable on Drupal 8
58 | 24 | 2944 | | 2019-07-10 16:02+0.16h civi/dev dev/core#931 Civi 5.13.0 fails to upgrade on multilingual sites
59 | 24 | 3144 | | 2019-07-10 16:19+7.50h civi/dev dev/core#1030 Seach builder doesn't work with search action "schedule/send via CiviMail"
60 | 24 | 2491 | | 2019-07-10 16:27+0.56h civi/dev dev/membership#9 Back-office membership renewals don't display an on-screen notification
61 | 24 | 3091 | | 2019-07-10 16:29+0.21h civi/dev dev/financial#59 [Unreleased regression] Undefined method when viewing Contribution Batch Search screen
62 | 24 | 3144 | | 2019-07-10 16:31+0.37h civi/dev dev/core#1030 Seach builder doesn't work with search action "schedule/send via CiviMail"
63 | 24 | 2946 | | 2019-07-10 16:34+1.25h civi/dev dev/wordpress#26 Regression: REST calls fail on WP on 5.13.0
64 | 24 | 3045 | | 2019-07-10 16:35+0.82h civi/dev dev/drupal#64 Drupal8/Backdrop: Bad URL on ACL page linking to CMS permissions
65 | 24 | 3312 | | 2019-07-10 16:38+1.78h civi/dev events/civicamp-nyc#5 Attend CiviCamp/Sprint
66 | 24 | 3279 | | 2019-07-10 16:39+0.25h civi/dev dev/event#7 Confirming from waitlist counts deleted contacts
67 | 24 | 3309 | | 2019-07-10 16:39+0.43h civi/dev dev/drupal#75 [regression] `cv` fails on CiviCRM 5.15.0
68 | 24 | 3254 | | 2019-07-10 16:41+0.26h civi/dev dev/mail#46 Contribution tokens with option values display values, not label
69 | 485 | 3185 | | 2019-07-10 16:47+6.50h civi/dev dev/core#1050 Delete repeating activities not working as intended
70 | 24 | 3313 | | 2019-07-10 16:48+4.13h civi/dev dev/drupal#76 Proposal: Don't migrate drush commands to D8
71 | 24 | 3313 | | 2019-07-10 16:49+0.25h civi/dev dev/drupal#76 Proposal: Don't migrate drush commands to D8
(18 rows)