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 (
    8303, 8665, 9880, 8286, 9818, 9883, 8666, 
    8300, 8306, 8289, 8361, 8304
  ) 
  AND cscart_ult_product_descriptions.company_id = 2 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00054

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
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>
8289 <p style="text-align: justify;">The unusual structure and unique coloration give a realistic look of quarried stone to the <strong>CALIFORNIA 2 (GREY)</strong>&nbsp;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;">✓ 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>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;">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> Beautiful structured facing bricks for interiors and exterior facades with a Mediterranean look. At baubaY.de you will find everything to do with brick slips and accessories <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>
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>
8304 <p style="text-align: justify;"><strong>NEPAL 2 (DESERT)</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> <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> NEPAL DESERT ✔ Facades ✔ Interiors ✔ Fences ✔ Weatherproof ✔ Elegant look ✔ Easy installation | Order now at baubaY.de <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.46 m<sup>2</sup> per box</strong></p>
8306 <p style="text-align: justify;"><strong>PALERMO 2 (GRAPHITE)</strong> decorative stone adds the warm charm of each block which is characteristic for the Sicilian architecture.</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>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> <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> PALERMO GRAPHITE ✔ Facades ✔ Interiors ✔ Fences ✔ Weatherproof ✔ Elegant look ✔ Easy installation | Order now at baubaY.de <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>8 pieces per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.62 m<sup>2</sup> per box</strong></p>
8361 <p style="text-align: justify;">Natural stone with delicate shades – from ivory, beige, subdued browns and yellows to whitened grays. Multi coloring is a great advantage of Ivory, which fits perfectly in traditional and modern homes. The three-dimensional structure of the arrangement of individual fragments creates walls that harmonize very dynamically with the changing lighting. Daylight makes Ivory very bright, pastel, and artificial light brings out many intriguing shadows. The bright colors of the Ivory natural stone make it brighten the room, so it will be perfect not only in living rooms, bedrooms or kitchens, but also in halls. The naturalness of the material promotes well-being.</p> <p style="text-align: justify;">✓ natural stone for interiors 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-400x100x8-12</td> <td>12</td> <td>0,43 m<sup>2</sup></td> <td>12 kg</td> </tr> </tbody> </table> IVORY Natural stone for interior and exterior facades »Natural look for modern interior design» Ordering & consulting ☎ 030 30 807 169 - Discover assortment <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>
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>