albums_labels

10 rows where label_id = 598

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1146 1146 985 985 Young Stoner Life 598
1224 1224 1055 1055 Young Stoner Life 598
2071 2071 1804 1804 Young Stoner Life 598
3197 3197 2796 2796 Young Stoner Life 598
4485 4485 3916 3916 Young Stoner Life 598
4948 4948 4325 4325 Young Stoner Life 598
5462 5462 4756 4756 Young Stoner Life 598
5674 5674 4939 4939 Young Stoner Life 598
29695 29695 26766 26766 Young Stoner Life 598
29716 29716 26783 26783 Young Stoner Life 598

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