prepare("
SELECT p.unique_id, p.paste_title, p.created_at, p.likes, p.dislikes, p.views,
CASE WHEN p.paste_by = 0 THEN 'Anonymous' ELSE u.username END AS username
FROM paste p
LEFT JOIN users u ON p.paste_by = u.id
WHERE p.visibility = 1
ORDER BY p.views DESC, p.created_at DESC
LIMIT 10
");
$stmt->execute();
$result = $stmt->get_result();
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
$pastes[] = $row;
}
}
$stmt->close();
?>
Top Pastes