albums_labels

7 rows where label_id = 3026

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
13618 13618 11993 11993 Мишка 3026
13716 13716 12082 12082 Мишка 3026
13846 13846 12202 12202 Мишка 3026
14666 14666 12953 12953 Мишка 3026
14894 14894 13150 13150 Мишка 3026
15449 15449 13650 13650 Мишка 3026
17140 17140 15149 15149 Мишка 3026

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