albums_labels

8 rows where label_id = 1337

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3769 3769 3290 3290 Flightless 1337
4257 4257 3723 3723 Flightless 1337
4590 4590 4006 4006 Flightless 1337
4708 4708 4108 4108 Flightless 1337
6607 6607 5749 5749 Flightless 1337
7120 7120 6201 6201 Flightless 1337
7915 7915 6888 6888 Flightless 1337
11073 11073 9689 9689 Flightless 1337

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