home / pf

albums_labels

17 rows where label_id = 3554

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
17625 17625 15573 15573 Mego 3554
21890 21890 19520 19520 Mego 3554
24669 24669 22114 22114 Mego 3554
25088 25088 22520 22520 Mego 3554
25554 25554 22963 22963 Mego 3554
25664 25664 23070 23070 Mego 3554
26102 26102 23490 23490 Mego 3554
26827 26827 24183 24183 Mego 3554
26836 26836 24191 24191 Mego 3554
26982 26982 24327 24327 Mego 3554
26999 26999 24341 24341 Mego 3554
27126 27126 24454 24454 Mego 3554
27191 27191 24514 24514 Mego 3554
27213 27213 24535 24535 Mego 3554
27913 27913 25187 25187 Mego 3554
28307 28307 25547 25547 Mego 3554
28736 28736 25939 25939 Mego 3554

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)
);
Powered by Datasette · Queries took 56.332ms