blog_post_tags
8 rows where blog_post_hash = "038e851a4c"
This data as json, CSV (advanced)
Link | blog_post_hash | tag_hash |
---|---|---|
038e851a4c,0dcb092a8e | Architecture Monthly Magazine: Genomics 038e851a4c | Blog Post 0dcb092a8e |
038e851a4c,12dca648d3 | Architecture Monthly Magazine: Genomics 038e851a4c | Life Sciences 12dca648d3 |
038e851a4c,237dc128b2 | Architecture Monthly Magazine: Genomics 038e851a4c | architecture 237dc128b2 |
038e851a4c,330681aa0c | Architecture Monthly Magazine: Genomics 038e851a4c | industries 330681aa0c |
038e851a4c,783d724325 | Architecture Monthly Magazine: Genomics 038e851a4c | life-sciences 783d724325 |
038e851a4c,91f09fc738 | Architecture Monthly Magazine: Genomics 038e851a4c | Healthcare 91f09fc738 |
038e851a4c,abcd9a0b94 | Architecture Monthly Magazine: Genomics 038e851a4c | healthcare abcd9a0b94 |
038e851a4c,ee1fd0749d | Architecture Monthly Magazine: Genomics 038e851a4c | genomics ee1fd0749d |
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]);