Request area

Hello,

I wanted to code request area from scratch. You should ask why – I will tell you – it is simple. Request area have some really weird SQL code (some sub-querries) and it locks database, so whole sites works slower (or even did not work). So I have to disable request area of time being.

Also me, and some of you are missing features there, so here I come with idea, how to make it better. Here is list what new request area should contain / support:

  • searching/filtering by name of movie, language…
  • sorting by name, number of requests, user, latest request, imdb rating…
  • displaying “my requests”
  • other things which old request area contains

If you are think I am missing something, let me know and I will think about that. I have to create 2 new tables for this feature though…It seems this weekend I don’t finish it, maybe next one…

Start the discussion at forum.opensubtitles.com

Read more

90fm trivia

The Role of Subtitles in Trivia Mastery

The 90FM Trivia Contest, hosted annually by the University of Wisconsin-Stevens Point’s student-run radio station WWSP 90FM, stands as a testament to the enduring allure of trivia. Established in 1969, this 54-hour marathon challenges participants with a relentless stream of questions, demanding not only vast knowledge but also strategic resourcefulness. As teams gear up for “Trivia 55: NO LIMIT,” scheduled for April 11-13, 2025, the importance of diverse research tools becomes ever more apparent.

What can global subtitles reveal about how often – and how meaningfully – films say ‘I love you’?

New research by film data expert Stephen Follows uses subtitle data from OpenSubtitles to explore how often films include the phrase “I love you” and how characters respond when they hear it.

Drawing on over 72,000 English-language subtitle files from fiction feature films made between 1911 and 2022, the analysis reveals patterns in cinematic declarations of love across genres and decades.