albums_labels

7 rows where label_id = 12

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
17 17 17 17 Forever Living Originals 12
882 882 754 754 Forever Living Originals 12
1822 1822 1596 1596 Forever Living Originals 12
2454 2454 2138 2138 Forever Living Originals 12
2455 2455 2139 2139 Forever Living Originals 12
29991 29991 27022 27022 Forever Living Originals 12
30354 30354 27352 27352 Forever Living Originals 12

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