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 (
    9878, 10434, 10426, 10034, 10413, 9881, 
    10033, 10438, 10441, 10041, 10440, 
    10037
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00076

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 12 Using index condition

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
9878 <p style="text-align: justify;">Decorative stone <strong>GRENADA 3 (MOCCA),</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> <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> GRENADA MOCCA ✔ 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>
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>
10033 <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> Corner GRENADA RUSSET ✔ suitable for inside and outside ✔ made of concrete ✔ reminds of the atmosphere of Spanish cities ✔ height - 11.7cm | Here ! ☎ 030 30 807 169
10034 <table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Karton</strong></td> <td style="text-align: center;" width="95">Stück</td> <td style="text-align: center;" width="95">Meter</td> <td style="text-align: center;" width="95">Gewicht</td> </tr> <tr> <td><strong>Verblender</strong></td> <td>12</td> <td>0,46 m<sup>2</sup></td> <td>13,7 kg</td> </tr> <tr> <td><strong>Ecke</strong></td> <td>12</td> <td>1,2 lm</td> <td>13,5 kg</td> </tr> </tbody> </table> <p>&nbsp;</p> NEPAL FROST corner ✔ suitable for inside and outside ✔ made of concrete ✔ modern design ✔ height - 10cm | Online! ☎ 030 30 807 169
10037 <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>8</td> <td>0,62m<sup>2</sup></td> <td>15,1&nbsp; kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>8</td> <td>1,13 lm</td> <td>15,1 kg</td> </tr> </tbody> </table> Corner PALERMO GRAPHITE ✔ suitable for inside and outside ✔ made of concrete ✔ similar to Sicilian architecture ✔ weatherproof | Inexpensive! ☎ 030 30 807 169
10041 <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> Corner GRENADA GRAPHITE ✔ for inside and outside ✔ made of concrete ✔ reminds of the atmosphere of Spanish cities ✔ gray ✔ height - 11.7cm | Online! ☎ 030 30 807 169
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>
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>
10434 <p style="text-align: justify;"><strong class="last-child" style="font-weight: bold;">ROMA 1 (DESERT)</strong><strong class="last-child" style="font-weight: normal;"> </strong>- decorative stone made from concrete imitates polished sandstone.&nbsp;It&nbsp;<strong class="last-child" style="font-weight: normal;">reminiscent of the hot sun Italian vineyards and calm atmosphere of local towns. It is perfect as a cladding of any stable surface.</strong></p> <p style="text-align: justify;">✓ Interior and exterior decorative stone</p> <table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105">Package</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>Tiles</td> <td>15</td> <td>0.75 m<sup>2</sup></td> <td>16.3 kg</td> </tr> <tr> <td>Corner</td> <td>7</td> <td>1.19 lm</td> <td>9.5 kg</td> </tr> </tbody> </table> ROMA DESERT - elegant and modern design of concrete tiles. It will make your home special. Check it out at baubaY.de »Order hotline ✆ 030 30 807 169 <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>15 tiles per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0,75 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>