albums_labels

14 rows where label_id = 3648

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
18401 18401 16305 16305 Hidden Agenda 3648
18477 18477 16377 16377 Hidden Agenda 3648
23137 23137 20668 20668 Hidden Agenda 3648
24856 24856 22292 22292 Hidden Agenda 3648
25760 25760 23163 23163 Hidden Agenda 3648
25784 25784 23188 23188 Hidden Agenda 3648
26675 26675 24040 24040 Hidden Agenda 3648
26867 26867 24220 24220 Hidden Agenda 3648
26906 26906 24257 24257 Hidden Agenda 3648
27109 27109 24438 24438 Hidden Agenda 3648
27839 27839 25118 25118 Hidden Agenda 3648
27893 27893 25168 25168 Hidden Agenda 3648
28262 28262 25504 25504 Hidden Agenda 3648
28776 28776 25975 25975 Hidden Agenda 3648

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