albums_labels

8 rows where label_id = 704

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1496 1496 1296 1296 London 704
6760 6760 5889 5889 London 704
7405 7405 6440 6440 London 704
23315 23315 20842 20842 London 704
28026 28026 25291 25291 London 704
28740 28740 25941 25941 London 704
28833 28833 26026 26026 London 704
29728 29728 26793 26793 London 704

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)
);