albums_labels

6 rows where label_id = 2

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2 2 2 2 Wisdom Teeth 2
1906 1906 1665 1665 Wisdom Teeth 2
2158 2158 1876 1876 Wisdom Teeth 2
3303 3303 2887 2887 Wisdom Teeth 2
29748 29748 26809 26809 Wisdom Teeth 2
30258 30258 27265 27265 Wisdom Teeth 2

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