reviews_authors

12 rows where author_id = 273

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
2573 2573 <em>До Свидания / Goodbye</em> 2573 NM Mashurov 273
2600 2600 <em>Fucking Hell</em> 2600 NM Mashurov 273
3671 3671 <em>Good Morning Cruel World</em> 3671 NM Mashurov 273
3862 3862 Personal Best / Captain My Captain / Choices, Chances, Changes: Singles &amp; Comptracks 1994-2000 3862 NM Mashurov 273
4030 4030 <em>Covert Contracts</em> 4030 NM Mashurov 273
4179 4179 <em>I Don’t Know How to Be Happy</em> 4179 NM Mashurov 273
5147 5147 <em>I Have Fought Against It, But I Can’t Any Longer.</em> 5147 NM Mashurov 273
5811 5811 <em>CCFX EP</em> 5811 NM Mashurov 273
6371 6371 <em>Life After Youth</em> 6371 NM Mashurov 273
6532 6532 <em>Mystic 100’s</em> 6532 NM Mashurov 273
6971 6971 <em>Flasher EP</em> 6971 NM Mashurov 273
7040 7040 <em>xxx</em> 7040 NM Mashurov 273

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