SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.product, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    1515, 1514, 1512, 423, 2708, 4555, 421, 
    1967, 422, 4558, 2723, 7735, 7734, 6193, 
    7737, 6195, 6194, 7736, 7750, 6196, 
    4415, 4417, 4414, 4412, 4416, 7588, 
    7589, 7590, 7591, 7592, 7240, 7237, 
    7236, 7238, 7239, 5875, 5877, 5874, 
    5879, 5880, 5873, 5876, 5878, 5881, 
    5872, 3999, 4004, 4005
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00094

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "33.61"
    },
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code"
      ],
      "key_length": "9",
      "rows_examined_per_scan": 48,
      "rows_produced_per_join": 48,
      "filtered": "100.00",
      "index_condition": "((`dbggbern`.`cscart_product_descriptions`.`product_id` in (1515,1514,1512,423,2708,4555,421,1967,422,4558,2723,7735,7734,6193,7737,6195,6194,7736,7750,6196,4415,4417,4414,4412,4416,7588,7589,7590,7591,7592,7240,7237,7236,7238,7239,5875,5877,5874,5879,5880,5873,5876,5878,5881,5872,3999,4004,4005)) and (`dbggbern`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "28.81",
        "eval_cost": "4.80",
        "prefix_cost": "33.61",
        "data_read_per_join": "183K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "product",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id product short_description full_description
