Index: src/routes/admin-stats.js
===================================================================
--- src/routes/admin-stats.js	(revision d5495493691e5642bb7df668ba1fd87506fdd369)
+++ src/routes/admin-stats.js	(revision 37edecd7c1a492799587f07cc44fb88fbd1567ee)
@@ -10,4 +10,5 @@
 
 import express from 'express';
+import db from '../config/database.js';
 import { renderPage } from '../middleware/render.js';
 import { requireGod } from '../middleware/auth.js';
@@ -21,8 +22,18 @@
     return res.status(403).send('Statistieken is een premium-functie — koppel Patreon in Beheer → Instellingen.');
   }
+  // Link-in-bio klikken (premium #6) voor de huidige site.
+  let linkClicks = [];
+  if (res.locals.site) {
+    try {
+      linkClicks = db.prepare(
+        'SELECT url, clicks FROM link_clicks WHERE site_id = ? AND clicks > 0 ORDER BY clicks DESC LIMIT 50'
+      ).all(res.locals.site.id);
+    } catch { linkClicks = []; }
+  }
   renderPage(req, res, 'pages/admin-stats', {
     pageTitle: 'Statistieken',
     bodyClass: 'on-admin',
     stats: getStats(14),
+    linkClicks,
   });
 });