SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '', 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    8368, 8730, 9817, 8732, 8731, 8291, 8734, 
    8728, 8729, 10430, 9484, 8284
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00050

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_descriptions range PRIMARY,product_id PRIMARY 9 12 Using index condition

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
8284 <p style="text-align: justify;"><strong>VENEZIA 3 (LATTE) </strong>is a decorative stone which suits for every interior. It gives the atmosphere of Venetian street and the warmth of an Italian sun. The visual effect is additionally enhanced by its unusual texture which imitates finely cracked stone.</p> <p style="text-align: justify;">✓ Interior 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">Meters</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tiles</strong></td> <td>6</td> <td>0,5 m<sup>2</sup></td> <td>11 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>7</td> <td>1,06 lm</td> <td>8,5 kg</td> </tr> </tbody> </table> Decorative tile for interiors. Venezia Latte tiles create a Mediterranean flair in your living room. You can find many more straps on baubaY.de <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>6 tiles per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.5 m<sup>2</sup> per box</strong></p>
8291 <p style="text-align: justify;"><strong>SANTORINI 1 </strong>is an innovative solution on the stone cladding market. Tile with joint guarantees a simple and quick installation. Apart from practical issues, it is characterized by diverse structure and uniform color. Irregular stone texture refers to the Greek architecture, which perfectly complements the interior or façade maintained in both traditional and modern style.</p> <p style="text-align: justify;">✓ Interior and exterior decorative 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>32</td> <td>0.47 m<sup>2</sup></td> <td>15.0 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>14</td> <td>0.84 lm</td> <td>10.8 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> SANTORINI ✔ Facades ✔ Interiors ✔ Fences ✔ Weatherproof ✔ Easy installation ✔ Protects the wall from dirt and deposits »Order & advise | baubaY.de <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>32 tiles per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.47 m<sup>2</sup> per box</strong></p>
8368 <p style="text-align: justify;"><strong class="last-child">Application</strong><br /> RUSTICAL mortar for facing tiles is designed for pointing facing tiles imitating stone, sandstone as well as for a natural stone and some kinds of clinker. It is characterised by plasticity, increased adhesion to the surface and resistance to weather conditions (frost proof and water-resistant). It can be applied indoor and outdoor on buildings as well as on fence posts.</p> <p style="text-align: justify;"><strong class="last-child">Surface preparation</strong><br /> Before starting jointing make sure that both - surface and the adhesive used for tiles - are completely dry. Use spatula to remove the dirt and dust from the joint to ensure optimum adherence.</p> <p style="text-align: justify;"><strong class="last-child">Directions for us</strong><br /> Mix about 2 kg of dry grout (more may set before using it all up) in a clean bucket adding about 0,33 litres of clean water. Stir well until the grout becomes uniform and after 3 min. stir again. Using the attached bag with a 8 mm diameter hole apply the grout evenly and tightly into the joints (Fig. 1,5). After about 2 min. smooth it out with a small trowel (Fig. 2,7) or with the other end of the attached brush (Fig. 6). Use spatula to remove the excess of the grout (Fig. 3). The mixture must be used within 15 minutes after time of mixing. Note that depending on the type of tiles and weather conditions the drying time may be shorten (in case of gypsum boards and temperature over 20°C). After application but before setting of the grout, use the brush (Fig. 4,8) to give the joint the final look remembering not to stain the tiles. Note that overdone smoothing with the brush may cause unpleasant gloss of the joint and differences in the joint colour.</p> <p style="text-align: justify;"><strong class="last-child">Precautions</strong><br /> The work should be done in dry conditions in layer and air temperature from +5°C to +20°C. Freshly applied grout must be shield from the rain, sun, dew, temperature below +5°C, and strong wind for at least 24 hrs. after finishing the work (fence elements should be protected from rain, sun, temperature at least for 3 days). Conservation work on the surface can be done after at least 7&nbsp;days from finishing the work. „Rustic joint for facing tiles” includes cement and after mixing with water has alkaline reaction therefore avoid contact with eyes and skin. In case of contact with eyes rinse immediately with water and in case of subsequent redness seek medical advice. Keep out of reach of children. In case of dry substances, avoid inhaling the dust.</p> <p style="text-align: justify;"><strong class="last-child">Technical information</strong></p> <ul> <li>Mixing proportions: about 2,5 l of water to 15 kg of dry grout</li> <li>Consumption time: 15 - 20 min. (depending on the ambient temperature)</li> <li>Preliminary setting: 24 hours</li> <li>Total setting about: 28 days</li> <li class="last-child">Efficiency: depends on the kind of tiles and width and depth of the joint and has average of 2 - 5 kg to a square meter.</li> </ul>
8728 <p style="text-align: justify;"><strong class="last-child" style="font-weight: normal;">COUNTRY 610</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;">✓ Interior and exterior concrete 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">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> Brick tile COUNTRY 610 ✔ for inside and outside ✔ Protects the wall from dirt and deposits ✔ Easy installation ✔ Weatherproof ✔ Fences ✔ Natural look for modern interior design | Buy online at 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>
8729 <p style="text-align: justify;"><strong class="last-child" style="font-weight: normal;">COUNTRY 618</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> <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> Brick tile COUNTRY 618 ✔ for inside and outside ✔ Protects the wall from dirt and deposits ✔ Easy installation ✔ Weatherproof ✔ Fences ✔ Natural look for modern interior design | Buy online at 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>
8730 <p style="text-align: justify;"><strong class="last-child" style="font-weight: normal;">COUNTRY 640</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> <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> Brick tile COUNTRY 640 ✔ for inside and outside ✔ Protects the wall from dirt and deposits ✔ Easy installation ✔ Weatherproof ✔ Fences ✔ Natural look for modern interior design | Buy online at 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>
8731 <p style="text-align: justify;"><strong class="last-child" style="font-weight: normal;">COUNTRY 668</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> <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> Brick tile COUNTRY 668 ✔ for inside and outside ✔ Protects the wall from dirt and deposits ✔ Easy installation ✔ Weatherproof ✔ Fences ✔ Natural look for modern interior design | Buy online at 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>
8732 <p style="text-align: justify;"><strong class="last-child" style="font-weight: normal;">RUSTIC 526</strong> frost-resistant tiles and corners, which imitate old Dutch brick, are an excellent material, especially for a facade. Hand-modeled, they allow for an atmospheric finish of building facades, fences and interior elements. RUSTIK brick-like tiles will give a unique character to any surface.</p> <p style="text-align: justify;">✓ Exterior and Interior concrete 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">Meter</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tiles</strong></td> <td>63</td> <td>1m<sup>2</sup></td> <td>22 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>27</td> <td>2 lm</td> <td>13 kg</td> </tr> </tbody> </table> RUSTIK 526 ➟ seamless system ➟ quick and easy installation ➟ facades ➟ interior fittings ➟ Weatherproof ➟ main decorative trends ➟ Fences ✔✔✔ inexpensive at 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>
8734 <p style="text-align: justify;"><strong class="last-child" style="font-weight: normal;">RUSTIC 548</strong> frost-resistant tiles and corners, which imitate old Dutch brick, are an excellent material, especially for a facade. Hand-modeled, they allow for an atmospheric finish of building facades, fences and interior elements. RUSTIK brick-like tiles will give a unique character to any surface.</p> <p style="text-align: justify;">✓ Exterior and Interior concrete 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">Meter</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tiles</strong></td> <td>63</td> <td>1m<sup>2</sup></td> <td>22 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>27</td> <td>2 lm</td> <td>13 kg</td> </tr> </tbody> </table> RUSTIK 548 ➟ seamless system ➟ quick and easy installation ➟ facades ➟ interior fittings ➟ Weatherproof ➟ main decorative trends ➟ Fences ✔✔✔ inexpensive at 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>
9484 <p style="text-align: justify;"><strong>BOSTON 4 (MOONLIGHT)</strong> dekortegel is an innovative product, which is characterized by integrated joint. Thanks to its unique design, BOSTON dekorsten is incredibly easy to install. Due to its thanks to its classic form, BOSTON dekorativ sten perfectly suits both traditional and modern designs. It can be easily painted in any other color with standard paints.</p> <p style="text-align: justify;">BOSTON 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;">✓ Interior and exterior decorative 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">Meter</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tile</strong></td> <td>32</td> <td>0,52 m<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> Dark brick cladding brick BOSTON Moonlight »Integrated joints • Suitable for exterior facades • Easy installation • Large range of accessories» Buy 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>
9817 <p style="text-align: justify;"><strong>CAIRO 2 (MOONLIGHT)</strong> is a gypsum tile with unique stone structure and neutral colour. Characteristic regular drawing of Cairo imitates rock block, with clearly shaped edges. It is perfect decorations of modern interior. Tiles Cairo perfectly fits to wooden floors and sumptuous furnishings made of natural wood.</p> <p style="text-align: justify;">✓ Interior decorative gypsum 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>7</td> <td>0,36 m<sup>2</sup></td> <td>7,8 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>6</td> <td>0,6 lm</td> <td>5,25 kg</td> </tr> </tbody> </table> CAIRO MOONLIGHT ✔ Elegant look ✔ Interiors ✔ Easy assembly ✔ Protects the wall from dirt and deposits ✔ Bricks for living spaces create a unique atmosphere ✔ Order cheap brick slips now at baubaY.de <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>7 tiles per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.36 m<sup>2</sup> per box</strong></p>
10430 <p style="text-align: justify;"><strong>MEXICANA 3 (GRAPHITE)</strong> is a facade stone, designed for interior and exterior use. MEXICANA tiles are also very resistant to adverse weather conditions, especially frost and moisture. The installation of the tiles is simple and the obtained effect lasts for years. MEXICAN is available in the form of tiles and a corner (3 dimensions).</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"><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,5 m<sup>2</sup></td> <td>16,9 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>7</td> <td>1 lm</td> <td>15,7 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> MEXICANA GRAPHITE - elegant and modern design of concrete tiles. It will make your home special. Check it out on baubaY.de <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.5 m<sup>2</sup> per box</strong></p>