albums_labels

8 rows where label_id = 2423

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
9398 9398 8217 8217 Nacional 2423
19242 19242 17094 17094 Nacional 2423
19687 19687 17532 17532 Nacional 2423
19688 19688 17533 17533 Nacional 2423
19896 19896 17733 17733 Nacional 2423
19910 19910 17744 17744 Nacional 2423
20948 20948 18664 18664 Nacional 2423
22740 22740 20298 20298 Nacional 2423

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