albums_labels

11 rows where label_id = 1151

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3017 3017 2640 2640 Big Beat 1151
5926 5926 5167 5167 Big Beat 1151
11821 11821 10346 10346 Big Beat 1151
11896 11896 10410 10410 Big Beat 1151
12116 12116 10608 10608 Big Beat 1151
12718 12718 11166 11166 Big Beat 1151
14009 14009 12345 12345 Big Beat 1151
15695 15695 13856 13856 Big Beat 1151
16081 16081 14199 14199 Big Beat 1151
22191 22191 19801 19801 Big Beat 1151
22580 22580 20154 20154 Big Beat 1151

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