film_category

66 rows where category_id = 2

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update, last_update (date)

Link film_id category_id last_update
18,2 ALTER VICTORY 18 Animation 2 2020-12-23 07:14:58
23,2 ANACONDA CONFESSIONS 23 Animation 2 2020-12-23 07:14:58
36,2 ARGONAUTS TOWN 36 Animation 2 2020-12-23 07:14:58
70,2 BIKINI BORROWERS 70 Animation 2 2020-12-23 07:14:59
78,2 BLACKOUT PRIVATE 78 Animation 2 2020-12-23 07:14:59
89,2 BORROWERS BEDAZZLED 89 Animation 2 2020-12-23 07:14:59
118,2 CANYON STOCK 118 Animation 2 2020-12-23 07:14:59
121,2 CAROL TEXAS 121 Animation 2 2020-12-23 07:14:59
134,2 CHAMPION FLATLINERS 134 Animation 2 2020-12-23 07:15:00
154,2 CLASH FREDDY 154 Animation 2 2020-12-23 07:15:00
160,2 CLUB GRAFFITI 160 Animation 2 2020-12-23 07:15:00
193,2 CROSSROADS CASUALTIES 193 Animation 2 2020-12-23 07:15:00
208,2 DARES PLUTO 208 Animation 2 2020-12-23 07:15:01
223,2 DESIRE ALIEN 223 Animation 2 2020-12-23 07:15:01
239,2 DOGMA FAMILY 239 Animation 2 2020-12-23 07:15:01
241,2 DONNIE ALLEY 241 Animation 2 2020-12-23 07:15:01
243,2 DOORS PRESIDENT 243 Animation 2 2020-12-23 07:15:01
245,2 DOUBLE WRATH 245 Animation 2 2020-12-23 07:15:01
259,2 DUCK RACER 259 Animation 2 2020-12-23 07:15:01
268,2 EARLY HOME 268 Animation 2 2020-12-23 07:15:01
300,2 FALCON VOLUME 300 Animation 2 2020-12-23 07:15:02
314,2 FIGHT JAWBREAKER 314 Animation 2 2020-12-23 07:15:02
325,2 FLOATS GARDEN 325 Animation 2 2020-12-23 07:15:02
326,2 FLYING HOOK 326 Animation 2 2020-12-23 07:15:02
330,2 FORRESTER COMANCHEROS 330 Animation 2 2020-12-23 07:15:02
349,2 GANGS PRIDE 349 Animation 2 2020-12-23 07:15:02
355,2 GHOSTBUSTERS ELF 355 Animation 2 2020-12-23 07:15:02
402,2 HARPER DYING 402 Animation 2 2020-12-23 07:15:03
430,2 HOOK CHARIOTS 430 Animation 2 2020-12-23 07:15:03
433,2 HORN WORKING 433 Animation 2 2020-12-23 07:15:03
456,2 INCH JET 456 Animation 2 2020-12-23 07:15:04
461,2 INSECTS STONE 461 Animation 2 2020-12-23 07:15:04
464,2 INTENTIONS EMPIRE 464 Animation 2 2020-12-23 07:15:04
470,2 ISHTAR ROCKETEER 470 Animation 2 2020-12-23 07:15:04
489,2 JUGGLER HARDLY 489 Animation 2 2020-12-23 07:15:04
510,2 LAWLESS VISION 510 Animation 2 2020-12-23 07:15:04
541,2 LUKE MUMMY 541 Animation 2 2020-12-23 07:15:05
564,2 MASSAGE IMAGE 564 Animation 2 2020-12-23 07:15:05
569,2 MENAGERIE RUSHMORE 569 Animation 2 2020-12-23 07:15:05
582,2 MIRACLE VIRTUAL 582 Animation 2 2020-12-23 07:15:05
583,2 MISSION ZOOLANDER 583 Animation 2 2020-12-23 07:15:05
615,2 NASH CHOCOLAT 615 Animation 2 2020-12-23 07:15:06
644,2 OSCAR GOLD 644 Animation 2 2020-12-23 07:15:06
649,2 OZ LIAISONS 649 Animation 2 2020-12-23 07:15:06
651,2 PACKER MADIGAN 651 Animation 2 2020-12-23 07:15:06
690,2 POND SEATTLE 690 Animation 2 2020-12-23 07:15:07
692,2 POTLUCK MIXED 692 Animation 2 2020-12-23 07:15:07
693,2 POTTER CONNECTICUT 693 Animation 2 2020-12-23 07:15:07
696,2 PRIDE ALAMO 696 Animation 2 2020-12-23 07:15:07
703,2 PUNK DIVORCE 703 Animation 2 2020-12-23 07:15:07

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
;