albums_labels

7 rows where label_id = 496

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
892 892 763 763 2 B Real  496
2908 2908 2537 2537 2 B Real  496
3207 3207 2805 2805 2 B Real  496
5076 5076 4437 4437 2 B Real  496
8244 8244 7183 7183 2 B Real  496
8265 8265 7203 7203 2 B Real  496
12012 12012 10514 10514 2 B Real  496

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