Changeset 8cdb377 in Klonkt for src/routes
- Timestamp:
- 06/19/2026 09:40:04 AM (3 months ago)
- Branches:
- main
- Children:
- 535f955
- Parents:
- 1e2e9e7
- File:
-
- 1 edited
-
src/routes/posts.js (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
src/routes/posts.js
r1e2e9e7 r8cdb377 401 401 const ordered = isHub 402 402 ? db.prepare(` 403 SELECT p.id, p.slug, p.title, s.slug AS site_slug403 SELECT p.id, p.slug, p.title, p.pinned, s.slug AS site_slug 404 404 FROM posts p JOIN sites s ON s.id = p.site_id 405 405 WHERE p.status = 'published' … … 407 407 `).all() 408 408 : db.prepare(` 409 SELECT id, slug, title FROM posts409 SELECT id, slug, title, pinned FROM posts 410 410 WHERE site_id = ? AND status = 'published' 411 411 ORDER BY (pinned = 0) ASC, pinned ASC, published_at DESC
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)