video8: releases: 1 row where country_release = "Films", promo = "Y" and title

Data license: CC0 · Data source: github.com/rikker/video8

id: ID
title_id: Title
title_release: Release Title
title_release_lang: Release Title Language
catalog_number: Catalog No.
release_date: Release Date
country_release: Country of Release
encoding: Encoding
runtime_mins: Runtime (mins)
list_price: List Price
upc: UPC
isbn: ISBN
audio_format: Audio Format
audio_language: Audio Language
audio_dubbed: Dubbed
subtitle_language: Subtitles / CC
promo: Promo
notes: Notes

1 row where country_release = "Films", promo = "Y" and title_id = 2487

descending

id ▼	title_id	title_release	title_release_lang	catalog_number	release_date	country_release	encoding	runtime_mins	list_price	upc	isbn	audio_format	audio_language	audio_dubbed	subtitle_language	promo	notes
2782	Beat the Devil 2487					Films	PAL	89.0								Y	RCA promotional release in generic promo slipcover. These all use the same standard base design with b&w RCA/Columbia logo in top left, and the label says "(C) Artwork and Design 1986" regardless of the year the film came out (even some post 1986, such as Punch Line). Actual distribution date of these promos seems to be more like 1989/90, but it's possible some were produced earlier. Need more info.

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE releases (
            id INTEGER PRIMARY KEY,
            title_id INTEGER REFERENCES titles(id),
            title_release TEXT,
            title_release_lang TEXT,
            catalog_number TEXT,
            release_date TEXT,
            country_release TEXT,
            encoding TEXT,
            runtime_mins REAL,
            list_price TEXT,
            upc TEXT,
            isbn TEXT,
            audio_format TEXT,
            audio_language TEXT,
            audio_dubbed TEXT,
            subtitle_language TEXT,
            promo TEXT,
            notes TEXT
        );