albums_labels

6 rows where label_id = 4282

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
22405 22405 19993 19993 Chicks on Speed 4282
22700 22700 20261 20261 Chicks on Speed 4282
24223 24223 21694 21694 Chicks on Speed 4282
25533 25533 22944 22944 Chicks on Speed 4282
25624 25624 23031 23031 Chicks on Speed 4282
27636 27636 24932 24932 Chicks on Speed 4282

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