database: products: 5 rows where series_id = "CNT

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

5 rows where series_id = "CNT_326ZTXWA4TR0"

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	on_sale_at
PRD_11VHV0WD48CG	CNT_1YWYW94B34BG	Pig Bride CNT_326ZTXWA4TR0	CNT_326ZTXWA4TR0	2	1	1	Volume 3	[]	Pig Bride, Vol. 3	Now that she has discovered Si-Joon's secret fiancée, Doe-Doe will stop at nothing to rip the masked girl away from Si-Joon, whom she has already claimed as her own. But Mu-Yeon's affection for Si-Joon is not something to be trifled with, especially when dark spiritual forces are involved...As memories of his past life with Mu-Yeon resurface, the time when Si-Joon will have to face the mystery of the pig bride head-on is drawing near. But will he be prepared when the critical moment comes?	01KGA2FGGEG944B092M0AF5GYF	3.0	2018-01-19T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1P205DKRV2XG	Pig Bride, Vol. 3	2018-01-19T08:00:00.000Z
PRD_14806KSQ08KG	CNT_3Y7BZMTKE3MG	Pig Bride CNT_326ZTXWA4TR0	CNT_326ZTXWA4TR0	2	1	1	Volume 1	[]	Pig Bride, Vol. 1	Lost in the mountains on a trip to summer camp, eight-year-old Si-Joon fears he'll never make it out alive. When a strange girl in a pig mask appears before him, he follows her to a house deep in the woods, where he is told that he must marry the pig-faced girl to atone for the sins of their ancestors. Si-Joon's not too keen on getting married, but that wedding feast looks so delicious! It's only afterward that he realizes what he's done and...wakes up. Now in high school, Si-Joon Lee has been dreaming about the pig bride for as long as he can remember. But it's all just a dream, right?	01KGA1HYCYM80V1NKH66Y82V1M	1.0	2018-01-19T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1P6A9KWCPCY0	Pig Bride, Vol. 1	2018-01-19T08:00:00.000Z
PRD_1X518C2AR9DG	CNT_3ZJ1WZE2M5AG	Pig Bride CNT_326ZTXWA4TR0	CNT_326ZTXWA4TR0	2	1	1	Volume 5	[]	Pig Bride, Vol. 5	Si-Joon immediately recognizes Mu-Yeon when she unexpectedly appears at his school. Though he can't deny he's happy to see her - especially maskless - he's not thrilled about the country bumpkin enrolling at his über-elite private high school. But fitting in with her peers is the least of Mu-Yeon's worries. She's won Si-Joon's heart and secured the admiration of every boy on campus, but she has yet to win over Si-Joon's grandfather. And if he doesn't approve, they can never marry! Will wedding bells ring at last in this final volume of Pig Bride?	01KGA2FJ64QZXB270BQ8C5FSTV	5.0	2018-01-19T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1P205DKRV2XG	Pig Bride, Vol. 5	2018-01-19T08:00:00.000Z
PRD_33J92PD869X0	CNT_0Z7RC096TMT0	Pig Bride CNT_326ZTXWA4TR0	CNT_326ZTXWA4TR0	2	1	1	Volume 4	[]	Pig Bride, Vol. 4	As if Si-Joon wasn't already a nervous wreck over Ki-Ryong's challenge, the sneaky princess has raised the stakes, capturing Si-Joon's dearest friend! With Ji-Oh in danger, Si-Joon can't back down from the task at hand-but how on earth is he going to tell the real pig bride from the fake?! The two masked girls look exactly the same, and Ki-Ryong's powers render any line of questioning pointless. If he can't rely on his head, he'll have to trust the murmurings of his heart to guide him to Mu-Youn. The gloves (and mask!) are off in the final showdown between these bitter rivals!	01KGA2FH340DK93TR5MDZ840T3	4.0	2018-01-19T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1P205DKRV2XG	Pig Bride, Vol. 4	2018-01-19T08:00:00.000Z
PRD_360RC9EJ28W0	CNT_2YHNFKZF9KV0	Pig Bride CNT_326ZTXWA4TR0	CNT_326ZTXWA4TR0	2	1	1	Volume 2	[]	Pig Bride, Vol. 2	When Doe-Doe makes an unexpected visit to his family's mansion, a panicked Si-Joon does what he can to keep her from finding out about his pig-faced bride. Yet even as Mu-Yeon is frantically ushered from the house, Doe-Doe overhears the maids gossiping about his mysterious fiancée. Enraged by the news, Doe-Doe plots to unseat the masked country bumpkin and take her place as Si-Joon's betrothed. But an even darker plot is afoot that threatens to separate Mu-Yeon from her lord...for good.	01KGA2FFY23K1MXNJJSHY7JA5W	2.0	2018-01-19T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1P205DKRV2XG	Pig Bride, Vol. 2	2018-01-19T08: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);