albums_labels

15 rows where label_id = 3394

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
16433 16433 14510 14510 Parasol 3394
20158 20158 17957 17957 Parasol 3394
21833 21833 19469 19469 Parasol 3394
23795 23795 21291 21291 Parasol 3394
23983 23983 21470 21470 Parasol 3394
25309 25309 22732 22732 Parasol 3394
27063 27063 24400 24400 Parasol 3394
27070 27070 24406 24406 Parasol 3394
27082 27082 24415 24415 Parasol 3394
27108 27108 24438 24438 Parasol 3394
27184 27184 24508 24508 Parasol 3394
28261 28261 25504 25504 Parasol 3394
28629 28629 25841 25841 Parasol 3394
28721 28721 25925 25925 Parasol 3394
29123 29123 26272 26272 Parasol 3394

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