repos_starred (view)
20 rows where id = 209590345
This data as json
starred_at (date) 17 ✖
- 2019-09-19 4
- 2019-12-12 1
- 2020-01-15 1
- 2020-08-20 1
- 2020-10-02 1
- 2020-11-14 1
- 2020-11-16 1
- 2020-12-17 1
- 2020-12-24 1
- 2021-01-18 1
- 2021-07-29 1
- 2021-09-24 1
- 2022-02-22 1
- 2022-09-12 1
- 2022-11-19 1
- 2023-03-13 1
- 2023-07-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;