albums_labels

12 rows where label_id = 344

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
555 555 465 465 The Null Corporation 344
3418 3418 2989 2989 The Null Corporation 344
3419 3419 2990 2990 The Null Corporation 344
3740 3740 3261 3261 The Null Corporation 344
5114 5114 4472 4472 The Null Corporation 344
5904 5904 5147 5147 The Null Corporation 344
7284 7284 6336 6336 The Null Corporation 344
8106 8106 7060 7060 The Null Corporation 344
8107 8107 7061 7061 The Null Corporation 344
15092 15092 13327 13327 The Null Corporation 344
17224 17224 15222 15222 The Null Corporation 344
20167 20167 17964 17964 The Null Corporation 344

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