repos_starred (view)
35 rows where id = 303218369
This data as json
starred_at (date) >30 ✖
- 2020-10-16 2
- 2020-10-20 2
- 2022-11-19 2
- 2020-10-12 1
- 2020-10-28 1
- 2020-11-11 1
- 2020-11-15 1
- 2020-12-07 1
- 2020-12-08 1
- 2020-12-09 1
- 2020-12-11 1
- 2021-01-10 1
- 2021-01-24 1
- 2021-02-01 1
- 2021-02-15 1
- 2021-02-22 1
- 2021-02-26 1
- 2021-03-18 1
- 2021-04-28 1
- 2021-04-29 1
- 2021-05-13 1
- 2021-06-20 1
- 2021-08-25 1
- 2021-08-27 1
- 2021-08-31 1
- 2021-09-30 1
- 2022-03-21 1
- 2022-10-03 1
- 2022-10-11 1
- 2023-01-24 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;