albums_labels

12 rows where label_id = 2393

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
9202 9202 8047 8047 Rockathon 2393
16871 16871 14903 14903 Rockathon 2393
23430 23430 20948 20948 Rockathon 2393
24205 24205 21678 21678 Rockathon 2393
27155 27155 24483 24483 Rockathon 2393
27759 27759 25045 25045 Rockathon 2393
28096 28096 25355 25355 Rockathon 2393
28198 28198 25446 25446 Rockathon 2393
28295 28295 25535 25535 Rockathon 2393
28635 28635 25847 25847 Rockathon 2393
28999 28999 26173 26173 Rockathon 2393
29000 29000 26174 26174 Rockathon 2393

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