home / pf

albums_labels

6 rows where label_id = 2290

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
8574 8574 7477 7477 Shitkatapult 2290
15106 15106 13341 13341 Shitkatapult 2290
24507 24507 21964 21964 Shitkatapult 2290
25734 25734 23139 23139 Shitkatapult 2290
25822 25822 23226 23226 Shitkatapult 2290
26048 26048 23438 23438 Shitkatapult 2290

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