albums_labels

7 rows where label_id = 202

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
284 284 246 246 Hopeless 202
1515 1515 1313 1313 Hopeless 202
1666 1666 1449 1449 Hopeless 202
6255 6255 5446 5446 Hopeless 202
26570 26570 23937 23937 Hopeless 202
27504 27504 24808 24808 Hopeless 202
27999 27999 25268 25268 Hopeless 202

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