film_category
73 rows where category_id = 9
This data as json, xlsx, CSV (advanced)
Suggested facets: last_update, last_update (date)
| Link | film_id | category_id | last_update |
|---|---|---|---|
| 6,9 | AGENT TRUMAN 6 | Foreign 9 | 2020-12-23 07:14:58 |
| 11,9 | ALAMO VIDEOTAPE 11 | Foreign 9 | 2020-12-23 07:14:58 |
| 15,9 | ALIEN CENTER 15 | Foreign 9 | 2020-12-23 07:14:58 |
| 16,9 | ALLEY EVOLUTION 16 | Foreign 9 | 2020-12-23 07:14:58 |
| 47,9 | BABY HALL 47 | Foreign 9 | 2020-12-23 07:14:58 |
| 52,9 | BALLROOM MOCKINGBIRD 52 | Foreign 9 | 2020-12-23 07:14:59 |
| 100,9 | BROOKLYN DESERT 100 | Foreign 9 | 2020-12-23 07:14:59 |
| 104,9 | BUGSY SONG 104 | Foreign 9 | 2020-12-23 07:14:59 |
| 112,9 | CALENDAR GUNFIGHT 112 | Foreign 9 | 2020-12-23 07:14:59 |
| 128,9 | CATCH AMISTAD 128 | Foreign 9 | 2020-12-23 07:15:00 |
| 148,9 | CHOCOLATE DUCK 148 | Foreign 9 | 2020-12-23 07:15:00 |
| 170,9 | COMMAND DARLING 170 | Foreign 9 | 2020-12-23 07:15:00 |
| 185,9 | COWBOY DOOM 185 | Foreign 9 | 2020-12-23 07:15:00 |
| 192,9 | CROSSING DIVORCE 192 | Foreign 9 | 2020-12-23 07:15:00 |
| 198,9 | CRYSTAL BREAKING 198 | Foreign 9 | 2020-12-23 07:15:00 |
| 201,9 | CYCLONE FAMILY 201 | Foreign 9 | 2020-12-23 07:15:00 |
| 207,9 | DANGEROUS UPTOWN 207 | Foreign 9 | 2020-12-23 07:15:01 |
| 246,9 | DOUBTFIRE LABYRINTH 246 | Foreign 9 | 2020-12-23 07:15:01 |
| 290,9 | EVERYONE CRAFT 290 | Foreign 9 | 2020-12-23 07:15:01 |
| 311,9 | FICTION CHRISTMAS 311 | Foreign 9 | 2020-12-23 07:15:02 |
| 337,9 | FRIDA SLIPPER 337 | Foreign 9 | 2020-12-23 07:15:02 |
| 353,9 | GENTLEMEN STAGE 353 | Foreign 9 | 2020-12-23 07:15:02 |
| 376,9 | GRAPES FURY 376 | Foreign 9 | 2020-12-23 07:15:03 |
| 380,9 | GREEK EVERYONE 380 | Foreign 9 | 2020-12-23 07:15:03 |
| 399,9 | HAPPINESS UNITED 399 | Foreign 9 | 2020-12-23 07:15:03 |
| 414,9 | HELLFIGHTERS SIERRA 414 | Foreign 9 | 2020-12-23 07:15:03 |
| 416,9 | HIGHBALL POTTER 416 | Foreign 9 | 2020-12-23 07:15:03 |
| 421,9 | HOLIDAY GAMES 421 | Foreign 9 | 2020-12-23 07:15:03 |
| 431,9 | HOOSIERS BIRDCAGE 431 | Foreign 9 | 2020-12-23 07:15:03 |
| 435,9 | HOTEL HAPPINESS 435 | Foreign 9 | 2020-12-23 07:15:03 |
| 440,9 | HUNGER ROOF 440 | Foreign 9 | 2020-12-23 07:15:03 |
| 452,9 | ILLUSION AMELIE 452 | Foreign 9 | 2020-12-23 07:15:04 |
| 455,9 | IMPOSSIBLE PREJUDICE 455 | Foreign 9 | 2020-12-23 07:15:04 |
| 459,9 | INFORMER DOUBLE 459 | Foreign 9 | 2020-12-23 07:15:04 |
| 460,9 | INNOCENT USUAL 460 | Foreign 9 | 2020-12-23 07:15:04 |
| 467,9 | INTRIGUE WORST 467 | Foreign 9 | 2020-12-23 07:15:04 |
| 486,9 | JET NEIGHBORS 486 | Foreign 9 | 2020-12-23 07:15:04 |
| 493,9 | KANE EXORCIST 493 | Foreign 9 | 2020-12-23 07:15:04 |
| 500,9 | KISS GLORY 500 | Foreign 9 | 2020-12-23 07:15:04 |
| 531,9 | LOSE INCH 531 | Foreign 9 | 2020-12-23 07:15:05 |
| 533,9 | LOST BIRD 533 | Foreign 9 | 2020-12-23 07:15:05 |
| 545,9 | MADNESS ATTACKS 545 | Foreign 9 | 2020-12-23 07:15:05 |
| 565,9 | MATRIX SNOWMAN 565 | Foreign 9 | 2020-12-23 07:15:05 |
| 566,9 | MAUDE MOD 566 | Foreign 9 | 2020-12-23 07:15:05 |
| 567,9 | MEET CHOCOLATE 567 | Foreign 9 | 2020-12-23 07:15:05 |
| 584,9 | MIXED DOORS 584 | Foreign 9 | 2020-12-23 07:15:05 |
| 595,9 | MOON BUNCH 595 | Foreign 9 | 2020-12-23 07:15:05 |
| 605,9 | MULHOLLAND BEAST 605 | Foreign 9 | 2020-12-23 07:15:05 |
| 607,9 | MUPPET MILE 607 | Foreign 9 | 2020-12-23 07:15:05 |
| 623,9 | NEWTON LABYRINTH 623 | Foreign 9 | 2020-12-23 07:15:06 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE film_category ( film_id INT NOT NULL, category_id SMALLINT NOT NULL, last_update TIMESTAMP NOT NULL, PRIMARY KEY (film_id, category_id), CONSTRAINT fk_film_category_film FOREIGN KEY (film_id) REFERENCES film (film_id) ON DELETE NO ACTION ON UPDATE CASCADE, CONSTRAINT fk_film_category_category FOREIGN KEY (category_id) REFERENCES category (category_id) ON DELETE NO ACTION ON UPDATE CASCADE ); CREATE INDEX idx_fk_film_category_film ON film_category(film_id) ; CREATE INDEX idx_fk_film_category_category ON film_category(category_id) ;