prepare('SELECT w.name, SUM(cw.usage_count) AS usage_count
FROM channel_words cw
INNER JOIN words w ON w.id = cw.word_id
INNER JOIN channels c ON c.alias_name = ?
INNER JOIN users u ON u.alias_name = ?
WHERE cw.channel_id = c.id AND cw.user_id = u.id
GROUP BY cw.word_id
ORDER BY usage_count DESC
LIMIT 100
');
$stmt->execute([$channel, $user]);
} else if (isset($channel)) {
$stmt = $db->prepare('SELECT w.name, SUM(cw.usage_count) AS usage_count
FROM channel_words cw
INNER JOIN words w ON w.id = cw.word_id
INNER JOIN channels c ON c.alias_name = ?
WHERE cw.channel_id = c.id
GROUP BY cw.word_id
ORDER BY usage_count DESC
LIMIT 100
');
$stmt->execute([$channel]);
} else if (isset($user)) {
$stmt = $db->prepare('SELECT w.name, SUM(cw.usage_count) AS usage_count
FROM channel_words cw
INNER JOIN words w ON w.id = cw.word_id
INNER JOIN users u ON u.alias_name = ?
WHERE cw.user_id = u.id
GROUP BY cw.word_id
ORDER BY usage_count DESC
LIMIT 100
');
$stmt->execute([$user]);
} else {
$stmt = $db->prepare('SELECT w.name, SUM(cw.usage_count) AS usage_count
FROM channel_words cw
INNER JOIN words w ON w.id = cw.word_id
GROUP BY cw.word_id
ORDER BY usage_count DESC
LIMIT 100
');
$stmt->execute();
}
$words = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>
<?= INSTANCE_NAME ?>
Words