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

[maiki]

AshtonJ는 대시보드에서 코드를 가져와 Data Explorer(아마도 좋아하실 매우 멋진 플러그인)로 쉽게 수정할 수 있도록 쿼리를 작성했습니다:

Top 10 referrers over the last month

Another one I can’t take any credit for - ripped directly out of DC’s dashboard 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…