421 Ultimate Guard Arkhive™ 800+ Standardgröße XenoSkin™ Petrolblau <p>- Ideal for storing a variety of Ultimate Guard products<br>- Comfortable transport of multiple decks of cards<br>- Easy access to the content<br>- Ideal for Cubing<br>- Resistant XenoSkin&trade; -material<br>- Microfiber covered inside<br>- Strong magnetic closure</p>
422 Ultimate Guard Arkhive™ 800+ Standardgröße XenoSkin™ Violet <p>- Ideal for storing a variety of Ultimate Guard products<br>- Comfortable transport of multiple decks of cards<br>- Easy access to the content<br>- Ideal for Cubing<br>- Resistant XenoSkin&trade; -material<br>- Microfiber covered inside<br>- Strong magnetic closure</p>
423 Ultimate Guard Arkhive™ 800+ Standardgröße XenoSkin™ Black <p>- Ideal for storing a variety of Ultimate Guard products<br>- Comfortable transport of multiple decks of cards<br>- Easy access to the content<br>- Ideal for Cubing<br>- Resistant XenoSkin&trade; -material<br>- Microfiber covered inside<br>- Strong magnetic closure</p>
1512 Ultimate Guard Arkhive 400+ XenoSkin Monocolor Schwarz <p>- Designed für bis zu 450 (double-sleeved) oder 500 (single-sleeved) Karten der Standardgröße in Ultimate Guard Sleeves*<br>- Modularer Aufbau zur Kombination mit einer Vielzahl von Ultimate Guard-Produkten<br>- Komfortabler Transport mehrerer Kartendecks<br>- Einfacher Zugriff<br>- Ideal für Cubing<br>- Widerstandsfähiges Xenoskin-Material<br>- Einfarbiges Design mit hochwertiger Mikrofaser-Innenseite<br>- Starker Magnetverschluss<br><br>Abmessungen ca.: 310 x 95 x 113 mm<br>Innenabmessungen ca.: 303 x 76.5 x 103 mm</p>
1514 Ultimate Guard Arkhive 400+ XenoSkin Monocolor Rot <p>- Designed für bis zu 450 (double-sleeved) oder 500 (single-sleeved) Karten der Standardgröße in Ultimate Guard Sleeves*<br>- Modularer Aufbau zur Kombination mit einer Vielzahl von Ultimate Guard-Produkten<br>- Komfortabler Transport mehrerer Kartendecks<br>- Einfacher Zugriff<br>- Ideal für Cubing<br>- Widerstandsfähiges Xenoskin-Material<br>- Einfarbiges Design mit hochwertiger Mikrofaser-Innenseite<br>- Starker Magnetverschluss<br><br>Abmessungen ca.: 310 x 95 x 113 mm<br>Innenabmessungen ca.: 303 x 76.5 x 103 mm</p>
1515 Ultimate Guard Arkhive 400+ XenoSkin Monocolor Petrolblau <p>- Designed für bis zu 450 (double-sleeved) oder 500 (single-sleeved) Karten der Standardgröße in Ultimate Guard Sleeves*<br>- Modularer Aufbau zur Kombination mit einer Vielzahl von Ultimate Guard-Produkten<br>- Komfortabler Transport mehrerer Kartendecks<br>- Einfacher Zugriff<br>- Ideal für Cubing<br>- Widerstandsfähiges Xenoskin-Material<br>- Einfarbiges Design mit hochwertiger Mikrofaser-Innenseite<br>- Starker Magnetverschluss<br><br>Abmessungen ca.: 310 x 95 x 113 mm<br>Innenabmessungen ca.: 303 x 76.5 x 103 mm</p>
1967 Ultimate Guard Arkhive™ 800+ Standardgröße XenoSkin™ Red <p>- Ideal for storing a variety of Ultimate Guard products<br>- Comfortable transport of multiple decks of cards<br>- Easy access to the content<br>- Ideal for Cubing<br>- Resistant XenoSkin&trade; -material<br>- Microfiber covered inside<br>- Strong magnetic closure</p>
2708 Ultimate Guard Arkhive™ 800+ Standardgröße XenoSkin™ Blue Monocolor <p>- Ideal for storing a variety of Ultimate Guard products<br>- Comfortable transport of multiple decks of cards<br>- Easy access to the content<br>- Ideal for Cubing<br>- Resistant XenoSkin&trade; -material<br>- Microfiber covered inside<br>- Strong magnetic closure</p>
2723 Ultimate Guard Arkhive™ Minthive Xenoskin Black 30+ <p>Graded cards are little treasures, precious memories, and investments of undeniable value. Our Minthive 30+ offers you the smartest way to sort and store your cards. With space for 30+ card cases from various grading services, this hive will keep your gems pristine. Store them or travel and trade without compromise!<br>• Designed to hold 30+ Graded Card Cases from various grading services such as Beckett, CGC, SGC, PSA or GMA<br>• Modular design for storing a variety of Ultimate Guard products<br>• Resistant Xenoskin material<br>• Monocolored design with quality microfiber inner lining<br>• Strong magnetic closure with additional ZnapClaw locking mechanism</p>
3999 Ultimate Guard Boulder Deck Case 100+ Solid Black <figure><a href="https://www.heo.com/de/en/producer/Ultimate%20Guard" ng-href="en/producer/Ultimate Guard"><img ng-src="https://www.heomedia.com/category_logos/color/uglogo.jpg" width="122" height="46" tooltip-placement="top" uib-tooltip="Show all products from Ultimate Guard" src="https://www.heomedia.com/category_logos/color/uglogo.jpg" style="margin: 0px auto; padding: 0px; border-width: initial; border-style: none; outline: 0px; color: rgb(0, 0, 0); text-align: justify; display: inline-block; line-height: normal; max-height: inherit; vertical-align: top; width: inherit; height: inherit;"></a></figure> <h1>Ultimate Guard Boulder Deck Case 100+ Solid Black</h1> <h2>Card Boxes Ultimate Guard</h2> <p>Ultimate Guard is very proud to present the Ultimate Guard Boulder 100+ Solid. You asked for it, we delivered: A solid Boulder for 100 double sleeved cards which perfectly matches our monochromatic color scheme, and fits ideally within the Ultimate Guard Arkhive lines of product.<br><br>- Designed for 100 double-sleeved cards or 120 single-sleeved cards in Ultimate Guard Sleeves*<br>- Color designed to complement Ultimate Guard Monocolor Line<br>- Durable and rigid box<br>- Modular design to combine with Ultimate Guard products<br>- Secure closure<br>- Made in Germany<br><br>Box size.: 76 × 75 × 98.5 mm</p>
4004 Ultimate Guard Boulder Deck Case 100+ Solid Blue <figure><a href="https://www.heo.com/de/en/producer/Ultimate%20Guard" ng-href="en/producer/Ultimate Guard"><img ng-src="https://www.heomedia.com/category_logos/color/uglogo.jpg" width="122" height="46" tooltip-placement="top" uib-tooltip="Show all products from Ultimate Guard" src="https://www.heomedia.com/category_logos/color/uglogo.jpg" style="margin: 0px auto; padding: 0px; border-width: initial; border-style: none; outline: 0px; color: rgb(0, 0, 0); text-align: justify; display: inline-block; line-height: normal; max-height: inherit; vertical-align: top; width: inherit; height: inherit;"></a></figure> <h1>Ultimate Guard Boulder Deck Case 100+ Solid Blue</h1> <h2>Card Boxes Ultimate Guard</h2> <p>Ultimate Guard is very proud to present the Ultimate Guard Boulder 100+ Solid. You asked for it, we delivered: A solid Boulder for 100 double sleeved cards which perfectly matches our monochromatic color scheme, and fits ideally within the Ultimate Guard Arkhive lines of product.<br><br>- Designed for 100 double-sleeved cards or 120 single-sleeved cards in Ultimate Guard Sleeves*<br>- Color designed to complement Ultimate Guard Monocolor Line<br>- Durable and rigid box<br>- Modular design to combine with Ultimate Guard products<br>- Secure closure<br>- Made in Germany<br><br>Box size.: 76 × 75 × 98.5 mm</p>
4005 Ultimate Guard Boulder Deck Case 100+ Solid Green <figure><a href="https://www.heo.com/de/en/producer/Ultimate%20Guard" ng-href="en/producer/Ultimate Guard"><img ng-src="https://www.heomedia.com/category_logos/color/uglogo.jpg" width="122" height="46" tooltip-placement="top" uib-tooltip="Show all products from Ultimate Guard" src="https://www.heomedia.com/category_logos/color/uglogo.jpg" style="margin: 0px auto; padding: 0px; border-width: initial; border-style: none; outline: 0px; color: rgb(0, 0, 0); text-align: justify; display: inline-block; line-height: normal; max-height: inherit; vertical-align: top; width: inherit; height: inherit;"></a></figure> <h1>Ultimate Guard Boulder Deck Case 100+ Solid Green</h1> <h2>Card Boxes Ultimate Guard</h2> <p>Ultimate Guard is very proud to present the Ultimate Guard Boulder 100+ Solid. You asked for it, we delivered: A solid Boulder for 100 double sleeved cards which perfectly matches our monochromatic color scheme, and fits ideally within the Ultimate Guard Arkhive lines of product.<br><br>- Designed for 100 double-sleeved cards or 120 single-sleeved cards in Ultimate Guard Sleeves*<br>- Color designed to complement Ultimate Guard Monocolor Line<br>- Durable and rigid box<br>- Modular design to combine with Ultimate Guard products<br>- Secure closure<br>- Made in Germany<br><br>Box size.: 76 × 75 × 98.5 mm<br></p>
4412 Ultimate Guard Boulder 100+ Druidic Secrets Nubis (Lavendel) <p>Lasse deine Deck-Boxen zu einem mystischen Ort werden! Mit dem Druidic Secrets Boulder 100+ bekommst du nicht nur eine verlässliche Deck-Box in gewohnt höchster Ultimate Guard-Qualität, sondern mit ihren magischen Ornamenten auch einen wahren Hingucker - egal, ob als einzelne Box oder perfekte Ergänzung zu unserem Druidic Secrets Bundle. Bei sechs exklusiven Farben und geheimnisvollen Mustern findest du garantiert die Deck-Box, die zu dir passt. Die Druidic Secrets Boulder 100+ haben unsere berühmte Soft-Touch-Oberfläche, ins Innere der Box passen 100 doppelt gesleevete Karten.<br><br>- Designed für bis zu 100 (double-sleeved) oder 120 (single-sleeved) Karten<br>- Modularer Aufbau zur Kombination mit einer Vielzahl von Ultimate Guard-Produkten<br>- Langlebige und stabile Box<br>- Die perfekte Ergänzung zum limitierten Ultimate Guard Druidic Secrets Bundle<br>- Soft-Touch-Oberfläche<br>- Sicherer Verschluss<br><br>Abmessungen: 76 × 75 × 98.5 mm</p>
4414 Ultimate Guard Boulder 100+ Druidic Secrets Impetus (Dunkelorange) <p>Lasse deine Deck-Boxen zu einem mystischen Ort werden! Mit dem Druidic Secrets Boulder 100+ bekommst du nicht nur eine verlässliche Deck-Box in gewohnt höchster Ultimate Guard-Qualität, sondern mit ihren magischen Ornamenten auch einen wahren Hingucker - egal, ob als einzelne Box oder perfekte Ergänzung zu unserem Druidic Secrets Bundle. Bei sechs exklusiven Farben und geheimnisvollen Mustern findest du garantiert die Deck-Box, die zu dir passt. Die Druidic Secrets Boulder 100+ haben unsere berühmte Soft-Touch-Oberfläche, ins Innere der Box passen 100 doppelt gesleevete Karten.<br><br>- Designed für bis zu 100 (double-sleeved) oder 120 (single-sleeved) Karten<br>- Modularer Aufbau zur Kombination mit einer Vielzahl von Ultimate Guard-Produkten<br>- Langlebige und stabile Box<br>- Die perfekte Ergänzung zum limitierten Ultimate Guard Druidic Secrets Bundle<br>- Soft-Touch-Oberfläche<br>- Sicherer Verschluss<br><br>Abmessungen: 76 × 75 × 98.5 mm</p>
4415 Ultimate Guard Boulder 100+ Druidic Secrets Arbor (Olivgrün) <p>Lasse deine Deck-Boxen zu einem mystischen Ort werden! Mit dem Druidic Secrets Boulder 100+ bekommst du nicht nur eine verlässliche Deck-Box in gewohnt höchster Ultimate Guard-Qualität, sondern mit ihren magischen Ornamenten auch einen wahren Hingucker - egal, ob als einzelne Box oder perfekte Ergänzung zu unserem Druidic Secrets Bundle. Bei sechs exklusiven Farben und geheimnisvollen Mustern findest du garantiert die Deck-Box, die zu dir passt. Die Druidic Secrets Boulder 100+ haben unsere berühmte Soft-Touch-Oberfläche, ins Innere der Box passen 100 doppelt gesleevete Karten.<br><br>- Designed für bis zu 100 (double-sleeved) oder 120 (single-sleeved) Karten<br>- Modularer Aufbau zur Kombination mit einer Vielzahl von Ultimate Guard-Produkten<br>- Langlebige und stabile Box<br>- Die perfekte Ergänzung zum limitierten Ultimate Guard Druidic Secrets Bundle<br>- Soft-Touch-Oberfläche<br>- Sicherer Verschluss<br><br>Abmessungen: 76 × 75 × 98.5 mm</p>
4416 Ultimate Guard Boulder 100+ Druidic Secrets Sol (Sand) <p>Lasse deine Deck-Boxen zu einem mystischen Ort werden! Mit dem Druidic Secrets Boulder 100+ bekommst du nicht nur eine verlässliche Deck-Box in gewohnt höchster Ultimate Guard-Qualität, sondern mit ihren magischen Ornamenten auch einen wahren Hingucker - egal, ob als einzelne Box oder perfekte Ergänzung zu unserem Druidic Secrets Bundle. Bei sechs exklusiven Farben und geheimnisvollen Mustern findest du garantiert die Deck-Box, die zu dir passt. Die Druidic Secrets Boulder 100+ haben unsere berühmte Soft-Touch-Oberfläche, ins Innere der Box passen 100 doppelt gesleevete Karten.<br><br>- Designed für bis zu 100 (double-sleeved) oder 120 (single-sleeved) Karten<br>- Modularer Aufbau zur Kombination mit einer Vielzahl von Ultimate Guard-Produkten<br>- Langlebige und stabile Box<br>- Die perfekte Ergänzung zum limitierten Ultimate Guard Druidic Secrets Bundle<br>- Soft-Touch-Oberfläche<br>- Sicherer Verschluss<br><br>Abmessungen: 76 × 75 × 98.5 mm</p>
4417 Ultimate Guard Boulder 100+ Druidic Secrets Fatum (Pink) <p>Lasse deine Deck-Boxen zu einem mystischen Ort werden! Mit dem Druidic Secrets Boulder 100+ bekommst du nicht nur eine verlässliche Deck-Box in gewohnt höchster Ultimate Guard-Qualität, sondern mit ihren magischen Ornamenten auch einen wahren Hingucker - egal, ob als einzelne Box oder perfekte Ergänzung zu unserem Druidic Secrets Bundle. Bei sechs exklusiven Farben und geheimnisvollen Mustern findest du garantiert die Deck-Box, die zu dir passt. Die Druidic Secrets Boulder 100+ haben unsere berühmte Soft-Touch-Oberfläche, ins Innere der Box passen 100 doppelt gesleevete Karten.<br><br>- Designed für bis zu 100 (double-sleeved) oder 120 (single-sleeved) Karten<br>- Modularer Aufbau zur Kombination mit einer Vielzahl von Ultimate Guard-Produkten<br>- Langlebige und stabile Box<br>- Die perfekte Ergänzung zum limitierten Ultimate Guard Druidic Secrets Bundle<br>- Soft-Touch-Oberfläche<br>- Sicherer Verschluss<br><br>Abmessungen: 76 × 75 × 98.5 mm</p>
4555 Ultimate Guard Arkhive™ 800+ Standardgröße XenoSkin™ Grün <p>- Ideal for storing a variety of Ultimate Guard products<br>- Comfortable transport of multiple decks of cards<br>- Easy access to the content<br>- Ideal for Cubing<br>- Resistant XenoSkin&trade; -material<br>- Microfiber covered inside<br>- Strong magnetic closure</p>
4558 Ultimate Guard Arkhive™ 800+ Standardgröße XenoSkin™ Weiss Monocolor <p>- Ideal for storing a variety of Ultimate Guard products<br>- Comfortable transport of multiple decks of cards<br>- Easy access to the content<br>- Ideal for Cubing<br>- Resistant XenoSkin&trade; -material<br>- Microfiber covered inside<br>- Strong magnetic closure</p>
5872 Ultimate Guard Boulder 100+ Magic: The Gathering "Guild Summit" - Simic <p>The guilds of Ravnica vie for your favor - which faction will you join as a guild mage?<br>&nbsp;<br>Ultimate Guard celebrates one of the most iconic and popular planes in Magic: The Gathering history with the “Guild Summit” series: ten classy Boulder 100+ with the golden crest of each guild on the semi-transparent deck box with a silky soft-touch finish. The Boulder 100+ holds up to 100 double-sleeved cards, making it the perfect home for your two-color Commander deck! Don't miss out on the stunning Arkhive 1000+ Xenoskin from the “Guild Summit” series either, which is the perfect storage place for up to ten Boulder 100+.</p>
5873 Ultimate Guard Boulder 100+ Magic: The Gathering "Guild Summit" - Izzet <p>The guilds of Ravnica vie for your favor - which faction will you join as a guild mage?<br>&nbsp;<br>Ultimate Guard celebrates one of the most iconic and popular planes in Magic: The Gathering history with the “Guild Summit” series: ten classy Boulder 100+ with the golden crest of each guild on the semi-transparent deck box with a silky soft-touch finish. The Boulder 100+ holds up to 100 double-sleeved cards, making it the perfect home for your two-color Commander deck! Don't miss out on the stunning Arkhive 1000+ Xenoskin from the “Guild Summit” series either, which is the perfect storage place for up to ten Boulder 100+.</p>
5874 Ultimate Guard Boulder 100+ Magic: The Gathering "Guild Summit" - Dimir <p>The guilds of Ravnica vie for your favor - which faction will you join as a guild mage?<br>&nbsp;<br>Ultimate Guard celebrates one of the most iconic and popular planes in Magic: The Gathering history with the “Guild Summit” series: ten classy Boulder 100+ with the golden crest of each guild on the semi-transparent deck box with a silky soft-touch finish. The Boulder 100+ holds up to 100 double-sleeved cards, making it the perfect home for your two-color Commander deck! Don't miss out on the stunning Arkhive 1000+ Xenoskin from the “Guild Summit” series either, which is the perfect storage place for up to ten Boulder 100+.</p>
5875 Ultimate Guard Boulder 100+ Magic: The Gathering "Guild Summit" - Azorius <p>The guilds of Ravnica vie for your favor - which faction will you join as a guild mage?<br>&nbsp;<br>Ultimate Guard celebrates one of the most iconic and popular planes in Magic: The Gathering history with the “Guild Summit” series: ten classy Boulder 100+ with the golden crest of each guild on the semi-transparent deck box with a silky soft-touch finish. The Boulder 100+ holds up to 100 double-sleeved cards, making it the perfect home for your two-color Commander deck! Don't miss out on the stunning Arkhive 1000+ Xenoskin from the “Guild Summit” series either, which is the perfect storage place for up to ten Boulder 100+.</p>
5876 Ultimate Guard Boulder 100+ Magic: The Gathering "Guild Summit" - Orzhov <p>The guilds of Ravnica vie for your favor - which faction will you join as a guild mage?<br>&nbsp;<br>Ultimate Guard celebrates one of the most iconic and popular planes in Magic: The Gathering history with the “Guild Summit” series: ten classy Boulder 100+ with the golden crest of each guild on the semi-transparent deck box with a silky soft-touch finish. The Boulder 100+ holds up to 100 double-sleeved cards, making it the perfect home for your two-color Commander deck! Don't miss out on the stunning Arkhive 1000+ Xenoskin from the “Guild Summit” series either, which is the perfect storage place for up to ten Boulder 100+.</p>
5877 Ultimate Guard Boulder 100+ Magic: The Gathering "Guild Summit" - Boros <p>The guilds of Ravnica vie for your favor - which faction will you join as a guild mage?<br>&nbsp;<br>Ultimate Guard celebrates one of the most iconic and popular planes in Magic: The Gathering history with the “Guild Summit” series: ten classy Boulder 100+ with the golden crest of each guild on the semi-transparent deck box with a silky soft-touch finish. The Boulder 100+ holds up to 100 double-sleeved cards, making it the perfect home for your two-color Commander deck! Don't miss out on the stunning Arkhive 1000+ Xenoskin from the “Guild Summit” series either, which is the perfect storage place for up to ten Boulder 100+.</p>
5878 Ultimate Guard Boulder 100+ Magic: The Gathering "Guild Summit" - Rakdos <p>The guilds of Ravnica vie for your favor - which faction will you join as a guild mage?<br>&nbsp;<br>Ultimate Guard celebrates one of the most iconic and popular planes in Magic: The Gathering history with the “Guild Summit” series: ten classy Boulder 100+ with the golden crest of each guild on the semi-transparent deck box with a silky soft-touch finish. The Boulder 100+ holds up to 100 double-sleeved cards, making it the perfect home for your two-color Commander deck! Don't miss out on the stunning Arkhive 1000+ Xenoskin from the “Guild Summit” series either, which is the perfect storage place for up to ten Boulder 100+.</p>
5879 Ultimate Guard Boulder 100+ Magic: The Gathering "Guild Summit" - Golgari <p>The guilds of Ravnica vie for your favor - which faction will you join as a guild mage?<br>&nbsp;<br>Ultimate Guard celebrates one of the most iconic and popular planes in Magic: The Gathering history with the “Guild Summit” series: ten classy Boulder 100+ with the golden crest of each guild on the semi-transparent deck box with a silky soft-touch finish. The Boulder 100+ holds up to 100 double-sleeved cards, making it the perfect home for your two-color Commander deck! Don't miss out on the stunning Arkhive 1000+ Xenoskin from the “Guild Summit” series either, which is the perfect storage place for up to ten Boulder 100+.</p>
5880 Ultimate Guard Boulder 100+ Magic: The Gathering "Guild Summit" - Gruul <p>The guilds of Ravnica vie for your favor - which faction will you join as a guild mage?<br>&nbsp;<br>Ultimate Guard celebrates one of the most iconic and popular planes in Magic: The Gathering history with the “Guild Summit” series: ten classy Boulder 100+ with the golden crest of each guild on the semi-transparent deck box with a silky soft-touch finish. The Boulder 100+ holds up to 100 double-sleeved cards, making it the perfect home for your two-color Commander deck! Don't miss out on the stunning Arkhive 1000+ Xenoskin from the “Guild Summit” series either, which is the perfect storage place for up to ten Boulder 100+.</p>
5881 Ultimate Guard Boulder 100+ Magic: The Gathering "Guild Summit" - Selesnya <p>The guilds of Ravnica vie for your favor - which faction will you join as a guild mage?<br>&nbsp;<br>Ultimate Guard celebrates one of the most iconic and popular planes in Magic: The Gathering history with the “Guild Summit” series: ten classy Boulder 100+ with the golden crest of each guild on the semi-transparent deck box with a silky soft-touch finish. The Boulder 100+ holds up to 100 double-sleeved cards, making it the perfect home for your two-color Commander deck! Don't miss out on the stunning Arkhive 1000+ Xenoskin from the “Guild Summit” series either, which is the perfect storage place for up to ten Boulder 100+.</p>
6193 Ultimate Guard Boulder 100+ Clear - Malachite <p>Die Legende ist zurück in neuem Design: Mit dem transparenten Boulder 100+ Clear habt ihr immer den Durchblick, welche Karten sich gerade in eurer Deck-Box befinden. Der Boulder 100+ Clear ist eine stabile und zuverlässige Deck-Box mit sicherem Verschluss. Geeignet für bis zu 100 (double-sleeved) oder 120 (single-sleeved) Karten aller gängigen Sammelkartenspiele wie Magic: The Gathering, Pokémon, Lorcana, One Piece oder Yu-Gi-Oh!</p> <ul><li>Komplett transparent</li><li>Sicherer Verschluss</li><li>Langlebige und stabile Box&nbsp;</li><li>Modularer Aufbau zur Kombination mit einer Vielzahl von Ultimate Guard-Produkten&nbsp;</li></ul>
6194 Ultimate Guard Boulder 100+ Clear - Rhodonite <p>Die Legende ist zurück in neuem Design: Mit dem transparenten Boulder 100+ Clear habt ihr immer den Durchblick, welche Karten sich gerade in eurer Deck-Box befinden. Der Boulder 100+ Clear ist eine stabile und zuverlässige Deck-Box mit sicherem Verschluss. Geeignet für bis zu 100 (double-sleeved) oder 120 (single-sleeved) Karten aller gängigen Sammelkartenspiele wie Magic: The Gathering, Pokémon, Lorcana, One Piece oder Yu-Gi-Oh!</p> <ul><li>Komplett transparent</li><li>Sicherer Verschluss</li><li>Langlebige und stabile Box&nbsp;</li><li>Modularer Aufbau zur Kombination mit einer Vielzahl von Ultimate Guard-Produkten&nbsp;</li></ul>
6195 Ultimate Guard Boulder 100+ Clear - Poppy Thopaz <p>Die Legende ist zurück in neuem Design: Mit dem transparenten Boulder 100+ Clear habt ihr immer den Durchblick, welche Karten sich gerade in eurer Deck-Box befinden. Der Boulder 100+ Clear ist eine stabile und zuverlässige Deck-Box mit sicherem Verschluss. Geeignet für bis zu 100 (double-sleeved) oder 120 (single-sleeved) Karten aller gängigen Sammelkartenspiele wie Magic: The Gathering, Pokémon, Lorcana, One Piece oder Yu-Gi-Oh!</p> <ul><li>Komplett transparent</li><li>Sicherer Verschluss</li><li>Langlebige und stabile Box&nbsp;</li><li>Modularer Aufbau zur Kombination mit einer Vielzahl von Ultimate Guard-Produkten&nbsp;</li></ul>
6196 Ultimate Guard Boulder 100+ Clear - Transparent <p>Die Legende ist zurück in neuem Design: Mit dem transparenten Boulder 100+ Clear habt ihr immer den Durchblick, welche Karten sich gerade in eurer Deck-Box befinden. Der Boulder 100+ Clear ist eine stabile und zuverlässige Deck-Box mit sicherem Verschluss. Geeignet für bis zu 100 (double-sleeved) oder 120 (single-sleeved) Karten aller gängigen Sammelkartenspiele wie Magic: The Gathering, Pokémon, Lorcana, One Piece oder Yu-Gi-Oh!</p> <ul><li>Komplett transparent</li><li>Sicherer Verschluss</li><li>Langlebige und stabile Box&nbsp;</li><li>Modularer Aufbau zur Kombination mit einer Vielzahl von Ultimate Guard-Produkten&nbsp;</li></ul>
7236 Ultimate Guard Boulder 100+ Magic: The Gathering "Edge of Eternities" - Kav <p>The Boulder 100+ is a sturdy and reliable deck box featuring officially licensed artwork from the Magic: The Gathering set ‘Edge of Eternities’. Despite its secure closure, the Boulder 100+ is easy and convenient to open and holds 100 double-sleeved cards in Ultimate Guard sleeves. Our Boulders are designed to be combined with all Ultimate Guard bulk storage boxes and fit particularly well in Arkhive, Superhive and Flip'n'Tray boxes.</p> <p> </p> <p>Designed for 100 double-sleeved cards in Ultimate Guard sleeves.</p> <p>Officially licensed Magic: The Gathering artwork.</p> <p>Modular design for combination with Ultimate Guard products.</p> <p>Durable and sturdy box.</p> <p>Secure closure.</p> <p></p>
7237 Ultimate Guard Boulder 100+ Magic: The Gathering "Edge of Eternities" - Illvoi <p>The Boulder 100+ is a sturdy and reliable deck box featuring officially licensed artwork from the Magic: The Gathering set ‘Edge of Eternities’. Despite its secure closure, the Boulder 100+ is easy and convenient to open and holds 100 double-sleeved cards in Ultimate Guard sleeves. Our Boulders are designed to be combined with all Ultimate Guard bulk storage boxes and fit particularly well in Arkhive, Superhive and Flip'n'Tray boxes.</p> <p> </p> <p>Designed for 100 double-sleeved cards in Ultimate Guard sleeves.</p> <p>Officially licensed Magic: The Gathering artwork.</p> <p>Modular design for combination with Ultimate Guard products.</p> <p>Durable and sturdy box.</p> <p>Secure closure.</p> <p></p>
7238 Ultimate Guard Boulder 100+ Magic: The Gathering "Edge of Eternities" - Monoists <p>The Boulder 100+ is a sturdy and reliable deck box featuring officially licensed artwork from the Magic: The Gathering set ‘Edge of Eternities’. Despite its secure closure, the Boulder 100+ is easy and convenient to open and holds 100 double-sleeved cards in Ultimate Guard sleeves. Our Boulders are designed to be combined with all Ultimate Guard bulk storage boxes and fit particularly well in Arkhive, Superhive and Flip'n'Tray boxes.</p> <p> </p> <p>Designed for 100 double-sleeved cards in Ultimate Guard sleeves.</p> <p>Officially licensed Magic: The Gathering artwork.</p> <p>Modular design for combination with Ultimate Guard products.</p> <p>Durable and sturdy box.</p> <p>Secure closure.</p> <p></p>
7239 Ultimate Guard Boulder 100+ Magic: The Gathering "Edge of Eternities" - Sunstar <p>The Boulder 100+ is a sturdy and reliable deck box featuring officially licensed artwork from the Magic: The Gathering set ‘Edge of Eternities’. Despite its secure closure, the Boulder 100+ is easy and convenient to open and holds 100 double-sleeved cards in Ultimate Guard sleeves. Our Boulders are designed to be combined with all Ultimate Guard bulk storage boxes and fit particularly well in Arkhive, Superhive and Flip'n'Tray boxes.</p> <p> </p> <p>Designed for 100 double-sleeved cards in Ultimate Guard sleeves.</p> <p>Officially licensed Magic: The Gathering artwork.</p> <p>Modular design for combination with Ultimate Guard products.</p> <p>Durable and sturdy box.</p> <p>Secure closure.</p> <p></p>
7240 Ultimate Guard Boulder 100+ Magic: The Gathering "Edge of Eternities" - Eumidians <p>The Boulder 100+ is a sturdy and reliable deck box featuring officially licensed artwork from the Magic: The Gathering set ‘Edge of Eternities’. Despite its secure closure, the Boulder 100+ is easy and convenient to open and holds 100 double-sleeved cards in Ultimate Guard sleeves. Our Boulders are designed to be combined with all Ultimate Guard bulk storage boxes and fit particularly well in Arkhive, Superhive and Flip'n'Tray boxes.</p> <p> </p> <p>Designed for 100 double-sleeved cards in Ultimate Guard sleeves.</p> <p>Officially licensed Magic: The Gathering artwork.</p> <p>Modular design for combination with Ultimate Guard products.</p> <p>Durable and sturdy box.</p> <p>Secure closure.</p> <p></p>
7588 Ultimate Guard Boulder 100+ Hybrid Magic: The Gathering "Mana Edition" - Forest <p>Ultimate Guard's Boulder 100+ Hybrid combines the completely transparent top of the Boulder Clear with a soft-touch base in the style of the original Boulder. The officially licensed MTG deck box is easy to open, but offers reliable protection for your cards thanks to its sturdy case and secure closure. The Boulder 100+ Hybrid holds up to 100 double-sleeved cards and is suitable for all Magic: The Gathering formats such as Commander (EDH), Standard or Modern.</p> <ul><li>Designed for 100 double-sleeved cards in Ultimate Guard sleeves</li><li>Officially licensed Magic: The Gathering artwork</li><li>Durable and rigid box</li><li>Secure closure</li><li>Transparent top, soft-touch base</li></ul>
7589 Ultimate Guard Boulder 100+ Hybrid Magic: The Gathering "Mana Edition" - Island <p>Ultimate Guard's Boulder 100+ Hybrid combines the completely transparent top of the Boulder Clear with a soft-touch base in the style of the original Boulder. The officially licensed MTG deck box is easy to open, but offers reliable protection for your cards thanks to its sturdy case and secure closure. The Boulder 100+ Hybrid holds up to 100 double-sleeved cards and is suitable for all Magic: The Gathering formats such as Commander (EDH), Standard or Modern.</p> <ul><li>Designed for 100 double-sleeved cards in Ultimate Guard sleeves</li><li>Officially licensed Magic: The Gathering artwork</li><li>Durable and rigid box</li><li>Secure closure</li><li>Transparent top, soft-touch base</li></ul>
7590 Ultimate Guard Boulder 100+ Hybrid Magic: The Gathering "Mana Edition" - Mountain <p>Ultimate Guard's Boulder 100+ Hybrid combines the completely transparent top of the Boulder Clear with a soft-touch base in the style of the original Boulder. The officially licensed MTG deck box is easy to open, but offers reliable protection for your cards thanks to its sturdy case and secure closure. The Boulder 100+ Hybrid holds up to 100 double-sleeved cards and is suitable for all Magic: The Gathering formats such as Commander (EDH), Standard or Modern.</p> <ul><li>Designed for 100 double-sleeved cards in Ultimate Guard sleeves</li><li>Officially licensed Magic: The Gathering artwork</li><li>Durable and rigid box</li><li>Secure closure</li><li>Transparent top, soft-touch base</li></ul>
7591 Ultimate Guard Boulder 100+ Hybrid Magic: The Gathering "Mana Edition" - Plains <p>Ultimate Guard's Boulder 100+ Hybrid combines the completely transparent top of the Boulder Clear with a soft-touch base in the style of the original Boulder. The officially licensed MTG deck box is easy to open, but offers reliable protection for your cards thanks to its sturdy case and secure closure. The Boulder 100+ Hybrid holds up to 100 double-sleeved cards and is suitable for all Magic: The Gathering formats such as Commander (EDH), Standard or Modern.</p> <ul><li>Designed for 100 double-sleeved cards in Ultimate Guard sleeves</li><li>Officially licensed Magic: The Gathering artwork</li><li>Durable and rigid box</li><li>Secure closure</li><li>Transparent top, soft-touch base</li></ul>
7592 Ultimate Guard Boulder 100+ Hybrid Magic: The Gathering "Mana Edition" - Swamp <p>Ultimate Guard's Boulder 100+ Hybrid combines the completely transparent top of the Boulder Clear with a soft-touch base in the style of the original Boulder. The officially licensed MTG deck box is easy to open, but offers reliable protection for your cards thanks to its sturdy case and secure closure. The Boulder 100+ Hybrid holds up to 100 double-sleeved cards and is suitable for all Magic: The Gathering formats such as Commander (EDH), Standard or Modern.</p> <ul><li>Designed for 100 double-sleeved cards in Ultimate Guard sleeves</li><li>Officially licensed Magic: The Gathering artwork</li><li>Durable and rigid box</li><li>Secure closure</li><li>Transparent top, soft-touch base</li></ul>
7734 Ultimate Guard Boulder 100+ Clear - Emerald <p>Die Legende ist zurück in neuem Design: Mit dem transparenten Boulder 100+ Clear habt ihr immer den Durchblick, welche Karten sich gerade in eurer Deck-Box befinden. Der Boulder 100+ Clear ist eine stabile und zuverlässige Deck-Box mit sicherem Verschluss. Geeignet für bis zu 100 (double-sleeved) oder 120 (single-sleeved) Karten aller gängigen Sammelkartenspiele wie Magic: The Gathering, Pokémon, Lorcana, One Piece oder Yu-Gi-Oh!</p> <ul><li>Komplett transparent</li><li>Sicherer Verschluss</li><li>Langlebige und stabile Box&nbsp;</li><li>Modularer Aufbau zur Kombination mit einer Vielzahl von Ultimate Guard-Produkten&nbsp;</li></ul>
7735 Ultimate Guard Boulder 100+ Clear - Amber <p>Die Legende ist zurück in neuem Design: Mit dem transparenten Boulder 100+ Clear habt ihr immer den Durchblick, welche Karten sich gerade in eurer Deck-Box befinden. Der Boulder 100+ Clear ist eine stabile und zuverlässige Deck-Box mit sicherem Verschluss. Geeignet für bis zu 100 (double-sleeved) oder 120 (single-sleeved) Karten aller gängigen Sammelkartenspiele wie Magic: The Gathering, Pokémon, Lorcana, One Piece oder Yu-Gi-Oh!</p> <ul><li>Komplett transparent</li><li>Sicherer Verschluss</li><li>Langlebige und stabile Box&nbsp;</li><li>Modularer Aufbau zur Kombination mit einer Vielzahl von Ultimate Guard-Produkten&nbsp;</li></ul>
7736 Ultimate Guard Boulder 100+ Clear - Ruby <p>Die Legende ist zurück in neuem Design: Mit dem transparenten Boulder 100+ Clear habt ihr immer den Durchblick, welche Karten sich gerade in eurer Deck-Box befinden. Der Boulder 100+ Clear ist eine stabile und zuverlässige Deck-Box mit sicherem Verschluss. Geeignet für bis zu 100 (double-sleeved) oder 120 (single-sleeved) Karten aller gängigen Sammelkartenspiele wie Magic: The Gathering, Pokémon, Lorcana, One Piece oder Yu-Gi-Oh!</p> <ul><li>Komplett transparent</li><li>Sicherer Verschluss</li><li>Langlebige und stabile Box&nbsp;</li><li>Modularer Aufbau zur Kombination mit einer Vielzahl von Ultimate Guard-Produkten&nbsp;</li></ul>
7737 Ultimate Guard Boulder 100+ Clear - Onyx <p>Die Legende ist zurück in neuem Design: Mit dem transparenten Boulder 100+ Clear habt ihr immer den Durchblick, welche Karten sich gerade in eurer Deck-Box befinden. Der Boulder 100+ Clear ist eine stabile und zuverlässige Deck-Box mit sicherem Verschluss. Geeignet für bis zu 100 (double-sleeved) oder 120 (single-sleeved) Karten aller gängigen Sammelkartenspiele wie Magic: The Gathering, Pokémon, Lorcana, One Piece oder Yu-Gi-Oh!</p> <ul><li>Komplett transparent</li><li>Sicherer Verschluss</li><li>Langlebige und stabile Box&nbsp;</li><li>Modularer Aufbau zur Kombination mit einer Vielzahl von Ultimate Guard-Produkten&nbsp;</li></ul>
7750 Ultimate Guard Boulder 100+ Clear - Sapphire <p>Die Legende ist zurück in neuem Design: Mit dem transparenten Boulder 100+ Clear habt ihr immer den Durchblick, welche Karten sich gerade in eurer Deck-Box befinden. Der Boulder 100+ Clear ist eine stabile und zuverlässige Deck-Box mit sicherem Verschluss. Geeignet für bis zu 100 (double-sleeved) oder 120 (single-sleeved) Karten aller gängigen Sammelkartenspiele wie Magic: The Gathering, Pokémon, Lorcana, One Piece oder Yu-Gi-Oh!</p> <ul><li>Komplett transparent</li><li>Sicherer Verschluss</li><li>Langlebige und stabile Box&nbsp;</li><li>Modularer Aufbau zur Kombination mit einer Vielzahl von Ultimate Guard-Produkten&nbsp;</li></ul>