home / pf

reviews_authors

17 rows where author_id = 97

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
189 189 <em>Rolling Golden Holy</em> 189 Amanda Wicks 97
732 732 <em>Break Me Open</em> 732 Amanda Wicks 97
1836 1836 <em>Head of Roses</em> 1836 Amanda Wicks 97
2083 2083 <em>Plastic Bouquet</em> 2083 Amanda Wicks 97
2398 2398 <em>Western Swing &amp; Waltzes and Other Punchy Songs</em> 2398 Amanda Wicks 97
3201 3201 <em>New Ways</em> 3201 Amanda Wicks 97
3511 3511 <em>Karaoke Angel</em> 3511 Amanda Wicks 97
4206 4206 <em>American Love Call</em> 4206 Amanda Wicks 97
4299 4299 <em>True North</em> 4299 Amanda Wicks 97
4388 4388 <em>Starter Home</em> 4388 Amanda Wicks 97
4618 4618 <em>Songs of the Plains</em> 4618 Amanda Wicks 97
4698 4698 <em>Magic Ship</em> 4698 Amanda Wicks 97
4728 4728 <em>My New Moon</em> 4728 Amanda Wicks 97
5058 5058 <em>Lightlessness Is Nothing New</em> 5058 Amanda Wicks 97
25779 25779 <em>Little Songs</em> 25775 Amanda Wicks 97
25859 25859 <em>You’re the One</em> 25855 Amanda Wicks 97
26368 26368 <em>Bite Down</em> 26364 Amanda Wicks 97

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 59.676ms