home / pf

albums_labels

7 rows where label_id = 593

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1139 1139 978 978 Tapete 593
4901 4901 4284 4284 Tapete 593
6787 6787 5915 5915 Tapete 593
8053 8053 7011 7011 Tapete 593
9290 9290 8124 8124 Tapete 593
18445 18445 16346 16346 Tapete 593
29264 29264 26392 26392 Tapete 593

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