albums_labels

10 rows where label_id = 348

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
565 565 473 473 Dine Alone 348
3420 3420 2991 2991 Dine Alone 348
3696 3696 3222 3222 Dine Alone 348
4122 4122 3611 3611 Dine Alone 348
5084 5084 4444 4444 Dine Alone 348
5626 5626 4896 4896 Dine Alone 348
9447 9447 8261 8261 Dine Alone 348
9875 9875 8637 8637 Dine Alone 348
10410 10410 9107 9107 Dine Alone 348
10781 10781 9435 9435 Dine Alone 348

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