albums_labels

5 rows where label_id = 743

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1613 1613 1401 1401 Age 101 743
3253 3253 2846 2846 Age 101 743
4911 4911 4293 4293 Age 101 743
8126 8126 7077 7077 Age 101 743
9974 9974 8722 8722 Age 101 743

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