albums_labels

6 rows where label_id = 249

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
371 371 316 316 DDS 249
1190 1190 1023 1023 DDS 249
2991 2991 2616 2616 DDS 249
5560 5560 4840 4840 DDS 249
6744 6744 5874 5874 DDS 249
7493 7493 6520 6520 DDS 249

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