products

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

17 rows where series_id = "CNT_2ZHHKFM7ZGE0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: listed_at (date), on_sale_at (date)

id ▼ content_id series_id parent_content_id level content_type product_type title alt_titles subtitle display_title display_title_short description description_short image_id display_order listed_at label_id geoblock_id display_name copyright on_presale_at on_sale_at off_sale_at add_on add_on_campaign_only
PRD_02RZ9SJETHKG CNT_085XHZK1B4K0 S.A CNT_2ZHHKFM7ZGE0 CNT_2ZHHKFM7ZGE0 2 1 1 Volume 12 []   S.A, Vol. 12   Special A is in an uproar! The conservatory is set to be demolished unless the SA class wins the Elite High School Student Tournament. Hikari is enthusiastic to be in the competition, but Kei and Ryu are at odds over a mysterious girl! Will they be able to come together and defeat their old nemesis Kokusen High, or is this end of Special A?!   01KGBPRWMHS4AVKD5E5PSCG5XC 12.0 2025-06-20T07:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1J2M4YTFN3M0 S.A, Vol. 12 S･A -Special A- © Maki Minami 2003/HAKUSENSHA, Inc.   2025-06-20T07:00:00.000Z   0 0
PRD_08QM1MTVVTVG CNT_0N5P0WSHJXV0 S.A CNT_2ZHHKFM7ZGE0 CNT_2ZHHKFM7ZGE0 2 1 1 Volume 6 []   S.A, Vol. 6   Being No. 2 Sucks!The Kokusen Academy Culture Festival is here, and the Special A crew is making sure it runs smoothly. But chaos erupts when Kei's grandfather tries to haul Kei off to London! Worse, when Hikari tries to intervene, she gets abducted! But the worst part of it all is that amidst all the drama, Hikari is starting to realize her true feelings for Kei...   01KGBPPHY84JYD16KWNA08W6BJ 6.0 2025-06-20T07:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1J2M4YTFN3M0 S.A, Vol. 6 S･A -Special A- © Maki Minami 2003/HAKUSENSHA, Inc.   2025-06-20T07:00:00.000Z   0 0
PRD_08XCSPDXVMW0 CNT_1BQR8NZ47R3G S.A CNT_2ZHHKFM7ZGE0 CNT_2ZHHKFM7ZGE0 2 1 1 Volume 3 []   S.A, Vol. 3   Yahiro, a childhood friend of Kei and Akira, tells Hikari that Kei is in love with her. Hikari would confront Kei to find out the truth...if she wasn't so busy avoiding him!   01KGBPKVP61TKG1TK57YTMPW32 3.0 2025-06-20T07:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1J2M4YTFN3M0 S.A, Vol. 3 S･A -Special A- © Maki Minami 2003/HAKUSENSHA, Inc.   2025-06-20T07:00:00.000Z   0 0
PRD_08YKHN5JN6YG CNT_3W6QGTX8MT00 S.A CNT_2ZHHKFM7ZGE0 CNT_2ZHHKFM7ZGE0 2 1 1 Volume 5 []   S.A, Vol. 5   Being No. 2 Sucks!Kei's family has arranged for him to marry a girl named Sakura...but Sakura is already hopelessly in love with her ideal "prince," Jun! When Hikari finds out, she is all too delighted to play matchmaker between Jun and Sakura...but this latest attempt to humiliate Kei is about to backfire in a way she never expected!   01KGBPMRPY9J6XR8KZYBEACA4R 5.0 2025-06-20T07:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1J2M4YTFN3M0 S.A, Vol. 5 S･A -Special A- © Maki Minami 2003/HAKUSENSHA, Inc.   2025-06-20T07:00:00.000Z   0 0
PRD_0TAKMQR3F9S0 CNT_2Q37EHKT4X6G S.A CNT_2ZHHKFM7ZGE0 CNT_2ZHHKFM7ZGE0 2 1 1 Volume 11 []   S.A, Vol. 11   Just when it seems like Hikari might finally come to terms with her feelings for Kei, a huge new obstacle looms up between them. Kei's grandfather, the patriarch of the clan, comes to Japan, demanding that Kei return to London. But is that his real objective, or is he hiding something?   01KGBPM2T0GN1MG8BS6M5GHJ1G 11.0 2025-06-20T07:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1J2M4YTFN3M0 S.A, Vol. 11 S･A -Special A- © Maki Minami 2003/HAKUSENSHA, Inc.   2025-06-20T07:00:00.000Z   0 0
PRD_0X9JHXMFQQZ0 CNT_39R1EEYAYV0G S.A CNT_2ZHHKFM7ZGE0 CNT_2ZHHKFM7ZGE0 2 1 1 Volume 7 []   S.A, Vol. 7   Being No. 2 Sucks!The Sports Festival rages on, and Hikari has to win if she wants to stay in SA... but she's not the only one who's sweating. Will Kei risk his reputation to keep Hikari in the fold? Prepare for ruthless battles, nail-biting tension, and the introduction of SA's first couple!   01KGBPKZBY7Z3VQZ90BH30SH5G 7.0 2025-06-20T07:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1J2M4YTFN3M0 S.A, Vol. 7 S･A -Special A- © Maki Minami 2003/HAKUSENSHA, Inc.   2025-06-20T07:00:00.000Z   0 0
PRD_0YV26AT5B8R0 CNT_0PDME382KW7G S.A CNT_2ZHHKFM7ZGE0 CNT_2ZHHKFM7ZGE0 2 1 1 Volume 9 []   S.A, Vol. 9   Being No. 2 Sucks!Kei's grandfather summons Hikari to London to tell her Kei is overextending himself for her sake. Feeling guilty, Hikari decides to keep her distance from Kei. But her luck takes a strange turn when a prince she meets in London follows her all the way back to Japan! Will Hikari fall for his royal charms while she's avoiding Kei?   01KGBPM1QHTXPCXQDNJMM9KA0G 9.0 2025-06-20T07:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1J2M4YTFN3M0 S.A, Vol. 9 S･A -Special A- © Maki Minami 2003/HAKUSENSHA, Inc.   2025-06-20T07:00:00.000Z   0 0
PRD_10HXBTKE2H20 CNT_07Z25ZK7YNDG S.A CNT_2ZHHKFM7ZGE0 CNT_2ZHHKFM7ZGE0 2 1 1 Volume 15 []   S.A, Vol. 15   The SA class decides to get away from it all with a vacation in Finn's home country to join in the big beach festival. But it's no fun in the sun for Finn when the alluring Alisa Appleton attempts to make Ryu her boyfriend. Things go from bad to worse when during a poolside accident, Hikari finds out Finn's secret!   01KGBPN8VPJZ13GM71DTRW1DTZ 15.0 2025-06-20T07:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1J2M4YTFN3M0 S.A, Vol. 15 S･A -Special A- © Maki Minami 2003/HAKUSENSHA, Inc.   2025-06-20T07:00:00.000Z   0 0
PRD_1BDPGZZ3HKX0 CNT_1ZKAMYT1PQ2G S.A CNT_2ZHHKFM7ZGE0 CNT_2ZHHKFM7ZGE0 2 1 1 Volume 17 []   S.A, Vol. 17   Joy abounds when final exams are over and the students begin to plan for the summer festival. But secretly Hikari is heartbroken--she'll be moving to Kyushu because of her father's job. She can't bring herself to tell Kei and the others. Will she really leave the boy and the school she loves?   01KGBPPZM19STN71G002NDRZGS 17.0 2025-06-20T07:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1J2M4YTFN3M0 S.A, Vol. 17 S･A -Special A- © Maki Minami 2003/HAKUSENSHA, Inc.   2025-06-20T07:00:00.000Z   0 0
PRD_1E213JS5XJW0 CNT_3YX7M8GA5P3G S.A CNT_2ZHHKFM7ZGE0 CNT_2ZHHKFM7ZGE0 2 1 1 Volume 16 []   S.A, Vol. 16   Hikari's friendship with Iori Tokiwa is causing Kei much anxiety. He hates himself for being jealous yet is still mad at Iori for taking up Hikari's time. But Hikari is dedicated to helping Iori fulfill his dream of becoming a hairdresser. The tension builds when she agrees to be Iori's model in a hairstyling contest!   01KGBPPYDTTS53Z710YA0PPCQZ 16.0 2025-06-20T07:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1J2M4YTFN3M0 S.A, Vol. 16 S･A -Special A- © Maki Minami 2003/HAKUSENSHA, Inc.   2025-06-20T07:00:00.000Z   0 0
PRD_1KS06VSKPPZ0 CNT_23B0VV7XZT0G S.A CNT_2ZHHKFM7ZGE0 CNT_2ZHHKFM7ZGE0 2 1 1 Volume 1 []   S.A, Vol. 1   Being No. 2 Sucks!Her whole life, Hikari Hanazono has been consumed with the desire to win against her school rival, Kei Takishima--at anything. He always comes out on top no matter what he does, and Hikari is determined to do whatever it takes to beat this guy...somehow!At age 6 Hikari lost to Kei in an impromptu wrestling match. Now, at 15, Hikari joins "Special A," a group of the top seven students at a private academy, for the opportunity to trounce the guy who made her suffer her first defeat.   01KGBNV8XW70X9VJ0Y7ZB0A3YC 1.0 2025-06-20T07:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1J2M4YTFN3M0 S.A, Vol. 1 S･A -Special A- © Maki Minami 2003/HAKUSENSHA, Inc.   2025-06-20T07:00:00.000Z   0 0
PRD_1W7Z08RQD00G CNT_3G55JF0V2ME0 S.A CNT_2ZHHKFM7ZGE0 CNT_2ZHHKFM7ZGE0 2 1 1 Volume 13 []   S.A, Vol. 13   Kei's grandfather, determined to keep the boy under his control, traps him in London and makes plans to publicly announce Kei's appointment to president of a company, along with his engagement to the company chairman's daughter. Hikari and the SA gang try to get to London to save him--but with Aoi determined to stop them at all costs, will they make it in time?   01KGBPME0NQ30FPN3HENFXGDS1 13.0 2025-06-20T07:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1J2M4YTFN3M0 S.A, Vol. 13 S･A -Special A- © Maki Minami 2003/HAKUSENSHA, Inc.   2025-06-20T07:00:00.000Z   0 0
PRD_2AECFABPXT40 CNT_3NGZGVYDCEBG S.A CNT_2ZHHKFM7ZGE0 CNT_2ZHHKFM7ZGE0 2 1 1 Volume 8 []   S.A, Vol. 8   Being No. 2 Sucks!When Hikari finally asks Kei out, it seems like a dream come true. But they weren't counting on a double date with Sakura and Jun! And when Kei and Hikari finally get a moment alone, who shows up but the dreaded Yahiro? Throw Megumi, Takashi and Akira in the mix, and it's another troubled day in paradise!   01KGBPPJYCEJHQGF2KVFV85VSP 8.0 2025-06-20T07:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1J2M4YTFN3M0 S.A, Vol. 8 S･A -Special A- © Maki Minami 2003/HAKUSENSHA, Inc.   2025-06-20T07:00:00.000Z   0 0
PRD_2AM47C2RXMCG CNT_0821RK4018J0 S.A CNT_2ZHHKFM7ZGE0 CNT_2ZHHKFM7ZGE0 2 1 1 Volume 4 []   S.A, Vol. 4   Being No. 2 Sucks!After finding out about Hikari's date with Tadashi, Kei is driven to distraction and kidnaps Hikari. However, Kei soon develops a high fever and collapses, and Hikari finds herself nursing him. Will Kei's love finally reach the thickheaded Hikari?   01KGBPKW8KF72S3SPTDYYCC8Q3 4.0 2025-06-20T07:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1J2M4YTFN3M0 S.A, Vol. 4 S･A -Special A- © Maki Minami 2003/HAKUSENSHA, Inc.   2025-06-20T07:00:00.000Z   0 0
PRD_2DHRDHFE8PFG CNT_13PABJCSSAQ0 S.A CNT_2ZHHKFM7ZGE0 CNT_2ZHHKFM7ZGE0 2 1 1 Volume 2 []   S.A, Vol. 2   Being No. 2 Sucks!Hikari and Kei are pitted against a pair of professional wresters in a challenge issued by the student council. Hikari may now be on the same team as Kei, but a rival is still a rival!   01KGBPNGJVRBSN98C8ERWKKP2N 2.0 2025-06-20T07:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1J2M4YTFN3M0 S.A, Vol. 2 S･A -Special A- © Maki Minami 2003/HAKUSENSHA, Inc.   2025-06-20T07:00:00.000Z   0 0
PRD_2JQ2N52VCF0G CNT_3DR5FN8E3KE0 S.A CNT_2ZHHKFM7ZGE0 CNT_2ZHHKFM7ZGE0 2 1 1 Volume 14 []   S.A, Vol. 14   The world of the SA class is turned upside down when Iori Tokiwa, a new student, transfers in and takes second place after Kei in the rankings, knocking Hikari down to third. But instead of resenting him, Hikari recognizes Iori as a kindred spirit as they both aim for the number one spot. As the two grow close, Kei must deal with a completely new experience--jealousy.   01KGBPP1FF55Y0515BZWV2DQ15 14.0 2025-06-20T07:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1J2M4YTFN3M0 S.A, Vol. 14 S･A -Special A- © Maki Minami 2003/HAKUSENSHA, Inc.   2025-06-20T07:00:00.000Z   0 0
PRD_2RF95Z3N6TB0 CNT_2V8D6ZB2TEMG S.A CNT_2ZHHKFM7ZGE0 CNT_2ZHHKFM7ZGE0 2 1 1 Volume 10 []   S.A, Vol. 10   Being No. 2 Sucks!When Sakura learns of Hikari's feelings for Kei, she is determined to get the two together! But getting Hikari to confess is more difficult than anyone imagined. The effort will take Kei and Hikari from a haunted house to a deadly duel to a date with Kei's mom to...Australia?! This is one trip you won't want to miss!   01KGBPMYD0VNSV6RXT94BAR0EP 10.0 2025-06-20T07:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1J2M4YTFN3M0 S.A, Vol. 10 S･A -Special A- © Maki Minami 2003/HAKUSENSHA, Inc.   2025-06-20T07:00:00.000Z   0 0

Advanced export

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

CSV options: 

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);