Changeset ab544fd in Klonkt for src/routes
- Timestamp:
- 06/14/2026 04:49:24 PM (3 months ago)
- Branches:
- main
- Children:
- 6150acb
- Parents:
- a64f642
- File:
-
- 1 edited
-
src/routes/hub.js (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
src/routes/hub.js
ra64f642 rab544fd 38 38 const artists = db.prepare(` 39 39 SELECT s.slug, s.title, s.tagline, s.profile_photo, s.accent, 40 u.avatar_url AS owner_avatar, 40 41 (SELECT COUNT(*) FROM posts WHERE site_id = s.id AND status = 'published') AS post_count 41 42 FROM sites s 43 LEFT JOIN users u ON u.id = s.owner_id 42 44 ORDER BY s.created_at ASC 43 45 `).all();
Note:
See TracChangeset
for help on using the changeset viewer.
![(please configure the [header_logo] section in trac.ini)](/chrome/site/your_project_logo.png)