albums_labels

8 rows where label_id = 261

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
394 394 335 335 Palilalia 261
2162 2162 1880 1880 Palilalia 261
4041 4041 3538 3538 Palilalia 261
5212 5212 4548 4548 Palilalia 261
7378 7378 6416 6416 Palilalia 261
13149 13149 11559 11559 Palilalia 261
14187 14187 12512 12512 Palilalia 261
29523 29523 26619 26619 Palilalia 261

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