SELECT 
  cscart_ult_product_descriptions.product_id, 
  cscart_ult_product_descriptions.short_description, 
  IF(
    cscart_ult_product_descriptions.short_description = "", 
    cscart_ult_product_descriptions.full_description, 
    ""
  ) AS full_description, 
  cscart_ult_product_descriptions.meta_keywords, 
  cscart_ult_product_descriptions.meta_description, 
  cscart_ult_product_descriptions.search_words, 
  cscart_ult_product_descriptions.promo_text 
FROM 
  cscart_ult_product_descriptions 
WHERE 
  cscart_ult_product_descriptions.product_id IN (
    10426, 10413, 9881, 10438, 10441, 10440, 
    10444, 10427, 10419, 10459, 10414
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00044

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_ult_product_descriptions range PRIMARY,product_id,company_id PRIMARY 13 11 Using index condition

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
9881 <p style="text-align: justify;">Decorative stone <strong>GRENADA 6 (ROSA)</strong>, reflects unique features of a natural stone. Inspired by picturesque Andalusian landscapes, it brings to mind charming and mysterious atmosphere of Spanish towns. Thanks to exceptional structure and the subtle colours, Grenada is a perfect match for both inetrior and exterior walls.</p> <p style="text-align: justify;">✓ Interior and exterior decorative concrete tile</p> <table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></td> <td style="text-align: center;" width="95">Piece</td> <td style="text-align: center;" width="95">Meter</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tile</strong></td> <td>5</td> <td>0,32 m<sup>2</sup></td> <td>11,60 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>5</td> <td>0,58 lm</td> <td>11,55 kg</td> </tr> </tbody> </table> GRENADA ROSA ✔ Facades ✔ Interiors ✔ Fences ✔ Weatherproof ✔ Elegant look ✔ Easy installation ✔ Protects the wall from dirt and deposits | Order now at baubaY.de! <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>5 tiles per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.32 m<sup>2</sup> per box</strong></p>
10413 <p style="text-align: justify;"><strong>LOFT 2 (RED)</strong> is a brick-like tile with slightly rounded soft edges. It matches modern architecture and minimalist interiors. The Loft will do great both on the entire wall surface as well as on its fragments, especially in small rooms. The Loft tile will not only decorate the room but will designate zones, which in turn is important in spacious interiors that combine several functions.</p> <p style="text-align: justify;">✓ Interior brick tile</p> <table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></td> <td style="text-align: center;" width="95">Piece</td> <td style="text-align: center;" width="95">Meters</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tiles</strong></td> <td>38</td> <td>0,6 m<sup>2</sup></td> <td>7,5 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>16</td> <td>1,17 lm</td> <td>4,7 kg</td> </tr> </tbody> </table> Light brick slips for interiors. The easy-to-install brick slips from the LOFT series conjure up a bright atmosphere and protect the wall. <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>38 pieces per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.6 m<sup>2</sup> per box</strong></p>
10414 <p style="text-align: justify;">Loft is a brick-like tile with slightly rounded soft edges. Available in white and red, it matches modern architecture and minimalist interiors. The Loft will do great both on the entire wall surface as well as on its fragments, especially in small rooms. The Loft tile will not only decorate the room but will designate zones, which in turn is important in spacious interiors that combine several functions.</p> <table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></td> <td style="text-align: center;" width="95">Piece</td> <td style="text-align: center;" width="95">Meters</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tiles</strong></td> <td>38</td> <td>0,6 m<sup>2</sup></td> <td>7,5 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>16</td> <td>1,17 lm</td> <td>4,7 kg</td> </tr> </tbody> </table> Corner LOFT RED ✔ suitable for interiors ✔ based on synthetic plaster ✔ easy assembly ✔ height - 6.3cm | Have a look now! ☎ 030 30 807 169
10419 <p style="text-align: justify;">The unusual structure and unique coloration give a realistic look of quarried stone to the <strong>CALIFORNIA 3 (MOCCA)</strong> tiles and corners. The use of California tiles for elevation creates an amazing play of lights and shadows thanks to a variety of textures and colors.</p> <p style="text-align: justify;">✓ Decorative stone for indoor and outdoor use<br /> ✓ Concrete cladding board</p> <table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></td> <td style="text-align: center;" width="95">Piece</td> <td style="text-align: center;" width="95">Meter</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tile</strong></td> <td>6</td> <td>0,5m<sup>2</sup></td> <td>16,9 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>6</td> <td>0,9 ml</td> <td>16,9 kg</td> </tr> </tbody> </table> <h2 style="text-align: justify;">&nbsp;</h2> <h2 style="text-align: justify;">Installation Video</h2> <p><iframe allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="515" src="https://www.youtube.com/embed/pg6_4OI9o3M" width="916"></iframe></p> CALIFORNIA MOCCA- elegant and modern design of concrete tiles. Check it out at baubaY.de »Order hotline ✆ 030 30 807 169 <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>6 pieces per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.5 m<sup>2</sup> per box</strong></p>
10426 <p style="text-align: justify;"><strong>KENYA 1 (GREY)</strong> decorative stone is the result of a fascination with nature, its shapes, patterns and colors. Kenya is distinguished by a distinctive, irregular texture and its name is not accidental. Kenya 1 with a white-gray, slightly soiled color brings to mind the snowy Batian peak from the volcanic massif of Kenya. In contrast, Kenya 2 resembles volcanic lava. It is brownish red with dimmed, smoky elements. The volcanic origin is highlighted by noticeable pits. Kenya stones can be installed indoors and on facades.</p> <p style="text-align: justify;">✓ Interior and exterior decorative stone</p> <p style="text-align: justify;">Tile dimensions: 473 x 120 x 16-33 mm</p> <table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></td> <td style="text-align: center;" width="95">Piece</td> <td style="text-align: center;" width="95">Meter</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tile</strong></td> <td>7</td> <td>0,4 m<sup>2</sup></td> <td>15,2 kg</td> </tr> </tbody> </table> <h2 style="text-align: justify;">Installation Video</h2> <p><iframe allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="515" src="https://www.youtube.com/embed/pg6_4OI9o3M" width="916"></iframe></p> KENYA GREY ✔ elegant and modern design of concrete tiles ✔ for inside and outside ✔ check it out at baubaY.de »order hotline ✆ 030 30 807 169 <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>7 pieces per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.4 m<sup>2</sup> per box</strong></p>
10427 <p style="text-align: justify;"><strong>KENYA 2 (MOCCA)</strong> decorative stone is the result of a fascination with nature, its shapes, patterns and colors. Kenya is distinguished by a distinctive, irregular texture and its name is not accidental. Kenya 1 with a white-gray, slightly soiled color brings to mind the snowy Batian peak from the volcanic massif of Kenya. In contrast, Kenya 2 resembles volcanic lava. It is brownish red with dimmed, smoky elements. The volcanic origin is highlighted by noticeable pits. Kenya stones can be installed indoors and on facades.</p> <p style="text-align: justify;">✓ Interior and exterior decorative stone</p> <p style="text-align: justify;">Tile dimensions: 473 x 120 x 16-33 mm</p> <table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></td> <td style="text-align: center;" width="95">Piece</td> <td style="text-align: center;" width="95">Meter</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tile</strong></td> <td>7</td> <td>0,4 m<sup>2</sup></td> <td>15,2 kg</td> </tr> </tbody> </table> <h2 style="text-align: justify;">Installation Video</h2> <p><iframe allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="515" src="https://www.youtube.com/embed/pg6_4OI9o3M" width="916"></iframe></p> KENYA MOCCA ✔ elegant and modern design of concrete tiles ✔ for inside and outside ✔ check it out at baubaY.de »order hotline ✆ 030 30 807 169 <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>7 pieces per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.4 m<sup>2</sup> per box</strong></p>
10438 <p style="text-align: justify;">ARGENTO – a natural stone that brings a unique effect to the interior. Its surface is uneven, full of carves and delicate pores. However, this stone is distinguished mainly by an unusual color – silvery gray, thanks to which Argento beautifully reflects the light and plays with it. Depending on the character of the interior and the accessories, Argento will bring a neoglamour vibe (as opposed to classic, golden shades) or a modern style in which the silvery, almost metallic gloss of this stone resounds with full force.</p> <p style="text-align: justify;">Argento is a stone obtained from stone blocks, cut into narrow tiles joined in an easy-to-install panel.</p> <p style="text-align: justify;">✓ Interior and exterior natural stone</p> <p style="text-align: justify;">Natural Product - discoloration may be subject to natural, arising from the time discoloration is a natural process.</p> <table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></td> <td style="text-align: center;" width="95">Dimensions (mm)</td> <td style="text-align: center;" width="95">Piece</td> <td style="text-align: center;" width="95">Meter</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tile</strong></td> <td>360-400x100x12-17</td> <td>12</td> <td>0,43 m<sup>2</sup></td> <td>11.3 kg</td> </tr> </tbody> </table> ARGENTO natural stone for interior and exterior facades » It will make your home something special » Buy online at baubaY.de! | Order ☎ 030 30 807 169 <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>12 pieces per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.43 m<sup>2</sup> per box</strong></p>
10440 <p style="text-align: justify;">The advantage of natural stone is undoubtedly a beautiful design and unique charm of the natural form. The variety of colors and stone structures allows to emphasize the individuality of each interior, terrace or staircase. Perfect for laying horizontally and vertically.</p> <p style="text-align: justify;">Preto natural stone is an excellent product for those looking for classic wall coverings with universal colors. Gray walls never go out of fashion. They can only acquire nobility. Preto impresses with its depth of color, stone drawing with delicate faults, characteristic for natural stones and a subtle, barely noticeable gloss. An insightful eye will see that Preto combines many shades of gray penetrating each other on the surface of one tile. Up close, you can also see a few delicate russets.</p> <p style="text-align: justify;">Preto is build in a structure of panel, consisting of several tiles, which significantly speeds up and facilitates installation.</p> <p style="text-align: justify;">✓ Natural stone inside and outside</p> <p style="text-align: justify;">Natural Product - discoloration may be subject to natural, arising from the time discoloration is a natural process.</p> <table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></td> <td style="text-align: center;" width="95">Dimensions (mm)</td> <td style="text-align: center;" width="95">Piece</td> <td style="text-align: center;" width="95">Meter</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tile</strong></td> <td>360-400x100x12-17</td> <td>12</td> <td>0,43 m<sup>2</sup></td> <td>12 kg</td> </tr> </tbody> </table> PRETO natural stone for interior and exterior facades »It will make your home something special» Buy online baubaY.de! | Order ☎ 030 30 807 169 <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>12 pieces per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.43 m<sup>2</sup> per box</strong></p>
10441 <p style="text-align: justify;"><strong>BOSTON 5 (GRAPHITE)</strong> brick slip is an innovative product, which is is characterized by integrated joint. Thanks to its unique design, BOSTON interior decorative stone is incredibly easy to install. Due to its thanks to its classic form, BOSTON brick slip perfectly suits both traditional and modern designs. BOSTON decorative stone is an excellent innovation designed for non-experts. It’s a fast and easy solution that stays in line with main decorative trends.</p> <p style="text-align: justify;">✓ Brick tile inside and outside</p> <table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></td> <td style="text-align: center;" width="95">Piece</td> <td style="text-align: center;" width="95">Meter</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tile</strong></td> <td>32</td> <td>0,52m<sup>2</sup></td> <td>14,4 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>12</td> <td>0,87 lm</td> <td>8,7 kg</td> </tr> </tbody> </table> BOSTON GRAPHITE brick tiles with already integrated joints »Easy installation ✔ for inside and outside ✔ Long durability ✔ Weatherproof ✔ Order now <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>32 pieces per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.52 m<sup>2</sup> per box</strong></p>
10444 <p style="text-align: justify;"><strong class="last-child" style="font-weight: bold;">CAMBRIDGE 2 (CREAM)</strong>&nbsp;is a&nbsp; frostproof&nbsp; Frost-resistant brick-like tiles in the form of natural and platinum bricks with colourations.</p> <p style="text-align: justify;">✓ Interior and exterior decorative brick</p> <p style="text-align: justify;">✓ Concrete facing brick</p> <p style="text-align: justify;">&nbsp;</p> <table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></td> <td style="text-align: center;" width="95">Piece</td> <td style="text-align: center;" width="95">Meter</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tiles</strong></td> <td>57</td> <td>0.91 m<sup>2</sup></td> <td>20 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>24</td> <td>1.75 lm</td> <td>13 kg</td> </tr> </tbody> </table> CAMBRIDGE CREAM Frost-resistant brick-like tiles » Easy installation ✔ for inside and outside ✔ Long durability ✔ Weather-resistant ✔ Order now <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>57 pieces per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.91 m<sup>2</sup> per box</strong></p>
10459 <p style="text-align: justify;"><strong class="last-child" style="font-weight: normal;">COUNTRY 680</strong> is a frost- proof, brick slip which is a perfect imitation of old Belgian brick. Hand-cast, from natural components only, on the base of pressed cement. They perfectly&nbsp; serve us a finishing material to every type of a building.</p> <p style="text-align: justify;">✓ Brick tile inside and outside.</p> <table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Package</strong></td> <td style="text-align: center;" width="95">Piece</td> <td style="text-align: center;" width="95">Meter</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tile</strong></td> <td>63</td> <td>1m<sup>2</sup></td> <td>17,9 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>24</td> <td>1,8 lm</td> <td>10,4 kg</td> </tr> </tbody> </table> Structured brick slips from the COUNTRY series »Easy installation ✔ Long durability ✔ Weatherproof ✔ Order now | baubaY.de! <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>63 pieces per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>1 m<sup>2</sup> per box</strong></p>