Created
October 17, 2023 18:32
-
-
Save SebastianCastilloDev/f8fc801beda3f703b1e0ad25629ca864 to your computer and use it in GitHub Desktop.
Archivos necesarios para la ejecución del trabajo de bases de datos pro 202 aiep
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| INSERT INTO tabla VALUES(27205, 'Inception', 8.364, 34495, 'Released', '2010-07-15', 825532764, 148, 0, '/8ZTVqvKDQ8emSGUEMjsS4yHAwrp.jpg', 160000000, 'https://www.warnerbros.com/movies/inception', 'tt1375666', 'en', 'Inception', '\"Cobb, a skilled thief who commits corporate espionage by infiltrating the subconscious of his targets is offered a chance to regain his old life as payment for a task considered to be impossible: \"\"inception\"\", the implantation of another person''s idea into a target''s subconscious.\"', 83.952, '/oYuLEt3zVCKq57qu2F8dT7NIa6f.jpg', 'Your mind is the scene of the crime.', '\"Action, Science Fiction, Adventure\"', '\"Legendary Pictures, Syncopy, Warner Bros. Pictures\"', '\"United Kingdom, United States of America\"', '\"English, French, Japanese, Swahili\"') | |
| INSERT INTO tabla VALUES(157336, 'Interstellar', 8.417, 32571, 'Released', '2014-11-05', 701729206, 169, 0, '/pbrkL804c8yAv3zBZR4QPEafpAR.jpg', 165000000, 'http://www.interstellarmovie.net/', 'tt0816692', 'en', 'Interstellar', 'The adventures of a group of explorers who make use of a newly discovered wormhole to surpass the limitations on human space travel and conquer the vast distances involved in an interstellar voyage.', 140.241, '/gEU2QniE6E77NI6lCU6MxlNBvIx.jpg', 'Mankind was born on Earth. It was never meant to die here.', '\"Adventure, Drama, Science Fiction\"', '\"Legendary Pictures, Syncopy, Lynda Obst Productions\"', '\"United Kingdom, United States of America\"', 'English') | |
| INSERT INTO tabla VALUES(155, 'The Dark Knight', 8.512, 30619, 'Released', '2008-07-16', 1004558444, 152, 0, '/nMKdUUepR0i5zn0y1T4CsSB5chy.jpg', 185000000, 'https://www.warnerbros.com/movies/dark-knight/', 'tt0468569', 'en', 'The Dark Knight', '\"Batman raises the stakes in his war on crime. With the help of Lt. Jim Gordon and District Attorney Harvey Dent, Batman sets out to dismantle the remaining criminal organizations that plague the streets. The partnership proves to be effective, but they soon find themselves prey to a reign of chaos unleashed by a rising criminal mastermind known to the terrified citizens of Gotham as the Joker.\"', 130.643, '/qJ2tW6WMUDux911r6m7haRef0WH.jpg', 'Welcome to a world without rules.', '\"Drama, Action, Crime, Thriller\"', '\"DC Comics, Legendary Pictures, Syncopy, Isobel Griffiths, Warner Bros. Pictures\"', '\"United Kingdom, United States of America\"', '\"English, Mandarin\"') | |
| INSERT INTO tabla VALUES(19995, 'Avatar', 7.573, 29815, 'Released', '2009-12-15', 2923706026, 162, 0, '/vL5LR6WdxWPjLPFRLe133jXWsh5.jpg', 237000000, 'https://www.avatar.com/movies/avatar', 'tt0499549', 'en', 'Avatar', '\"In the 22nd century, a paraplegic Marine is dispatched to the moon Pandora on a unique mission, but becomes torn between following orders and protecting an alien civilization.\"', 79.932, '/kyeqWdyUXW608qlYkRqosgbbJyK.jpg', 'Enter the world of Pandora.', '\"Action, Adventure, Fantasy, Science Fiction\"', '\"Dune Entertainment, Lightstorm Entertainment, 20th Century Fox, Ingenious Media\"', '\"United States of America, United Kingdom\"', '\"English, Spanish\"') | |
| INSERT INTO tabla VALUES(24428, 'The Avengers', 7.71, 29166, 'Released', '2012-04-25', 1518815515, 143, 0, '/9BBTo63ANSmhC4e6r62OJFuK2GL.jpg', 220000000, 'https://www.marvel.com/movies/the-avengers', 'tt0848228', 'en', 'The Avengers', '\"When an unexpected enemy emerges and threatens global safety and security, Nick Fury, director of the international peacekeeping agency known as S.H.I.E.L.D., finds himself in need of a team to pull the world back from the brink of disaster. Spanning the globe, a daring recruitment effort begins!\"', 98.082, '/RYMX2wcKCBAr24UyPD7xwmjaTn.jpg', 'Some assembly required.', '\"Science Fiction, Action, Adventure\"', 'Marvel Studios', 'United States of America', '\"English, Hindi, Russian\"') | |
| INSERT INTO tabla VALUES(293660, 'Deadpool', 7.606, 28894, 'Released', '2016-02-09', 783100000, 108, 0, '/en971MEXui9diirXlogOrPKmsEn.jpg', 58000000, 'https://www.20thcenturystudios.com/movies/deadpool', 'tt1431045', 'en', 'Deadpool', '\"The origin story of former Special Forces operative turned mercenary Wade Wilson, who, after being subjected to a rogue experiment that leaves him with accelerated healing powers, adopts the alter ego Deadpool. Armed with his new abilities and a dark, twisted sense of humor, Deadpool hunts down the man who nearly destroyed his life.\"', 72.735, '/zq8Cl3PNIDGU3iWNRoc5nEZ6pCe.jpg', 'Witness the beginning of a happy ending.', '\"Action, Adventure, Comedy\"', '\"20th Century Fox, The Donners'' Company, Genre Films\"', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(299536, 'Avengers: Infinity War', 8.255, 27713, 'Released', '2018-04-25', 2052415039, 149, 0, '/mDfJG3LC3Dqb67AZ52x3Z0jU0uB.jpg', 300000000, 'https://www.marvel.com/movies/avengers-infinity-war', 'tt4154756', 'en', 'Avengers: Infinity War', '\"As the Avengers and their allies have continued to protect the world from threats too large for any one hero to handle, a new danger has emerged from the cosmic shadows: Thanos. A despot of intergalactic infamy, his goal is to collect all six Infinity Stones, artifacts of unimaginable power, and use them to inflict his twisted will on all of reality. Everything the Avengers have fought for has led up to this moment - the fate of Earth and existence itself has never been more uncertain.\"', 154.34, '/7WsyChQLEftFiDOVTGkv3hFpyyt.jpg', 'An entire universe. Once and for all.', '\"Adventure, Action, Science Fiction\"', 'Marvel Studios', 'United States of America', '\"English, Xhosa\"') | |
| INSERT INTO tabla VALUES(550, 'Fight Club', 8.438, 27238, 'Released', '1999-10-15', 100853753, 139, 0, '/hZkgoQYus5vegHoetLkCJzb17zJ.jpg', 63000000, 'http://www.foxmovies.com/movies/fight-club', 'tt0137523', 'en', 'Fight Club', '\"A ticking-time-bomb insomniac and a slippery soap salesman channel primal male aggression into a shocking new form of therapy. Their concept catches on, with underground \"\"fight clubs\"\" forming in every town, until an eccentric gets in the way and ignites an out-of-control spiral toward oblivion.\"', 69.498, '/pB8BM7pdSp6B6Ih7QZ4DrQ3PmJK.jpg', 'Mischief. Mayhem. Soap.', 'Drama', '\"Regency Enterprises, Fox 2000 Pictures, Taurus Film, Atman Entertainment, Knickerbocker Films, The Linson Company, 20th Century Fox\"', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(118340, 'Guardians of the Galaxy', 7.906, 26638, 'Released', '2014-07-30', 772776600, 121, 0, '/uLtVbjvS1O7gXL8lUOwsFOH4man.jpg', 170000000, 'http://marvel.com/guardians', 'tt2015381', 'en', 'Guardians of the Galaxy', '\"Light years from Earth, 26 years after being abducted, Peter Quill finds himself the prime target of a manhunt after discovering an orb wanted by Ronan the Accuser.\"', 33.255, '/r7vmZjiyZw9rpJMQJdXpjgiCOk9.jpg', 'All heroes start somewhere.', '\"Action, Science Fiction, Adventure\"', 'Marvel Studios', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(680, 'Pulp Fiction', 8.488, 25893, 'Released', '1994-09-10', 213900000, 154, 0, '/suaEOtk1N1sgg2MTM7oZd2cfVp3.jpg', 8500000, 'https://www.miramax.com/movie/pulp-fiction/', 'tt0110912', 'en', 'Pulp Fiction', '\"A burger-loving hit man, his philosophical partner, a drug-addled gangster''s moll and a washed-up boxer converge in this sprawling, comedic crime caper. Their adventures unfurl in three stories that ingeniously trip back and forth in time.\"', 74.862, '/d5iIlFn5s0ImszYzBPb8JPIfbXD.jpg', 'Just because you are a character doesn''t mean you have character.', '\"Thriller, Crime\"', '\"Miramax, A Band Apart, Jersey Films\"', 'United States of America', '\"English, Spanish, French\"') | |
| INSERT INTO tabla VALUES(13, 'Forrest Gump', 8.477, 25409, 'Released', '1994-06-23', 677387716, 142, 0, '/qdIMHd4sEfJSckfVJfKQvisL02a.jpg', 55000000, 'https://www.paramountmovies.com/movies/forrest-gump', 'tt0109830', 'en', 'Forrest Gump', '\"A man with a low IQ has accomplished great things in his life and been present during significant historic events—in each case, far exceeding what anyone imagined he could do. But despite all he has achieved, his one true love eludes him.\"', 92.693, '/arw2vcBveWOVZr6pxd9XTd1TdQa.jpg', 'The world will never be the same once you''ve seen it through the eyes of Forrest Gump.', '\"Comedy, Drama, Romance\"', '\"Paramount, The Steve Tisch Company, Wendy Finerman Productions\"', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(671, 'Harry Potter and the Philosopher''s Stone', 7.916, 25379, 'Released', '2001-11-16', 976475550, 152, 0, '/hziiv14OpD73u9gAak4XDDfBKa2.jpg', 125000000, 'https://www.warnerbros.com/movies/harry-potter-and-sorcerers-stone/', 'tt0241527', 'en', 'Harry Potter and the Philosopher''s Stone', '\"Harry Potter has lived under the stairs at his aunt and uncle''s house his whole life. But on his 11th birthday, he learns he''s a powerful wizard—with a place waiting for him at the Hogwarts School of Witchcraft and Wizardry. As he learns to harness his newfound powers with the help of the school''s kindly headmaster, Harry uncovers the truth about his parents'' deaths—and about the villain who''s to blame.\"', 185.482, '/wuMc08IPKEatf9rnMNXvIDxqP4W.jpg', 'Let the magic begin.', '\"Adventure, Fantasy\"', '\"Warner Bros. Pictures, Heyday Films, 1492 Pictures\"', '\"United Kingdom, United States of America\"', 'English') | |
| INSERT INTO tabla VALUES(1726, 'Iron Man', 7.64, 24874, 'Released', '2008-04-30', 585174222, 126, 0, '/cyecB7godJ6kNHGONFjUyVN9OX5.jpg', 140000000, 'https://www.marvel.com/movies/iron-man', 'tt0371746', 'en', 'Iron Man', '\"After being held captive in an Afghan cave, billionaire engineer Tony Stark creates a unique weaponized suit of armor to fight evil.\"', 72.897, '/78lPtwv72eTNqFW9COBYI0dWDJa.jpg', 'Heroes aren''t born. They''re built.', '\"Action, Science Fiction, Adventure\"', 'Marvel Studios', 'United States of America', '\"English, Persian, Urdu, Arabic\"') | |
| INSERT INTO tabla VALUES(68718, 'Django Unchained', 8.171, 24672, 'Released', '2012-12-25', 425368238, 165, 0, '/5Lbm0gpFDRAPIV1Cth6ln9iL1ou.jpg', 100000000, 'http://www.unchainedmovie.com', 'tt1853728', 'en', 'Django Unchained', '\"With the help of a German bounty hunter, a freed slave sets out to rescue his wife from a brutal Mississippi plantation owner.\"', 54.224, '/7oWY8VDWW7thTzWh3OKYRkWUlD5.jpg', '\"Life, liberty and the pursuit of vengeance.\"', '\"Drama, Western\"', '\"The Weinstein Company, Columbia Pictures\"', 'United States of America', '\"English, French, German\"') | |
| INSERT INTO tabla VALUES(278, 'The Shawshank Redemption', 8.702, 24649, 'Released', '1994-09-23', 28341469, 142, 0, '/kXfqcdQKsToO0OUXHcrrNCHDBzO.jpg', 25000000, 'Not Available', 'tt0111161', 'en', 'The Shawshank Redemption', '\"Framed in the 1940s for the double murder of his wife and her lover, upstanding banker Andy Dufresne begins a new life at the Shawshank prison, where he puts his accounting skills to work for an amoral warden. During his long stretch in prison, Dufresne comes to be admired by the other inmates -- including an older prisoner named Red -- for his integrity and unquenchable sense of hope.\"', 122.61, '/lyQBXzOQSuE59IsHyhrp0qIiPAz.jpg', 'Fear can hold you prisoner. Hope can set you free.', '\"Drama, Crime\"', 'Castle Rock Entertainment', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(299534, 'Avengers: Endgame', 8.263, 23857, 'Released', '2019-04-24', 2800000000, 181, 0, '/7RyHsO4yDXtBv1zUU3mTpHeQ0d5.jpg', 356000000, 'https://www.marvel.com/movies/avengers-endgame', 'tt4154796', 'en', 'Avengers: Endgame', '\"After the devastating events of Avengers: Infinity War, the universe is in ruins due to the efforts of the Mad Titan, Thanos. With the help of remaining allies, the Avengers must assemble once more in order to undo Thanos'' actions and restore order to the universe once and for all, no matter what consequences may be in store.\"', 91.756, '/or06FN3Dka5tukK1e9sl16pB3iy.jpg', 'Avenge the fallen.', '\"Adventure, Science Fiction, Action\"', 'Marvel Studios', 'United States of America', '\"English, Japanese, Xhosa\"') | |
| INSERT INTO tabla VALUES(603, 'The Matrix', 8.206, 23815, 'Released', '1999-03-30', 463517383, 136, 0, '/oMsxZEvz9a708d49b6UdZK1KAo5.jpg', 63000000, 'http://www.warnerbros.com/matrix', 'tt0133093', 'en', 'The Matrix', '\"Set in the 22nd century, The Matrix tells the story of a computer hacker who joins a group of underground insurgents fighting the vast and powerful computers who now rule the earth.\"', 78.564, '/f89U3ADr1oiB1s9GkdPOEpXUk5H.jpg', 'Welcome to the Real World.', '\"Action, Science Fiction\"', '\"Village Roadshow Pictures, Groucho II Film Partnership, Silver Pictures, Warner Bros. Pictures\"', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(597, 'Titanic', 7.9, 23637, 'Released', '1997-11-18', 2264162353, 194, 0, '/rzdPqYx7Um4FUZeD8wpXqjAUcEm.jpg', 200000000, 'https://www.paramountmovies.com/movies/titanic', 'tt0120338', 'en', 'Titanic', '\"101-year-old Rose DeWitt Bukater tells the story of her life aboard the Titanic, 84 years later. A young Rose boards the ship with her mother and fiancé. Meanwhile, Jack Dawson and Fabrizio De Rossi win third-class tickets aboard the ship. Rose tells the whole story from Titanic''s departure through to its death—on its first and last voyage—on April 15, 1912.\"', 102.348, '/9xjZS2rlVxm8SFx8kPC3aIGCOYQ.jpg', 'Nothing on Earth could come between them.', '\"Drama, Romance\"', '\"Paramount, 20th Century Fox, Lightstorm Entertainment\"', 'United States of America', '\"English, French, German, Swedish, Italian, Russian\"') | |
| INSERT INTO tabla VALUES(475557, 'Joker', 8.168, 23425, 'Released', '2019-10-01', 1074458282, 122, 0, '/hO7KbdvGOtDdeg0W4Y5nKEHeDDh.jpg', 55000000, 'http://www.jokermovie.net/', 'tt7286456', 'en', 'Joker', '\"During the 1980s, a failed stand-up comedian is driven insane and turns to a life of crime and chaos in Gotham City while becoming an infamous psychopathic crime figure.\"', 54.522, '/udDclJoHjfjb8Ekgsd4FDteOkCU.jpg', 'Put on a happy face.', '\"Crime, Thriller, Drama\"', '\"Warner Bros. Pictures, Joint Effort, Village Roadshow Pictures, Bron Studios, DC Films\"', '\"Canada, United States of America\"', 'English') | |
| INSERT INTO tabla VALUES(120, 'The Lord of the Rings: The Fellowship of the Ring', 8.402, 23323, 'Released', '2001-12-18', 871368364, 179, 0, '/x2RS3uTcsJJ9IfjNPcgDmukoEcQ.jpg', 93000000, 'http://www.lordoftherings.net/', 'tt0120737', 'en', 'The Lord of the Rings: The Fellowship of the Ring', '\"Young hobbit Frodo Baggins, after inheriting a mysterious ring from his uncle Bilbo, must leave his home in order to keep it from falling into the hands of its evil creator. Along the way, a fellowship is formed to protect the ringbearer and make sure that the ring arrives at its final destination: Mt. Doom, the only place where it can be destroyed.\"', 87.037, '/6oom5QYQ2yQTMJIbnvbkBL9cHo6.jpg', 'One ring to rule them all', '\"Adventure, Fantasy, Action\"', '\"New Line Cinema, WingNut Films, The Saul Zaentz Company\"', '\"New Zealand, United States of America\"', 'English') | |
| INSERT INTO tabla VALUES(122, 'The Lord of the Rings: The Return of the King', 8.474, 22334, 'Released', '2003-12-01', 1118888979, 201, 0, '/2u7zbn8EudG6kLlBzUYqP8RyFU4.jpg', 94000000, 'http://www.lordoftherings.net', 'tt0167260', 'en', 'The Lord of the Rings: The Return of the King', '\"Aragorn is revealed as the heir to the ancient kings as he, Gandalf and the other members of the broken fellowship struggle to save Gondor from Sauron''s forces. Meanwhile, Frodo and Sam take the ring closer to the heart of Mordor, the dark lord''s realm.\"', 99.276, '/rCzpDGLbOoPwLjy3OAm5NUPOTrC.jpg', 'The eye of the enemy is moving.', '\"Adventure, Fantasy, Action\"', '\"New Line Cinema, WingNut Films, The Saul Zaentz Company\"', '\"New Zealand, United States of America\"', 'English') | |
| INSERT INTO tabla VALUES(11324, 'Shutter Island', 8.2, 22318, 'Released', '2010-02-14', 294800000, 138, 0, '/2nqsOT2AqPkTW81bWaLRtjgjqVM.jpg', 80000000, 'http://www.shutterisland.com/', 'tt1130884', 'en', 'Shutter Island', '\"World War II soldier-turned-U.S. Marshal Teddy Daniels investigates the disappearance of a patient from a hospital for the criminally insane, but his efforts are compromised by troubling visions and a mysterious doctor.\"', 56.595, '/4GDy0PHYX3VRXUtwK5ysFbg3kEx.jpg', 'Some places never let you go.', '\"Drama, Thriller, Mystery\"', '\"Phoenix Pictures, Paramount, Appian Way, Sikelia Productions, Mandate International\"', 'United States of America', '\"English, German\"') | |
| INSERT INTO tabla VALUES(106646, 'The Wolf of Wall Street', 8.035, 22222, 'Released', '2013-12-25', 392000000, 180, 0, '/63y4XSVTZ7mRzAzkqwi3o0ajDZZ.jpg', 100000000, 'http://www.thewolfofwallstreet.com/', 'tt0993846', 'en', 'The Wolf of Wall Street', '\"A New York stockbroker refuses to cooperate in a large securities fraud case involving corruption on Wall Street, corporate banking world and mob infiltration. Based on Jordan Belfort''s autobiography.\"', 97.444, '/34m2tygAYBGqA9MXKhRDtzYd4MR.jpg', 'Earn. Spend. Party.', '\"Crime, Drama, Comedy\"', '\"EMJAG Productions, Red Granite Pictures, Appian Way, Sikelia Productions\"', 'United States of America', '\"English, French\"') | |
| INSERT INTO tabla VALUES(99861, 'Avengers: Age of Ultron', 7.276, 21754, 'Released', '2015-04-22', 1405403694, 141, 0, '/6YwkGolwdOMNpbTOmLjoehlVWs5.jpg', 365000000, 'http://marvel.com/movies/movie/193/avengers_age_of_ultron', 'tt2395427', 'en', 'Avengers: Age of Ultron', '\"When Tony Stark tries to jumpstart a dormant peacekeeping program, things go awry and Earth’s Mightiest Heroes are put to the ultimate test as the fate of the planet hangs in the balance. As the villainous Ultron emerges, it is up to The Avengers to stop him from enacting his terrible plans, and soon uneasy alliances and unexpected action pave the way for an epic and unique global adventure.\"', 96.565, '/4ssDuvEDkSArWEdyBl2X5EHvYKU.jpg', 'A new age has come.', '\"Action, Adventure, Science Fiction\"', 'Marvel Studios', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(271110, 'Captain America: Civil War', 7.4, 21541, 'Released', '2016-04-27', 1155046416, 147, 0, '/wdwcOBMkt3zmPQuEMxB3FUtMio2.jpg', 250000000, 'https://www.marvel.com/movies/captain-america-civil-war', 'tt3498820', 'en', 'Captain America: Civil War', '\"Following the events of Age of Ultron, the collective governments of the world pass an act designed to regulate all superhuman activity. This polarizes opinion amongst the Avengers, causing two factions to side with Iron Man or Captain America, which causes an epic battle between former allies.\"', 70.741, '/rAGiXaUfPzY7CDEyNKUofk3Kw2e.jpg', 'United we stand. Divided we fall.', '\"Adventure, Action, Science Fiction\"', 'Marvel Studios', 'United States of America', '\"Romanian, English, German, Russian\"') | |
| INSERT INTO tabla VALUES(49026, 'The Dark Knight Rises', 7.777, 21335, 'Released', '2012-07-17', 1081041287, 165, 0, '/c3OHQncTAnKFhdOTX7D3LTW6son.jpg', 250000000, 'http://www.thedarkknightrises.com/', 'tt1345836', 'en', 'The Dark Knight Rises', '\"Following the death of District Attorney Harvey Dent, Batman assumes responsibility for Dent''s crimes to protect the late attorney''s reputation and is subsequently hunted by the Gotham City Police Department. Eight years later, Batman encounters the mysterious Selina Kyle and the villainous Bane, a new terrorist leader who overwhelms Gotham''s finest. The Dark Knight resurfaces to protect a city that has branded him an enemy.\"', 76.914, '/hr0L2aueqlP2BYUblTTjmtn0hw4.jpg', 'The Legend Ends', '\"Action, Crime, Drama, Thriller\"', '\"Syncopy, Legendary Pictures, DC Entertainment, Warner Bros. Pictures\"', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(68721, 'Iron Man 3', 6.928, 21064, 'Released', '2013-04-18', 1215577205, 130, 0, '/aFTYFqrWp4RS46Twm87l5e0ItYb.jpg', 200000000, 'https://www.marvel.com/movies/iron-man-3', 'tt1300854', 'en', 'Iron Man 3', '\"When Tony Stark''s world is torn apart by a formidable terrorist called the Mandarin, he starts an odyssey of rebuilding and retribution.\"', 61.06, '/qhPtAc1TKbMPqNvcdXSOn9Bn7hZ.jpg', 'Unleash the power behind the armor.', '\"Action, Adventure, Science Fiction\"', 'Marvel Studios', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(284054, 'Black Panther', 7.39, 21053, 'Released', '2018-02-13', 1349926083, 135, 0, '/b6ZJZHUdMEFECvGiDpJjlfUWela.jpg', 200000000, 'https://www.marvel.com/movies/black-panther', 'tt1825683', 'en', 'Black Panther', '\"King T''Challa returns home to the reclusive, technologically advanced African nation of Wakanda to serve as his country''s new leader. However, T''Challa soon finds that he is challenged for the throne by factions within his own country as well as without. Using powers reserved to Wakandan kings, T''Challa assumes the Black Panther mantle to join with ex-girlfriend Nakia, the queen-mother, his princess-kid sister, members of the Dora Milaje (the Wakandan ''special forces'') and an American secret agent, to prevent Wakanda from being dragged into a world war.\"', 43.665, '/uxzzxijgPIY7slzFvMotPv8wjKA.jpg', 'Long live the king.', '\"Action, Adventure, Science Fiction\"', 'Marvel Studios', 'United States of America', '\"English, Korean, Swahili, Xhosa\"') | |
| INSERT INTO tabla VALUES(284052, 'Doctor Strange', 7.427, 20935, 'Released', '2016-10-25', 676343174, 115, 0, '/qUv51IFUvVRAP2379ThmA3eLJx6.jpg', 180000000, 'http://marvel.com/doctorstrange', 'tt1211837', 'en', 'Doctor Strange', '\"After his career is destroyed, a brilliant but arrogant surgeon gets a new lease on life when a sorcerer takes him under her wing and trains him to defend the world against evil.\"', 70.535, '/uGBVj3bEbCoZbDjjl9wTxcygko1.jpg', 'The impossibilities are endless.', '\"Action, Adventure, Fantasy\"', 'Marvel Studios', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(76341, 'Mad Max: Fury Road', 7.582, 20911, 'Released', '2015-05-13', 378858340, 121, 0, '/8yACFuo4OaIiKr9hHFlmPcGalKx.jpg', 150000000, 'https://www.warnerbros.com/movies/mad-max-fury-road', 'tt1392190', 'en', 'Mad Max: Fury Road', '\"An apocalyptic story set in the furthest reaches of our planet, in a stark desert landscape where humanity is broken, and most everyone is crazed fighting for the necessities of life. Within this world exist two rebels on the run who just might be able to restore order.\"', 78.319, '/8tZYtuWezp8JbcsvHYO0O46tFbo.jpg', 'What a Lovely Day.', '\"Action, Adventure, Science Fiction\"', '\"Kennedy Miller Productions, Warner Bros. Pictures, RatPac Entertainment, Village Roadshow Pictures\"', '\"Australia, United States of America, South Africa\"', 'English') | |
| INSERT INTO tabla VALUES(16869, 'Inglourious Basterds', 8.215, 20746, 'Released', '2009-08-19', 321457747, 153, 0, '/8pEnePgGyfUqj8Qa6d91OZQ6Aih.jpg', 70000000, 'Not Available', 'tt0361748', 'en', 'Inglourious Basterds', '\"In Nazi-occupied France during World War II, a group of Jewish-American soldiers known as \"\"The Basterds\"\" are chosen specifically to spread fear throughout the Third Reich by scalping and brutally killing Nazis. The Basterds, lead by Lt. Aldo Raine soon cross paths with a French-Jewish teenage girl who runs a movie theater in Paris which is targeted by the soldiers.\"', 59.162, '/7sfbEnaARXDDhKm0CZ7D7uc2sbo.jpg', 'Once upon a time in Nazi occupied France...', '\"Drama, Thriller, War\"', '\"The Weinstein Company, Universal Pictures, A Band Apart, Zehnte Babelsberg Film, Visiona Romantica, Peninsula Films\"', '\"France, Germany, United States of America\"', '\"German, English, French, Italian\"') | |
| INSERT INTO tabla VALUES(70160, 'The Hunger Games', 7.193, 20636, 'Released', '2012-03-12', 694394724, 142, 0, '/yDbyVT8tTOgXUrUXNkHEUqbxb1K.jpg', 75000000, 'http://www.thehungergames.movie/', 'tt1392170', 'en', 'The Hunger Games', '\"Every year in the ruins of what was once North America, the nation of Panem forces each of its twelve districts to send a teenage boy and girl to compete in the Hunger Games. Part twisted entertainment, part government intimidation tactic, the Hunger Games are a nationally televised event in which “Tributes” must fight with one another until one survivor remains. Pitted against highly-trained Tributes who have prepared for these Games their entire lives, Katniss is forced to rely upon her sharp instincts as well as the mentorship of drunken former victor Haymitch Abernathy. If she’s ever to return home to District 12, Katniss must make impossible choices in the arena that weigh survival against humanity and life against love. The world will be watching.\"', 29.577, '/yXCbOiVDCxO71zI7cuwBRXdftq8.jpg', 'May The Odds Be Ever In Your Favor.', '\"Science Fiction, Adventure, Fantasy\"', '\"Lionsgate, Color Force\"', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(315635, 'Spider-Man: Homecoming', 7.345, 20507, 'Released', '2017-07-05', 880166924, 133, 0, '/fn4n6uOYcB6Uh89nbNPoU2w80RV.jpg', 175000000, 'http://www.spidermanhomecoming.com', 'tt2250912', 'en', 'Spider-Man: Homecoming', '\"Following the events of Captain America: Civil War, Peter Parker, with the help of his mentor Tony Stark, tries to balance his life as an ordinary high school student in Queens, New York City, with fighting crime as his superhero alter ego Spider-Man as a new threat, the Vulture, emerges.\"', 65.88, '/c24sv2weTHPsmDa7jEMN0m2P3RT.jpg', 'Homework can wait. The city can''t.', '\"Action, Adventure, Science Fiction, Drama\"', '\"Marvel Studios, Pascal Pictures, LStar Capital, Columbia Pictures\"', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(672, 'Harry Potter and the Chamber of Secrets', 7.721, 20390, 'Released', '2002-11-13', 876688482, 161, 0, '/1stUIsjawROZxjiCMtqqXqgfZWC.jpg', 100000000, 'https://www.warnerbros.com/movies/harry-potter-and-chamber-secrets/', 'tt0295297', 'en', 'Harry Potter and the Chamber of Secrets', '\"Cars fly, trees fight back, and a mysterious house-elf comes to warn Harry Potter at the start of his second year at Hogwarts. Adventure and danger await when bloody writing on a wall announces: The Chamber Of Secrets Has Been Opened. To save Hogwarts will require all of Harry, Ron and Hermione’s magical abilities and courage.\"', 121.699, '/sdEOH0992YZ0QSxgXNIGLq1ToUi.jpg', 'Hogwarts is back in session.', '\"Adventure, Fantasy\"', '\"Warner Bros. Pictures, Heyday Films, 1492 Pictures\"', '\"United Kingdom, United States of America\"', 'English') | |
| INSERT INTO tabla VALUES(283995, 'Guardians of the Galaxy Vol. 2', 7.624, 20353, 'Released', '2017-04-19', 863756051, 137, 0, '/aJn9XeesqsrSLKcHfHP4u5985hn.jpg', 200000000, 'http://marvel.com/movies/movie/221/guardians_of_the_galaxy_vol_2', 'tt3896198', 'en', 'Guardians of the Galaxy Vol. 2', 'The Guardians must fight to keep their newfound family together as they unravel the mysteries of Peter Quill''s true parentage.', 67.553, '/y4MBh0EjBlMuOzv9axM4qJlmhzz.jpg', 'Obviously.', '\"Science Fiction, Adventure, Action\"', 'Marvel Studios', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(121, 'The Lord of the Rings: The Two Towers', 8.385, 20274, 'Released', '2002-12-18', 926287400, 179, 0, '/zcc0My3G4SYR72VuEYHNcUWkkW0.jpg', 79000000, 'http://www.lordoftherings.net/', 'tt0167261', 'en', 'The Lord of the Rings: The Two Towers', '\"Frodo and Sam are trekking to Mordor to destroy the One Ring of Power while Gimli, Legolas and Aragorn search for the orc-captured Merry and Pippin. All along, nefarious wizard Saruman awaits the Fellowship members at the Orthanc Tower in Isengard.\"', 78.73, '/5VTN0pR8gcqV3EPUHHfMGnJYN9L.jpg', 'A New Power Is Rising.', '\"Adventure, Fantasy, Action\"', '\"New Line Cinema, WingNut Films, The Saul Zaentz Company\"', '\"New Zealand, United States of America\"', 'English') | |
| INSERT INTO tabla VALUES(1771, 'Captain America: The First Avenger', 6.995, 20269, 'Released', '2011-07-22', 370569774, 124, 0, '/4NWWpT0jiMUak8r6jfpvG4eBgFU.jpg', 140000000, 'https://www.marvel.com/movies/captain-america-the-first-avenger', 'tt0458339', 'en', 'Captain America: The First Avenger', '\"During World War II, Steve Rogers is a sickly man from Brooklyn who''s transformed into super-soldier Captain America to aid in the war effort. Rogers must stop the Red Skull – Adolf Hitler''s ruthless head of weaponry, and the leader of an organization that intends to use a mysterious device of untold powers for world domination.\"', 43.665, '/vSNxAJTlD0r02V9sPYpOjqDZXUK.jpg', 'When patriots become heroes', '\"Action, Adventure, Science Fiction\"', 'Marvel Studios', 'United States of America', '\"French, Norwegian, English\"') | |
| INSERT INTO tabla VALUES(297761, 'Suicide Squad', 5.909, 20097, 'Released', '2016-08-03', 746846894, 123, 0, '/zC70x9wqPPtxU99HsoGsxQ8IhSw.jpg', 175000000, 'http://www.suicidesquad.com/', 'tt1386697', 'en', 'Suicide Squad', '\"From DC Comics comes the Suicide Squad, an antihero team of incarcerated supervillains who act as deniable assets for the United States government, undertaking high-risk black ops missions in exchange for commuted prison sentences.\"', 35.356, '/xFw9RXKZDvevAGocgBK0zteto4U.jpg', 'Worst. Heroes. Ever.', '\"Action, Adventure, Fantasy\"', '\"DC Entertainment, Dune Entertainment, Warner Bros. Pictures, Atlas Entertainment, DC Comics, DC Films, Lin Pictures\"', 'United States of America', '\"English, Japanese, Spanish\"') | |
| INSERT INTO tabla VALUES(673, 'Harry Potter and the Prisoner of Azkaban', 8.02, 20038, 'Released', '2004-05-31', 789804554, 141, 0, '/obKmfNexgL4ZP5cAmzdL4KbHHYX.jpg', 130000000, 'https://www.warnerbros.com/movies/harry-potter-and-prisoner-azkaban/', 'tt0304141', 'en', 'Harry Potter and the Prisoner of Azkaban', '\"Year three at Hogwarts means new fun and challenges as Harry learns the delicate art of approaching a Hippogriff, transforming shape-shifting Boggarts into hilarity and even turning back time. But the term also brings danger: soul-sucking Dementors hover over the school, an ally of the accursed He-Who-Cannot-Be-Named lurks within the castle walls, and fearsome wizard Sirius Black escapes Azkaban. And Harry will confront them all.\"', 124.386, '/aWxwnYoe8p2d2fcxOqtvAtJ72Rw.jpg', 'Something wicked this way comes.', '\"Adventure, Fantasy\"', '\"Warner Bros. Pictures, 1492 Pictures, Heyday Films, P of A Productions Limited\"', '\"United Kingdom, United States of America\"', 'English') | |
| INSERT INTO tabla VALUES(10195, 'Thor', 6.768, 20023, 'Released', '2011-04-21', 449326618, 115, 0, '/1wOu8rdvPxU1ObHi20VcRhfNpbo.jpg', 150000000, 'http://thor.marvel.com/', 'tt0800369', 'en', 'Thor', '\"Against his father Odin''s will, The Mighty Thor - a powerful but arrogant warrior god - recklessly reignites an ancient war. Thor is cast down to Earth and forced to live among humans as punishment. Once here, Thor learns what it takes to be a true hero when the most dangerous villain of his world sends the darkest forces of Asgard to invade Earth.\"', 51.277, '/prSfAi1xGrhLQNxVSUFh61xQ4Qy.jpg', 'Two worlds. One hero.', '\"Adventure, Fantasy, Action\"', 'Marvel Studios', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(10138, 'Iron Man 2', 6.835, 19756, 'Released', '2010-04-28', 623933331, 124, 0, '/jesRqfL9v6HNnowe795xjmuKUXl.jpg', 200000000, 'https://www.marvel.com/movies/iron-man-2', 'tt1228705', 'en', 'Iron Man 2', '\"With the world now aware of his dual life as the armored superhero Iron Man, billionaire inventor Tony Stark faces pressure from the government, the press and the public to share his technology with the military. Unwilling to let go of his invention, Stark, with Pepper Potts and James ''Rhodey'' Rhodes at his side, must forge new alliances – and confront powerful enemies.\"', 84.445, '/6WBeq4fCfn7AN0o21W9qNcRF2l9.jpg', '\"It''s not the armor that makes the hero, but the man inside.\"', '\"Adventure, Action, Science Fiction\"', '\"Marvel Studios, Fairview Entertainment\"', 'United States of America', '\"English, Russian, French\"') | |
| INSERT INTO tabla VALUES(272, 'Batman Begins', 7.701, 19561, 'Released', '2005-06-10', 374218673, 140, 0, '/lh5lbisD4oDbEKgUxoRaZU8HVrk.jpg', 150000000, 'https://www.warnerbros.com/movies/batman-begins/', 'tt0372784', 'en', 'Batman Begins', '\"Driven by tragedy, billionaire Bruce Wayne dedicates his life to uncovering and defeating the corruption that plagues his home, Gotham City. Unable to work within the system, he instead creates a new identity, a symbol of fear for the criminal underworld - The Batman.\"', 66.286, '/4MpN4kIEqUjW8OPtOQJXlTdHiJV.jpg', 'Evil fears the knight.', '\"Action, Crime, Drama\"', '\"Warner Bros. Pictures, DC Comics, Syncopy, Legendary Pictures, Patalex III Productions Limited\"', '\"United Kingdom, United States of America\"', '\"English, Urdu, Mandarin\"') | |
| INSERT INTO tabla VALUES(284053, 'Thor: Ragnarok', 7.595, 19539, 'Released', '2017-10-02', 855301806, 131, 0, '/kaIfm5ryEOwYg8mLbq8HkPuM1Fo.jpg', 180000000, 'https://marvel.com/movies/movie/222/thor_ragnarok', 'tt3501632', 'en', 'Thor: Ragnarok', '\"Thor is imprisoned on the other side of the universe and finds himself in a race against time to get back to Asgard to stop Ragnarok, the destruction of his home-world and the end of Asgardian civilization, at the hands of a powerful new threat, the ruthless Hela.\"', 45.2, '/rzRwTcFvttcN1ZpX2xv4j3tSdJu.jpg', 'No hammer. No problem.', '\"Action, Adventure, Science Fiction\"', 'Marvel Studios', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(150540, 'Inside Out', 7.922, 19463, 'Released', '2015-06-09', 857611174, 95, 0, '/j29ekbcLpBvxnGk6LjdTc2EI5SA.jpg', 175000000, 'http://movies.disney.com/inside-out', 'tt2096673', 'en', 'Inside Out', '\"Growing up can be a bumpy road, and it''s no exception for Riley, who is uprooted from her Midwest life when her father starts a new job in San Francisco. Riley''s guiding emotions— Joy, Fear, Anger, Disgust and Sadness—live in Headquarters, the control centre inside Riley''s mind, where they help advise her through everyday life and tries to keep things positive, but the emotions conflict on how best to navigate a new city, house and school.\"', 107.292, '/2H1TmgdfNtsKlU9jKdeNyYL5y8T.jpg', 'Meet the little voices inside your head.', '\"Animation, Family, Adventure, Drama, Comedy\"', '\"Pixar, Walt Disney Pictures\"', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(135397, 'Jurassic World', 6.682, 19414, 'Released', '2015-06-06', 1671537444, 124, 0, '/dF6FjTZzRTENfB4R17HDN20jLT2.jpg', 150000000, 'http://www.jurassicworld.com/', 'tt0369610', 'en', 'Jurassic World', '\"Twenty-two years after the events of Jurassic Park, Isla Nublar now features a fully functioning dinosaur theme park, Jurassic World, as originally envisioned by John Hammond.\"', 54.089, '/A0LZHXUzo5C60Oahvt7VxvwuzHw.jpg', 'The park is open.', '\"Action, Adventure, Science Fiction, Thriller\"', '\"Amblin Entertainment, Universal Pictures\"', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(807, 'Se7en', 8.368, 19403, 'Released', '1995-09-22', 327311859, 127, 0, '/i5H7zusQGsysGQ8i6P361Vnr0n2.jpg', 33000000, 'http://www.sevenmovie.com/', 'tt0114369', 'en', 'Se7en', '\"Two homicide detectives are on a desperate hunt for a serial killer whose crimes are based on the \"\"seven deadly sins\"\" in this dark and haunting film that takes viewers from the tortured remains of one victim to the next. The seasoned Det. Sommerset researches each sin in an effort to get inside the killer''s mind, while his novice partner, Mills, scoffs at his efforts to unravel the case.\"', 53.521, '/6yoghtyTpznpBik8EngEmJskVUO.jpg', 'Seven deadly sins. Seven ways to die.', '\"Crime, Mystery, Thriller\"', '\"New Line Cinema, Juno Pix, Cecchi Gori Pictures\"', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(674, 'Harry Potter and the Goblet of Fire', 7.816, 19287, 'Released', '2005-11-16', 895921036, 157, 0, '/5rrGVmRUuCKVbqUu41XIWTXJmNA.jpg', 150000000, 'https://www.warnerbros.com/movies/harry-potter-and-goblet-fire/', 'tt0330373', 'en', 'Harry Potter and the Goblet of Fire', '\"When Harry Potter''s name emerges from the Goblet of Fire, he becomes a competitor in a grueling battle for glory among three wizarding schools—the Triwizard Tournament. But since Harry never submitted his name for the Tournament, who did? Now Harry must confront a deadly dragon, fierce water demons and an enchanted maze only to find himself in the cruel grasp of He Who Must Not Be Named.\"', 134.276, '/fECBtHlr0RB3foNHDiCBXeg9Bv9.jpg', 'Dark And Difficult Times Lie Ahead.', '\"Adventure, Fantasy\"', '\"Warner Bros. Pictures, Heyday Films, Patalex IV Productions Limited\"', '\"United Kingdom, United States of America\"', '\"English, French\"') | |
| INSERT INTO tabla VALUES(22, 'Pirates of the Caribbean: The Curse of the Black Pearl', 7.794, 19233, 'Released', '2003-07-09', 655011224, 143, 0, '/wW7Wt5bXzPy4VOEE4LTIUDyDgBo.jpg', 140000000, 'https://movies.disney.com/pirates-of-the-caribbean-the-curse-of-the-black-pearl', 'tt0325980', 'en', 'Pirates of the Caribbean: The Curse of the Black Pearl', '\"Jack Sparrow, a freewheeling 18th-century pirate, quarrels with a rival pirate bent on pillaging Port Royal. When the governor''s daughter is kidnapped, Sparrow decides to help the girl''s love save her.\"', 80.509, '/z8onk7LV9Mmw6zKz4hT6pzzvmvl.jpg', 'Prepare to be blown out of the water.', '\"Adventure, Fantasy, Action\"', '\"Walt Disney Pictures, Jerry Bruckheimer Films\"', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(12445, 'Harry Potter and the Deathly Hallows: Part 2', 8.105, 19183, 'Released', '2011-07-12', 1341511219, 130, 0, '/n5A7brJCjejceZmHyujwUTVgQNC.jpg', 125000000, 'https://www.warnerbros.com/movies/harry-potter-and-deathly-hallows-part-2/', 'tt1201607', 'en', 'Harry Potter and the Deathly Hallows: Part 2', '\"Harry, Ron and Hermione continue their quest to vanquish the evil Voldemort once and for all. Just as things begin to look hopeless for the young wizards, Harry discovers a trio of magical objects that endow him with powers to rival Voldemort''s formidable skills.\"', 110.974, '/c54HpQmuwXjHq2C9wmoACjxoom3.jpg', 'It all ends here.', '\"Fantasy, Adventure\"', '\"Warner Bros. Pictures, Heyday Films\"', '\"United Kingdom, United States of America\"', 'English') | |
| INSERT INTO tabla VALUES(11, 'Star Wars', 8.204, 19155, 'Released', '1977-05-25', 775398007, 121, 0, '/zqkmTXzjkAgXmEWLRsY4UpTWCeo.jpg', 11000000, 'http://www.starwars.com/films/star-wars-episode-iv-a-new-hope', 'tt0076759', 'en', 'Star Wars', 'Princess Leia is captured and held hostage by the evil Imperial forces in their effort to take over the galactic Empire. Venturesome Luke Skywalker and dashing captain Han Solo team together with the loveable robot duo R2-D2 and C-3PO to rescue the beautiful princess and restore peace and justice in the Empire.', 88.559, '/6FfCtAuVAW8XJjZ7eWeLibRLWTw.jpg', '\"A long time ago in a galaxy far, far away...\"', '\"Adventure, Action, Science Fiction\"', '\"Lucasfilm Ltd., 20th Century Fox\"', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(297762, 'Wonder Woman', 7.236, 18954, 'Released', '2017-05-30', 822854286, 141, 0, '/AaABt75ZzfMGrscUR2seabz4PEX.jpg', 149000000, 'https://www.warnerbros.com/movies/wonder-woman', 'tt0451279', 'en', 'Wonder Woman', 'An Amazon princess comes to the world of Man in the grips of the First World War to confront the forces of evil and bring an end to human conflict.', 54.628, '/imekS7f1OuHyUP2LAiTEM0zBzUz.jpg', 'Power. Grace. Wisdom. Wonder.', '\"Action, Adventure, Fantasy\"', '\"Atlas Entertainment, Cruel & Unusual Films, DC Films\"', 'United States of America', '\"German, English\"') | |
| INSERT INTO tabla VALUES(14160, 'Up', 7.949, 18857, 'Released', '2009-05-28', 735099082, 96, 0, '/hGGC9gKo7CFE3fW07RA587e5kol.jpg', 175000000, 'http://disney.go.com/disneypictures/up/', 'tt1049413', 'en', 'Up', '\"Carl Fredricksen spent his entire life dreaming of exploring the globe and experiencing life to its fullest. But at age 78, life seems to have passed him by, until a twist of fate (and a persistent 8-year old Wilderness Explorer named Russell) gives him a new lease on life.\"', 90.968, '/vpbaStTMt8qqXaEgnOR2EE4DNJk.jpg', 'The greatest adventure is just getting back home.', '\"Animation, Comedy, Family, Adventure\"', 'Pixar', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(102899, 'Ant-Man', 7.082, 18730, 'Released', '2015-07-14', 519311965, 117, 0, '/1K3JmSNUN8OpjYsCjc0Hy0SYxAb.jpg', 130000000, 'http://marvel.com/movies/movie/180/ant-man', 'tt0478970', 'en', 'Ant-Man', '\"Armed with the astonishing ability to shrink in scale but increase in strength, master thief Scott Lang must embrace his inner-hero and help his mentor, Doctor Hank Pym, protect the secret behind his spectacular Ant-Man suit from a new generation of towering threats. Against seemingly insurmountable obstacles, Pym and Lang must plan and pull off a heist that will save the world.\"', 37.692, '/8YxOIPrabqkQCOKKbuxaz9IcqhO.jpg', 'Heroes don''t get any bigger.', '\"Science Fiction, Action, Adventure\"', 'Marvel Studios', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(238, 'The Godfather', 8.707, 18677, 'Released', '1972-03-14', 245066411, 175, 0, '/tmU7GeKVybMWFButWEGl2M4GeiP.jpg', 6000000, 'http://www.thegodfather.com/', 'tt0068646', 'en', 'The Godfather', '\"Spanning the years 1945 to 1955, a chronicle of the fictional Italian-American Corleone crime family. When organized crime family patriarch, Vito Corleone barely survives an attempt on his life, his youngest son, Michael steps in to take care of the would-be killers, launching a campaign of bloody revenge.\"', 158.448, '/3bhkrj58Vtu7enYsRolD1fZdja1.jpg', 'An offer you can''t refuse.', '\"Drama, Crime\"', '\"Paramount, Alfran Productions\"', 'United States of America', '\"English, Italian, Latin\"') | |
| INSERT INTO tabla VALUES(286217, 'The Martian', 7.678, 18525, 'Released', '2015-09-30', 630600000, 141, 0, '/3dPhs7hUnQLphDFzdkD407VZDYo.jpg', 108000000, 'https://www.20thcenturystudios.com/movies/the-martian', 'tt3659388', 'en', 'The Martian', '\"During a manned mission to Mars, Astronaut Mark Watney is presumed dead after a fierce storm and left behind by his crew. But Watney has survived and finds himself stranded and alone on the hostile planet. With only meager supplies, he must draw upon his ingenuity, wit and spirit to subsist and find a way to signal to Earth that he is alive.\"', 76.0, '/5BHuvQ6p9kfc091Z8RiFNhCwL4b.jpg', 'Bring Him Home', '\"Drama, Adventure, Science Fiction\"', '\"Scott Free Productions, Genre Films\"', '\"United Kingdom, United States of America\"', '\"English, Mandarin\"') | |
| INSERT INTO tabla VALUES(105, 'Back to the Future', 8.314, 18442, 'Released', '1985-07-03', 381109762, 116, 0, '/5bzPWQ2dFUl2aZKkp7ILJVVkRed.jpg', 19000000, 'http://www.backtothefuture.com/movies/backtothefuture1', 'tt0088763', 'en', 'Back to the Future', '\"Eighties teenager Marty McFly is accidentally sent back in time to 1955, inadvertently disrupting his parents'' first meeting and attracting his mother''s romantic interest. Marty must repair the damage to history by rekindling his parents'' romance and - with the help of his eccentric inventor friend Doc Brown - return to 1985.\"', 62.543, '/fNOH9f1aA7XRTzl1sAOx9iF553Q.jpg', 'He''s the only kid ever to get into trouble before he was born.', '\"Adventure, Comedy, Science Fiction\"', '\"Universal Pictures, Amblin Entertainment\"', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(140607, 'Star Wars: The Force Awakens', 7.293, 18352, 'Released', '2015-12-15', 2068223624, 136, 0, '/8BTsTfln4jlQrLXUBquXJ0ASQy9.jpg', 245000000, 'http://www.starwars.com/films/star-wars-episode-vii', 'tt2488496', 'en', 'Star Wars: The Force Awakens', '\"Thirty years after defeating the Galactic Empire, Han Solo and his allies face a new threat from the evil Kylo Ren and his army of Stormtroopers.\"', 66.772, '/wqnLdwVXoBjKibFRR5U3y0aDUhs.jpg', 'Every generation has a story.', '\"Adventure, Action, Science Fiction\"', '\"Lucasfilm Ltd., Bad Robot\"', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(634649, 'Spider-Man: No Way Home', 7.99, 18299, 'Released', '2021-12-15', 1921847111, 148, 0, '/14QbnygCuTO0vl7CAFmPf1fgZfV.jpg', 200000000, 'https://www.spidermannowayhome.movie', 'tt10872600', 'en', 'Spider-Man: No Way Home', '\"Peter Parker is unmasked and no longer able to separate his normal life from the high-stakes of being a super-hero. When he asks for help from Doctor Strange the stakes become even more dangerous, forcing him to discover what it truly means to be Spider-Man.\"', 186.065, '/5weKu49pzJCt06OPpjvT80efnQj.jpg', 'The Multiverse unleashed.', '\"Action, Adventure, Science Fiction\"', '\"Marvel Studios, Pascal Pictures, Columbia Pictures\"', 'United States of America', '\"English, Tagalog\"') | |
| INSERT INTO tabla VALUES(675, 'Harry Potter and the Order of the Phoenix', 7.686, 18177, 'Released', '2007-07-08', 938212738, 138, 0, '/pkxPkHOPJjOvzfQOclANEBT8OfK.jpg', 150000000, 'https://www.warnerbros.com/movies/harry-potter-and-order-phoenix/', 'tt0373889', 'en', 'Harry Potter and the Order of the Phoenix', '\"Returning for his fifth year of study at Hogwarts, Harry is stunned to find that his warnings about the return of Lord Voldemort have been ignored. Left with no choice, Harry takes matters into his own hands, training a small group of students to defend themselves against the dark arts.\"', 117.168, '/5aOyriWkPec0zUDxmHFP9qMmBaj.jpg', 'Evil Must Be Confronted.', '\"Adventure, Fantasy\"', '\"Warner Bros. Pictures, Heyday Films\"', '\"United Kingdom, United States of America\"', 'English') | |
| INSERT INTO tabla VALUES(767, 'Harry Potter and the Half-Blood Prince', 7.697, 18127, 'Released', '2009-07-15', 933959197, 153, 0, '/urDWNffjwmNi5IQaezw9GwqkUXa.jpg', 250000000, 'https://www.warnerbros.com/movies/harry-potter-and-half-blood-prince/', 'tt0417741', 'en', 'Harry Potter and the Half-Blood Prince', '\"As Lord Voldemort tightens his grip on both the Muggle and wizarding worlds, Hogwarts is no longer a safe haven. Harry suspects perils may even lie within the castle, but Dumbledore is more intent upon preparing him for the final battle fast approaching. Together they work to find the key to unlock Voldemorts defenses and to this end, Dumbledore recruits his old friend and colleague Horace Slughorn, whom he believes holds crucial information. Even as the decisive showdown looms, romance blossoms for Harry, Ron, Hermione and their classmates. Love is in the air, but danger lies ahead and Hogwarts may never be the same again.\"', 121.735, '/z7uo9zmQdQwU5ZJHFpv2Upl30i1.jpg', 'Dark Secrets Revealed', '\"Adventure, Fantasy\"', '\"Warner Bros. Pictures, Heyday Films\"', '\"United Kingdom, United States of America\"', 'English') | |
| INSERT INTO tabla VALUES(263115, 'Logan', 7.8, 18116, 'Released', '2017-02-28', 619021436, 137, 0, '/9X7YweCJw3q8Mcf6GadxReFEksM.jpg', 97000000, 'https://www.20thcenturystudios.com/movies/logan', 'tt3315342', 'en', 'Logan', '\"In the near future, a weary Logan cares for an ailing Professor X in a hideout on the Mexican border. But Logan''s attempts to hide from the world and his legacy are upended when a young mutant arrives, pursued by dark forces.\"', 54.194, '/fnbjcRDYn6YviCcePDnGdyAkYsB.jpg', 'His time has come.', '\"Action, Drama, Science Fiction\"', '\"Hutch Parker Entertainment, The Donners'' Company, Genre Films, 20th Century Fox\"', 'United States of America', '\"English, Spanish\"') | |
| INSERT INTO tabla VALUES(12, 'Finding Nemo', 7.824, 18061, 'Released', '2003-05-30', 940335536, 100, 0, '/h3uqFk7sZRJvLZDdLiFB9qwbL07.jpg', 94000000, 'http://movies.disney.com/finding-nemo', 'tt0266543', 'en', 'Finding Nemo', '\"Nemo, an adventurous young clownfish, is unexpectedly taken from his Great Barrier Reef home to a dentist''s office aquarium. It''s up to his worrisome father Marlin and a friendly but forgetful fish Dory to bring Nemo home -- meeting vegetarian sharks, surfer dude turtles, hypnotic jellyfish, hungry seagulls, and more along the way.\"', 55.456, '/ggQ6o8X5984OCh3kZi2UIJQJY5y.jpg', 'There are 3.7 trillion fish in the ocean. They''re looking for one.', '\"Animation, Family\"', 'Pixar', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(346364, 'It', 7.242, 18018, 'Released', '2017-09-06', 701800000, 135, 0, '/tcheoA2nPATCm2vvXw2hVQoaEFD.jpg', 40000000, 'http://itthemovie.com/', 'tt1396484', 'en', 'It', '\"In a small town in Maine, seven children known as The Losers Club come face to face with life problems, bullies and a monster that takes the shape of a clown called Pennywise.\"', 74.73, '/9E2y5Q7WlCVNEhP5GiVTjhEhx1o.jpg', 'You’ll float too', '\"Horror, Fantasy\"', '\"New Line Cinema, Vertigo Entertainment, Lin Pictures, KatzSmith Productions\"', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(245891, 'John Wick', 7.421, 17923, 'Released', '2014-10-22', 88761661, 101, 0, '/7dzngS8pLkGJpyeskCFcjPO9qLF.jpg', 20000000, 'https://www.lionsgate.com/movies/john-wick', 'tt2911666', 'en', 'John Wick', 'Ex-hitman John Wick comes out of retirement to track down the gangsters that took everything from him.', 55.739, '/fZPSd91yGE9fCcCe6OoQr6E3Bev.jpg', 'Don''t set him off.', '\"Action, Thriller\"', '\"87Eleven, DefyNite Films, MJW Films, Thunder Road\"', 'United States of America', '\"Hungarian, English, Russian\"') | |
| INSERT INTO tabla VALUES(259316, 'Fantastic Beasts and Where to Find Them', 7.334, 17892, 'Released', '2016-11-16', 809342332, 132, 0, '/8Qsr8pvDL3s1jNZQ4HK1d1Xlvnh.jpg', 180000000, 'http://www.fantasticbeasts.com/', 'tt3183660', 'en', 'Fantastic Beasts and Where to Find Them', '\"In 1926, Newt Scamander arrives at the Magical Congress of the United States of America with a magically expanded briefcase, which houses a number of dangerous creatures and their habitats. When the creatures escape from the briefcase, it sends the American wizarding authorities after Newt, and threatens to strain even further the state of magical and non-magical relations.\"', 46.103, '/h6NYfVUyM6CDURtZSnBpz647Ldd.jpg', 'From J.K. Rowling''s wizarding world.', '\"Fantasy, Adventure, Family\"', '\"Heyday Films, Warner Bros. Pictures\"', '\"United Kingdom, United States of America\"', 'English') | |
| INSERT INTO tabla VALUES(12444, 'Harry Potter and the Deathly Hallows: Part 1', 7.763, 17782, 'Released', '2010-11-17', 954305868, 146, 0, '/AqLcLsGGTzAjm3pCCq0CZCQrp6m.jpg', 250000000, 'https://www.warnerbros.com/movies/harry-potter-and-deathly-hallows-part-1/', 'tt0926084', 'en', 'Harry Potter and the Deathly Hallows: Part 1', '\"Harry, Ron and Hermione walk away from their last year at Hogwarts to find and destroy the remaining Horcruxes, putting an end to Voldemort''s bid for immortality. But with Harry''s beloved Dumbledore dead and Voldemort''s unscrupulous Death Eaters on the loose, the world is more dangerous than ever.\"', 111.984, '/iGoXIpQb7Pot00EEdwpwPajheZ5.jpg', 'One Way… One Fate… One Hero.', '\"Adventure, Fantasy\"', '\"Warner Bros. Pictures, Heyday Films\"', '\"United Kingdom, United States of America\"', 'English') | |
| INSERT INTO tabla VALUES(354912, 'Coco', 8.222, 17742, 'Released', '2017-10-27', 800526015, 105, 0, '/askg3SMvhqEl4OL52YuvdtY40Yb.jpg', 175000000, 'https://www.pixar.com/feature-films/coco', 'tt2380307', 'en', 'Coco', '\"Despite his family’s baffling generations-old ban on music, Miguel dreams of becoming an accomplished musician like his idol, Ernesto de la Cruz. Desperate to prove his talent, Miguel finds himself in the stunning and colorful Land of the Dead following a mysterious chain of events. Along the way, he meets charming trickster Hector, and together, they set off on an extraordinary journey to unlock the real story behind Miguel''s family history.\"', 166.578, '/gGEsBPAijhVUFoiNpgZXqRVWJt2.jpg', 'The celebration of a lifetime', '\"Family, Animation, Fantasy, Music, Comedy, Adventure\"', '\"Pixar, Walt Disney Pictures\"', 'United States of America', '\"English, Spanish\"') | |
| INSERT INTO tabla VALUES(100402, 'Captain America: The Winter Soldier', 7.671, 17692, 'Released', '2014-03-20', 714766572, 136, 0, '/1RWLMyC9KcFfcaoViMiJGSSZzzr.jpg', 170000000, 'http://www.captainamericathewintersoldiermovie.com', 'tt1843866', 'en', 'Captain America: The Winter Soldier', '\"After the cataclysmic events in New York with The Avengers, Steve Rogers, aka Captain America is living quietly in Washington, D.C. and trying to adjust to the modern world. But when a S.H.I.E.L.D. colleague comes under attack, Steve becomes embroiled in a web of intrigue that threatens to put the world at risk. Joining forces with the Black Widow, Captain America struggles to expose the ever-widening conspiracy while fighting off professional assassins sent to silence him at every turn. When the full scope of the villainous plot is revealed, Captain America and the Black Widow enlist the help of a new ally, the Falcon. However, they soon find themselves up against an unexpected and formidable enemy—the Winter Soldier.\"', 31.482, '/tVFRpFw3xTedgPGqxW0AOI8Qhh0.jpg', 'In heroes we trust.', '\"Action, Adventure, Science Fiction\"', 'Marvel Studios', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(557, 'Spider-Man', 7.279, 17653, 'Released', '2002-05-01', 821708551, 121, 0, '/jHxCeXnSchAuwHnmVatTgqMYdX8.jpg', 139000000, 'https://www.sonypictures.com/movies/spiderman', 'tt0145487', 'en', 'Spider-Man', '\"After being bitten by a genetically altered spider at Oscorp, nerdy but endearing high school student Peter Parker is endowed with amazing powers to become the superhero known as Spider-Man.\"', 63.478, '/gh4cZbhZxyTbgxQPxD0dOudNPTn.jpg', 'With great power comes great responsibility.', '\"Fantasy, Action\"', '\"Marvel Enterprises, Laura Ziskin Productions, Columbia Pictures\"', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(10681, 'WALL·E', 8.078, 17446, 'Released', '2008-06-22', 521311860, 98, 0, '/fK5ssgvtI43z19FoWigdlqgpLRE.jpg', 180000000, 'https://www.pixar.com/feature-films/walle/', 'tt0910970', 'en', 'WALL·E', '\"What if mankind had to leave Earth and somebody forgot to turn the last robot off? After hundreds of years doing what he was built for, WALL•E discovers a new purpose in life when he meets a sleek search robot named EVE. EVE comes to realize that WALL•E has inadvertently stumbled upon the key to the planet''s future, and races back to space to report to the humans. Meanwhile, WALL•E chases EVE across the galaxy and sets into motion one of the most imaginative adventures ever brought to the big screen.\"', 58.517, '/hbhFnRzzg6ZDmm8YAmxBnQpQIPh.jpg', '\"After 700 years of doing what he was built for, he''ll discover what he was meant for.\"', '\"Animation, Family, Science Fiction\"', '\"Pixar, Walt Disney Pictures\"', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(210577, 'Gone Girl', 7.892, 17381, 'Released', '2014-10-01', 369330363, 149, 0, '/h2JaQWLKhapm7AuSViJwGiv8ngC.jpg', 61000000, 'http://www.gonegirlmovie.com/', 'tt2267998', 'en', 'Gone Girl', '\"With his wife''s disappearance having become the focus of an intense media circus, a man sees the spotlight turned on him when it''s suspected that he may not be innocent.\"', 46.611, '/qymaJhucquUwjpb8oiqynMeXnID.jpg', 'You don''t know what you''ve got ''til it''s...', '\"Mystery, Thriller, Drama\"', '\"Regency Enterprises, New Regency Pictures, Pacific Standard, TSG Entertainment, Artemple - Hollywood, 20th Century Fox\"', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(49051, 'The Hobbit: An Unexpected Journey', 7.339, 17356, 'Released', '2012-12-12', 1021103568, 169, 0, '/xyXmtuvsoM5J3yNad0nvcetpBdY.jpg', 250000000, 'http://www.thehobbit.com/', 'tt0903624', 'en', 'The Hobbit: An Unexpected Journey', '\"Bilbo Baggins, a hobbit enjoying his quiet life, is swept into an epic quest by Gandalf the Grey and thirteen dwarves who seek to reclaim their mountain home from Smaug, the dragon.\"', 83.524, '/yHA9Fc37VmpUA5UncTxxo3rTGVA.jpg', 'From the smallest beginnings come the greatest legends.', '\"Adventure, Fantasy, Action\"', '\"Warner Bros. Pictures, Metro-Goldwyn-Mayer, New Line Cinema, WingNut Films\"', '\"New Zealand, United States of America\"', 'English') | |
| INSERT INTO tabla VALUES(585, '\"Monsters, Inc.\"', 7.835, 17189, 'Released', '2001-11-01', 579707738, 92, 0, '/vUTVUdfbsY4DePCYzxxDMXKp6v6.jpg', 115000000, 'http://movies.disney.com/monsters-inc', 'tt0198781', 'en', '\"Monsters, Inc.\"', '\"Lovable Sulley and his wisecracking sidekick Mike Wazowski are the top scare team at Monsters, Inc., the scream-processing factory in Monstropolis. When a little girl named Boo wanders into their world, it''s the monsters who are scared silly, and it''s up to Sulley and Mike to keep her out of sight and get her back home.\"', 86.936, '/sgheSKxZkttIe8ONsf2sWXPgip3.jpg', 'We Scare Because We Care.', '\"Animation, Comedy, Family\"', 'Pixar', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(862, 'Toy Story', 7.971, 17152, 'Released', '1995-10-30', 394400000, 81, 0, '/3Rfvhy1Nl6sSGJwyjb0QiZzZYlB.jpg', 30000000, 'http://toystory.disney.com/toy-story', 'tt0114709', 'en', 'Toy Story', '\"Led by Woody, Andy''s toys live happily in his room until Andy''s birthday brings Buzz Lightyear onto the scene. Afraid of losing his place in Andy''s heart, Woody plots against Buzz. But when circumstances separate Buzz and Woody from their owner, the duo eventually learns to put aside their differences.\"', 78.404, '/uXDfjJbdP4ijW5hWSBrPrlKpxab.jpg', 'Hang on for the comedy that goes to infinity and beyond!', '\"Animation, Adventure, Family, Comedy\"', 'Pixar', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(281957, 'The Revenant', 7.5, 17114, 'Released', '2015-12-25', 532950503, 157, 0, '/3uM41OT0RfBkE6Gb6U89LEskJBr.jpg', 135000000, 'https://www.foxmovies.com/movies/the-revenant', 'tt1663202', 'en', 'The Revenant', '\"In the 1820s, a frontiersman, Hugh Glass, sets out on a path of vengeance against those who left him for dead after a bear mauling.\"', 36.747, '/ji3ecJphATlVgWNY0B0RVXZizdf.jpg', '\"(n. One who has returned, as if from the dead.)\"', '\"Western, Drama, Adventure\"', '\"Monarchy Enterprises S.a.r.l., Regency Enterprises, Appian Way, CatchPlay, Anonymous Content, New Regency Pictures, Hong Kong Alpha Motion Pictures Co., M Productions, RatPac Entertainment\"', '\"Canada, Hong Kong, Taiwan, United States of America\"', '\"English, French\"') | |
| INSERT INTO tabla VALUES(209112, 'Batman v Superman: Dawn of Justice', 5.952, 17081, 'Released', '2016-03-23', 873637528, 152, 0, '/5fX1oSGuYdKgwWmUTAN5MNSQGzr.jpg', 250000000, 'https://www.warnerbros.com/movies/batman-v-superman-dawn-justice', 'tt2975590', 'en', 'Batman v Superman: Dawn of Justice', '\"Fearing the actions of a god-like Super Hero left unchecked, Gotham City’s own formidable, forceful vigilante takes on Metropolis’s most revered, modern-day savior, while the world wrestles with what sort of hero it really needs. And with Batman and Superman at war with one another, a new threat quickly arises, putting mankind in greater danger than it’s ever known before.\"', 78.589, '/5UsK3grJvtQrtzEgqNlDljJW96w.jpg', 'Who will win?', '\"Action, Adventure, Fantasy\"', '\"Warner Bros. Pictures, RatPac Entertainment, Atlas Entertainment, Cruel & Unusual Films, DC Entertainment, Syncopy\"', '\"Canada, United Kingdom, United States of America\"', 'English') | |
| INSERT INTO tabla VALUES(8587, 'The Lion King', 8.256, 16991, 'Released', '1994-06-24', 763455561, 89, 0, '/yDaMQbBfyGzGWKxUsPMxzWVuJlY.jpg', 45000000, 'http://movies.disney.com/the-lion-king', 'tt0110357', 'en', 'The Lion King', '\"A young lion prince is cast out of his pride by his cruel uncle, who claims he killed his father. While the uncle rules with an iron paw, the prince grows up beyond the Savannah, living by a philosophy: No worries for the rest of your days. But when his past comes to haunt him, the young prince must decide his fate: Will he remain an outcast or face his demons and become what he needs to be?\"', 87.384, '/sKCr78MXSLixwmZ8DyJLrpMsd15.jpg', 'Life''s greatest adventure is finding your place in the Circle of Life.', '\"Family, Animation, Drama\"', '\"Walt Disney Pictures, Walt Disney Feature Animation\"', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(98, 'Gladiator', 8.209, 16962, 'Released', '2000-05-04', 465361176, 155, 0, '/3ZVEtQxVPpEp5LNpAULDcxadTU3.jpg', 103000000, 'Not Available', 'tt0172495', 'en', 'Gladiator', '\"In the year 180, the death of emperor Marcus Aurelius throws the Roman Empire into chaos. Maximus is one of the Roman army''s most capable and trusted generals and a key advisor to the emperor. As Marcus'' devious son Commodus ascends to the throne, Maximus is set to be executed. He escapes, but is captured by slave traders. Renamed Spaniard and forced to become a gladiator, Maximus must battle to the death with other men for the amusement of paying audiences.\"', 53.587, '/ty8TGRuvJLPUmAR1H1nRIsgwvim.jpg', 'A hero will rise.', '\"Action, Drama, Adventure\"', '\"Universal Pictures, Scott Free Productions, Red Wagon Entertainment, Mill Film, C & L, Dawliz, DreamWorks Pictures\"', '\"United Kingdom, United States of America\"', 'English') | |
| INSERT INTO tabla VALUES(37165, 'The Truman Show', 8.133, 16827, 'Released', '1998-06-04', 264118201, 103, 0, '/aCHn2TXYJfzPXQKA6r9mKPbMlUB.jpg', 60000000, 'Not Available', 'tt0120382', 'en', 'The Truman Show', '\"Truman Burbank is the star of The Truman Show, a 24-hour-a-day reality TV show that broadcasts every aspect of his life without his knowledge. His entire life has been an unending soap opera for consumption by the rest of the world. And everyone he knows, including his wife and his best friend, is really an actor, paid to be part of his life.\"', 42.954, '/vuza0WqY239yBXOadKlGwJsZJFE.jpg', 'On the air. Unaware.', '\"Comedy, Drama\"', '\"Paramount, Scott Rudin Productions\"', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(9806, 'The Incredibles', 7.704, 16584, 'Released', '2004-10-27', 631442092, 115, 0, '/se5Hxz7PArQZOG3Nx2bpfOhLhtV.jpg', 92000000, 'http://disney.go.com/disneyvideos/animatedfilms/incredibles/main.html', 'tt0317705', 'en', 'The Incredibles', '\"Bob Parr has given up his superhero days to log in time as an insurance adjuster and raise his three children with his formerly heroic wife in suburbia. But when he receives a mysterious assignment, it''s time to get back into costume.\"', 62.609, '/2LqaLgk4Z226KkgPJuiOQ58wvrm.jpg', '\"No gut, no glory\"', '\"Action, Adventure, Animation, Family\"', '\"Pixar, Walt Disney Pictures\"', 'United States of America', '\"French, English\"') | |
| INSERT INTO tabla VALUES(329865, 'Arrival', 7.6, 16564, 'Released', '2016-11-10', 203388186, 116, 0, '/5B14ls1dftgOyTSRdzV9EPCa5pR.jpg', 47000000, 'http://www.arrivalmovie.com/', 'tt2543164', 'en', 'Arrival', '\"Taking place after alien crafts land around the world, an expert linguist is recruited by the military to determine whether they come in peace or are a threat.\"', 47.983, '/x2FJsf1ElAgr63Y3PNPtJrcmpoe.jpg', 'Why are they here?', '\"Drama, Science Fiction, Mystery\"', '\"FilmNation Entertainment, Lava Bear Films, Reliance Entertainment, Xenolinguistics, 21 Laps Entertainment, Paramount, Stage 6 Films\"', '\"Canada, India, United States of America\"', '\"Mandarin, English, Russian\"') | |
| INSERT INTO tabla VALUES(496243, 'Parasite', 8.515, 16430, 'Released', '2019-05-30', 257591776, 133, 0, '/hiKmpZMGZsrkA3cdce8a7Dpos1j.jpg', 11363000, 'https://www.parasite-movie.com/', 'tt6751668', 'ko', '기생충', '\"All unemployed, Ki-taek''s family takes peculiar interest in the wealthy and glamorous Parks for their livelihood until they get entangled in an unexpected incident.\"', 64.627, '/7IiTTgloJzvGI1TAYymCfbfl3vT.jpg', 'Act like you own the place.', '\"Comedy, Thriller, Drama\"', 'Barunson E&A', 'South Korea', '\"English, German, Korean\"') | |
| INSERT INTO tabla VALUES(76338, 'Thor: The Dark World', 6.538, 16359, 'Released', '2013-10-30', 644783140, 112, 0, '/4zTsF0RtO0av3YX1NaKDqGKPxYF.jpg', 170000000, 'https://www.marvel.com/movies/thor-the-dark-world', 'tt1981115', 'en', 'Thor: The Dark World', '\"Thor fights to restore order across the cosmos… but an ancient race led by the vengeful Malekith returns to plunge the universe back into darkness. Faced with an enemy that even Odin and Asgard cannot withstand, Thor must embark on his most perilous and personal journey yet, one that will reunite him with Jane Foster and force him to sacrifice everything to save us all.\"', 59.968, '/wp6OxE4poJ4G7c0U2ZIXasTSMR7.jpg', 'Delve into the darkness', '\"Action, Adventure, Fantasy\"', 'Marvel Studios', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(1930, 'The Amazing Spider-Man', 6.691, 16352, 'Released', '2012-06-23', 757930663, 136, 0, '/sLWUtbrpiLp23a0XDSiUiltdFPJ.jpg', 215000000, 'https://www.sonypictures.com/movies/theamazingspiderman', 'tt0948470', 'en', 'The Amazing Spider-Man', '\"Peter Parker is an outcast high schooler abandoned by his parents as a boy, leaving him to be raised by his Uncle Ben and Aunt May. Like most teenagers, Peter is trying to figure out who he is and how he got to be the person he is today. As Peter discovers a mysterious briefcase that belonged to his father, he begins a quest to understand his parents'' disappearance – leading him directly to Oscorp and the lab of Dr. Curt Connors, his father''s former partner. As Spider-Man is set on a collision course with Connors'' alter ego, The Lizard, Peter will make life-altering choices to use his powers and shape his destiny to become a hero.\"', 78.989, '/jIfkQNARYyERqRAq1p1c8xgePp4.jpg', 'The untold story begins.', '\"Action, Adventure, Fantasy\"', '\"Marvel Entertainment, Laura Ziskin Productions, Columbia Pictures, Matt Tolmach Productions, Arad Productions\"', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(381288, 'Split', 7.337, 16345, 'Released', '2017-01-19', 278454358, 117, 0, '/9pkZesKMnblFfKxEhQx45YQ2kIe.jpg', 9000000, 'http://www.splitmovie.com/', 'tt4972582', 'en', 'Split', '\"Though Kevin has evidenced 23 personalities to his trusted psychiatrist, Dr. Fletcher, there remains one still submerged who is set to materialize and dominate all the others. Compelled to abduct three teenage girls led by the willful, observant Casey, Kevin reaches a war for survival among all of those contained within him — as well as everyone around him — as the walls between his compartments shatter apart.\"', 44.51, '/lli31lYTFpvxVBeFHWoe5PMfW5s.jpg', 'Kevin has 23 distinct personalities. The 24th is about to be unleashed.', '\"Horror, Thriller\"', '\"Universal Pictures, Blinding Edge Pictures, Blumhouse Productions\"', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(383498, 'Deadpool 2', 7.492, 16324, 'Released', '2018-05-10', 785896609, 120, 0, '/3P52oz9HPQWxcwHOwxtyrVV1LKi.jpg', 110000000, 'https://www.20thcenturystudios.com/movies/deadpool-2', 'tt5463162', 'en', 'Deadpool 2', 'Wisecracking mercenary Deadpool battles the evil and powerful Cable and other bad guys to save a boy''s life.', 66.096, '/to0spRl1CMDvyUbOnbb4fTk3VAd.jpg', 'Prepare for the Second Coming.', '\"Action, Comedy, Adventure\"', '\"Maximum Effort, Genre Films, 20th Century Fox\"', 'United States of America', '\"Cantonese, English, Russian, Spanish\"') | |
| INSERT INTO tabla VALUES(694, 'The Shining', 8.218, 16205, 'Released', '1980-05-23', 44781695, 144, 0, '/AdKA2F1SzYPhSZdEbjH1Zh75UVQ.jpg', 19000000, 'Not Available', 'tt0081505', 'en', 'The Shining', '\"Jack Torrance accepts a caretaker job at the Overlook Hotel, where he, along with his wife Wendy and their son Danny, must live isolated from the rest of the world for the winter. But they aren''t prepared for the madness that lurks within.\"', 45.252, '/xazWoLealQwEgqZ89MLZklLZD3k.jpg', '\"He came as the caretaker, but this hotel had its own guardians - who''d been there a long time\"', '\"Horror, Thriller\"', '\"Hawk Films, Peregrine, Producers Circle, Warner Bros. Pictures\"', '\"United Kingdom, United States of America\"', 'English') | |
| INSERT INTO tabla VALUES(24, 'Kill Bill: Vol. 1', 7.97, 16188, 'Released', '2003-10-10', 180906076, 111, 0, '/k9Ps0EsrTnqbQ4oTTWx628BQ2TW.jpg', 30000000, 'http://www.miramax.com/movie/kill-bill-volume-1', 'tt0266697', 'en', 'Kill Bill: Vol. 1', '\"An assassin is shot by her ruthless employer, Bill, and other members of their assassination circle – but she lives to plot her vengeance.\"', 36.315, '/v7TaX8kXMXs5yFFGR41guUDNcnB.jpg', 'A roaring rampage of revenge.', '\"Action, Crime\"', '\"Miramax, A Band Apart, Super Cool ManChu\"', 'United States of America', '\"English, Japanese, French\"') | |
| INSERT INTO tabla VALUES(101299, 'The Hunger Games: Catching Fire', 7.4, 16182, 'Released', '2013-11-15', 865011746, 146, 0, '/dIi0De3LzEVSQHEUlh0Q2zUpmeW.jpg', 130000000, 'http://www.thehungergames.movie/', 'tt1951264', 'en', 'The Hunger Games: Catching Fire', '\"Katniss Everdeen has returned home safe after winning the 74th Annual Hunger Games along with fellow tribute Peeta Mellark. Winning means that they must turn around and leave their family and close friends, embarking on a \"\"Victor''s Tour\"\" of the districts. Along the way Katniss senses that a rebellion is simmering, but the Capitol is still very much in control as President Snow prepares the 75th Annual Hunger Games (The Quarter Quell) - a competition that could change Panem forever.\"', 49.864, '/vrQHDXjVmbYzadOXQ0UaObunoy2.jpg', 'Every revolution begins with a spark.', '\"Adventure, Action, Science Fiction\"', '\"Lionsgate, Color Force\"', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(77338, 'The Intouchables', 8.277, 16083, 'Released', '2011-11-02', 426588510, 113, 0, '/bGksau9GGu0uJ8DJQ8DYc9JW5LM.jpg', 13000000, 'Not Available', 'tt1675434', 'fr', 'Intouchables', 'A true story of two men who should never have met – a quadriplegic aristocrat who was injured in a paragliding accident and a young man from the projects.', 41.656, '/323BP0itpxTsO0skTwdnVmf7YC9.jpg', 'Sometimes you have to reach into someone else''s world to find out what''s missing in your own.', '\"Drama, Comedy\"', '\"Gaumont, CinéCinéma, Quad Productions, Chaocorp, Ten Films, TF1, Canal+, TF1 Films Production\"', 'France', '\"English, French\"') | |
| INSERT INTO tabla VALUES(419430, 'Get Out', 7.62, 16081, 'Released', '2017-02-24', 255407969, 104, 0, '/o8dPH0ZSIyyViP6rjRX1djwCUwI.jpg', 4500000, 'http://www.getoutfilm.com/', 'tt5052448', 'en', 'Get Out', '\"Chris and his girlfriend Rose go upstate to visit her parents for the weekend. At first, Chris reads the family''s overly accommodating behavior as nervous attempts to deal with their daughter''s interracial relationship, but as the weekend progresses, a series of increasingly disturbing discoveries lead him to a truth that he never could have imagined.\"', 36.442, '/mE24wUCfjK8AoBBjaMjho7Rczr7.jpg', '\"Just because you''re invited, doesn''t mean you''re welcome.\"', '\"Mystery, Thriller, Horror\"', '\"Monkeypaw Productions, Blumhouse Productions, QC Entertainment\"', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(205596, 'The Imitation Game', 8.007, 15973, 'Released', '2014-11-14', 233555708, 113, 0, '/caQp2MhwfrTYGqVr7d9ayn8tqQ7.jpg', 14000000, 'Not Available', 'tt2084970', 'en', 'The Imitation Game', '\"Based on the real life story of legendary cryptanalyst Alan Turing, the film portrays the nail-biting race against time by Turing and his brilliant team of code-breakers at Britain''s top-secret Government Code and Cypher School at Bletchley Park, during the darkest days of World War II.\"', 47.491, '/zSqJ1qFq8NXFfi7JeIYMlzyR0dx.jpg', 'The true enigma was the man who cracked the code.', '\"History, Drama, Thriller, War\"', '\"Bristol Automotive, Black Bear Pictures, The Weinstein Company, FilmNation Entertainment\"', '\"United Kingdom, United States of America\"', 'English') | |
| INSERT INTO tabla VALUES(424694, 'Bohemian Rhapsody', 7.997, 15965, 'Released', '2018-10-24', 903992901, 135, 0, '/dcvbs8z0GEXslC1kCT77x19XDeR.jpg', 52000000, 'http://bohemianrhapsody.com', 'tt1727824', 'en', 'Bohemian Rhapsody', '\"Singer Freddie Mercury, guitarist Brian May, drummer Roger Taylor and bass guitarist John Deacon take the music world by storm when they form the rock ''n'' roll band Queen in 1970. Hit songs become instant classics. When Mercury''s increasingly wild lifestyle starts to spiral out of control, Queen soon faces its greatest challenge yet – finding a way to keep the band together amid the success and excess.\"', 37.55, '/lHu1wtNaczFPGFDTrjCSzeLPTKN.jpg', 'Fearless lives forever', '\"Music, Drama, History\"', '\"GK Films, Regency Enterprises, Queen Films, Tribeca Productions, New Regency Pictures, 20th Century Fox\"', '\"United Kingdom, United States of America\"', 'English') | |
| INSERT INTO tabla VALUES(497, 'The Green Mile', 8.507, 15937, 'Released', '1999-12-10', 286801374, 189, 0, '/l6hQWH9eDksNJNiXWYRkWqikOdu.jpg', 60000000, 'http://thegreenmile.warnerbros.com/', 'tt0120689', 'en', 'The Green Mile', '\"A supernatural tale set on death row in a Southern prison, where gentle giant John Coffey possesses the mysterious power to heal people''s ailments. When the cell block''s head guard, Paul Edgecomb, recognizes Coffey''s miraculous gift, he tries desperately to help stave off the condemned man''s execution.\"', 83.739, '/8VG8fDNiy50H4FedGwdSVUPoaJe.jpg', 'Miracles do happen.', '\"Fantasy, Drama, Crime\"', '\"Castle Rock Entertainment, Darkwoods Productions, Warner Bros. Pictures, PolyGram Filmed Entertainment\"', 'United States of America', '\"French, English\"') | |
| INSERT INTO tabla VALUES(198663, 'The Maze Runner', 7.173, 15901, 'Released', '2014-09-10', 348319861, 113, 0, '/vHJlbhsXrZ5yrO2KqCbGSIU6fRX.jpg', 34000000, 'https://www.20thcenturystudios.com/movies/the-maze-runner', 'tt1790864', 'en', 'The Maze Runner', '\"Set in a post-apocalyptic world, young Thomas is deposited in a community of boys after his memory is erased, soon learning they''re all trapped in a maze that will require him to join forces with fellow “runners” for a shot at escape.\"', 83.206, '/ode14q7WtDugFDp78fo9lCsmay9.jpg', 'Remember. Survive. Run.', '\"Action, Mystery, Science Fiction, Thriller\"', '\"Ingenious Media, Gotham Group, Dayday Films, Temple Hill Entertainment, TSG Entertainment, 20th Century Fox\"', '\"United States of America, United Kingdom\"', 'English') | |
| INSERT INTO tabla VALUES(18785, 'The Hangover', 7.312, 15812, 'Released', '2009-06-02', 469310836, 100, 0, '/2o0PKGmnSgCGkzoSePNAqse8Ure.jpg', 35000000, 'https://www.warnerbros.com/movies/hangover', 'tt1119646', 'en', 'The Hangover', '\"When three friends finally come to after a raucous night of bachelor-party revelry, they find a baby in the closet and a tiger in the bathroom. But they can''t seem to locate their best friend, Doug – who''s supposed to be tying the knot. Launching a frantic search for Doug, the trio perseveres through a nasty hangover to try to make it to the church on time.\"', 72.655, '/uluhlXubGu1VxU63X9VHCLWDAYP.jpg', 'Some guys just can''t handle Vegas.', 'Comedy', '\"Legendary Pictures, Green Hat Films, Warner Bros. Pictures\"', '\"Germany, United States of America\"', 'English') | |
| INSERT INTO tabla VALUES(1891, 'The Empire Strikes Back', 8.4, 15773, 'Released', '1980-05-20', 538400000, 124, 0, '/aJCtkxLLzkk1pECehVjKHA2lBgw.jpg', 18000000, 'http://www.starwars.com/films/star-wars-episode-v-the-empire-strikes-back', 'tt0080684', 'en', 'The Empire Strikes Back', '\"The epic saga continues as Luke Skywalker, in hopes of defeating the evil Galactic Empire, learns the ways of the Jedi from aging master Yoda. But Darth Vader is more determined than ever to capture Luke. Meanwhile, rebel leader Princess Leia, cocky Han Solo, Chewbacca, and droids C-3PO and R2-D2 are thrown into various stages of capture, betrayal and despair.\"', 35.265, '/nNAeTmF4CtdSgMDplXTDPOpYzsX.jpg', 'The Adventure Continues...', '\"Adventure, Action, Science Fiction\"', 'Lucasfilm Ltd.', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(808, 'Shrek', 7.73, 15765, 'Released', '2001-05-18', 487853320, 90, 0, '/sRvXNDItGlWCqtO3j6wks52FmbD.jpg', 60000000, 'http://www.dreamworksanimation.com/shrek/', 'tt0126029', 'en', 'Shrek', '\"It ain''t easy bein'' green -- especially if you''re a likable (albeit smelly) ogre named Shrek. On a mission to retrieve a gorgeous princess from the clutches of a fire-breathing dragon, Shrek teams up with an unlikely compatriot -- a wisecracking donkey.\"', 94.456, '/dyhaB19AICF7TO7CK2aD6KfymnQ.jpg', 'The greatest fairy tale never told.', '\"Animation, Comedy, Fantasy, Adventure, Family\"', '\"DreamWorks Pictures, Pacific Data Images, DreamWorks Animation\"', 'United States of America', 'English') | |
| INSERT INTO tabla VALUES(2062, 'Ratatouille', 7.809, 15728, 'Released', '2007-06-28', 623726000, 111, 0, '/xgDj56UWyeWQcxQ44f5A3RTWuSs.jpg', 150000000, 'http://disney.go.com/disneypictures/ratatouille', 'tt0382932', 'en', 'Ratatouille', '\"Remy, a resident of Paris, appreciates good food and has quite a sophisticated palate. He would love to become a chef so he can create and enjoy culinary masterpieces to his heart''s delight. The only problem is, Remy is a rat. When he winds up in the sewer beneath one of Paris'' finest restaurants, the rodent gourmet finds himself ideally placed to realize his dream.\"', 82.488, '/t3vaWRPSf6WjDSamIkKDs1iQWna.jpg', 'He''s dying to become a chef.', '\"Animation, Comedy, Family, Fantasy\"', '\"Pixar, Walt Disney Pictures\"', 'United States of America', '\"English, French\"') | |
| INSERT INTO tabla VALUES(207703, 'Kingsman: The Secret Service', 7.636, 15664, 'Released', '2014-12-13', 414351546, 129, 0, '/dGXKgxWmiPRZkxphtMvBuCEeLU0.jpg', 81000000, 'http://www.kingsmanmovie.com/', 'tt2802144', 'en', 'Kingsman: The Secret Service', 'The story of a super-secret spy organization that recruits an unrefined but promising street kid into the agency''s ultra-competitive training program just as a global threat emerges from a twisted tech genius.', 56.288, '/ay7xwXn1G9fzX9TUBlkGA584rGi.jpg', 'Manners maketh man.', '\"Crime, Comedy, Action, Adventure\"', '\"20th Century Fox, Marv Films, Cloudy Productions, TSG Entertainment\"', '\"United Kingdom, United States of America\"', '\"Arabic, English\"') |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Procedimiento para consultar la tabla peliculas y devolver solo los valores unicos | |
| declare @miTabla as table ( | |
| id int identity, | |
| idioma varchar(50) | |
| ) | |
| declare @conComas varchar(1000) | |
| declare @sinComas varchar(1000) | |
| set @conComas = '\"English, French, Japanese, Swahili, French, Japanese, Swahili, French, Japanese, Swahili, French, Japanese, Swahili\"' | |
| set @sinComas = 'English' | |
| set @conComas = substring(@conComas,3,len(@conComas)-4) | |
| insert into @miTabla (idioma) | |
| select value as idioma from string_split(@conComas,',') | |
| insert into @miTabla (idioma) values (@sinComas) | |
| select * from @miTabla | |
| select distinct trim(idioma) as idioma from @miTabla | |
| insert into @miTabla (idioma) | |
| select | |
| case | |
| when idiomas_disponibles like '%,%' | |
| then trim(substring(idiomas_disponibles, 3, len(idiomas_disponibles)-4)) | |
| else idiomas_disponibles | |
| end as idioma | |
| from peliculas | |
| -- Verificar los datos en @miTabla | |
| select distinct * from @miTabla; | |
| go | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Ejemplo EXITOSO para construir la tabla idiomas_disponibles | |
| declare @miTabla as table ( | |
| id int identity, | |
| idioma varchar(max) | |
| ) | |
| -- Verificar si la tabla idiomas_disponibles contiene datos | |
| if exists (select 1 from idiomas_disponibles) | |
| begin | |
| -- Eliminar todos los registros de la tabla idiomas_disponibles | |
| delete from idiomas_disponibles; | |
| end | |
| insert into @miTabla (idioma) | |
| select value as idioma | |
| from ( | |
| select case | |
| -- Primera versión: Separar y eliminar caracteres | |
| when idiomas_disponibles like '%,%' | |
| then trim(substring(idiomas_disponibles, 3, len(idiomas_disponibles) - 4)) | |
| -- Segunda versión: Insertar directamente | |
| else idiomas_disponibles | |
| end as idiomas_disponibles | |
| from peliculas | |
| ) as Subquery | |
| cross apply string_split(idiomas_disponibles, ',') as Split; | |
| update @miTabla | |
| set idioma = LTRIM(RTRIM(idioma)); | |
| insert into idiomas_disponibles (idioma) | |
| select distinct idioma from @miTabla | |
| select * from idiomas_disponibles | |
| GO | |
| --------------------------------------------------------------- | |
| --Lo mismo para los paises | |
| declare @miTabla as table ( | |
| id int identity, | |
| variable varchar(200) | |
| ) | |
| -- Verificar si la tabla idiomas_disponibles contiene datos | |
| if exists (select 1 from paises_productores) | |
| begin | |
| -- Eliminar todos los registros de la tabla idiomas_disponibles | |
| delete from paises_productores; | |
| end | |
| insert into @miTabla (variable) | |
| select value as variable | |
| from ( | |
| select case | |
| -- Primera versión: Separar y eliminar caracteres | |
| when paises_productores like '%,%' | |
| then trim(substring(paises_productores, 3, len(paises_productores) - 4)) | |
| -- Segunda versión: Insertar directamente | |
| else paises_productores | |
| end as paises_productores | |
| from peliculas | |
| ) as Subquery | |
| cross apply string_split(paises_productores, ',') as Split; | |
| update @miTabla | |
| set variable = LTRIM(RTRIM(variable)); | |
| insert into paises_productores (pais) | |
| select distinct variable from @miTabla | |
| select * from paises_productores | |
| GO | |
| -- compañias productoras | |
| declare @miTabla as table ( | |
| id int identity, | |
| variable varchar(200) | |
| ) | |
| -- Verificar si la tabla idiomas_disponibles contiene datos | |
| if exists (select 1 from companias_productoras) | |
| begin | |
| -- Eliminar todos los registros de la tabla idiomas_disponibles | |
| delete from companias_productoras; | |
| end | |
| insert into @miTabla (variable) | |
| select value as variable | |
| from ( | |
| select case | |
| -- Primera versión: Separar y eliminar caracteres | |
| when compañias_productoras like '%,%' | |
| then trim(substring(compañias_productoras, 3, len(compañias_productoras) - 4)) | |
| -- Segunda versión: Insertar directamente | |
| else compañias_productoras | |
| end as compañias_productoras | |
| from peliculas | |
| ) as Subquery | |
| cross apply string_split(compañias_productoras, ',') as Split; | |
| update @miTabla | |
| set variable = LTRIM(RTRIM(variable)); | |
| insert into companias_productoras (productora) | |
| select distinct variable from @miTabla | |
| select * from companias_productoras | |
| GO | |
| --------------------------------------------------------------------------------------------------- | |
| -- generos | |
| declare @miTabla as table ( | |
| id int identity, | |
| variable varchar(200) | |
| ) | |
| -- Verificar si la tabla idiomas_disponibles contiene datos | |
| if exists (select 1 from generos) | |
| begin | |
| -- Eliminar todos los registros de la tabla idiomas_disponibles | |
| delete from generos; | |
| end | |
| insert into @miTabla (variable) | |
| select value as variable | |
| from ( | |
| select case | |
| -- Primera versión: Separar y eliminar caracteres | |
| when generos like '%,%' | |
| then trim(substring(generos, 3, len(generos) - 4)) | |
| -- Segunda versión: Insertar directamente | |
| else generos | |
| end as generos | |
| from peliculas | |
| ) as Subquery | |
| cross apply string_split(generos, ',') as Split; | |
| --select * from @miTabla; | |
| update @miTabla | |
| set variable = LTRIM(RTRIM(variable)); | |
| insert into generos (genero) | |
| select distinct variable from @miTabla | |
| select * from generos | |
| go |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Estudiando procedimientos almacenados | |
| -- CASE | |
| -- https://www.youtube.com/watch?v=9Z9Mc1jNcb0&list=PLIygiKpYTC_6_CGfKc2RlyHO9J442HI_z&index=106 | |
| -- ejemplo 1 | |
| select votacion_recuento, condicion = | |
| case | |
| when votacion_recuento < 33000 then 'Menos de 33000' | |
| when votacion_recuento >= 33000 then 'Mas de 33000' | |
| else 'no se' | |
| end | |
| from peliculas | |
| --ejemplo 2: verificar si existen comas en un campo. para separar idiomas por ejemplo | |
| select idiomas_disponibles, condicion = | |
| case | |
| when idiomas_disponibles like '%,%'then 'mas de un idioma' | |
| else 'un solo idioma' | |
| end | |
| from peliculas | |
| --ejemplo 3: imprimirla duración de la pelicula en formato: horas minutos | |
| select duracion, DuracionHM = | |
| case | |
| when duracion < 60 then cast(duracion as varchar) + ' minutos' | |
| else cast(FLOOR(duracion/60) as varchar) + ' horas ' + cast((duracion%60) as varchar) + ' minutos' | |
| end | |
| from peliculas; | |
| select duracion from peliculas | |
| --ejemplo 4: usando un when anidado para que cuando la cantidad de horas sea igual a 1, imprima "hora" | |
| select duracion, DuracionHM = | |
| case | |
| when | |
| duracion < 60 then cast(duracion as varchar) + ' minutos' | |
| when FLOOR(duracion / 60) = 1 then | |
| cast(FLOOR(duracion/60) as varchar) + ' hora ' + | |
| cast((duracion%60) as varchar) + ' minutos' | |
| else | |
| cast(FLOOR(duracion/60) as varchar) + ' horas ' + | |
| cast((duracion%60) as varchar) + ' minutos' | |
| end | |
| from peliculas; | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| create database films | |
| go | |
| use films | |
| go | |
| drop table peliculas | |
| create table peliculas( | |
| id int primary key, | |
| titulo varchar(100), | |
| votacion_promedio float, | |
| votacion_recuento int, | |
| estado varchar(15), | |
| fecha_lanzamiento varchar(12), | |
| ingresos bigint, | |
| duracion int, | |
| adult bit, | |
| ruta_backdrop varchar(500), | |
| presupuesto bigint, | |
| pagina_web varchar(500), | |
| imdb_id varchar(50), | |
| idioma_original varchar(200), | |
| titulo_original varchar(1000), | |
| sinopsis varchar(2000), | |
| popularidad varchar(10), | |
| ruta_poster varchar(200), | |
| tagline varchar(500), | |
| generos varchar(300), | |
| compañias_productoras varchar(1000), | |
| paises_productores varchar(500), | |
| idiomas_disponibles varchar(500) | |
| ) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| use films; | |
| go | |
| create table pelicula( | |
| id int primary key, | |
| titulo varchar(max), | |
| votacion_promedio float, | |
| votacion_recuento int, | |
| fecha_lanzamiento varchar(12), | |
| ingresos bigint, | |
| duracion int, | |
| adult bit, | |
| ruta_backdrop varchar(max), | |
| presupuesto bigint, | |
| pagina_web varchar(max), | |
| imdb_id varchar(max), | |
| idioma_original varchar(max), | |
| titulo_original varchar(max), | |
| sinopsis varchar(max), | |
| popularidad varchar(10), | |
| ruta_poster varchar(max), | |
| tagline varchar(max) | |
| ) | |
| go | |
| create table generos( | |
| idGenero int primary key identity, | |
| genero varchar(max) not null | |
| ) | |
| go | |
| create table companias_productoras( | |
| idCompania_productora int primary key identity, | |
| productora varchar(max) not null | |
| ) | |
| go | |
| create table paises_productores( | |
| idPaises_productores int primary key identity, | |
| pais varchar(max) not null | |
| ) | |
| go | |
| create table idiomas_disponibles( | |
| idIdiomas_disponibles int primary key identity, | |
| idioma varchar(max) not null | |
| ) | |
| go | |
| create table pelicula_genero( | |
| id int primary key identity, | |
| idGenero int references generos(idGenero) not null, | |
| idPelicula int references pelicula(id) not null | |
| ) | |
| go | |
| create table pelicula_compania( | |
| id int primary key identity, | |
| idCompania_productora int references companias_productoras(idCompania_productora) not null, | |
| idPelicula int references pelicula(id) not null | |
| ) | |
| go | |
| create table pelicula_paises_productores( | |
| id int primary key identity, | |
| idPaises_productores int references paises_productores(idPaises_productores) not null, | |
| idPelicula int references pelicula(id) not null | |
| ) | |
| go | |
| create table pelicula_idiomas( | |
| id int primary key identity, | |
| idIdiomas_disponibles int references idiomas_disponibles(idIdiomas_disponibles) not null, | |
| idPelicula int references pelicula(id) not null | |
| ) | |
| go | |
| select * from peliculas | |
| drop table pelicula_paises_productores | |
| go | |
| drop table pelicula_idiomas | |
| go | |
| drop table pelicula_genero | |
| go | |
| drop table pelicula_compania | |
| go | |
| drop table paises_productores | |
| go | |
| drop table idiomas_disponibles | |
| go | |
| drop table generos | |
| go | |
| drop table companias_productoras | |
| go | |
| drop table pelicula | |
| go | |
| drop table estado | |
| go |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- IF | |
| -- Ejemplo 1: Compruebe si un valor es menor que 5 | |
| declare @miVariable as int | |
| set @miVariable = 4 | |
| if @miVariable < 5 | |
| begin | |
| print 'Menor que 5' | |
| --muchas instrucciones hacia abajo | |
| end | |
| else | |
| begin | |
| select 'mayor o igual que 5' | |
| --muchas instrucciones hacia abajo | |
| end | |
| -- Ejemplo 2: Comprobar si una cadena contiene un caracter | |
| declare @caracterABuscar as char | |
| declare @cadena as varchar(100) | |
| set @caracterABuscar = ',' | |
| set @cadena = 'Acá, viene una coma' | |
| select @cadena | |
| if @cadena like '%,%' | |
| select @cadena, 'tiene coma' | |
| else | |
| select @cadena, 'no tiene coma' | |
| -- Ejemplo 3: Comprobar si una tabla tiene registros | |
| if (select count(*) from estado) = 0 print 'estado NO contiene registros' | |
| else print 'contiene registros' | |
| if (select count(*) from peliculas) = 0 print 'NO contiene registros' | |
| else print 'pelicula SI contiene registros' | |
| -- Ejemplo 4: Operador ternario | |
| select generos, tieneComa = iif(generos like '%,%', 'tiene coma','no tiene coma') from peliculas | |
| select idiomas_disponibles, tieneComa = iif(idiomas_disponibles like '%,%', 'tiene coma','no tiene coma') from peliculas | |
| -- procedimientos para llenar tablas | |
| --poniendo dos valores en la tabla estado | |
| if (select count(*) from estado) = 0 | |
| insert into estado values ('Released'), ('Not released') | |
| else | |
| delete from estado | |
| insert into estado values ('Released'), ('Not released') | |
| select * from estado | |
| if (select count(*) from pelicula) = 0 | |
| begin | |
| insert into | |
| pelicula (id, titulo, votacion_promedio, votacion_recuento, fecha_lanzamiento,ingresos,duracion,adult,ruta_backdrop, presupuesto, pagina_web,imdb_id,idioma_original, titulo_original, sinopsis, popularidad, ruta_poster, tagline) | |
| select id, titulo, votacion_promedio, votacion_recuento, fecha_lanzamiento,ingresos,duracion,adult,ruta_backdrop, presupuesto, pagina_web,imdb_id,idioma_original, titulo_original, sinopsis, popularidad, ruta_poster, tagline from peliculas | |
| select * from pelicula | |
| end | |
| else | |
| begin | |
| delete from pelicula | |
| end | |
| select idiomas_disponibles from peliculas | |
| select distinct estado from peliculas | |
| delete from pelicula |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| int n = 1000; | |
| string[] lineas = new string[n]; | |
| string[] lineasSql = new string[n]; | |
| string path = "/Users/sebastiancastillo/Downloads/TMDB_movie_dataset_v11/TMDB_movie_dataset_v11.csv"; | |
| string pathSalida = "/Users/sebastiancastillo/Downloads/TMDB_movie_dataset_v11/Salida.csv"; | |
| string nombreTabla = "peliculas"; | |
| LeerArchivo(path, n, false); | |
| for(int i = 0; i < lineasSql.Length; i++) { | |
| lineasSql[i] = generarLineaSQL(lineas[i]); | |
| } | |
| EscribirArchivo(pathSalida, lineasSql); | |
| string generarLineaSQL(string linea) | |
| { | |
| List<int> comillasDoblesList= BuscarPosiciones('"', linea); //List{a,b,c,d,e,f,g,h,i} | |
| List<int> comasList = BuscarPosiciones(',', linea); | |
| var paresComillasDobles = generarParesDeComillasDobles(comillasDoblesList); | |
| List<int> comasDentroDeComillasList = generarComasDentroDeComillasList(paresComillasDobles); | |
| List<int> comasSeparadorasList = generarComasSeparadorasList(paresComillasDobles); | |
| int longitudLinea = linea.Length; | |
| Film peliculas = FILM(); | |
| //separar los elementos de la linea de acuerdo a las comas separadoras | |
| Film FILM() | |
| { | |
| Film film = new Film(); | |
| film.id = linea.Substring(0,comasSeparadorasList[0] - 0); | |
| film.title= linea.Substring(comasSeparadorasList[0]+1,comasSeparadorasList[1]-comasSeparadorasList[0]-1); | |
| film.vote_average= linea.Substring(comasSeparadorasList[1]+1,comasSeparadorasList[2]-comasSeparadorasList[1]-1); | |
| film.vote_count= linea.Substring(comasSeparadorasList[2]+1,comasSeparadorasList[3]-comasSeparadorasList[2]-1); | |
| film.status= linea.Substring(comasSeparadorasList[3]+1,comasSeparadorasList[4]-comasSeparadorasList[3]-1);; | |
| film.release_date= linea.Substring(comasSeparadorasList[4]+1,comasSeparadorasList[5]-comasSeparadorasList[4]-1); | |
| film.revenue= linea.Substring(comasSeparadorasList[5]+1,comasSeparadorasList[6]-comasSeparadorasList[5]-1); | |
| film.runtime= linea.Substring(comasSeparadorasList[6]+1,comasSeparadorasList[7]-comasSeparadorasList[6]-1); | |
| film.adult= linea.Substring(comasSeparadorasList[7]+1,comasSeparadorasList[8]-comasSeparadorasList[7]-1); | |
| film.backdrop_path= linea.Substring(comasSeparadorasList[8]+1,comasSeparadorasList[9]-comasSeparadorasList[8]-1); | |
| film.budget= linea.Substring(comasSeparadorasList[9]+1,comasSeparadorasList[10]-comasSeparadorasList[9]-1); | |
| film.homepage= linea.Substring(comasSeparadorasList[10]+1,comasSeparadorasList[11]-comasSeparadorasList[10]-1); | |
| film.imdb_id= linea.Substring(comasSeparadorasList[11]+1,comasSeparadorasList[12]-comasSeparadorasList[11]-1); | |
| film.original_language= linea.Substring(comasSeparadorasList[12]+1,comasSeparadorasList[13]-comasSeparadorasList[12]-1); | |
| film.original_title= linea.Substring(comasSeparadorasList[13]+1,comasSeparadorasList[14]-comasSeparadorasList[13]-1); | |
| film.overview= linea.Substring(comasSeparadorasList[14]+1,comasSeparadorasList[15]-comasSeparadorasList[14]-1); | |
| film.popularity= linea.Substring(comasSeparadorasList[15]+1,comasSeparadorasList[16]-comasSeparadorasList[15]-1); | |
| film.poster_path= linea.Substring(comasSeparadorasList[16]+1,comasSeparadorasList[17]-comasSeparadorasList[16]-1); | |
| film.tagline= linea.Substring(comasSeparadorasList[17]+1,comasSeparadorasList[18]-comasSeparadorasList[17]-1); | |
| film.genres= linea.Substring(comasSeparadorasList[18]+1,comasSeparadorasList[19]-comasSeparadorasList[18]-1); | |
| film.production_companies= linea.Substring(comasSeparadorasList[19]+1,comasSeparadorasList[20]-comasSeparadorasList[19]-1); | |
| film.production_countries= linea.Substring(comasSeparadorasList[20]+1,comasSeparadorasList[21]-comasSeparadorasList[20]-1); | |
| film.spoken_languages= linea.Substring(comasSeparadorasList[21]+1,longitudLinea-comasSeparadorasList[21]-1); | |
| film.title = ReemplazoDeCadenas(film.title); | |
| film.status = ReemplazoDeCadenas(film.status); | |
| film.adult = ReemplazoDeCadenas(film.adult); | |
| film.backdrop_path = ReemplazoDeCadenas(film.backdrop_path); | |
| film.homepage = ReemplazoDeCadenas(film.homepage); | |
| film.original_language = ReemplazoDeCadenas(film.original_language); | |
| film.original_title = ReemplazoDeCadenas(film.original_title); | |
| film.overview = ReemplazoDeCadenas(film.overview); | |
| film.poster_path = ReemplazoDeCadenas(film.poster_path); | |
| film.tagline = ReemplazoDeCadenas(film.tagline); | |
| film.genres = ReemplazoDeCadenas(film.genres); | |
| film.production_companies = ReemplazoDeCadenas(film.production_companies); | |
| film.production_countries = ReemplazoDeCadenas(film.production_countries); | |
| film.spoken_languages = ReemplazoDeCadenas(film.spoken_languages); | |
| if (film.adult.Trim().ToLower() == "false"){ | |
| film.adult = "0"; | |
| } else { | |
| film.adult = "1"; | |
| } | |
| return film; | |
| } | |
| string ReemplazoDeCadenas(string cadena) { | |
| cadena = cadena.Replace("\"","\\\""); | |
| cadena = cadena.Replace("'","''"); | |
| return cadena; | |
| } | |
| string SQL() { | |
| string cadena = ""; | |
| cadena += "INSERT INTO "+nombreTabla +" VALUES("; | |
| cadena += peliculas.id+", "; | |
| cadena += "'"+peliculas.title+"', "; | |
| cadena += peliculas.vote_average+", "; | |
| cadena += peliculas.vote_count+", "; | |
| cadena += "'"+peliculas.status+"', "; | |
| cadena += "'"+peliculas.release_date+"', "; | |
| cadena += peliculas.revenue+", "; | |
| cadena += peliculas.runtime+", "; | |
| cadena += peliculas.adult+", "; | |
| cadena += "'"+peliculas.backdrop_path+"', "; | |
| cadena += peliculas.budget+", "; | |
| cadena += "'"+peliculas.homepage+"', "; | |
| cadena += "'"+peliculas.imdb_id+"', "; | |
| cadena += "'"+peliculas.original_language+"', "; | |
| cadena += "'"+peliculas.original_title+"', "; | |
| cadena += "'"+peliculas.overview+"', "; | |
| cadena += peliculas.popularity+", "; | |
| cadena += "'"+peliculas.poster_path+"', "; | |
| cadena += "'"+peliculas.tagline+"', "; | |
| cadena += "'"+peliculas.genres+"', "; | |
| cadena += "'"+peliculas.production_companies+"', "; | |
| cadena += "'"+peliculas.production_countries+"', "; | |
| cadena += "'"+peliculas.spoken_languages+"'"; | |
| cadena += ")"; | |
| return cadena; | |
| } | |
| return SQL(); | |
| List<int> generarComasDentroDeComillasList(int[][] paresComillasDobles){ | |
| List<int> comasDentroDeComillasList = new List<int>(); | |
| for (int comaAEvaluar = 0; comaAEvaluar < comasList.Count(); comaAEvaluar++) { | |
| for(int parAEvaluar = 0; parAEvaluar < paresComillasDobles.Length; parAEvaluar++){ | |
| if (EstaEntre(comasList[comaAEvaluar],paresComillasDobles[parAEvaluar][0], paresComillasDobles[parAEvaluar][1])){ | |
| comasDentroDeComillasList.Add(comasList[comaAEvaluar]); | |
| } | |
| } | |
| } | |
| return comasDentroDeComillasList; | |
| } | |
| List<int> generarComasSeparadorasList(int[][] paresComillasDobles) { | |
| List<int> comasSeparadorasList = new List<int>(); | |
| //Añadiendo las comas separadoras a comasSeparadorasList | |
| foreach (int coma in comasList) | |
| { | |
| if(comasDentroDeComillasList.Contains(coma)){ | |
| } else { | |
| comasSeparadorasList.Add(coma); | |
| } | |
| } | |
| return comasSeparadorasList; | |
| } | |
| int[][] generarParesDeComillasDobles(List<int> comillasDoblesList){ | |
| int[][] paresComillasDobles= new int[comillasDoblesList.Count()/2][]; | |
| for(int i = 0; i < paresComillasDobles.Length; i++) | |
| { | |
| int[]? par = new int[2]; | |
| par[0] = comillasDoblesList[2*i]; | |
| par[1] = comillasDoblesList[2*i+1]; | |
| paresComillasDobles[i] = par; | |
| } | |
| return paresComillasDobles; | |
| } | |
| } | |
| bool EstaEntre(int valor, int inf, int sup) { | |
| return valor > inf && valor < sup; | |
| } | |
| void MostrarLista(List<int> lista){ | |
| foreach(int elemento in lista){ | |
| Console.Write(elemento+","); | |
| } | |
| Console.WriteLine(); | |
| } | |
| // buscar el caracter comilla doble en cada linea | |
| List<int> BuscarPosiciones(char caracter, string linea) { | |
| List<int> posiciones = new List<int>(); | |
| int lastPos = 0; | |
| linea.Trim(); | |
| while(linea.IndexOf(caracter,lastPos == 0 ? lastPos : lastPos+1) != -1) { | |
| lastPos = linea.IndexOf(caracter,lastPos == 0 ? lastPos : lastPos+1); | |
| posiciones.Add(lastPos); | |
| } | |
| return posiciones; | |
| } | |
| void EscribirArchivo(string pathSalida, string[] lineas){ | |
| try { | |
| StreamWriter sw = new StreamWriter(pathSalida); | |
| foreach (string linea in lineas) | |
| { | |
| sw.WriteLine(linea); | |
| } | |
| Console.WriteLine(lineas.Length); | |
| sw.Close(); | |
| } catch (Exception e){ | |
| Console.WriteLine("Exception: " + e.Message); | |
| } finally { | |
| Console.WriteLine("Escritura de archivo finalizada"); | |
| } | |
| } | |
| void LeerArchivo(string path, int n, bool consola){ | |
| string? linea; | |
| try{ | |
| StreamReader? sr = new StreamReader(path); | |
| linea = sr.ReadLine(); | |
| int counter = 0; | |
| while (linea != null && counter < n) | |
| { | |
| linea = sr.ReadLine(); | |
| lineas[counter] = linea; | |
| counter++; | |
| if(consola){ | |
| Console.WriteLine(linea); | |
| } | |
| } | |
| sr.Close(); | |
| } | |
| catch (Exception e) | |
| { | |
| Console.WriteLine("Exception: " + e.Message); | |
| } | |
| finally | |
| { | |
| Console.WriteLine("Lectura de archivo finalizada"); | |
| } | |
| } | |
| class Film{ | |
| public string id { get; set; } | |
| public string title { get; set; } | |
| public string vote_average { get; set; } | |
| public string vote_count { get; set; } | |
| public string status { get; set; } | |
| public string release_date { get; set; } | |
| public string revenue { get; set; } | |
| public string runtime { get; set; } | |
| public string adult { get; set; } | |
| public string backdrop_path { get; set; } | |
| public string budget { get; set; } | |
| public string homepage { get; set; } | |
| public string imdb_id { get; set; } | |
| public string original_language { get; set; } | |
| public string original_title { get; set; } | |
| public string overview { get; set; } | |
| public string popularity { get; set; } | |
| public string poster_path { get; set; } | |
| public string tagline { get; set; } | |
| public string genres { get; set; } | |
| public string production_companies { get; set; } | |
| public string production_countries { get; set; } | |
| public string spoken_languages { get; set; } | |
| //constructor | |
| // public Film(int id, string title, float vote_average, int vote_count, string status, string release_date, int revenue, int runtime, bool adult, string backdrop_path, int budget, string homepage, string imdb_id, string original_language, string original_title, string overview, float popularity, string poster_path, string tagline, string[] genres, string[] production_companies, string[] production_countries, string[] spoken_languages){ | |
| // this.id = id; | |
| // this.title = title; | |
| // this.vote_average = vote_average; | |
| // this.vote_count = vote_count; | |
| // this.status = status; | |
| // this.release_date = release_date; | |
| // this.revenue = revenue; | |
| // this.runtime = runtime; | |
| // this.adult = adult; | |
| // this.backdrop_path = backdrop_path; | |
| // this.budget = budget; | |
| // this.homepage = homepage; | |
| // this.imdb_id = imdb_id; | |
| // this.original_language = original_language; | |
| // this.original_title = original_title; | |
| // this.overview = overview; | |
| // this.popularity = popularity; | |
| // this.poster_path = poster_path; | |
| // this.tagline = tagline; | |
| // this.genres = genres; | |
| // this.production_companies = production_companies; | |
| // this.production_countries = production_countries; | |
| // this.spoken_languages = spoken_languages; | |
| // } | |
| } |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Procedimiento para llenar una tabla virtual con los idiomas | |
| declare @miTabla as table ( | |
| id int identity, | |
| idioma varchar(50) | |
| ) | |
| declare @conComas varchar(1000) | |
| declare @sinComas varchar(1000) | |
| set @conComas = '\"English, French, Japanese, Swahili, French, Japanese, Swahili, French, Japanese, Swahili, French, Japanese, Swahili\"' | |
| set @sinComas = 'English' | |
| set @conComas = substring(@conComas,3,len(@conComas)-4) | |
| insert into @miTabla (idioma) | |
| select value as idioma from string_split(@conComas,',') | |
| insert into @miTabla (idioma) values (@sinComas) | |
| select * from @miTabla | |
| select distinct trim(idioma) as idioma from @miTabla |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| declare @var1 as int = 10 | |
| select sinopsis from peliculas; | |
| print @var1 | |
| declare @filas int; | |
| set @filas = select COUNT(*) from peliculas | |
| declare @varSinopsis varchar(500) | |
| select Substring(sinopsis,3,LEN(sinopsis)-3) from peliculas where sinopsis like '\"%' | |
| select generos from peliculas | |
| select compañias_productoras from peliculas | |
| select paises_productores from peliculas | |
| select idiomas_disponibles from peliculas | |
| declare @numero1 int | |
| set @numero1 = 5 | |
| declare @numero2 int | |
| set @numero2 = 10 | |
| --procedimiento para sacar los caracteres \" del inicio y fin de la cadena. | |
| declare @texto varchar(500) | |
| set @texto = '\"Cobb, a skilled thief who commits corporate espionage by infiltrating the subconscious of his targets is offered a chance to regain his old life as payment for a task considered to be impossible: \"\"inception\"\", the implantation of another person''s idea into a target''s subconscious.\"' | |
| select substring(@texto,3,len(@texto)-4) | |
| declare @texto2 varchar(500) | |
| set @texto2 = '\"Action, Science Fiction, Adventure\"' | |
| select * from string_split((select substring(@texto2,3,len(@texto2)-4)), ',') |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment