database: products: 8 rows where series_id = "CNT

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

8 rows where series_id = "CNT_1S4M4G3GFRV0"

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_091AXXQXFN20	CNT_2F587QDT5ME0	My Clueless First Friend CNT_1S4M4G3GFRV0	CNT_1S4M4G3GFRV0	2	1	1	Volume 04	[]	My Clueless First Friend 04	Valentine's Day has arrived, and Kasahara plans to give Takada a special gift. Will she risk her budding friendship with Nishimura to finally confess her love for the object of both their affections? Then April rolls around, and the gang advances to sixth grade! With plenty of new classmates, like an angsty gamer who often skips school, our protagonists might just find their friend group growing a little bigger...	01KGBRJX75Y938D9EM1Z7V00PZ	4.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	My Clueless First Friend 04	2025-07-03T07:00:00.000Z
PRD_12A54E2PH16G	CNT_0QJN9ADH0GAG	My Clueless First Friend CNT_1S4M4G3GFRV0	CNT_1S4M4G3GFRV0	2	1	1	Volume 06	[]	My Clueless First Friend 06	The days are getting longer and hotter as another summer approaches. But this time, things are a little different. Kitagawa is acting nicer, Kasahara is more honest about her feelings, and Nishimura has no shortage of friends to enjoy the sun with! After a round of surfing lessons at the beach, the kids of Class 6-1 head off to a campsite in the woods, where a romantic superstition forces Takada to make a tough decision!	01KGBRKHXG338VEQBD22EWPEDS	6.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	My Clueless First Friend 06	2025-07-03T07:00:00.000Z
PRD_1MW3NRWACYA0	CNT_3850PMJAFDP0	My Clueless First Friend CNT_1S4M4G3GFRV0	CNT_1S4M4G3GFRV0	2	1	1	Volume 01	[]	My Clueless First Friend 01	One lonely, gloomy fifth-grade girl is the target of her classmates' relentless bullying and teasing—that is, until a new kid arrives on the scene! Friendly Takada is as clueless as he is well-meaning, but somehow he possesses the magic ability to start drawing "Grim Reaper" Nishimura out of her shell. As the elementary schoolers experience all the fun of a childhood summer together—from going to the pool to picking sunflowers to watching fireworks—an unusual friendship blossoms!	01KGBQTJ9D10BDHZYBRBAWB5DS	1.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	My Clueless First Friend 01	2025-07-03T07:00:00.000Z
PRD_1V0978ZZ2N30	CNT_3SDTHKZ4QMD0	My Clueless First Friend CNT_1S4M4G3GFRV0	CNT_1S4M4G3GFRV0	2	1	1	Volume 08	[]	My Clueless First Friend 08	It's Field Day again at Sonohenno Elementary School! The sixth-graders' families have come to spectate the event, where a heap of surprises awaits. No one can guess who will come in clutch, who will dance their heart out, and who will win the climactic footrace this year! Once the dust settles, the kids get ready for their next big activity: a field trip by train. Can Adachi and Inada group up their classmates in a way that will keep everyone happy?	01KGBRMN6EXJ6QYBAHC64V10GP	8.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	My Clueless First Friend 08	2025-07-03T07:00:00.000Z
PRD_21PP6C10JSF0	CNT_3HA6WP49J8H0	My Clueless First Friend CNT_1S4M4G3GFRV0	CNT_1S4M4G3GFRV0	2	1	1	Volume 07	[]	My Clueless First Friend 07	With the heart-pounding camping trip behind them, Nishimura and Takada continue to make the most of their second summer together. Their busy schedule includes a fireworks show, a visit to a farm in the countryside, a sleepover with a bit of stargazing, and a slew of scientific experiments! But all good things come to an end, and before they know it, they're back in a classroom full of familiar faces...	01KGBRKYRHGXKTRMZDX4MCDP5V	7.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	My Clueless First Friend 07	2025-07-03T07:00:00.000Z
PRD_2T42FNV8VRD0	CNT_06C12577F7K0	My Clueless First Friend CNT_1S4M4G3GFRV0	CNT_1S4M4G3GFRV0	2	1	1	Volume 02	[]	My Clueless First Friend 02	With the end of summer vacation for friendly Takada and gloomy Nishimura, school is back in session. The new semester brings new changes for all the kids in their elementary class, including Nishimura. Her unusual friendship with Takada is helping her to open up little by little! But will she revert back to a wallflower when the school sports festival rolls around in autumn and Takada gets hurt? Feeling responsible, Nishimura must steel herself to be more than a spectator at the festival for the very first time! Will Takada's enthusiasm carry her through?	01KGBRJ7ZCBJ7JKM1TP59QY1MX	2.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	My Clueless First Friend 02	2025-07-03T07:00:00.000Z
PRD_3BTS3ZGKDXSG	CNT_35D6GBN1JW7G	My Clueless First Friend CNT_1S4M4G3GFRV0	CNT_1S4M4G3GFRV0	2	1	1	Volume 05	[]	My Clueless First Friend 05	A new school year means new lessons, new friends, and new...rivals? When rumors about the infamous "Grim Reaper" reach the ears of a self-proclaimed "witch," will Nishimura meet her gloomy match? Later, what will Adachi do when she spies Hino getting chummy with a taller, prettier classmate? And how will Takada react when he receives a heartfelt love letter—not from Nishimura, not from Kasahara, but from a girl he's never met? Sixth grade is off to a rousing start!	01KGBRJFKFH93TJT8R25A7XDJS	5.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	My Clueless First Friend 05	2025-07-03T07:00:00.000Z
PRD_3EFTPKT0WAY0	CNT_2G84BGD5GS20	My Clueless First Friend CNT_1S4M4G3GFRV0	CNT_1S4M4G3GFRV0	2	1	1	Volume 03	[]	My Clueless First Friend 03	As the season changes to winter, the cold weather does nothing to put a chill on pushy Takada and shy Nishimura's deepening bond! Nishimura also finds herself building friendships with the rest of her classmates, too, even hosting friends at her home—for the very first time! What will she do when Christmas comes around and Takada, wondering how his feelings for Nishimura differ from how he feels about the rest of their friends, asks her if they should kiss?	01KGBRHCKY3SVVNXPB1J2M89D0	3.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	My Clueless First Friend 03	2025-07-03T07: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);