film_category

63 rows where category_id = 13

✎ 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
22,13 AMISTAD MIDSUMMER 22 New 13 2020-12-23 07:14:58
25,13 ANGELS LIFE 25 New 13 2020-12-23 07:14:58
32,13 APOCALYPSE FLAMINGOS 32 New 13 2020-12-23 07:14:58
45,13 ATTRACTION NEWTON 45 New 13 2020-12-23 07:14:58
77,13 BIRDS PERDITION 77 New 13 2020-12-23 07:14:59
90,13 BOULEVARD MOB 90 New 13 2020-12-23 07:14:59
93,13 BRANNIGAN SUNRISE 93 New 13 2020-12-23 07:14:59
95,13 BREAKFAST GOLDFINGER 95 New 13 2020-12-23 07:14:59
96,13 BREAKING HOME 96 New 13 2020-12-23 07:14:59
108,13 BUTCH PANTHER 108 New 13 2020-12-23 07:14:59
109,13 BUTTERFLY CHOCOLAT 109 New 13 2020-12-23 07:14:59
136,13 CHAPLIN LICENSE 136 New 13 2020-12-23 07:15:00
144,13 CHINATOWN GLADIATOR 144 New 13 2020-12-23 07:15:00
155,13 CLEOPATRA DEVIL 155 New 13 2020-12-23 07:15:00
163,13 CLYDE THEORY 163 New 13 2020-12-23 07:15:00
216,13 DAY UNFAITHFUL 216 New 13 2020-12-23 07:15:01
226,13 DESTINY SATURDAY 226 New 13 2020-12-23 07:15:01
251,13 DRAGONFLY STRANGERS 251 New 13 2020-12-23 07:15:01
267,13 EAGLES PANKY 267 New 13 2020-12-23 07:15:01
270,13 EARTH VISION 270 New 13 2020-12-23 07:15:01
283,13 ENDING CROWDS 283 New 13 2020-12-23 07:15:01
289,13 EVE RESURRECTION 289 New 13 2020-12-23 07:15:01
305,13 FATAL HAUNTED 305 New 13 2020-12-23 07:15:02
320,13 FLAMINGOS CONNECTICUT 320 New 13 2020-12-23 07:15:02
321,13 FLASH WARS 321 New 13 2020-12-23 07:15:02
340,13 FRONTIER CABIN 340 New 13 2020-12-23 07:15:02
364,13 GODFATHER DIARY 364 New 13 2020-12-23 07:15:02
436,13 HOURS RAGE 436 New 13 2020-12-23 07:15:03
448,13 IDAHO LOVE 448 New 13 2020-12-23 07:15:04
465,13 INTERVIEW LIAISONS 465 New 13 2020-12-23 07:15:04
481,13 JEKYLL FROGMEN 481 New 13 2020-12-23 07:15:04
490,13 JUMANJI BLADE 490 New 13 2020-12-23 07:15:04
492,13 JUNGLE CLOSER 492 New 13 2020-12-23 07:15:04
538,13 LOVERBOY ATTACKS 538 New 13 2020-12-23 07:15:05
551,13 MAIDEN HOME 551 New 13 2020-12-23 07:15:05
558,13 MANNEQUIN WORST 558 New 13 2020-12-23 07:15:05
561,13 MASK PEACH 561 New 13 2020-12-23 07:15:05
580,13 MINE TITANS 580 New 13 2020-12-23 07:15:05
590,13 MONEY HAROLD 590 New 13 2020-12-23 07:15:05
632,13 NUTS TIES 632 New 13 2020-12-23 07:15:06
635,13 OKLAHOMA JUMANJI 635 New 13 2020-12-23 07:15:06
675,13 PHANTOM GLORY 675 New 13 2020-12-23 07:15:06
677,13 PIANIST OUTFIELD 677 New 13 2020-12-23 07:15:06
685,13 PLATOON INSTINCT 685 New 13 2020-12-23 07:15:06
686,13 PLUTO OLEANDER 686 New 13 2020-12-23 07:15:06
720,13 REDEMPTION COMFORTS 720 New 13 2020-12-23 07:15:07
730,13 RIDGEMONT SUBMARINE 730 New 13 2020-12-23 07:15:07
750,13 RUN PACIFIC 750 New 13 2020-12-23 07:15:07
751,13 RUNAWAY TENENBAUMS 751 New 13 2020-12-23 07:15:07
759,13 SALUTE APOLLO 759 New 13 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)
;