I want to see everyone’s bookmarks. So I try this simple query in Data Explorer. SELECT * from bookmarks That returns no results. I added a bookmark of my own and ran it again. Still no results. Where are bookmarks stored, if not in the bookmarks table?

[image] Mark_Schmucker: I try this simple query in Data Explorer. SELECT * from bookmarks The bookmarks table doesn’t seem to be getting used yet. It is part of some improvements that are being made to Discourse’s bookmarking functionality. Currenty, you can get information about bookmarks with a query like this: SELECT t.user_id, t.id AS topic_id, COUNT(*) AS bookmark_count FROM post_actions pa JOIN posts p ON p.id = pa.post_id JOIN topics t ON t.id = p.topic_id WHERE pa.post_action_type_id = 1 AND t.deleted_at IS NULL AND p.deleted_at IS NULL GROUP BY t.id, t.user_id ORDER BY bookmark_count DESC LIMIT 20

Try running SELECT COUNT(id) FROM bookmarks

[image] [image] One of my bookmarks. I’m sure others have bookmarks also: [image]

In what table are bookmarks stored, if not “bookmarks”?

Community Building Data & reporting

Mittineague (Mittineague) December 23, 2019, 4:18pm 4

Sorry, I’m at a loss for what the problem might be. That makes no sense to me at all. I would think you would get some kind of error message or at least the 1 you know exists.

Topic		Replies	Views
Easy way to access bookmarked posts from a specific topic Feature completed , bookmarks	5	717	April 7, 2026
I try to navigate to bookmarks. System display Page not found Product Support	2	92	April 30, 2025
Easier access to bookmarks :bookmark: Announcements bookmarks	0	475	April 7, 2026
Bookmarks still exist for topics you no longer have access to UX bookmarks	2	216	January 21, 2026
Disappearing bookmarks and expected behavior of /bookmarks Bug bookmarks	23	2292	November 7, 2023

In what table are bookmarks stored, if not “bookmarks”?

Related topics