albums_labels

4 rows where label_id = 1014

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2493 2493 2175 2175 Delicious Vinyl 1014
12581 12581 11038 11038 Delicious Vinyl 1014
14576 14576 12875 12875 Delicious Vinyl 1014
19278 19278 17130 17130 Delicious Vinyl 1014

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE albums_labels (
	album_id integer NOT NULL,
	label_id integer NOT NULL,
	FOREIGN KEY(album_id) REFERENCES albums(id),
	FOREIGN KEY(label_id) REFERENCES labels(id),
	UNIQUE(album_id,label_id)
);