Changeset 13b2986 in Klonkt for src/routes/epk.js

Timestamp:

06/19/2026 08:20:35 AM (3 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

977f65d

Parents:

59e522f

Message:

EPK: Music section = top 10 most played (instead of first 6 in order)

Query now orders by play_count DESC LIMIT 10; section is titled "Most played"
with a rank number per track.

Co-Authored-By: Claude <noreply@…>

File:

• src/routes/epk.js (modified) (1 diff)

src/routes/epk.js

@@ -25 +25 @@
   if (!site) return next();
 
+  // Top 10 meest beluisterde nummers (op play_count), niet zomaar de eerste paar.
   const tracks = db.prepare(
-    `SELECT title, artist, duration, cover_url
+    `SELECT title, artist, duration, cover_url, COALESCE(play_count, 0) AS plays
        FROM audio_tracks
       WHERE site_id = ?
-      ORDER BY position ASC, created_at ASC
-      LIMIT 6`
+      ORDER BY plays DESC, position ASC, created_at ASC
+      LIMIT 10`
   ).all(site.id);