query("SELECT COUNT(*) as count FROM domains WHERE status = 1")->fetch()['count']; $totalUsers = $pdo->query("SELECT COUNT(*) as count FROM users WHERE is_verified = 1")->fetch()['count']; $stmt = $pdo->prepare("SELECT d.*, u.username FROM domains d LEFT JOIN users u ON d.user_id = u.id WHERE d.status = 1 ORDER BY d.created_at DESC LIMIT 10"); $stmt->execute(); $recentDomains = $stmt->fetchAll(); $currentTheme = getTheme(); $mainDomains = getMainDomains(); ?>