# ‘최상위 추천인’ 보고서에 항목을 더 포함하는 방법

**URL:** https://meta.discourse.org/t/how-to-include-more-entries-in-the-top-referrers-report/135346
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [12월 7, 2019, 11:11오전 UTC](https://meta.discourse.org/t/how-to-include-more-entries-in-the-top-referrers-report/135346 "2019-12-07T11:11:50Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![maiki](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/maiki/32/233950_2.png) [@maiki](https://meta.discourse.org/u/maiki)
#### Post date: [12월 8, 2019, 8:56오후 UTC](https://meta.discourse.org/t/how-to-include-more-entries-in-the-top-referrers-report/135346/2 "2019-12-08T20:56:41Z")

</div>

AshtonJ는 대시보드에서 코드를 가져와 [Data Explorer](https://meta.discourse.org/t/32566?silent=true)(아마도 좋아하실 매우 멋진 플러그인)로 쉽게 수정할 수 있도록 쿼리를 작성했습니다:

> [@Top 10 referrers over the last month](https://meta.discourse.org/t/top-10-referrers-over-the-last-month/275145?u=maiki):
>
> Another one I can’t take any credit for - ripped directly out of DC’s dashboard smiley Top 10 referrers over the last month 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\_l…

---

_[View the full topic](https://meta.discourse.org/t/how-to-include-more-entries-in-the-top-referrers-report/135346)._