video8: releases: 3 rows where audio_format = "Hi-Fi/Digital Mono", subtitle_language = "Japanese" 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

3 rows where audio_format = "Hi-Fi/Digital Mono", subtitle_language = "Japanese" and title_id = 901

descending

id ▼	title_id	catalog_number	release_date	country_release	encoding	runtime_mins	list_price	upc	audio_format	subtitle_language	notes
1031	Lost Horizon 901	A-?????		Japan	NTSC	132.0	¥10,000		Hi-Fi/Digital Mono	Japanese	RCA "Classic Series" release
1032	Lost Horizon 901	00HS-80446 (sticker over spine)	1988.12.01	Japan	NTSC	132.0	¥9,390		Hi-Fi/Digital Mono	Japanese	RCA "Classic Series" release
1033	Lost Horizon 901	CSWF-8654	1990.09.21	Japan	NTSC	132.0	¥3,800	4-988009-865478	Hi-Fi/Digital Mono	Japanese	RCA "Classic Series" release

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
        );