albums_labels

7 rows where label_id = 146

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
178 178 154 154 Play It Again Sam 146
7649 7649 6660 6660 Play It Again Sam 146
7736 7736 6732 6732 Play It Again Sam 146
8475 8475 7387 7387 Play It Again Sam 146
8856 8856 7731 7731 Play It Again Sam 146
9405 9405 8222 8222 Play It Again Sam 146
29703 29703 26771 26771 Play It Again Sam 146

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