# Statistiques sur les publications les plus aimées de tous les temps ?

**URL:** <https://meta.discourse.org/t/statistics-on-most-liked-posts-of-all-time/292882>\
**Category:** Data & reporting\
**Created:** [Janvier 25, 2024, 9:25 UTC](https://meta.discourse.org/t/statistics-on-most-liked-posts-of-all-time/292882 "2024-01-25T09:25:11Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![WaitroseCarpark](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/waitrosecarpark/32/198599_2.png) [@WaitroseCarpark](https://meta.discourse.org/u/WaitroseCarpark)\
**Post date:** [Août 25, 2025, 12:47 UTC](https://meta.discourse.org/t/statistics-on-most-liked-posts-of-all-time/292882/4 "2025-08-25T12:47:53Z")

</div>

Je viens de créer cette requête [Data Explorer](https://meta.discourse.org/t/32566?silent=true) avec l’aide de Gemini. Elle donne les 10 publications les plus aimées, de tous les temps.

```plaintext
-- Interroge les 10 publications les plus aimées de tous les temps (pour les versions modernes de Discourse)
SELECT
    p.id AS post_id,
    p.like_count,
    CONCAT('/t/', t.slug, '/', t.id, '/', p.post_number) AS url,
    t.title AS topic_title,
    p.user_id,
    u.username
FROM posts AS p
JOIN topics AS t ON t.id = p.topic_id
JOIN users AS u ON u.id = p.user_id
WHERE p.deleted_at IS NULL
  AND t.deleted_at IS NULL
  AND p.post_type = 1 -- 1 pour les publications normales
ORDER BY p.like_count DESC
LIMIT 10

```

---

_[View the full topic](https://meta.discourse.org/t/statistics-on-most-liked-posts-of-all-time/292882)._