albums_labels

12 rows where label_id = 1257

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3447 3447 3013 3013 Bedroom Community 1257
7213 7213 6277 6277 Bedroom Community 1257
7659 7659 6669 6669 Bedroom Community 1257
8144 8144 7094 7094 Bedroom Community 1257
11824 11824 10348 10348 Bedroom Community 1257
13830 13830 12186 12186 Bedroom Community 1257
14078 14078 12407 12407 Bedroom Community 1257
17449 17449 15414 15414 Bedroom Community 1257
17640 17640 15587 15587 Bedroom Community 1257
17856 17856 15791 15791 Bedroom Community 1257
19611 19611 17458 17458 Bedroom Community 1257
20387 20387 18156 18156 Bedroom Community 1257

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