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 (
    8303, 8665, 9880, 8281, 8286, 9818, 8371, 
    8364, 9883, 8666, 8300, 8365
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00056

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
8281 <p style="text-align: justify;"><strong>RODOS 1 (SAND)</strong> is a decorative stone that symbolizes the warmth and the sun of an Greek island. Due to its raw texture it perfectly suits for wooden, glass or metal elements.</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>22</td> <td>1 m<sup>2</sup></td> <td>10,5 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>10</td> <td>2 lm</td> <td>10 kg</td> </tr> </tbody> </table> <h4>&nbsp;</h4> <h2 style="text-align: justify;">vidéo d'installation</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> Decorative bricks for interiors ✔ Sandstone texture ✔ Easy assembly ✔ Elegant look ✔ Large selection »Advice & ordering baubaY.de <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>22 tiles per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>1 m<sup>2</sup> per box</strong></p>
8286 <p style="text-align: justify;"><strong>CALABRIA 1 (MOCCA)</strong> is a frost resistant tile. It’s an unusual imitation of Italian limestone, which will create an outstanding character both outside and insite of a building.</p> <p>✓ 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">Meters</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tiles</strong></td> <td>20-22</td> <td>0,7m<sup>2</sup></td> <td>19 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>11</td> <td>1,7 lm</td> <td>16 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> CALABRIA MOCCA ✔ Facades ✔ Interiors ✔ Fences ✔ Weatherproof ✔ Elegant look ✔ Easy assembly ✔ Protects the wall from dirt and deposits ✔ Buy cheap online | baubaY.de ! <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>20-22 pieces per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.7 m<sup>2</sup> per box</strong></p>
8300 <p style="text-align: justify;"><strong>MONSANTO 1 RED</strong> is an innovative product in the decorative tile market. Jointless installation, i.e. a unique brick-like construction of the tile with a ready-to-use joint is a guarantee of quick and easy assembly. On the other hand, the fugue in a color which is different than the tile is a tribute to the authenticity and visual simplicity of bricks. The brick-like <strong>MONSANTO RED</strong> tiles work well on the façade as well as in the salon, the living room or the hallway. <strong>MONSANTO RED</strong> concrete lining is an interesting decorative element that will work in any architectural style.</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>24</td> <td>0,42 m<sup>2</sup></td> <td>15 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>10</td> <td>0,8 lm</td> <td>7 kg</td> </tr> </tbody> </table> ✓ seamless system ➟ quick and easy installation ❄ frost-resistant ➟ perfect for facades ✓ visual authenticity of the demolition bricks ➟ interior fittings ✔✔✔ inexpensive at baubaY.de ! <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>24 tiles per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.42 m<sup>2</sup> per box</strong></p>
8303 <p style="text-align: justify;">Setgu <strong>NEPAL 1 (FROST)</strong> is concrete decorative tile for exterior and interior use. NEPAL a frost- proof tile combines beauty and modern form. It is resistant to humidity, frost or damage. Nepal can be use as a decoration for fences or facades for example. It is done manually with no visible edges on the finished face.</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>12</td> <td>0,46 m<sup>2</sup></td> <td>13,7 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>12</td> <td>1,2 lm</td> <td>13,5 kg</td> </tr> </tbody> </table> <h4>&nbsp;</h4> <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> NEPAL FROST ✔ Facades ✔ Interiors ✔ Fences ✔ Weatherproof ✔ Elegant look ✔ Easy installation | Order now at baubaY.de <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>12 Plaquette par carton</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.46 m<sup>2</sup> par carton</strong></p>
8364 <p style="text-align: justify;"><strong>GRUNT</strong> is a product designed for surface priming, composed using top-quality acrylic resin. It forms a strong bond within the base, thus creating a hydrophobic (water-proof) coating. &nbsp;</p> <h2>Application</h2> <p style="text-align: justify;">For use both indoors and outdoors, for priming of concrete and cement bases, aerated concrete blocks, gypsum plasterboards and cardboards; applied prior to installing ceramic tiles, paints, wallpapers, glues, floor leveling and self-leveling floor. It greatly reduces the surface's absorption rates, diminishes dusting&nbsp; and&nbsp; prevents&nbsp; excessive&nbsp; attrition. &nbsp;</p> <p style="text-align: justify;">Before you begin, clear the surface of any dirt, oil etc. It has to be dry, too. Apply GRUNT with a painting brush/roller or have it sprayed on the surface. For heavily absorbent surfaces, you might want to lay two or three layers of GRUNT for best effect. For use on plasterboards and cardboards, GRUNT works best mixed with water on a 1:1 ratio. Having finished laying one layer of GRUNT, you must wait 4 hours before you might lay another one. The surface's temperature should not be lower than +5 not higher than +40 C. &nbsp;</p> <h2>Average consumption</h2> <p style="text-align: justify;">0,05 - 0,2 l / m²</p> <p style="background: #ddd; text-align: justify;"><strong>Avarage consumption: 0.05-0.2 l/m²</strong></p>
8365 <h2>Dispersion adhesive STEGU POWERELASTIK</h2> <p style="text-align: justify;"><strong>Stegu PowerElastik</strong> is suitable for bonding of decorative stone and concrete, gypsum, clinker and ceramic tiles on walls and floors. The substrate may be concrete, cement and anhydrite floors, aerated concrete, bricks, cement and cement/lime plaster, drywall, rigid chipboard and OSB.</p> <h4>✓ ready to use after opening the bucket<br /> ✓ multi-purpose<br /> ✓ flexible<br /> ✓ high bonding strength<br /> ✓ frost-proof and waterproof<br /> ✓ for indoor and outdoor use<br /> ✓ does not stain natural stone<br /> ✓ in the form of a thick paste<br /> ✓ applied in thin layers (approx. 2–3mm)<br /> ✓ suitable for applications where the adhesive layer is thicker than 4 mm</h4> <h3>Stegu PowerElastik specification</h3> <ul style="text-align: justify;"> <li>coverage to 2,5 m<sup>2</sup></li> <li>application temperature (air, substrate, material) from +5 °C to +25 °C</li> <li>open time up to 20 minutes</li> <li>tile alignment correction time up to 20 minutes</li> <li>full curing time 7 days</li> </ul> <p style="background: #00F700; text-align: justify;"><strong>Average consumption:<br /> 2,5 kg for 1m<sup>2</sup></strong></p>
8371 <p style="text-align: justify;">Impregnat for brick slips&nbsp;is a milk-white, water-soluble silicon emulsion with a little admixture of solvent designed for surface hydrophobisation of building materials such as: porous concrete tiles, concrete window sills and roofs, gypsum blocks, cellular concrete, roof tiles, cement-lime plasters and, in certain cases, acrylic plasters.</p> <h2>Use</h2> <p style="text-align: justify;">In order to achieve correct impregnation results it is necessary to adequately prepare the application surface. The surface should be evenly porous, dry, clean and free from grease. STEGU tiles should be impregnated together with joints at least 7 days after work completion. New cement-lime and acrylic plasters, as well as concrete must not be impregnated earlier than 24-30 days after the end of work. Surfaces repaired with the use of PCC-type mortar or filler should be impregnated after 6 days. Treated surfaces should be impregnated in dry weather and moderate wind conditions, at external temperatures in the range from +5 to +30°C. Prior to work, carefully secure all non-impregnated surfaces (e.g. window panels, metal and wooden parts, polished stones). In case of fouling, clean the surface immediately with mineral spirits.</p> <h2>Application</h2> <p style="text-align: justify;">Impregnation can be performed using a brush or by spraying. The application method depends on the absorbability and structure of the material. In order to achieve the best results, it is recommended to impregnate the surface twice, at short intervals and using the ‘wet to wet’ method (i.e. depending on the ambient temperature and porosity of the material the second layer should be applied within 30 minutes from the application of the first one i.e. when the surface is still wet). Surface should be impregnated completely and evenly.</p> <h2>Consumption</h2> <p style="text-align: justify;">Consumption of the impregnating agent depends on the absorbability of the treated material, as well as application method and amounts up to 10 m² per 1 litre of the emulsion (with a one impregnation). Store in original containers, in roofed and dry rooms, at temperatures in the range from +5 to +25°C.</p> <p style="background: #ddd;"><strong>up to 10 m² per 1 litre of the emulsion</strong></p>
8665 <p style="text-align: justify;">Decorative stone <strong>GRENADA 1 (RUSSET)</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> <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> Decorative tiles with a noble look ✔ Facades ✔ Interiors ✔ Fences ✔ Natural stone look ✔ Weatherproof ✔ Protects the wall from dirt and deposits ✔ Accessories »Advice & ordering ✆ 030 30 807 169 <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>5 pieces per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.32 m<sup>2</sup> per box</strong></p>
8666 <p style="text-align: justify;">GRENADA FROST est une plaquette de parement résistante aux conditions atmosphériques comme à l'humidité et au gel p.ex. Pour usage à l’intérieur ou à l’extérieur comme un décor des clôtures ou des façades p.ex. Elle montre les traits naturels d'une pierre. Inspirée par les paysages pittoresques de l'Andalousie, fait penser à l'ambiance charmante et mystérieuse des villes espagnoles. Elle est parfaitement combinés avec d'autres matériaux, p.ex avec le bois, ce qui affecte efficacement l'esthétique de la pièce ou la façade du bâtiment.</p> <p style="text-align: justify;">✓ Pierre décorative intérieur et extérieur<br /> ✓ Plaquette de parement en béton</p> <h2>Emballage</h2> <table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Carton</strong></td> <td style="text-align: center;" width="95">Pièce</td> <td style="text-align: center;" width="95">Mètre</td> <td style="text-align: center;" width="95">Poids</td> </tr> <tr> <td><strong>Plaquette</strong></td> <td>5</td> <td>0.32 m<sup>2</sup></td> <td>11.60 kg</td> </tr> <tr> <td><strong>Angle</strong></td> <td>5</td> <td>0.58 ml</td> <td>11.55 kg</td> </tr> </tbody> </table> <h4>Attention!</h4> <p style="text-align: justify;">Toutes les couleurs présentées ci-dessous peuvent se différer légèrement des couleurs réelles. Cela dépend de la résolution de votre écran et de celle de votre carte graphique. Les couleurs sont affectées par de nombreux facteurs par exemple l'éclairage, l'age, le type de finition, le type de substrat et les couleurs adjacentes. Nous n'acceptons aucune réclamation pour les écarts de couleurs entre les couleurs affichées à l'écran et les couleurs réelles. <strong>Il n'y a pas de retour en raison de variances des couleurs</strong>.</p> <h2 style="text-align: justify;">vidéo d'installation</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> Pierre décorative intérieur et extérieur ; Plaquette de parement en béton ; matbaY.fr plaquette de parement résistante aux conditions atmosphériques comme à l'humidité et au gel p.ex. Pour usage à l’intérieur ou à l’extérieur comme un décor des clôtures ou des façades p.ex. Elle montre les traits naturels d'une pierre ; <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>5 Plaquette par carton</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.32 m<sup>2</sup> par carton</strong></p>
9818 <p style="text-align: justify;">Recent advances in manufacturing technology have brought the ability to create exquisitely realistic wood look tiles – bringing the authentic look and texture to durable, water resistant concrete wood look cladding. <strong>TIMBER 1 (WOOD)&nbsp;</strong>is one of the examples of a concrete tile imitating irregular structure of natural wood having a huge potential of becoming the hit product of the next season. Coming in three unique colours–each, Timber can be a modern accompaniment to a contemporary interior and facade or a vintage accent to a more rustic setting.</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>7</td> <td>0,43 m<sup>2</sup></td> <td>13,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> TIMBER WOOD facing bricks in a noble wood look ✔ natural look ✔ weather-resistant ✔ inside & outside ✔ order online | baybaY.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.43 m<sup>2</sup> per box</strong></p>
9880 <p style="text-align: justify;">GRENADA GRAPHITE est une plaquette de parement résistante aux conditions atmosphériques comme à l'humidité et au gel. Pour usage intérieur ou extérieur comme un décor des clôtures ou des façades p.ex. Elle montre les traits naturels d'une pierre. Inspirée par les paysages pittoresques de l'Andalousie, fait penser à l'ambiance charmante et mystérieuse des villes espagnoles. Elle est parfaitement combinés avec d'autres matériaux, p.ex avec le bois, ce qui affecte efficacement l'esthétique de la pièce ou de la façade du bâtiment.</p> <p style="text-align: justify;">✓ Pierre décorative intérieur et extérieur<br /> ✓ Plaquette de parement en béton</p> <p style="text-align: justify;">&nbsp;</p> <table style="text-align: center;"> <tbody> <tr> <td style="text-align: center;" width="105"><strong>Carton</strong></td> <td style="text-align: center;" width="95">Pièce</td> <td style="text-align: center;" width="95">Mètre</td> <td style="text-align: center;" width="95">Poids</td> </tr> <tr> <td><strong>Plaquette</strong></td> <td>5</td> <td>0.32 m<sup>2</sup></td> <td>11.60 kg</td> </tr> <tr> <td><strong>Angle</strong></td> <td>5</td> <td>0.58 ml</td> <td>11.55 kg</td> </tr> </tbody> </table> <h4>Attention!</h4> <p style="text-align: justify;">Toutes les couleurs présentées ci-dessous peuvent se différer légèrement des couleurs réelles. Cela dépend de la résolution de votre écran et de celle de votre carte graphique. Les couleurs sont affectées par de nombreux facteurs par exemple l'éclairage, l'age, le type de finition, le type de substrat et les couleurs adjacentes. Nous n'acceptons aucune réclamation pour les écarts de couleurs entre les couleurs affichées à l'écran et les couleurs réelles. <strong>Il n'y a pas de retour en raison de variances des couleurs</strong>.</p> <h2 style="text-align: justify;">vidéo d'installation</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> <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>5 Plaquette par carton</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.32 m<sup>2</sup> par carton</strong></p>
9883 <p style="text-align: justify;">The structure of the tile <b>AMSTERDAM 2 (GRAPHITE)&nbsp;</b>imitates hand-hewn stone. It is an interesting facade’s decoration. You can arrange it with the fugue, and without – reaching in both cases drawing of beautiful stone. The subdued shades of warm grey is certainly another advantage of freeze proof Amsterdam.</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>30</td> <td>0,59m<sup>2</sup></td> <td>15,5 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>10</td> <td>0,76 lm</td> <td>7,5 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> Amsterdam Graphite ✔ Facades ✔ Interiors ✔ Weatherproof ✔ Easy assembly ✔ Protects the wall from dirt and deposits | Buy cheap <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>30 pieces per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.59 m<sup>2</sup> per box</strong></p>