albums_labels

5 rows where label_id = 1244

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3391 3391 2964 2964 Static Shock 1244
3675 3675 3207 3207 Static Shock 1244
8119 8119 7072 7072 Static Shock 1244
9369 9369 8192 8192 Static Shock 1244
11567 11567 10119 10119 Static Shock 1244

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