albums_labels

4 rows where label_id = 717

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1537 1537 1332 1332 Little Tokyo 717
5366 5366 4672 4672 Little Tokyo 717
8747 8747 7630 7630 Little Tokyo 717
10483 10483 9174 9174 Little Tokyo 717

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