albums_labels

8 rows where label_id = 1697

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
5391 5391 4696 4696 Konichiwa 1697
10192 10192 8918 8918 Konichiwa 1697
10440 10440 9135 9135 Konichiwa 1697
16562 16562 14627 14627 Konichiwa 1697
16912 16912 14937 14937 Konichiwa 1697
17276 17276 15268 15268 Konichiwa 1697
21983 21983 19608 19608 Konichiwa 1697
23572 23572 21084 21084 Konichiwa 1697

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