home / pf

reviews_authors

19 rows where author_id = 330

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
4160 4160 <em>Rapture EP</em> 4160 Erin MacLeod 330
5527 5527 <em>Con Todo El Mundo</em> 5527 Erin MacLeod 330
6017 6017 <em>Afrobeat Hot Hits: New Urban Dance Grooves From Africa</em> 6017 Erin MacLeod 330
6188 6188 <em>Chronology</em> 6188 Erin MacLeod 330
6344 6344 <em>Mulatu Of Ethiopia</em> 6344 Erin MacLeod 330
6570 6570 <em>Room 29</em> 6570 Erin MacLeod 330
6715 6715 <em>Studio One Rocksteady 2: The Soul of Young Jamaica</em> 6715 Erin MacLeod 330
7194 7194 <em>We Are the Halluci Nation</em> 7194 Erin MacLeod 330
7421 7421 <em>Horror Zone</em> 7421 Erin MacLeod 330
7588 7588 <em>The Wailing Wailers</em> 7588 Erin MacLeod 330
7617 7617 <em>Ere Gobez</em> 7617 Erin MacLeod 330
7697 7697 <em>Junjo Presents: Wins the World Cup</em> 7697 Erin MacLeod 330
8568 8568 <em>Rastafari: The Dreads Enter Babylon, 1955-83</em> 8568 Erin MacLeod 330
10229 10229 <em>Soul Jazz Presents: Studio One Rocksteady</em> 10229 Erin MacLeod 330
10953 10953 <em>Mirror to the Soul: Music, Culture, and Identity in the Caribbean 1920-72</em> 10953 Erin MacLeod 330
11228 11228 <em>Young, Gifted &amp; Yellow</em> 11228 Erin MacLeod 330
12109 12109 <em>Rebirth</em> 12109 Erin MacLeod 330
12470 12470 <em>Harmony, Melody and Style: Lovers Rock and Rare Groove in the UK</em> 12470 Erin MacLeod 330
25860 25860 <em>Reset in Dub</em> 25856 Erin MacLeod 330

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