home / pf

reviews_authors

27 rows where author_id = 99

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
195 195 <em>Anywhere But Here</em> 195 Aimee Cliff 99
214 214 <em>Hysteria</em> 214 Aimee Cliff 99
531 531 <em>MUNA</em> 531 Aimee Cliff 99
709 709 <em>Two Ribbons</em> 709 Aimee Cliff 99
2305 2305 <em>Personal History</em> 2305 Aimee Cliff 99
2341 2341 <em>Hyper Romance</em> 2341 Aimee Cliff 99
2400 2400 <em>Ten Billion Angels</em> 2400 Aimee Cliff 99
2645 2645 <em>Women in Music Pt. III</em> 2645 Aimee Cliff 99
2754 2754 <em>Hair of the Dog</em> 2754 Aimee Cliff 99
2779 2779 <em>Drop 6 EP</em> 2779 Aimee Cliff 99
2804 2804 <em>Frozen</em> 2804 Aimee Cliff 99
2866 2866 <em>In Another Life</em> 2866 Aimee Cliff 99
2880 2880 <em>Jacqueline</em> 2880 Aimee Cliff 99
2887 2887 <em>Friday Forever</em> 2887 Aimee Cliff 99
2900 2900 <em>If You’re Dreaming</em> 2900 Aimee Cliff 99
2903 2903 <em>925</em> 2903 Aimee Cliff 99
2994 2994 <em>Ceremony</em> 2994 Aimee Cliff 99
3152 3152 <em>Everything Else Has Gone Wrong</em> 3152 Aimee Cliff 99
3195 3195 <em>Walking Like We Do</em> 3195 Aimee Cliff 99
3497 3497 <em>Hey, I’m Just Like You</em> 3497 Aimee Cliff 99
3533 3533 <em>Metronomy Forever</em> 3533 Aimee Cliff 99
3638 3638 <em>forevher</em> 3638 Aimee Cliff 99
3931 3931 <em>Spice</em> 3931 Aimee Cliff 99
25345 25345 <em>My 21st Century Blues</em> 25341 Aimee Cliff 99
25916 25916 <em>Mid Air</em> 25912 Aimee Cliff 99
25975 25975 <em>Falling or Flying</em> 25971 Aimee Cliff 99
26335 26335 <em>Where’s My Utopia?</em> 26331 Aimee Cliff 99

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