albums_genres
2,949 rows where genre_id = 2
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | genre_id |
|---|---|---|---|
| 7 | 7 | 8 8 | 2 2 |
| 27 | 27 | 27 27 | 2 2 |
| 28 | 28 | 28 28 | 2 2 |
| 40 | 40 | 38 38 | 2 2 |
| 41 | 41 | 39 39 | 2 2 |
| 53 | 53 | 50 50 | 2 2 |
| 60 | 60 | 57 57 | 2 2 |
| 67 | 67 | 62 62 | 2 2 |
| 69 | 69 | 63 63 | 2 2 |
| 70 | 70 | 64 64 | 2 2 |
| 73 | 73 | 67 67 | 2 2 |
| 75 | 75 | 68 68 | 2 2 |
| 92 | 92 | 85 85 | 2 2 |
| 94 | 94 | 87 87 | 2 2 |
| 112 | 112 | 105 105 | 2 2 |
| 113 | 113 | 106 106 | 2 2 |
| 132 | 132 | 122 122 | 2 2 |
| 153 | 153 | 143 143 | 2 2 |
| 166 | 166 | 151 151 | 2 2 |
| 174 | 174 | 159 159 | 2 2 |
| 193 | 193 | 175 175 | 2 2 |
| 215 | 215 | 196 196 | 2 2 |
| 220 | 220 | 201 201 | 2 2 |
| 222 | 222 | 203 203 | 2 2 |
| 225 | 225 | 205 205 | 2 2 |
| 239 | 239 | 217 217 | 2 2 |
| 255 | 255 | 231 231 | 2 2 |
| 262 | 262 | 237 237 | 2 2 |
| 270 | 270 | 242 242 | 2 2 |
| 272 | 272 | 244 244 | 2 2 |
| 282 | 282 | 253 253 | 2 2 |
| 316 | 316 | 283 283 | 2 2 |
| 327 | 327 | 293 293 | 2 2 |
| 334 | 334 | 300 300 | 2 2 |
| 341 | 341 | 305 305 | 2 2 |
| 351 | 351 | 313 313 | 2 2 |
| 361 | 361 | 320 320 | 2 2 |
| 362 | 362 | 321 321 | 2 2 |
| 367 | 367 | 326 326 | 2 2 |
| 368 | 368 | 327 327 | 2 2 |
| 370 | 370 | 328 328 | 2 2 |
| 378 | 378 | 335 335 | 2 2 |
| 381 | 381 | 338 338 | 2 2 |
| 383 | 383 | 339 339 | 2 2 |
| 388 | 388 | 343 343 | 2 2 |
| 389 | 389 | 344 344 | 2 2 |
| 391 | 391 | 346 346 | 2 2 |
| 392 | 392 | 347 347 | 2 2 |
| 393 | 393 | 348 348 | 2 2 |
| 401 | 401 | 355 355 | 2 2 |
| 404 | 404 | 357 357 | 2 2 |
| 405 | 405 | 358 358 | 2 2 |
| 407 | 407 | 360 360 | 2 2 |
| 420 | 420 | 370 370 | 2 2 |
| 438 | 438 | 390 390 | 2 2 |
| 442 | 442 | 392 392 | 2 2 |
| 447 | 447 | 397 397 | 2 2 |
| 472 | 472 | 418 418 | 2 2 |
| 509 | 509 | 451 451 | 2 2 |
| 521 | 521 | 462 462 | 2 2 |
| 524 | 524 | 464 464 | 2 2 |
| 526 | 526 | 465 465 | 2 2 |
| 531 | 531 | 470 470 | 2 2 |
| 537 | 537 | 474 474 | 2 2 |
| 541 | 541 | 477 477 | 2 2 |
| 542 | 542 | 478 478 | 2 2 |
| 547 | 547 | 483 483 | 2 2 |
| 562 | 562 | 498 498 | 2 2 |
| 565 | 565 | 501 501 | 2 2 |
| 566 | 566 | 502 502 | 2 2 |
| 572 | 572 | 508 508 | 2 2 |
| 573 | 573 | 509 509 | 2 2 |
| 574 | 574 | 510 510 | 2 2 |
| 590 | 590 | 525 525 | 2 2 |
| 622 | 622 | 556 556 | 2 2 |
| 629 | 629 | 563 563 | 2 2 |
| 637 | 637 | 572 572 | 2 2 |
| 644 | 644 | 579 579 | 2 2 |
| 651 | 651 | 586 586 | 2 2 |
| 673 | 673 | 608 608 | 2 2 |
| 681 | 681 | 612 612 | 2 2 |
| 683 | 683 | 614 614 | 2 2 |
| 687 | 687 | 616 616 | 2 2 |
| 693 | 693 | 620 620 | 2 2 |
| 696 | 696 | 623 623 | 2 2 |
| 697 | 697 | 624 624 | 2 2 |
| 703 | 703 | 630 630 | 2 2 |
| 707 | 707 | 634 634 | 2 2 |
| 709 | 709 | 636 636 | 2 2 |
| 731 | 731 | 656 656 | 2 2 |
| 732 | 732 | 657 657 | 2 2 |
| 778 | 778 | 703 703 | 2 2 |
| 779 | 779 | 704 704 | 2 2 |
| 782 | 782 | 707 707 | 2 2 |
| 795 | 795 | 718 718 | 2 2 |
| 800 | 800 | 723 723 | 2 2 |
| 807 | 807 | 727 727 | 2 2 |
| 811 | 811 | 732 732 | 2 2 |
| 816 | 816 | 739 739 | 2 2 |
| 822 | 822 | 743 743 | 2 2 |
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) );