home / pf

albums_labels

6 rows where label_id = 3407

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
16574 16574 14638 14638 Monika 3407
19207 19207 17060 17060 Monika 3407
21083 21083 18790 18790 Monika 3407
21610 21610 19268 19268 Monika 3407
22584 22584 20158 20158 Monika 3407
26627 26627 23994 23994 Monika 3407

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