albums_labels

6 rows where label_id = 3242

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
15253 15253 13476 13476 Hybris 3242
18553 18553 16446 16446 Hybris 3242
19767 19767 17611 17611 Hybris 3242
21318 21318 19004 19004 Hybris 3242
22215 22215 19823 19823 Hybris 3242
22445 22445 20029 20029 Hybris 3242

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