home / pf

reviews_authors

20 rows where author_id = 494

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
11095 11095 <em>Once I Was an Eagle</em> 11095 Rachael Maddux 494
11369 11369 <em>Child Ballads</em> 11369 Rachael Maddux 494
11502 11502 <em>Pedestrian Verse</em> 11502 Rachael Maddux 494
11904 11904 <em>Deer Creek Canyon</em> 11904 Rachael Maddux 494
11925 11925 <em>Incorruptible Heart</em> 11925 Rachael Maddux 494
11969 11969 <em>The Carpenter</em> 11969 Rachael Maddux 494
12047 12047 <em>Just Tell Me That You Want Me: Tribute to Fleetwood Mac</em> 12047 Rachael Maddux 494
12141 12141 <em>Woody at 100: The Woody Guthrie Centennial Collection</em> 12141 Rachael Maddux 494
12253 12253 <em>Blood Speaks</em> 12253 Rachael Maddux 494
12288 12288 <em>A Monument</em> 12288 Rachael Maddux 494
12467 12467 <em>A Wasteland Companion</em> 12467 Rachael Maddux 494
12472 12472 <em>Boys &amp; Girls</em> 12472 Rachael Maddux 494
12510 12510 <em>Illusion EP</em> 12510 Rachael Maddux 494
12534 12534 <em>Leaving Atlanta</em> 12534 Rachael Maddux 494
12717 12717 <em>Tramp</em> 12717 Rachael Maddux 494
12730 12730 <em>Hospitality</em> 12730 Rachael Maddux 494
12739 12739 <em>The Lion's Roar</em> 12739 Rachael Maddux 494
12804 12804 <em>I Want What You Want</em> 12804 Rachael Maddux 494
12957 12957 <em>Long Live the King EP</em> 12957 Rachael Maddux 494
12997 12997 <em>Norman OST</em> 12997 Rachael Maddux 494

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)
);
Powered by Datasette · Queries took 62.947ms