tag_count_view

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

int8

√

null

content

varchar

255

√

null

created_at

timestamptz

35,6

√

null

updated_at

timestamptz

35,6

√

null

recent_count

int8

√

null

count

int8

√

null

last_used

timestamptz

35,6

√

null

tag_score

float8

17,17

√

null

View Definition

SELECT tag.id,
    tag.content,
    tag.created_at,
    tag.updated_at,
    a1.recent_count,
    a2.count,
    a3.last_used,
    (((COALESCE(a1.recent_count, (0)::bigint) * ((a3.last_used >= (now() - '72:00:00'::interval)))::integer))::double precision * COALESCE(b.boost, (1)::real)) AS tag_score
   FROM ((((tag
     LEFT JOIN ( SELECT count(article_tag.id) AS recent_count,
            article_tag.tag_id
           FROM article_tag
          WHERE (article_tag.created_at >= (now() - '30 days'::interval))
          GROUP BY article_tag.tag_id) a1 ON ((tag.id = a1.tag_id)))
     LEFT JOIN ( SELECT count(article_tag.id) AS count,
            article_tag.tag_id
           FROM article_tag
          GROUP BY article_tag.tag_id) a2 ON ((tag.id = a2.tag_id)))
     LEFT JOIN ( SELECT max(article_tag.created_at) AS last_used,
            article_tag.tag_id
           FROM article_tag
          GROUP BY article_tag.tag_id) a3 ON ((tag.id = a3.tag_id)))
     LEFT JOIN ( SELECT tag_boost.boost,
            tag_boost.tag_id
           FROM tag_boost) b ON ((tag.id = b.tag_id)));

Columns

View Definition

Possibly Referenced Tables/Views