# Create a Network chart of your forum - data visualization

**URL:** https://meta.discourse.org/t/create-a-network-chart-of-your-forum-data-visualization/37426
**Category:** Administrators
**Tags:** how-to, reporting
**Created:** [2016 年 1 月 4 日午後 5:13 UTC](https://meta.discourse.org/t/create-a-network-chart-of-your-forum-data-visualization/37426 "2016-01-04T17:13:02Z")
**Posts on this page:** 1
**Showing post:** 3

<div class="post-metadata">

### Author: ![riking](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/riking/32/170938_2.png) [@riking](https://meta.discourse.org/u/riking)
#### Post date: [2016 年 1 月 4 日午後 11:21 UTC](https://meta.discourse.org/t/create-a-network-chart-of-your-forum-data-visualization/37426/3 "2016-01-04T23:21:20Z")

</div>

> [@DavidGNavas](#):
>
> SELECT liker liker\_user\_id, liked liked\_user\_id, count(\*)  
> FROM pairs, group\_users AS a, groups AS b

Replace these two lines with this to have the usernames instead:

```plaintext
SELECT u1.username_lower liker_username, u2.username_lower liked_username, count(*)
FROM pairs, group_users AS a, groups AS b
LEFT JOIN users u1 ON u1.id = liker
LEFT JOIN users u2 ON u2.id = liked

```

---

_[View the full topic](https://meta.discourse.org/t/create-a-network-chart-of-your-forum-data-visualization/37426)._