albums_labels

10 rows where label_id = 1056

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2647 2647 2308 2308 Grand Hustle 1056
5459 5459 4755 4755 Grand Hustle 1056
5603 5603 4878 4878 Grand Hustle 1056
8114 8114 7068 7068 Grand Hustle 1056
9995 9995 8742 8742 Grand Hustle 1056
10200 10200 8925 8925 Grand Hustle 1056
11242 11242 9835 9835 Grand Hustle 1056
13743 13743 12106 12106 Grand Hustle 1056
17349 17349 15328 15328 Grand Hustle 1056
21187 21187 18885 18885 Grand Hustle 1056

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