albums_labels

22 rows where label_id = 310

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
493 493 416 416 Exploding in Sound 310
694 694 584 584 Exploding in Sound 310
1333 1333 1147 1147 Exploding in Sound 310
2079 2079 1810 1810 Exploding in Sound 310
2187 2187 1903 1903 Exploding in Sound 310
2215 2215 1928 1928 Exploding in Sound 310
2333 2333 2029 2029 Exploding in Sound 310
2844 2844 2480 2480 Exploding in Sound 310
3276 3276 2865 2865 Exploding in Sound 310
3742 3742 3263 3263 Exploding in Sound 310
4680 4680 4086 4086 Exploding in Sound 310
5800 5800 5052 5052 Exploding in Sound 310
6186 6186 5383 5383 Exploding in Sound 310
7192 7192 6259 6259 Exploding in Sound 310
7767 7767 6761 6761 Exploding in Sound 310
9376 9376 8197 8197 Exploding in Sound 310
9486 9486 8296 8296 Exploding in Sound 310
10149 10149 8879 8879 Exploding in Sound 310
10824 10824 9473 9473 Exploding in Sound 310
10874 10874 9519 9519 Exploding in Sound 310
29289 29289 26417 26417 Exploding in Sound 310
29918 29918 26956 26956 Exploding in Sound 310

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