albums_labels

5 rows where label_id = 235

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
349 349 299 299 Young 235
1218 1218 1050 1050 Young 235
1802 1802 1573 1573 Young 235
29930 29930 26968 26968 Young 235
30091 30091 27113 27113 Young 235

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