albums_labels

26 rows where label_id = 290

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
450 450 383 383 Alamo 290
682 682 573 573 Alamo 290
1022 1022 874 874 Alamo 290
1892 1892 1653 1653 Alamo 290
1910 1910 1667 1667 Alamo 290
2858 2858 2494 2494 Alamo 290
2875 2875 2508 2508 Alamo 290
3249 3249 2842 2842 Alamo 290
3389 3389 2963 2963 Alamo 290
3838 3838 3353 3353 Alamo 290
3917 3917 3423 3423 Alamo 290
4325 4325 3776 3776 Alamo 290
4718 4718 4118 4118 Alamo 290
4860 4860 4247 4247 Alamo 290
5612 5612 4885 4885 Alamo 290
5859 5859 5107 5107 Alamo 290
6193 6193 5390 5390 Alamo 290
6351 6351 5534 5534 Alamo 290
6728 6728 5860 5860 Alamo 290
6953 6953 6051 6051 Alamo 290
7222 7222 6285 6285 Alamo 290
29194 29194 26334 26334 Alamo 290
29616 29616 26697 26697 Alamo 290
29640 29640 26718 26718 Alamo 290
29759 29759 26820 26820 Alamo 290
30421 30421 27412 27412 Alamo 290

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