albums_labels

19 rows where label_id = 2904

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
12572 12572 11029 11029 Hippos in Tanks 2904
13195 13195 11603 11603 Hippos in Tanks 2904
13325 13325 11725 11725 Hippos in Tanks 2904
13390 13390 11783 11783 Hippos in Tanks 2904
13777 13777 12138 12138 Hippos in Tanks 2904
13839 13839 12195 12195 Hippos in Tanks 2904
14344 14344 12665 12665 Hippos in Tanks 2904
14386 14386 12705 12705 Hippos in Tanks 2904
14421 14421 12738 12738 Hippos in Tanks 2904
14500 14500 12807 12807 Hippos in Tanks 2904
14834 14834 13104 13104 Hippos in Tanks 2904
15302 15302 13515 13515 Hippos in Tanks 2904
15428 15428 13631 13631 Hippos in Tanks 2904
15657 15657 13822 13822 Hippos in Tanks 2904
15799 15799 13948 13948 Hippos in Tanks 2904
15956 15956 14087 14087 Hippos in Tanks 2904
16226 16226 14327 14327 Hippos in Tanks 2904
16538 16538 14606 14606 Hippos in Tanks 2904
16648 16648 14698 14698 Hippos in Tanks 2904

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