database: products: 7 rows where series_id = "CNT

Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)

7 rows where series_id = "CNT_2N7PPEEHWXX0"

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	display_title	description	description_short	image_id	display_order	listed_at	label_id	geoblock_id	display_name	copyright	on_sale_at
PRD_17E5PT5GP4AG	CNT_1H9BNNA8JCA0	Strike Witches CNT_2N7PPEEHWXX0	CNT_2N7PPEEHWXX0	2	1	1	Maidens in the Sky Vol. 2	[]	Strike Witches: Maidens in the Sky Vol. 2	Alert! Alert! Mysterious aliens called the “neuroi” are attacking the earth! Nothing can harm them except for an elite team of magical girls who patrol the skies: the Strike Witches! In this second installment of Strike Witches: Maidens in the Sky, Miyafuji Yoshika is sent to complete her training on the far-off island of Britannia, where she finds new friends (each prettier than the next!) and grapples with new challenges. Yoshika learns more about her friends, stumbles on some of the Strike Witch battalion's deepest secrets, and searches for the source of her own magical powers. The entire cast of the popular anime is here, cheering Yoshika on (or getting in her way), as she continues her inner journey and faces the choice that will determine her destiny: remain a healer or become a soldier?	YOSHIKA CLAIMS HER DESTINY!	01KGA261MSDJ5CBXTS33GZMDKE	4.0	2017-12-03T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Strike Witches: Maidens in the Sky Vol. 2	(C) 2008 Yuuki TANAKA, (C) 2007 501st JOINT FIGHTER WING	2017-12-14T08:00:00.000Z
PRD_1BWM0D7TJ39G	CNT_3GKRN70H1BB0	Strike Witches CNT_2N7PPEEHWXX0	CNT_2N7PPEEHWXX0	2	1	1	1937 Fuso Sea Incident Vol. 2	[]	Strike Witches: 1937 Fuso Sea Incident Vol. 2	It's 1938, and things are looking bleak for humanity. The discovery that the alien Neuroi have a vulnerable “core” gave hope to soldiers and citizens alike, but there is no clear plan to push back the Neuroi's relentless advance. In the meantime, a new threat emerges when the giant “Mountain” Neuroi begins to cross the Fuso Sea, threatening the heart of the Empire itself. Forced into a stalemate an a grinding war of attrition, the Witches develop a desperate plan that hinges on two things: the cooperation of the Fuso Imperial Navy, and Mio Sakamoto's Magic Eye. Read on for the stunning conclusion of the “Fuso Sea Incident”, a major turning point in the war against the Neuroi--and the lives of Mio and the rest of the Strike Witches!	BAND OF SISTERS	01KGA25ZGBSTQHAARCVSWZ09A6	2.0	2017-12-03T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Strike Witches: 1937 Fuso Sea Incident Vol. 2	(C) Ningen 2012, (C) 2010 501st JOINT FIGHTER WING	2017-12-14T08:00:00.000Z
PRD_1N5V3EJZSR6G	CNT_1ZZ7BWK6ZGE0	Strike Witches CNT_2N7PPEEHWXX0	CNT_2N7PPEEHWXX0	2	1	1	The Sky That Connects Us	[]	Strike Witches: The Sky That Connects Us	The year is 1944, and the war against the Neuroi is over. The 501st Joint Fighter Wing, also known as the Strike Witches, have accomplished their goal of protecting Britannia from the alien invaders. Now that the battle is done, the Witches disband and decide to go their separate ways for some much-needed R&R. As the girls enjoy downtime in the warstricken lands of Gallia and the deserts of Africa, a new danger lurks. A mysterious alien/human hybrid foretells of another impending invasion. Can the Strike Witches regroup in time to defeat this latest evil threat?	SEPARATED...BUT NEVER APART!	01KGA266SSWCY6YBX55E398AD9	7.0	2017-12-03T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Strike Witches: The Sky That Connects Us	(C) Shin KYOGOKU 2010, (C) 2010 501st JOINT FIGHTER WING	2017-12-14T08:00:00.000Z
PRD_1STAE1C2275G	CNT_3Z9MBE9FDFF0	Strike Witches CNT_2N7PPEEHWXX0	CNT_2N7PPEEHWXX0	2	1	1	One-Winged Witches Vol. 2	[]	Strike Witches: One-Winged Witches Vol. 2	The war against the Neuroi seems endless. For a young rookie Witch who is just learning to use her magic to protect her homeland and the people she loves, magical power can seem boundless. But all things must come to an end. In the concluding volume of One-Winged Witches, the Isle of Wight Detachment helps fight a pivotal battle that proves to be a major turning point in the war against the Neuroi. Unfortunately, one Witch must come to terms with the loss of her magic and everything that loss entails. Fly with Wilma Bishop and the one-winged witches of the Isle of Wight Detachment one last time!	A TIME FOR EVERY PURPOSE	01KGA2657Y4YT3B3T8AK4P35JM	6.0	2017-12-03T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Strike Witches: One-Winged Witches Vol. 2	(C) Atsuto Shinozuka 2012, (C) 501st JOINT FIGHTER WING THE MOVIE	2017-12-14T08:00:00.000Z
PRD_1W8TSME4E64G	CNT_1YM1ASZQRE80	Strike Witches CNT_2N7PPEEHWXX0	CNT_2N7PPEEHWXX0	2	1	1	1937 Fuso Sea Incident Vol. 1	[]	Strike Witches: 1937 Fuso Sea Incident Vol. 1	It has been nearly twenty years since the last Great War, and while smaller skirmishes are still taking place across the world, peace is mostly the norm. In the Fuso Empire, Sakamoto Mio is about to join the war effort against the Neuroi alien invaders. She will have to distinguish herself among the other hardworking cadets if she is to become a full-fledged Strike Witch. Soon, she will have the chance to prove herself in battle, as the Neuroi launch their latest brutal attack.	ONCE MORE INTO THE BREACH!	01KGA2639AGPHE5DACS8QJ8Q8G	1.0	2017-12-03T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Strike Witches: 1937 Fuso Sea Incident Vol. 1	(C) Ningen 2011, (C) 2010 501st JOINT FIGHTER WING	2017-12-14T08:00:00.000Z
PRD_35QCF4MNM4T0	CNT_2GY25Y5CRVVG	Strike Witches CNT_2N7PPEEHWXX0	CNT_2N7PPEEHWXX0	2	1	1	One-Winged Witches Vol. 1	[]	Strike Witches: One-Winged Witches Vol. 1	In humanity's fight against the alien Neuroi, it's not just the super-aces and movie stars of the 501st Joint Fighter Wing who have stories worth telling. In this volume, Sergeant Wilma Bishop--the first character ever introduced from the Strike Witches world!--is transferred to the Isle of Wight detachment. It's the sister detachment to the famous 501st, but instead of aces, the Isle of Wight is filled with awkward, insecure newbies and the walking wounded. And yet, while these “one-winged Witches” may not be ready to soar with the aces, each one has her own story to tell.	NOT ALL WITCHES ARE ACES	01KGA26007MT6RW3CFMXDFXH2C	5.0	2017-12-03T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Strike Witches: One-Winged Witches Vol. 1	(C) Atsuto Shinozuka 2012, (C) 501st JOINT FIGHTER WING THE MOVIE	2017-12-14T08:00:00.000Z
PRD_3CTF4AG1W2R0	CNT_2KKC4VHXJT5G	Strike Witches CNT_2N7PPEEHWXX0	CNT_2N7PPEEHWXX0	2	1	1	Maidens in the Sky Vol. 1	[]	Strike Witches: Maidens in the Sky Vol. 1	What if World War II had not been a battle between Axis and Allies, but between the human race and mysterious attacking aliens? This is the world of Strike Witches: Maidens in the Sky. The Earth has been invaded by a mysterious alien race known as the “Neuroi.” Humanity is on the verge of annihilation and their only hope is a team of flying magical girls--the Strike Witches. Maidens in the Sky follows the story of Miyafuji Yoshika, a simple farm girl who dreams only of taking over her family's medical clinic. One fateful day, a Strike Witch falls out of the sky and lands right at her feet. Yoshika is a healer and wants nothing to do with warfare or violence, but this chance encounter will change her destiny forever!	Humanity's last hope--on wings of steel and magic!	01KGA1GRQC1GZHF22FFY8XD07E	3.0	2017-12-03T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Strike Witches: Maidens in the Sky Vol. 1	(C) 2008 Yuuki TANAKA, (C) 2007 501st JOINT FIGHTER WING	2017-12-14T08:00:00.000Z

