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 (
    8306, 8289, 8361, 8304, 9885, 8367, 9882, 
    8288, 8275, 8733, 8362, 8305
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00140

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
8275 <p style="text-align: justify;"><strong>CRETA 1 (CREAM)</strong> is a perfect imitation of cracked sandstone. Its rectangular shape makes an installation much easier. Perfect product for modern interiors.</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>10</td> <td>1 m<sup>2</sup></td> <td>18 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>10</td> <td>2 lm</td> <td>18 kg</td> </tr> </tbody> </table> CRETA CREAM ✔ Interiors ✔ Elegant look ✔ Easy installation ✔ Protects the wall from dirt and deposits | Check it on baubaY.de <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>10 tiles per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>1 m<sup>2</sup> per box</strong></p>
8288 <p style="text-align: justify;">The unusual structure and unique coloration give a realistic look of quarried stone to the <strong>CALIFORNIA 1 (DESERT)</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;">✓ 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> Decorative tiles California Desert ✔ Sandstone texture ✔ Easy installation ✔ Weatherproof ✔ Protects the wall from dirt and deposits »Buy online at baubaY.de <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>
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>
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>
8305 <p style="text-align: justify;"><strong>PALERMO 1 (WHITE)</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 WHITE ✔ 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>
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>
8362 <p style="text-align: justify;">Rusty natural stone offers all the richness of beauty and color brought by the rock blocks from which it was cut. Its face shimmers with gray, reddish, beige and brown. It is a bold stone that strongly marks its presence in the apartment. It works well in a wide range of interiors – from quite obvious industrial and loft styles, in which it replaces traditional bricks and concrete (or blends in with them skillfully), adding elegance and a sense of luxury, to classic apartments, where it introduces a sense of communing with nature, breaking the monotony of painted or wallpaper-finished walls.</p> <p style="text-align: justify;">Minimalist spaces based on white and black, high-gloss furniture gain character and vitality thanks to Rusty natural stone. They evolve, taking on the features of mature urban apartments.</p> <p style="text-align: justify;">✓ Interior and exterior decorative 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 kg</td> </tr> </tbody> </table> RUSTY natural stone for high-quality facades » Exterior facades ✔ Interiors ✔ Garden decoration ✔ Terraces ✔ Fireplace ✔ Steps ✔ Hotline ☎ 030 30 807 16 <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.42 m<sup>2</sup> per box</strong></p>
8367 <p>This adhesive is suitable for all gypsum-based facing bricks; indoor use only. Due to its good adhesion, it is particularly suitable for gypsum products.</p> <h2>Substrate Preparation</h2> <p>Can be applied to any stable substrates, such as concrete, brick and clinker bricks, wood and plasterboard. The substrate must be clean and dust-free. For highly absorbent substrates, preliminary priming is at least recommended, if not necessary.</p> <h2>Adhesive Preparation</h2> <p>Prepare the adhesive in a clean container that should be free of old residues that would shorten the setting time. Mix the adhesive with water (1.6-1.9l for 5kg of adhesive) and stir thoroughly. After 5 minutes, stir thoroughly again and process the finished mixture within 45 minutes.</p> <h2>Bonding</h2> <p>Apply the adhesive in dots (approx. 5mm thick) to the back of the facing bricks. Press the facing bricks against the wall and move them back and forth slightly to achieve optimal distribution. Then remove the excess adhesive from the joint area.&nbsp;</p> <h2>Tools</h2> <p>Clean container, stirrer, trowel</p> <h2>Consumption</h2> <p>approx. 2 kg / m²</p> <h2>Recommendation</h2> <p>Before large-scale bonding, carry out a test in a less visible area to identify and eliminate any potential problems.</p> <h2>Storage</h2> <p>Store adhesive in sealed containers in dry rooms; storage time approx. 6 months from the production date</p> <h2>Technical Data</h2> <table border="1" cellpadding="2" cellspacing="2" style="width: 505px; height: 228px; text-align: left;"> <tbody> <tr> <td>Consumption</td> <td>approx. 2kg / m²</td> </tr> <tr> <td>Stirring time with water</td> <td>approx. 2 minutes</td> </tr> <tr> <td>Mixing proportions</td> <td>1.6-1.9l water per 5kg adhesive</td> </tr> <tr> <td>Processing temperature</td> <td>+5° - +25°C</td> </tr> <tr> <td>Processing time</td> <td>up to 45 minutes</td> </tr> <tr> <td>Setting time</td> <td>approx. 8 hours</td> </tr> <tr> <td>Drying time</td> <td>up to 5 days</td> </tr> <tr> <td colspan="2">Not frost and water resistant</td> </tr> </tbody> </table> <p>&nbsp;</p> GIPS KLEBER ✔ auf Basis vom Material Gips ✔ breite Verwendung ✔ für innen geeignet | Online erhältlich ! ✉ info@baubay.de <p style="background: #ddd; text-align: justify;"><strong>Verbrauch: ca. 3 kg / m²</strong></p>
8733 <p style="text-align: justify;"><strong class="last-child" style="font-weight: normal;">RUSTIK 540</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 540 ➟ 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>
9882 <p style="text-align: justify;">The structure of the tile <strong>AMSTERDAM 1 (BEIGE)</strong> 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 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>30</td> <td>0,59 m<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 BEIGE ✔ 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 tiles per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.59 m<sup>2</sup> per box</strong></p>
9885 <p style="text-align: justify;"><strong>Loft 1 (White)</strong> 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> <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>