blog_post_tags
4 rows where tag_hash = "5381debf35"
This data as json, CSV (advanced)
Link | blog_post_hash | tag_hash |
---|---|---|
18863fcd53,5381debf35 | How-to: Use QVBR for streaming live events like the 2018 AWS re:Invent keynotes 18863fcd53 | non-profit 5381debf35 |
7c1fa11a58,5381debf35 | eBook | Accelerate your media workflows using AWS solutions 7c1fa11a58 | non-profit 5381debf35 |
97ee0f9f2b,5381debf35 | Using speech-to-text for media captioning and metadata generation 97ee0f9f2b | non-profit 5381debf35 |
bf9dd14cda,5381debf35 | Sky: Something new at the royal wedding bf9dd14cda | non-profit 5381debf35 |
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]);