repos_starred (view)
44 rows where created_at = "2020-03-21T04:02:05Z"
This data as json
starred_at (date) >30 ✖
- 2020-04-06 4
- 2020-10-17 3
- 2021-03-25 3
- 2020-04-05 2
- 2020-05-08 2
- 2020-03-24 1
- 2020-04-08 1
- 2020-08-04 1
- 2020-08-27 1
- 2020-09-04 1
- 2020-11-14 1
- 2020-11-16 1
- 2020-11-17 1
- 2021-02-23 1
- 2021-03-28 1
- 2021-04-13 1
- 2021-06-06 1
- 2021-07-12 1
- 2021-07-13 1
- 2021-07-14 1
- 2021-07-20 1
- 2021-08-10 1
- 2022-01-02 1
- 2022-02-04 1
- 2022-02-08 1
- 2022-02-10 1
- 2022-02-25 1
- 2022-03-28 1
- 2022-04-02 1
- 2022-06-28 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;