Hey there, I’m looking to display something like this on my Wordpress homepage: [תמונה] I’m using @meglio ’s Twig Anything to do this, which can pull data from any JSON feed. I’ve tried just using https://meta.discourse.org/latest.json , but the issue is that it’s difficult to pull the user avatar…

Thanks for sharing the link. I just took a look through, and it seems like it is mostly about badges? Is there a specific post in particular that you’re referring to?

No. It’s just a trove of sql examples.

[תמונה] pfaffman: No. It’s just a trove of sql examples. Badges are granted based on SQL queries typically.

So I spent a few hours this afternoon learning SQL queries. Lol. Here’s where I got: SELECT t.last_post_user_id, ua.custom_upload_id, u.username, u.username_lower, t.title, t.slug, t.id, t.category_id, c.name, c.color, t.posts_count, t.last_posted_at FROM topics t LEFT JOIN categories c ON c.id = t…

The "8 hours ago " thing gets done by a rails function. There is probably some function you can find that’ll do that for you.

Yep, with SQL queries you can extract about any data that you need from Discourse. Re date formatting, I might need to add an ago filter, like this one . Without AGO-ing, you can still format dates with using native date filter . You can also format dates directly in you SQL query .

Wohoo, just figured out how to get the “8 hours ago” using the Twig Syntax: {% set difference = date("now"|date("M j, g:ia T")).diff(date(row[11]|date("M j, g:ia T"))) %} {% set leftDays = difference.days %} {% set leftHours = difference.h %} {% set leftMinutes = difference.i %} {% if leftDays > 1 …

Using @meglio ’s Twig Anything ( https://twiganything.com/ ), on Wordpress.

SQL query in Data Explorer to pull latest topics?

קהילה נתונים ודיווח

pfaffman (Jay Pfaffman) 4 ביוני,‏ 2017,‏ 4:35pm 2

You might check out this thread [Superseded] What cool badge queries have you come up with?

נושא		תגובות	צפיות
Display Data Explorer query results in WordPress (with TwigAnything) Administrators data-explorer , how-to	3	6260	5 בדצמבר,‏ 2017
Discourse AI + Data Explorer? Feature data-explorer , completed , ai , ai-bot	47	4100	11 בינואר,‏ 2024
Formatting Data Explorer Table Results Data & reporting data-explorer , sql-tutorial	0	920	5 בספטמבר,‏ 2023
Run Data Explorer queries with the Discourse API Integrations data-explorer , rest-api , how-to	14	13707	6 במאי,‏ 2025
Understanding what our users are posting about Data & reporting sql-query	9	328	20 ביוני,‏ 2024

SQL query in Data Explorer to pull latest topics?

נושאים קשורים