# Looking to find the number of content shares in the last month

**URL:** <https://meta.discourse.org/t/looking-to-find-the-number-of-content-shares-in-the-last-month/98050>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [September 25, 2018, 10:37pm UTC](https://meta.discourse.org/t/looking-to-find-the-number-of-content-shares-in-the-last-month/98050 "2018-09-25T22:37:53Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Mittineague](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/mittineague/32/114259_2.png) [@Mittineague](https://meta.discourse.org/u/Mittineague)\
**Post date:** [September 25, 2018, 11:30pm UTC](https://meta.discourse.org/t/looking-to-find-the-number-of-content-shares-in-the-last-month/98050/2 "2018-09-25T23:30:42Z")

</div>

> [@jerdog](#):
>
> doesn’t pass the plausibility check

If you query the topics / posts tables do the numbers match up?

> <https://github.com/discourse/discourse/blob/main/app/models/incoming_link.rb#L93-L101>

Maybe you’re not asking the right question? eg. if there is a link to a post and it gets clicked 100 times, does that count as 1 (the same post) or 100 (the clicks)

---

_[View the full topic](https://meta.discourse.org/t/looking-to-find-the-number-of-content-shares-in-the-last-month/98050)._