albums_genres
278 rows where genre_id = 9
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | genre_id |
|---|---|---|---|
| 871 | 871 | 785 785 | 9 9 |
| 928 | 928 | 842 842 | 9 9 |
| 1089 | 1089 | 984 984 | 9 9 |
| 1154 | 1154 | 1043 1043 | 9 9 |
| 1157 | 1157 | 1045 1045 | 9 9 |
| 1218 | 1218 | 1095 1095 | 9 9 |
| 1323 | 1323 | 1191 1191 | 9 9 |
| 1508 | 1508 | 1363 1363 | 9 9 |
| 1559 | 1559 | 1410 1410 | 9 9 |
| 1607 | 1607 | 1453 1453 | 9 9 |
| 1757 | 1757 | 1592 1592 | 9 9 |
| 2231 | 2231 | 2010 2010 | 9 9 |
| 2745 | 2745 | 2471 2471 | 9 9 |
| 2759 | 2759 | 2482 2482 | 9 9 |
| 2793 | 2793 | 2512 2512 | 9 9 |
| 2807 | 2807 | 2523 2523 | 9 9 |
| 2817 | 2817 | 2532 2532 | 9 9 |
| 3217 | 3217 | 2896 2896 | 9 9 |
| 3311 | 3311 | 2986 2986 | 9 9 |
| 3350 | 3350 | 3024 3024 | 9 9 |
| 3517 | 3517 | 3172 3172 | 9 9 |
| 3606 | 3606 | 3257 3257 | 9 9 |
| 3618 | 3618 | 3268 3268 | 9 9 |
| 3873 | 3873 | 3509 3509 | 9 9 |
| 4354 | 4354 | 3969 3969 | 9 9 |
| 4374 | 4374 | 3986 3986 | 9 9 |
| 4377 | 4377 | 3989 3989 | 9 9 |
| 4479 | 4479 | 4088 4088 | 9 9 |
| 5040 | 5040 | 4627 4627 | 9 9 |
| 5332 | 5332 | 4899 4899 | 9 9 |
| 5352 | 5352 | 4919 4919 | 9 9 |
| 5361 | 5361 | 4929 4929 | 9 9 |
| 5378 | 5378 | 4946 4946 | 9 9 |
| 5400 | 5400 | 4967 4967 | 9 9 |
| 5486 | 5486 | 5055 5055 | 9 9 |
| 5503 | 5503 | 5071 5071 | 9 9 |
| 5775 | 5775 | 5335 5335 | 9 9 |
| 6041 | 6041 | 5602 5602 | 9 9 |
| 6247 | 6247 | 5805 5805 | 9 9 |
| 6539 | 6539 | 6095 6095 | 9 9 |
| 6666 | 6666 | 6216 6216 | 9 9 |
| 6840 | 6840 | 6390 6390 | 9 9 |
| 6880 | 6880 | 6430 6430 | 9 9 |
| 6894 | 6894 | 6443 6443 | 9 9 |
| 6950 | 6950 | 6493 6493 | 9 9 |
| 6957 | 6957 | 6499 6499 | 9 9 |
| 6967 | 6967 | 6506 6506 | 9 9 |
| 6970 | 6970 | 6509 6509 | 9 9 |
| 7006 | 7006 | 6542 6542 | 9 9 |
| 7012 | 7012 | 6546 6546 | 9 9 |
| 7047 | 7047 | 6578 6578 | 9 9 |
| 7216 | 7216 | 6744 6744 | 9 9 |
| 7236 | 7236 | 6759 6759 | 9 9 |
| 7287 | 7287 | 6807 6807 | 9 9 |
| 7297 | 7297 | 6817 6817 | 9 9 |
| 7315 | 7315 | 6833 6833 | 9 9 |
| 7332 | 7332 | 6850 6850 | 9 9 |
| 7333 | 7333 | 6851 6851 | 9 9 |
| 7334 | 7334 | 6852 6852 | 9 9 |
| 7338 | 7338 | 6855 6855 | 9 9 |
| 7400 | 7400 | 6913 6913 | 9 9 |
| 7624 | 7624 | 7123 7123 | 9 9 |
| 7628 | 7628 | 7129 7129 | 9 9 |
| 7847 | 7847 | 7342 7342 | 9 9 |
| 7861 | 7861 | 7355 7355 | 9 9 |
| 7907 | 7907 | 7400 7400 | 9 9 |
| 7955 | 7955 | 7447 7447 | 9 9 |
| 7987 | 7987 | 7479 7479 | 9 9 |
| 7997 | 7997 | 7489 7489 | 9 9 |
| 8075 | 8075 | 7559 7559 | 9 9 |
| 8180 | 8180 | 7660 7660 | 9 9 |
| 8181 | 8181 | 7661 7661 | 9 9 |
| 8213 | 8213 | 7693 7693 | 9 9 |
| 8249 | 8249 | 7730 7730 | 9 9 |
| 8394 | 8394 | 7868 7868 | 9 9 |
| 8427 | 8427 | 7902 7902 | 9 9 |
| 8475 | 8475 | 7953 7953 | 9 9 |
| 8498 | 8498 | 7973 7973 | 9 9 |
| 8501 | 8501 | 7974 7974 | 9 9 |
| 8504 | 8504 | 7975 7975 | 9 9 |
| 8507 | 8507 | 7976 7976 | 9 9 |
| 8510 | 8510 | 7977 7977 | 9 9 |
| 8513 | 8513 | 7978 7978 | 9 9 |
| 8516 | 8516 | 7979 7979 | 9 9 |
| 8519 | 8519 | 7980 7980 | 9 9 |
| 8522 | 8522 | 7981 7981 | 9 9 |
| 8593 | 8593 | 8043 8043 | 9 9 |
| 8759 | 8759 | 8189 8189 | 9 9 |
| 8805 | 8805 | 8234 8234 | 9 9 |
| 8857 | 8857 | 8286 8286 | 9 9 |
| 8860 | 8860 | 8288 8288 | 9 9 |
| 9010 | 9010 | 8438 8438 | 9 9 |
| 9509 | 9509 | 8932 8932 | 9 9 |
| 9640 | 9640 | 9062 9062 | 9 9 |
| 9716 | 9716 | 9139 9139 | 9 9 |
| 9721 | 9721 | 9142 9142 | 9 9 |
| 10128 | 10128 | 9560 9560 | 9 9 |
| 10166 | 10166 | 9600 9600 | 9 9 |
| 10230 | 10230 | 9664 9664 | 9 9 |
| 10391 | 10391 | 9845 9845 | 9 9 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE albums_genres ( album_id integer NOT NULL, genre_id integer NOT NULL, FOREIGN KEY(album_id) REFERENCES albums(id), FOREIGN KEY(genre_id) REFERENCES genres(id), UNIQUE(album_id,genre_id) );