home / pf

albums_labels

9 rows where label_id = 3612

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
18108 18108 16029 16029 Rapster 3612
18488 18488 16385 16385 Rapster 3612
20646 20646 18394 18394 Rapster 3612
20710 20710 18452 18452 Rapster 3612
22837 22837 20390 20390 Rapster 3612
25497 25497 22912 22912 Rapster 3612
25559 25559 22968 22968 Rapster 3612
25860 25860 23259 23259 Rapster 3612
27859 27859 25136 25136 Rapster 3612

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 64.028ms