home / pf

reviews_authors

34 rows where author_id = 55

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
83 83 <em>An Orange Colored Day</em> 83 Vrinda Jagota 55
290 290 <em>Jingul</em> 290 Vrinda Jagota 55
497 497 <em>The Essential Asha Puthli</em> 497 Vrinda Jagota 55
569 569 <em>19 Masters</em> 569 Vrinda Jagota 55
657 657 <em>Monologues</em> EP 657 Vrinda Jagota 55
1032 1032 <em>The Intifada 1987</em> 1032 Vrinda Jagota 55
1144 1144 <em>DEACON’S Grove EP</em> 1144 Vrinda Jagota 55
1507 1507 <em>TEMPORARY HIGHS IN THE VIOLET SKIES</em> 1507 Vrinda Jagota 55
1624 1624 <em>Bombay</em> 1624 Vrinda Jagota 55
1680 1680 <em>WINK</em> 1680 Vrinda Jagota 55
1981 1981 <em>With the Shifts</em> 1981 Vrinda Jagota 55
2114 2114 <em>Feeling Lucky? EP</em> 2114 Vrinda Jagota 55
2155 2155 <em>Copycat Killer</em> EP 2155 Vrinda Jagota 55
2420 2420 <em>The Room</em> 2420 Vrinda Jagota 55
2688 2688 <em>Meditations Mixtape, Vol. 1</em> 2688 Vrinda Jagota 55
2919 2919 <em>The Caretaker</em> 2919 Vrinda Jagota 55
2956 2956 <em>Oasis Nocturno</em> 2956 Vrinda Jagota 55
3250 3250 <em>Blood Transfusion EP</em> 3250 Vrinda Jagota 55
3350 3350 <em>Supermoon EP</em> 3350 Vrinda Jagota 55
3594 3594 <em>Anak Ko</em> 3594 Vrinda Jagota 55
3628 3628 <em>1989</em> 3628 Vrinda Jagota 55
3774 3774 <em>Bird Songs of a Killjoy</em> 3774 Vrinda Jagota 55
4005 4005 <em>Itekoma Hits</em> 4005 Vrinda Jagota 55
4089 4089 <em>Thalassa</em> 4089 Vrinda Jagota 55
4378 4378 <em>first bloom</em> 4378 Vrinda Jagota 55
4547 4547 <em>Alone at Last</em> 4547 Vrinda Jagota 55
4598 4598 <em>First Flower</em> 4598 Vrinda Jagota 55
5338 5338 <em>Cardamom Garden EP</em> 5338 Vrinda Jagota 55
5756 5756 <em>Backwater</em> 5756 Vrinda Jagota 55
6069 6069 <em>Elastic</em> 6069 Vrinda Jagota 55
25763 25763 <em>Speak Now (Taylor’s Version)</em> 25759 Vrinda Jagota 55
25970 25970 <em>Heaven</em> 25966 Vrinda Jagota 55
26007 26007 <em>So Far So Good</em> 26003 Vrinda Jagota 55
26138 26138 <em>Santhosam</em> 26134 Vrinda Jagota 55

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