blog_post_tags
5 rows where blog_post_hash = "7aa10213f4"
This data as json, CSV (advanced)
Link | blog_post_hash | tag_hash |
---|---|---|
7aa10213f4,0dcb092a8e | Making Developers’ Lives Easier with GitLab VP Brandon Jung 7aa10213f4 | Blog Post 0dcb092a8e |
7aa10213f4,2999dcd334 | Making Developers’ Lives Easier with GitLab VP Brandon Jung 7aa10213f4 | company-profile 2999dcd334 |
7aa10213f4,6283e6d28d | Making Developers’ Lives Easier with GitLab VP Brandon Jung 7aa10213f4 | General Startup 6283e6d28d |
7aa10213f4,63d28acde9 | Making Developers’ Lives Easier with GitLab VP Brandon Jung 7aa10213f4 | developer-tools 63d28acde9 |
7aa10213f4,8ef48176ec | Making Developers’ Lives Easier with GitLab VP Brandon Jung 7aa10213f4 | startup 8ef48176ec |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "blog_post_tags" ( [blog_post_hash] TEXT REFERENCES [blog_posts]([hash]), [tag_hash] TEXT REFERENCES [tags]([hash]), PRIMARY KEY ([blog_post_hash], [tag_hash]) ); CREATE INDEX [idx_blog_post_tags_tag_hash] ON [blog_post_tags] ([tag_hash]); CREATE INDEX [idx_blog_post_tags_blog_post_hash] ON [blog_post_tags] ([blog_post_hash]);