The Movie Database サポート

@Travis

There are 1184 entries marked as trailer, where teaser is contained in the trailer title.

1183 of them are for films which don't have the word teaser in their title.

Worth running some SQL to clear that up?

5 replies (on page 1 of 1)

Jump to last post

There's a UI tweak I'd like to make before doing anything with the data. I was actually working on this last week so it's close to being completed. Right now the "watch trailer" button only shows for trailers which is why this happens more often than it should (I've even done it.) So I'd like to fix the experience around that first and then we can look at cleaning up the data.

Before doing something it could be worth checking some individual cases. We (some of the mods) kind of decided in the past that any teaser trailer below 90 seconds should be added as a teaser, but above 90 seconds should be added as a trailer. For me, personally, a teaser Trailer is not a teaser but a proper trailer, but I know some others may disagree about that. So that's why, in the end, the compromise was the 90 second split.

With that background I assume that many of the Teaser Trailers are correctly placed as trailers based on the previous decision.

I am currently using the YouTube API v3 to check which trailers have been removed, which have been blocked due to copyright issues and which are region blocked in various areas.

Although a pipe dream, it would be good if TMDB had a cron job which did the same and removed accordingly.

You can also get trailer lengths from it.

Ya, I already use the YouTube API to validate entries and get things like length. I ran every record through it earlier in the year and removed all content that was no longer available.

It’s not something I think we need to run very often but it could easily be ran a few times a year.

A agree it only needs to be done X amount per year. Quarterly or Monthly.

Of the 64740 trailers that I checked, which were grabbed on the 1st of September:

873 are region blocked in some countries.
534 are not accessible due to copyright infringement.
739 are dead.

映画やテレビ番組が見つかりませんか?ログインして作成してください。

全般

s 検索バーに移動する
p プロファイルメニューを開く
esc 開いているウィンドウを閉じる
? キーボードショートカットウィンドウを開く

メディアのページ

b 戻る(または該当する場合は親に)
e 編集ページに行く

テレビ番組のシーズンのページ

(右矢印)次のシーズンに行く
(左矢印)前のシーズンに戻る

テレビ番組のエピソードのページ

(右矢印)次のエピソードに進む
(左矢印)前のエピソードに戻る

全ての画像のページ

a 画像追加ウィンドウを開く

全ての編集ページ

t 翻訳選択を開く
ctrl+ s フォームを送信する

ディスカッションのページ

n 新しいディスカッションを作成する
w 監視ステータスを切り替える
p 公開/非公開を切り替える
c 閉じる/開くを切り替える
a アクティビティを開く
r ディスカッションに返信
l 最後の返事に行く
ctrl+ enter メッセージを送信する
(右矢印)次のページ
(左矢印)前のページ

設定

このアイテムを評価したり、リストに追加したりしたいですか?

ログイン

メンバーではありませんか?

登録してコミュニティに参加