reviews_authors

23 rows where author_id = 59

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
91 91 <em>How the Light Felt</em>  91 Jude Noel 59
247 247 <em>Tyrannical Vibes</em>  247 Jude Noel 59
322 322 <em>Whipped Stream and Other Earthly Delights</em>  322 Jude Noel 59
433 433 <em>Freewave Lucifer f&lt;ck f^ck f&gt;ck</em> 433 Jude Noel 59
456 456 <em>High Reality</em> 456 Jude Noel 59
475 475 <em>Spider Season</em> 475 Jude Noel 59
562 562 <em>Revelators</em> 562 Jude Noel 59
582 582 <em>Magic Pony Ride</em> 582 Jude Noel 59
716 716 <em>192</em> 716 Jude Noel 59
734 734 <em>Don’t Wait for a Sign</em> 734 Jude Noel 59
798 798 <em>Mr Mixondo</em> 798 Jude Noel 59
939 939 <em>Ngbaka</em> EP 939 Jude Noel 59
25305 25305 <em>Surgery Channel</em> 25301 Jude Noel 59
25323 25323 <em>Letters to George</em> 25319 Jude Noel 59
25471 25471 <em>The Town That Cursed Your Name</em> 25467 Jude Noel 59
25590 25590 <em>Bird Hour</em> 25586 Jude Noel 59
25591 25591 <em>Short Term Agreement</em> 25587 Jude Noel 59
25664 25664 <em>Bunny</em> 25660 Jude Noel 59
25847 25847 <em>Crazy Trip EP</em> 25843 Jude Noel 59
26053 26053 <em>Hold</em> 26049 Jude Noel 59
26109 26109 <em>Uchigawa Tankentai EP</em> 26105 Jude Noel 59
26204 26204 <em>Slime Patrol 2</em> 26200 Jude Noel 59
26340 26340 <em>Unleash</em> 26336 Jude Noel 59

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE reviews_authors (
	review_id integer NOT NULL,
	author_id integer NOT NULL,
	FOREIGN KEY(review_id) REFERENCES reviews(id),
	FOREIGN KEY(author_id) REFERENCES authors(id),
	UNIQUE(review_id,author_id)
);