albums_labels

8 rows where label_id = 1741

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
5677 5677 4941 4941 Counter 1741
7076 7076 6163 6163 Counter 1741
9381 9381 8201 8201 Counter 1741
16141 16141 14253 14253 Counter 1741
18732 18732 16613 16613 Counter 1741
19322 19322 17174 17174 Counter 1741
19882 19882 17719 17719 Counter 1741
21846 21846 19481 19481 Counter 1741

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