reviews_authors

12 rows where author_id = 411

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
6442 6442 <em>Whatever Makes U Happy</em> 6442 Elias Leight 411
6589 6589 <em>Samurai</em> 6589 Elias Leight 411
6618 6618 <em>Yours Conditionally</em> 6618 Elias Leight 411
6654 6654 <em>The Iceberg</em> 6654 Elias Leight 411
6664 6664 <em>Skin Companion EP II</em> 6664 Elias Leight 411
6684 6684 <em>The Chief</em> 6684 Elias Leight 411
6696 6696 <em>Araya EP</em> 6696 Elias Leight 411
6733 6733 <em>The Drum Chord Theory</em> 6733 Elias Leight 411
6744 6744 <em>Backlash</em> 6744 Elias Leight 411
6799 6799 <em>Three Stripes</em> 6799 Elias Leight 411
6808 6808 <em>Jardín</em> 6808 Elias Leight 411
6834 6834 Chixtape 4 / The New Toronto 2 6834 Elias Leight 411

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