albums_labels

5 rows where label_id = 3121

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
14376 14376 12695 12695 Edsel 3121
14377 14377 12696 12696 Edsel 3121
14378 14378 12697 12697 Edsel 3121
14379 14379 12698 12698 Edsel 3121
24843 24843 22279 22279 Edsel 3121

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