repos_starred (view)
94 rows where id = 213286752
This data as json
starred_at (date) >30 ✖
- 2023-07-09 8
- 2022-08-23 3
- 2023-07-18 3
- 2019-10-07 2
- 2020-01-06 2
- 2020-07-11 2
- 2021-01-31 2
- 2021-03-25 2
- 2021-03-26 2
- 2023-01-23 2
- 2019-10-08 1
- 2019-10-13 1
- 2019-11-07 1
- 2019-11-12 1
- 2020-04-13 1
- 2020-04-23 1
- 2020-04-26 1
- 2020-06-16 1
- 2020-07-28 1
- 2020-09-05 1
- 2020-09-08 1
- 2020-09-10 1
- 2020-09-24 1
- 2020-10-17 1
- 2020-10-19 1
- 2020-10-20 1
- 2020-10-27 1
- 2020-10-29 1
- 2020-10-30 1
- 2020-11-14 1
- …
0 records
CREATE VIEW repos_starred AS select stars.starred_at, starring_user.login as starred_by, repos.* from repos join stars on repos.id = stars.repo join users as starring_user on stars.user = starring_user.id join users on repos.owner = users.id order by starred_at desc;