home / pf

reviews_authors

25 rows where author_id = 341

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
4407 4407 <em>Distancing</em> 4407 Calum Marsh 341
4465 4465 <em>“Ouch”</em> 4465 Calum Marsh 341
4517 4517 <em>Poison Ivy</em> 4517 Calum Marsh 341
4605 4605 <em>The Light Is Leaving Us All</em> 4605 Calum Marsh 341
4878 4878 <em>Bringing the Backline</em> 4878 Calum Marsh 341
4943 4943 <em>Pale Lemon</em> 4943 Calum Marsh 341
5138 5138 <em>Violet Psalms</em> 5138 Calum Marsh 341
5325 5325 <em>Isle of Dogs (Original Soundtrack)</em> 5325 Calum Marsh 341
5345 5345 <em>Longwave</em> 5345 Calum Marsh 341
5377 5377 <em>LONER</em> 5377 Calum Marsh 341
5497 5497 <em>Rock Island</em> 5497 Calum Marsh 341
5547 5547 <em>Beautiful Despair</em> 5547 Calum Marsh 341
5551 5551 <em>Digital Rain</em> 5551 Calum Marsh 341
5641 5641 <em>Tribute To 2</em> 5641 Calum Marsh 341
5678 5678 <em>Songs of Experience</em> 5678 Calum Marsh 341
5727 5727 <em>Introduce Yerself</em> 5727 Calum Marsh 341
5762 5762 <em>Do You Mind EP</em> 5762 Calum Marsh 341
5766 5766 <em>Tokorats</em> 5766 Calum Marsh 341
5818 5818 <em>Anthology: Movie Themes 1974-1998</em> 5818 Calum Marsh 341
5992 5992 <em>Twin Peaks (Music From the Limited Event Series)</em> 5992 Calum Marsh 341
6055 6055 <em>Across the Multiverse</em> 6055 Calum Marsh 341
6068 6068 <em>Last Chance</em> 6068 Calum Marsh 341
6178 6178 <em>Lifetime of Love</em> 6178 Calum Marsh 341
6220 6220 <em>Moonlight (Original Motion Picture Soundtrack)</em> 6220 Calum Marsh 341
6285 6285 <em>The Age of Anxiety</em> 6285 Calum Marsh 341

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