video8: releases: 29 rows where country_release = "Films", encoding = "PAL" and promo = "Y"

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

29 rows where country_release = "Films", encoding = "PAL" and promo = "Y"

descending

id ▼	title_id	release_date	country_release	encoding	runtime_mins	promo	notes
2781	Absence of Malice 1363		Films	PAL	116.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.
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.
2783	Berserk! 2488		Films	PAL	96.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.
2784	Born Free 2489	1986	Films	PAL	95.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.
2785	Fail Safe 2490		Films	PAL	111.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.
2786	Georgy Girl 2491		Films	PAL	100.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.
2787	Gilda 2492		Films	PAL		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.
2788	Here Comes Mr. Jordan 2493		Films	PAL	94.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.
2789	Holiday 2494		Films	PAL	95.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.
2790	In a Lonely Place 2495		Films	PAL	94.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.
2791	Mr. Deeds Goes to Town 2496		Films	PAL		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.
2792	Murder By Death 2497		Films	PAL	95.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.
2793	Punch Line 2498		Films	PAL	123.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.
2794	Robin and Marian 2499		Films	PAL	107.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.
2795	Scream of Fear 2500		Films	PAL	81.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.
2796	Seems Like Old Times 2501		Films	PAL	103.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.
2797	Shampoo 2502		Films	PAL		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.
2798	Sunset 2503		Films	PAL	107.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.
2799	The Fifth Musketeer 2504		Films	PAL	104.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.
2800	The Caine Mutiny 2505	1989	Films	PAL		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.
2801	The Lady from Shanghai 2506		Films	PAL	87.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.
2802	The Last Detail 2507		Films	PAL		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.
2803	The Last Hurrah 2508		Films	PAL		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.
2804	The Way We Were 475	1989	Films	PAL		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.
2805	The Wrong Box 2509		Films	PAL		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.
2806	True Believer 2510		Films	PAL		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.
2807	Twentieth Century 2511		Films	PAL		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.
2808	You Were Never Lovelier 2512		Films	PAL	98.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.
2809	You'll Never Get Rich 2513		Films	PAL	88.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
        );