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_1HFEKCRM4RHG"

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	display_title	description	image_id	display_order	listed_at	label_id	geoblock_id	display_name	copyright	on_sale_at
PRD_0DEJ3Q4698FG	CNT_3VX2GK9X2KB0	Lagoon Engine CNT_1HFEKCRM4RHG	CNT_1HFEKCRM4RHG	2	1	1	Volume 3	[]	Lagoon Engine, 3	Who's guarding the manor? That's the question Yen and Jin must answer when they confront the ghostly Maga that's haunting a creepy mansion! Can Jin master his special attack in time to slay the spooky specter?	01KKTXVPMA4A85N8A0DHNE61KP	3.0	2014-10-28T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Lagoon Engine, 3	(C) YUKIRU SUGISAKI 2004	2014-10-28T15:00:00.000Z
PRD_19TS8GPQ9HQG	CNT_3YGTXYP0DBK0	Lagoon Engine CNT_1HFEKCRM4RHG	CNT_1HFEKCRM4RHG	2	1	1	Volume 1	[]	Lagoon Engine, 1	Yen and Jin are brothers in elementary school - and successors in the Ragun family craft of defeating ghosts and evil spirits! In this world, the battle with these wicked "Maga" comes down to a game of guessing your opponent's true name. Once you know the name you gain control over the fight. While Yen and Jin train to join the family business, the two boys must keep their identities a secret...or risk death!	01K5FVJFRT1F0VWE8AC5HQE20Q	1.0	2014-10-28T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Lagoon Engine, 1	(C) YUKIRU SUGISAKI 2002	2014-10-28T15:00:00.000Z
PRD_1AT5XTTR79AG	CNT_0D4AXRR9VM80	Lagoon Engine CNT_1HFEKCRM4RHG	CNT_1HFEKCRM4RHG	2	1	1	Volume 7	[]	Lagoon Engine, 7	Young ghostbusters Yen and Jin will stop at nothing to capture a dangerous spirit before it possesses the queen of competitive Hyakunin Isshu. Their best friend Ayato's life may be at stake in this risky gambit if they fail. But first, can they pass the tests of the mystical Yamiya in order to obtain the tool they need to defeat the Hyaku Isshu once and for all?	01K5GA4K6NE96NSXWTB2QTM574	7.0	2015-01-30T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Lagoon Engine, 7	(C) YUKIRU SUGISAKI 2007	2015-01-30T15:00:00.000Z
PRD_1G3ZNB9VR5C0	CNT_2PR08R010GQG	Lagoon Engine CNT_1HFEKCRM4RHG	CNT_1HFEKCRM4RHG	2	1	1	Volume 2	[]	Lagoon Engine, 2	Kana Mikami, a member of the Mikami family, has a major crush on Yen Ragun...but is it really Yen whom she's in love with? When Kana is given a book that is rumored to grant wishes to its owner, will she make her move on Yen--or will she get burned?	01K5FYGGYA0SPV7EKBTNVQZK3E	2.0	2014-10-28T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Lagoon Engine, 2	(C) YUKIRU SUGISAKI 2003	2014-10-28T15:00:00.000Z
PRD_1RHVAD37QD6G	CNT_0BT6K6187RC0	Lagoon Engine CNT_1HFEKCRM4RHG	CNT_1HFEKCRM4RHG	2	1	1	Volume 6	[]	Lagoon Engine, 6	The adventures of young ghostbusters Yen and Jin continue! Since a dangerous Maga spirit is likely to appear at their friend Ayato's school, Yen and Jin must enter its Hyakunin Isshu tournament. But in order to defeat the Maga, they'll have to beat the Hyakunin Isshu champion first!	01K5GA51V66PBQNYRJKJN4M37D	6.0	2015-01-30T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Lagoon Engine, 6	(C) YUKIRU SUGISAKI 2006	2015-01-30T15:00:00.000Z
PRD_25MGM56K3HHG	CNT_231ZSNWNHBH0	Lagoon Engine CNT_1HFEKCRM4RHG	CNT_1HFEKCRM4RHG	2	1	1	Volume 5	[]	Lagoon Engine, 5	Yen and Jin take part in the test of courage at the Matsuri. All the kids are paired up and have to make a treacherous journey up an old mountain path to a shrine they may or may not return from! As if the journey isn't dangerous enough, Maga await somewhere on the way ready to ambush! Will Yen and Jin make it through this one? They'll not only have to prove their courage, they'll have to prove they can survive!	01KKTXZBFF8VR5T001ZJDC5RZD	5.0	2015-01-30T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Lagoon Engine, 5	(C) YUKIRU SUGISAKI 2006	2015-01-30T15:00:00.000Z
PRD_2GSR5PJ3HZNG	CNT_3H54WT2H79X0	Lagoon Engine CNT_1HFEKCRM4RHG	CNT_1HFEKCRM4RHG	2	1	1	Volume 4	[]	Lagoon Engine, 4	Summer vacation is about to begin for Yen and Jin! They go to the small town of Hanakage, where they must try to appease the gods through music and dance. The problem is that Yen and Jin can't play a note and they dance with two left feet. But with the help of a bitter Narama-a newfound friend with a tragic past-can Yen and Jin pull off the sacred dance?	01K5FYP4889WFW4DTBRRHZDN9A	4.0	2014-10-28T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Lagoon Engine, 4	(C) YUKIRU SUGISAKI 2006	2014-10-28T15: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);