albums_labels

8 rows where label_id = 1383

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3931 3931 3435 3435 Mixpak 1383
5803 5803 5055 5055 Mixpak 1383
6212 6212 5408 5408 Mixpak 1383
7458 7458 6488 6488 Mixpak 1383
8395 8395 7312 7312 Mixpak 1383
8940 8940 7806 7806 Mixpak 1383
11780 11780 10312 10312 Mixpak 1383
15756 15756 13910 13910 Mixpak 1383

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