Advanced export

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

CREATE TABLE products (
      id TEXT PRIMARY KEY,
      content_id TEXT NOT NULL,
      series_id TEXT NOT NULL,
      parent_content_id TEXT,
      level INTEGER NOT NULL,
      content_type INTEGER NOT NULL,
      product_type INTEGER NOT NULL,
      title TEXT NOT NULL,
      alt_titles TEXT NOT NULL,
      subtitle TEXT NOT NULL,
      display_title TEXT NOT NULL,
      display_title_short TEXT NOT NULL,
      description TEXT NOT NULL,
      description_short TEXT NOT NULL,
      image_id TEXT NOT NULL,
      display_order REAL NOT NULL,
      listed_at TEXT NOT NULL,
      label_id TEXT NOT NULL,
      geoblock_id TEXT,
      display_name TEXT NOT NULL,
      copyright TEXT,
      on_presale_at TEXT,
      on_sale_at TEXT NOT NULL,
      off_sale_at TEXT,
      add_on INTEGER NOT NULL,
      add_on_campaign_only INTEGER NOT NULL,
      FOREIGN KEY (series_id) REFERENCES series(id),
      FOREIGN KEY (label_id) REFERENCES labels(id),
      FOREIGN KEY (geoblock_id) REFERENCES geoblocks(id)
    );
CREATE INDEX idx_products_content ON products(content_id);
CREATE INDEX idx_products_series ON products(series_id);
CREATE INDEX idx_products_label ON products(label_id);
CREATE INDEX idx_products_geoblock ON products(geoblock_id);
CREATE INDEX idx_products_image ON products(image_id);