reviews_authors

19 rows where author_id = 37

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
50 50 <em>Wane Into It</em> 50 Patrick Lyons 37
86 86 <em>We’re Not Here to Be Loved</em> 86 Patrick Lyons 37
298 298 <em>Dimensional Bleed</em> 298 Patrick Lyons 37
416 416 <em>They Fear Us</em> 416 Patrick Lyons 37
594 594 <em>Epicus Doomicus Metallicus</em> 594 Patrick Lyons 37
629 629 <em>The Loser</em> 629 Patrick Lyons 37
693 693 <em>Alpha Games</em> 693 Patrick Lyons 37
816 816 <em>Get Wet.Radio</em> 816 Patrick Lyons 37
986 986 <em>Dissolution Wave</em> 986 Patrick Lyons 37
1173 1173 <em>Christfucker</em> 1173 Patrick Lyons 37
1411 1411 <em>Infinite Granite</em> 1411 Patrick Lyons 37
1477 1477 <em>Wildhund</em> 1477 Patrick Lyons 37
25455 25455 <em>Fantasy</em>  25451 Patrick Lyons 37
25741 25741 <em>Systemic</em> 25737 Patrick Lyons 37
25833 25833 <em>A Pocket Full of Rain</em> 25829 Patrick Lyons 37
25867 25867 <em>Ontological Mysterium</em> 25863 Patrick Lyons 37
26096 26096 <em>Empty Country II</em> 26092 Patrick Lyons 37
26217 26217 <em>Obsidian Wreath</em> 26213 Patrick Lyons 37
26346 26346 <em>Come With Me If You Want to Live</em> 26342 Patrick Lyons 37

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)
);