albums_labels

6 rows where label_id = 699

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1482 1482 1284 1284 Cactus Jack 699
3473 3473 3034 3034 Cactus Jack 699
3762 3762 3283 3283 Cactus Jack 699
5468 5468 4760 4760 Cactus Jack 699
5741 5741 4996 4996 Cactus Jack 699
29806 29806 26861 26861 Cactus Jack 699

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