database: products: 10 rows where series_id = "CNT

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

10 rows where series_id = "CNT_3VQDJQSWC5R0"

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_0KANCCY26N0G	CNT_3XPY5FHPJ83G	Tsubasa Omnibus CNT_3VQDJQSWC5R0	CNT_3VQDJQSWC5R0	2	1	1	Volume 6	[]	Tsubasa Omnibus 6	THE EYES HAVE IT Our group of dimension-traveling companions continues their long journey in search of Princess Sakura’s memories and have now found themselves in trouble in Tokyo. During a last ditch effort to save Princess Sakura from her underwater slumber, the truth about Syaoran is revealed and this shocking revelation changes everything. Who is the real Syaoran? Can they get the friend they know and love back?	01KG999T2K4VN2NN4GX8E32NF2	6.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Tsubasa Omnibus 6	(C) CLAMP/ Shigatsu Tsuitachi CO., LTD. / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_0QV5ZZR42M7G	CNT_1X1B4S7Z17CG	Tsubasa Omnibus CNT_3VQDJQSWC5R0	CNT_3VQDJQSWC5R0	2	1	1	Volume 4	[]	Tsubasa Omnibus 4	DRAGONFLY DASH Syaoran and his world-hopping friends find themselves in grave danger as they continue their inter-dimensional search for Princess Sakura's missing memories!?After the godlike Ashura-o kills the mighty Yasha-o, the country of Shura hangs in the balance-and Syaoran will do anything he can to correct the past.?Then, the dimension travelers are off to Piffle World, where the prize for the lucky pilot who wins the elusive Dragonfly Race is one of Princess Sakura's memories! But when contestants are eliminated from the competition unexpectedly, the friends fear that someone may be rigging the race with booby traps. Can the culprit be found before it's too late? And will any of our heroes emerge victorious? Princess Sakura's memories-and now their lives-depend on it! This omnibus edition includes volumes 10-12 of?Tsubasa. From the Trade Paperback edition.	01KG999RZJXED9Q6NP38CX1GQQ	4.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Tsubasa Omnibus 4	(C) CLAMP/ Shigatsu Tsuitachi CO., LTD. / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_0T9MAJTEEK6G	CNT_3WBR44W7C6DG	Tsubasa Omnibus CNT_3VQDJQSWC5R0	CNT_3VQDJQSWC5R0	2	1	1	Volume 2	[]	Tsubasa Omnibus 2	LEGEND HUNTERS Syaoran and his companions continue their inter-dimensional travels in order to restore the memories of Princess Sakura and this time, they find themselves having adventures in two exciting and mystery-filled worlds. They first come to Jade Country-a cold, snow-covered?land where the town of Spirit lives in fear of the legend of a 300 year-old princess who has been stealing the townspeople's children.?Following this, our worlds-spanning adventurers find themselves in Oto, where to earn money, they become hunters of demonic creatures called Oni. Will they be able to find more pieces of Princess Sakura's fragmented memories as they continue on through new and increasingly perilous worlds? From the Trade Paperback edition.	01KG999QQ0NCS4D7QK2R6CDH9G	2.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Tsubasa Omnibus 2	(C) CLAMP/ Shigatsu Tsuitachi CO., LTD. / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_1ECJ8FDTWQJ0	CNT_0TQANV09YSH0	Tsubasa Omnibus CNT_3VQDJQSWC5R0	CNT_3VQDJQSWC5R0	2	1	1	Volume 9	[]	Tsubasa Omnibus 9	LIFE WISH Syaoran reveals to his companions the heavy price he paid to be able to protect Sakura, one with consequences for many people, and his burden of guilt. As the time for both Syaoran and FeiWang’s wishes to come true arrives, the travelers must face off against FeiWang, all the magic he can summon against them, and Syaoran’s double. In this battle cut off from time, even the witch Yuko’s help may not be enough. This omnibus edition includes volumes 2526 of Tsubasa.	01KG999W4B7ZQ51RC2EW3ZVS9K	9.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Tsubasa Omnibus 9	(C) CLAMP/ Shigatsu Tsuitachi CO., LTD. / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_2HKX6N974NG0	CNT_0XBMMGCTRQK0	Tsubasa Omnibus CNT_3VQDJQSWC5R0	CNT_3VQDJQSWC5R0	2	1	1	Volume 5	[]	Tsubasa Omnibus 5	Childhood friends Princess Sakura and Syaoran, the son of an archaeologist, become entangled in a series of events that force them to traverse through alternate realities on an action-packed and unforgettable adventure! In the Kingdom of Clow, an archaeological dig unleashes an incredible power, causing Sakura to lose her memories. To save her, Syaoran must follow the orders of the Dimension Witch and travel alongside Kurogane, an unrivaled warrior; Fai, a powerful magician; and Mokona Modoki, a curiously strange creature, to retrieve Sakura’s dispersed memories! But first, there is a price to be paid …	01KG999SH67D4P2EV17N3V9G4S	5.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Tsubasa Omnibus 5	(C) CLAMP/ Shigatsu Tsuitachi CO., LTD. / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_2JX2V2FWRPH0	CNT_2T17N6PJDRJ0	Tsubasa Omnibus CNT_3VQDJQSWC5R0	CNT_3VQDJQSWC5R0	2	1	1	Volume 7	[]	Tsubasa Omnibus 7	FAI THE CURSED After the dangerous chess competition, Princess Sakura takes it upon herself to alter the future by leaving her companions behind. As a result, her body and soul are separated. To go after her, the travelers have to decide what they can afford to pay the witch, and Fai’s past comes out. As his lies are revealed, Fai’s curse comes back to haunt him?one that threatens everyone’s lives if he can’t find a way to escape it.	01KG999TYMNVAKZRA54AJ1N3MP	7.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Tsubasa Omnibus 7	(C) CLAMP/ Shigatsu Tsuitachi CO., LTD. / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_2M0DG8B90MQ0	CNT_2WP1M2137PW0	Tsubasa Omnibus CNT_3VQDJQSWC5R0	CNT_3VQDJQSWC5R0	2	1	1	Volume 3	[]	Tsubasa Omnibus 3	BATTLE OF THE GODS Syaoran and his traveling companions continue to hop, skip, and jump across dimensions-from a land of demon-hunters that hides a reality-shattering secret, to a world inhabited with furry creatures who are being terrorized by a living squall, and beyond-all in the name of restoring Sakura's memories. This time, Syaoran, Sakura, and Mokona find themselves separated from Fai and Kurogane, divided between two camps in a conflict that reaches to the heavens. Will Syaoran be forced to stand against his friends in this bloody battle between deities?? From the Trade Paperback edition.	01KG999R8R1VKYGGMWN5RGT4CJ	3.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Tsubasa Omnibus 3	(C) CLAMP/ Shigatsu Tsuitachi CO., LTD. / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_2RPW3V4KCKP0	CNT_0W0YMDQBJNX0	Tsubasa Omnibus CNT_3VQDJQSWC5R0	CNT_3VQDJQSWC5R0	2	1	1	Volume 1	[]	Tsubasa Omnibus 1	THE ULTIMATE SACRIFICE Childhood friends Princess Sakura and Syaoran, the son of an archaeologist, become entangled in a series of events that force them to traverse through alternate realities on an action-packed and unforgettable adventure!? In the Kingdom of Clow, an archaeological dig unleashes an incredible power, causing Sakura to lose her memories. To save her, Syaoran must follow the orders of the Dimension Witch and travel alongside Kurogane, an unrivaled warrior; Fai, a powerful magician; and Mokona Modoki, a curiously strange creature, to retrieve Sakura's dispersed memories! But first, there is a price to be paid... This omnibus edition includes volume 1-3 of Tsubasa. From the Trade Paperback edition.	01KG98DY0SQ47SRQ4S07ZQPRRK	1.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Tsubasa Omnibus 1	(C) CLAMP/ Shigatsu Tsuitachi CO., LTD. / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_387BQ52NYQ2G	CNT_3V1M5J55RA1G	Tsubasa Omnibus CNT_3VQDJQSWC5R0	CNT_3VQDJQSWC5R0	2	1	1	Volume 10	[]	Tsubasa Omnibus 10	DIMENSION TRAP The mystery of Yoko’s cylinder is revealed in this final volume of the Tsubasa Chronicles series. As Fei-Wang attempts to destroy both versions of Syaoran and Sakura in order to fulfill his wish, his final curse takes effect and Syaoran must decide what to pay for a final price. Time and dimensions collide, and hidden in Syaoran’s and Sakura’s past are the keys that may unlock a blessed future ? or a hell that will be lived and relived for eternity.	01KG999WK35PX8JM682JVBKFGH	10.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Tsubasa Omnibus 10	(C) CLAMP/ Shigatsu Tsuitachi CO., LTD. / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_3CNT2SWZTP1G	CNT_1TC15XVE792G	Tsubasa Omnibus CNT_3VQDJQSWC5R0	CNT_3VQDJQSWC5R0	2	1	1	Volume 8	[]	Tsubasa Omnibus 8	TIME OUT Syaoran challenges Seishiro, his former mentor, to a fight for one of Sakura’s feathers. In his determination not to lose again, Syaoran travels into a dream world where he gets a chance to face his own clone. With the information he received from the dream world, the travelers set out on another journey to the Kingdom of Clow. Their goal is to stop FeiWang Reed, but the consequences, both for them and for the citizens, may be more than they can handle.	01KG999VJE4HHQEWRVC86GM2QT	8.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Tsubasa Omnibus 8	(C) CLAMP/ Shigatsu Tsuitachi CO., LTD. / Kodansha Ltd.	2016-10-25T07: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);