Updated from another editor
Saved
SELECT id,'https://www.imdb.com/title/'||id,title,year,genres,rating2_9,ROUND(1.0*(votestotal-votes1-votes10)/(2018.0-1.0*year)) AS votesPerYear FROM movies WHERE (rating2_9 >= 7.3 AND movietype ='short') AND year >= 2010 AND votesPerYear<900 AND votesPerYear > 100 AND genres NOT LIKE '%documentary%' AND genres NOT LIKE '%history%' AND genres NOT LIKE '%horror%' AND genres NOT LIKE '%crime%' AND LENGTH(genres)>3 AND genres != 'horror' AND genres != 'drama' ORDER BY votesPerYear DESC LIMIT 1000000; **[The Rift](https://www.imdb.com/title/tt1954972)** (2012, sci-fi,short,thriller, 26m). "*An aspiring scientist discovers that behind dark rifts that are appearing in the sky, there is something that wants to cross to our side.*" **[Curfew](https://www.imdb.com/title/tt2088735)** (2012, drama,short, 19m). "*On the brink of demise, a self-destructive man who has sadly reached the lowest point in his life, receives an unexpected call from his estranged sister to look after her young daughter for the night.*" **[Power Rangers](https://www.imdb.com/title/tt4475970)** (2015, action,sci-fi,short, 14m). "*A dark and gritty re-imagining of the classic franchise.*" **[I'm Here](https://www.imdb.com/title/tt1571404)** (2010, drama,romance,sci-fi, 29m). "*A young man faces the abrupt loss of his friend.*" **[Darth Maul: Apprentice](https://www.imdb.com/title/tt5529680)** (2016, action,sci-fi,short, 18m). "*With his training almost complete, Darth Maul must face six Jedi in order to reach his true potential, and become a Dark Lord of the Sith.*" **[Stutterer](https://www.imdb.com/title/tt4817576)** (2015, drama,short, 12m). "*A man whose lush inner thoughts are rendered mute by a crippling stutter feels isolated from the world despite a flourishing online relationship.*" **[The Fantastic Flying Books of Mr. Morris Lessmore](https://www.imdb.com/title/tt1778342)** (2011, adventure,animation,drama, 15m). "*After a hurricane levels his city, a young man wanders into a mysterious library where books literally come to life.*" **[DeKalb Elementary](https://www.imdb.com/title/tt5926890)** (2017, drama,short, 21m). "*Inspired by an actual 911 call placed during a school shooting incident in Atlanta, Georgia.*" **[Bear Story](https://www.imdb.com/title/tt3829254)** (2014, adventure,animation,drama, 11m). "*An old, lonesome bear tells the story of his life through a mechanical diorama.*" **[Whiplash](https://www.imdb.com/title/tt2654430)** (2013, drama,music,short, 18m). "*A ferocious, bullying music teacher teaches a dedicated student.*" **[I Don't Want to Go Back Alone](https://www.imdb.com/title/tt1687221)** (2010, drama,romance,short, 17m). "*The arrival of a new student in school changes Leonardo's life. This 15 year-old blind teenager has to deal with the jealousy of his friend Giovana while figuring out the new feelings he's having towards his new friend, Gabriel.*" **[The Gunfighter](https://www.imdb.com/title/tt3375370)** (2014, comedy,short,western, 9m). "*In the tradition of classic westerns, a narrator sets up the story of a lone gunslinger who walks into a saloon. However, the people in this saloon can hear the narrator and the narrator may just be a little bit bloodthirsty.*" **[Beastie Boys: Fight for Your Right Revisited](https://www.imdb.com/title/tt1791504)** (2011, comedy,music,short, 30m). "*Following the conclusion of the storyline in the "Fight For Your Right" music video, the Beasties break into a liquor store, drop acid with groupies, and get into a breakdance competition with time-traveling future versions of...*" **[The Dam Keeper](https://www.imdb.com/title/tt3326262)** (2014, animation,drama,family, 18m). "*A little pig, who keeps his town safe from a cloud of pollution with his windmill dam, is ignored by a thankless public and bullied at school. When a new kid arrives, things begin to change.*" **[Decrepit Crescendo](https://www.imdb.com/title/tt2679334)** (2010, drama,short, 12m). "*If you want to get something done, do it yourself.*" **[Ghost Recon: Alpha](https://www.imdb.com/title/tt2386231)** (2012, action,sci-fi,short, 23m). "*Ghost Recon: Alpha sees a team led by Ghost Leader infiltrate a trade at a Russian depot between a general and a mysterious other figure.*" **[We Can't Live Without Cosmos](https://www.imdb.com/title/tt3965660)** (2014, animation,drama,short, 16m). "*Two cosmonauts, two friends, try to do their best in their everyday training life to make their common dream a reality. But this story is not only about the dream.*" **[Sintel](https://www.imdb.com/title/tt1727587)** (2010, animation,fantasy,short, 14m). "*The film follows a girl named Sintel who is searching for a baby dragon she calls Scales. A flashback reveals that Sintel found Scales with its wing injured and helped care for it, forming a close bond with it. By the time its wing...*" **[Room 8](https://www.imdb.com/title/tt2949338)** (2013, drama,fantasy,sci-fi, 7m). "*A prisoner discovers a magical box with a baneful secret that he falls foul to.*" **[The Wish and The Wisp](https://www.imdb.com/title/tt7647778)** (2017, fantasy,short, ). "*Two bickering siblings learn the true magic of believing, when they find a real wish and encounter the menacing creature who wants it back.*" **[Head Over Heels](https://www.imdb.com/title/tt2391009)** (2012, animation,comedy,family, 11m). "*Walter and Madge have grown apart: he lives on the floor and she lives on the ceiling. When Walter tries to reignite their old romance, the couple must face their equilibrium.*" **[The Present](https://www.imdb.com/title/tt3682556)** (2014, animation,comedy,family, 4m). "*Jake spends most of his time playing video games indoors until his mother decides to give him a present.*" **[One-Minute Time Machine](https://www.imdb.com/title/tt3620860)** (2014, comedy,romance,sci-fi, 6m). "*James is all too eager to put his one-minute time machine to use in winning the heart of Regina, until he discovers the unexpected consequences of his actions.*" **[Everything Will Be Okay](https://www.imdb.com/title/tt4324518)** (2015, drama,short,thriller, 30m). "*A divorced father picks up his eight-year-old daughter Lea. It seems pretty much like every second weekend, but after a while Lea can't help feeling that something isn't right. So begins a fateful journey.*" **[World of Tomorrow Episode Two: The Burden of Other People's Thoughts](https://www.imdb.com/title/tt7278178)** (2017, animation,comedy,fantasy, 23m). "*Emily is visited by a backup clone of herself from the even-more distant future, as they must venture into eachother's psyche in order to restore the clone's deteriorating mind.*" **[The Eleven O'Clock](https://www.imdb.com/title/tt6023474)** (2016, comedy,short, 13m). "*The delusional patient of a psychiatrist believes he is actually the psychiatrist. As they each attempt to treat each other the session gets out of control.*" **[Proximity](https://www.imdb.com/title/tt3389706)** (2013, action,sci-fi,short, 11m). "*After waking to find their ankles rigged with proximity triggered bombs, two men find themselves bound together while being forced to play a twisted game of survival as they are hunted by their captors.*" **[J...](https://www.imdb.com/title/tt3968112)** (2015, drama,short, 16m). "*When a young man wants to take life in his own hands everything goes wrong until he meets J.*" **[Scrat's Continental Crack-Up](https://www.imdb.com/title/tt1791596)** (2010, animation,comedy,family, 3m). "*Scrat's pursuit of his acorn causes the earth's land to split into different continents.*" **[Population Zero](https://www.imdb.com/title/tt2707140)** (2013, action,drama,sci-fi, 12m). "*A haunted survivor of a catastrophic alien invasion doesn't see an obvious truth when he finds a mute boy in an abandoned warehouse.*" **[The Great Surgeon](https://www.imdb.com/title/tt3889744)** (2016, animation,short, 22m). "*In a grave-world, the Grave Keeper keeps watch over the souls and bodies of those living and dead. Lazarus is chosen to be resurrected into this world and come to grips with the true natures of living and dying. He is ultimately...*" **[The Maker](https://www.imdb.com/title/tt1969151)** (2011, animation,family,fantasy, 6m). "*A strange creature races against time to make the most important and beautiful creation of his life.*" **[Ahalya](https://www.imdb.com/title/tt4876528)** (2015, short,thriller, 14m). "*A police officer searching for the reference of a missing person meets an artist and his wife.*" **[It's Such a Beautiful Day](https://www.imdb.com/title/tt2078648)** (2011, animation,drama,fantasy, 23m). "*Don Hertzfeldt closes his trilogy as Bill struggles to piece together his shattering psyche.*" **[U.F.Oh Yeah](https://www.imdb.com/title/tt4576034)** (2015, comedy,sci-fi,short, 5m). "*Ned Deedry, a conspiracy theorist and Extra-Terrestrial enthusiast, had always dreamed of making contact with other-worldly visitors. But, when that day finally arrived, things don't play out the way he'd hoped.*" **[Pixels](https://www.imdb.com/title/tt1635656)** (2010, action,animation,fantasy, 2m). "*New York City is invaded by 8-bit creatures.*" **[The Tale of Thomas Burberry](https://www.imdb.com/title/tt6219898)** (2016, drama,short, 3m). "*160 years in the making, a story inspired by the pioneering discoveries of our founder, reimagining key events that have shaped Burberry's history.*" **[Death Billiards](https://www.imdb.com/title/tt2807626)** (2013, animation,drama,mystery, 25m). "*An old man and a young adult find themselves in a strange bar where the barman forces them to bet their lives in a game of billiards.*" **[Curmudgeons](https://www.imdb.com/title/tt5585718)** (2016, comedy,short, 16m). "*Ralph is visited in his care home by his granddaughter and an unexpected guest.*" **[The Answers](https://www.imdb.com/title/tt4009492)** (2015, comedy,drama,fantasy, 8m). "*Immediately after his death, the victim of a car crash gets answers to every question he's ever had about his life, including the most import one of all - what did it all mean?*" **[The Smile Man](https://www.imdb.com/title/tt2987342)** (2013, comedy,drama,short, 9m). "*After a car accident, a man has to live the rest of his life with a smile on his face because of the nerve damage.*" **[Johnny Express](https://www.imdb.com/title/tt3723996)** (2014, animation,comedy,sci-fi, 5m). "*In the year 2150, Johnny, a lazy Space Delivery Man, must deliver a package on a planet he does not fully understand.*" **[God of Love](https://www.imdb.com/title/tt1631323)** (2010, comedy,fantasy,romance, 18m). "*A lovestruck, lounge-singing darts champion finds his prayers are answered -- literally -- when he mysteriously receives a box of love-inducing darts.*" **[The Fall of Men](https://www.imdb.com/title/tt3878998)** (2015, action,adventure,fantasy, 29m). "*The Fall Of Men is an original story of Trunks against the infamous Cell. It is a live action fan fiction of Dragon Ball Z.*" **[The Piano Tuner](https://www.imdb.com/title/tt1907704)** (2010, drama,short,thriller, 14m). "*Adrien is a young pianist prodigy. He collapsed psychologically having failed in a renowned competition and henceforth works as a piano tuner. As remedy to this life, he invents a blind person's mask to penetrate into the intimacy...*" **[Prelude to Axanar](https://www.imdb.com/title/tt3572740)** (2014, action,drama,sci-fi, 21m). "*Various retired leaders discuss their experiences of the Four Years War, a war between the Federation and the Klingons, and the build up to a battle at Axanar that caused a major turning point in the war.*" **[How to Lose Weight in 4 Easy Steps](https://www.imdb.com/title/tt5424972)** (2016, comedy,drama,short, 7m). "*Losing weight and getting fit has never been easier! Shed those unwanted pounds with these simple tricks your gym doesn't want you to know about. You won't believe what happens next!*" **[A Friend in Need](https://www.imdb.com/title/tt4809792)** (2015, drama,short, 13m). "*A rich young girl, realizes that someone broke into her house. Through their brief relationship, she finds a human way to make his life better, changing it forever.*" **[Noah](https://www.imdb.com/title/tt3001186)** (2013, animation,comedy,romance, 18m). "*Noah's relationship takes a rapid turn for the worse.*" **[Juice](https://www.imdb.com/title/tt7695134)** (2017, drama,fantasy,short, 15m). "*Singh's a middle family Mr Singh and his wife Manju have hosted a small get to gather in their house where the men our busy boozing and talking about the world.Manju is seen cleaning the leftovers from the table.Manju along with...*" **[Real Artists](https://www.imdb.com/title/tt5648094)** (2017, drama,sci-fi,short, 12m). "*In the near future, a young animator is offered what should be her dream job, but, when she discovers the truth of the modern 'creative' process, she must make a hard choice about her passion for film.*" **[Uncanny Valley](https://www.imdb.com/title/tt5269194)** (2015, sci-fi,short, 9m). "*A glimpse into a future where First Person Shooters have become a new drug for those disillusioned with society. The films examines the consequences of this on the global society.*" **[Rabbit and Deer](https://www.imdb.com/title/tt2664910)** (2013, adventure,animation,family, 17m). "*The friendship of Rabbit and Deer is put to the test by Deer's new obsession to find the formula for the 3rd dimension...*" **[Here We Go Again, Rubinot!](https://www.imdb.com/title/tt6123270)** (2017, sci-fi,short, ). "*An otherworldly, beautiful female android travels in time while scientists try to understand her enigmatic secrets exploiting the occasions of her mysterious, rare appearances. Until she decides the right time to share her vision...*" **[The Ancient Magus Bride](https://www.imdb.com/title/tt5970298)** (2016, animation,drama,fantasy, 23m). "*Hatori Chise has lived a life full of neglect and abuse, devoid of anything resembling love. Far from the warmth of family, she has had her share of troubles and pitfalls. Just when all hope seems lost, a fateful encounter awaits...*" **[8](https://www.imdb.com/title/tt1592502)** (2010, short,war, 9m). "*In the depths of a snowy forest in an unknown wartime, two soldiers from opposing armies try to outwit each other in a perilous game of Tic-Tac-Toe, until they find themselves outplayed by karma.*" **[Runaway](https://www.imdb.com/title/tt1756714)** (2010, music,short, 34m). "*A romantic relationship between a man and a half-woman, half-phoenix.*" **[Deposit for the Courier](https://www.imdb.com/title/tt4052178)** (2014, action,animation,sci-fi, 12m). "*The story line, set with in the year 2050, revolves around an intriguing chase from one city to another. With lead character, a young woman cyclist employed as a courier, in inadvertently found a strange navigation device in the...*" **[Tick Tock Tale](https://www.imdb.com/title/tt1736313)** (2010, adventure,animation,family, 6m). "*Amidst an old London clock shop, a small, quirky mantle clock comes to the aide of the store's more expensive clocks when a thief breaks in and threatens to steal them away.*" **[Harry Potter and the Forbidden Journey](https://www.imdb.com/title/tt1756545)** (2010, adventure,fantasy,short, 5m). "*Amusement ride at the Wizarding World of Harry Potter in the Island of Adventure Park, Orlando, Florida.*" **[Caer](https://www.imdb.com/title/tt5457062)** (2016, romance,short, ). "*Based on a poem by Rumi, tells of the silent love of a young man for an unknowing girl.*" **[Cream](https://www.imdb.com/title/tt6932742)** (2016, comedy,drama,sci-fi, 10m). "*Cream tells the story of Dr. Bellifer a scientific genius, who after years of smashing particles together, reveals his revolutionary new product: a cream with the power to fix all of the world's problems. - Regent Street Cinema.*" **[Vertigo](https://www.imdb.com/title/tt5433782)** (2016, drama,short, 6m). "*One Person on the street does not vertigo when suddenly something happens to him*" **[Crypt](https://www.imdb.com/title/tt6742352)** (2017, drama,short, 8m). "*Encounter two person with a common objective in broken timeline.*" **[Just Before Losing Everything](https://www.imdb.com/title/tt2689992)** (2013, drama,family,short, 29m). "*Miriam, with her two children, escapes her husband, whom she fears.*" **[Lifted](https://www.imdb.com/title/tt4679820)** (2015, drama,sci-fi,short, 6m). "*A little girl and her inventor father celebrate the success of their greatest dream, on a day she will never forget.*" **[The Death and Return of Superman](https://www.imdb.com/title/tt2117984)** (2011, comedy,sci-fi,short, 17m). "*Screenwriter Max Landis accounts DC's 1992 multi-issue story arc "The Death and Return of Superman," pointing out various plot holes and featuring a number of celebrity cameos.*" **[Friend Request Pending](https://www.imdb.com/title/tt2069775)** (2012, comedy,drama,short, 12m). "*FRIEND REQUEST PENDING is a short comedy drama about the mature generation dating in our modern social networking world. It's a tale of love but more importantly life long friendship. The twelve-minute tale tells the story of Mary...*" **[Symphony No. 42](https://www.imdb.com/title/tt3203054)** (2014, animation,mystery,short, 10m). "*The film applies an unconventional narrative. It presents a subjective world through 47 scenes. The small events, interlaced by associations, express the irrational coherence of our surroundings. The surreal situations are based on...*" **[Successful Alcoholics](https://www.imdb.com/title/tt1548018)** (2010, comedy,short, 25m). "*A couple that are very successful in their jobs and at the same time have a drinking problem try to manage their love life, their social life and their jobs.*"
Password
Cancel
Encrypt