# Top 10 referrers over the last month

**URL:** https://meta.discourse.org/t/top-10-referrers-over-the-last-month/275145
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [12 oktober 2018 om 01:04 UTC](https://meta.discourse.org/t/top-10-referrers-over-the-last-month/275145 "2018-10-12T01:04:27Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![AstonJ](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/astonj/32/215041_2.png) [@AstonJ](https://meta.discourse.org/u/AstonJ)
#### Post date: [12 oktober 2018 om 01:04 UTC](https://meta.discourse.org/t/top-10-referrers-over-the-last-month/275145/1 "2018-10-12T01:04:27Z")

</div>

Another one I can’t take any credit for - ripped directly out of DC’s dashboard 😃

**Top 10 referrers over the last month**

```plaintext
SELECT COUNT(*) AS count_all, incoming_domains.name 
AS incoming_domains_name 
FROM "incoming_links" 
INNER JOIN "posts" ON "posts"."id" = "incoming_links"."post_id" 
AND ("posts"."deleted_at" IS NULL) 
INNER JOIN "topics" ON "topics"."id" = "posts"."topic_id" 
AND ("topics"."deleted_at" IS NULL) 
INNER JOIN "incoming_referers" ON "incoming_referers"."id" = "incoming_links"."incoming_referer_id" 
INNER JOIN "incoming_domains" ON "incoming_domains"."id" = "incoming_referers"."incoming_domain_id" 
WHERE (topics.archetype = 'regular') 
AND ("topics"."deleted_at" IS NULL) 
AND (incoming_links.created_at > date_trunc('month', CURRENT_DATE) - INTERVAL '30 days' 
AND incoming_links.created_at < date_trunc('month', CURRENT_DATE)) 
GROUP BY incoming_domains.name 
ORDER BY count_all DESC LIMIT 10

```