home / pf

albums_labels

6 rows where label_id = 4466

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
24012 24012 21499 21499 Mo'Wax 4466
25755 25755 23159 23159 Mo'Wax 4466
25909 25909 23306 23306 Mo'Wax 4466
27755 27755 25041 25041 Mo'Wax 4466
27841 27841 25119 25119 Mo'Wax 4466
27974 27974 25245 25245 Mo'Wax 4466

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