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 (
    8273, 10423, 9819, 9481, 8283, 9483, 
    9879, 9875, 9869, 10428, 8735, 8287
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00048

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
8273 <p style="text-align: justify;">Decorative stone ARENA perfectly imitates limestone encountered in the Sinai. Subtle texture gives the tiles a very natural look. It is perfect for natural arrangement. ARENA perfectly fits to EGYPT COLLECTION decors, giving the interior a truly mysterious character. The package contains 15 different elements.</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>27</td> <td>1 m<sup>2</sup></td> <td>19 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>18</td> <td>2 lm</td> <td>13 kg</td> </tr> </tbody> </table> Arena Cream ✔ facing decorative tile ✔ stone look ✔ Interiors ✔ Protects the wall from dirt and deposits ✔ Order Now <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>27 tiles per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>1 m<sup>2</sup> per box</strong></p>
8283 <p style="text-align: justify;"><strong>VENEZIA 1 (CREAM)</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> Venezia Cream facing brick • Beautifully structured facing stone with a Mediterranean look. Order facing bricks online now at 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>
8287 <p style="text-align: justify;">Long brick in modernist style with rich texture of raw concrete. Tiles have slightly torn edges with visible surface pitting. <strong>DUBLIN 3&nbsp;</strong>matches metallic surfaces, glass and oiled wood. Geometric structure suits both industrial interiors in combination with white color and vivid colors such as yellow, lime or magenta. As a facade tile it emphasizes the shape of modern, minimalist architecture. Construction of the tiles (bricks with joint) provides easy installation.</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">Meters</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tiles</strong></td> <td>14</td> <td>0.52 m<sup>2</sup></td> <td>18.0 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>8</td> <td>0.66 lm</td> <td>8.5 kg</td> </tr> </tbody> </table> DUBLIN ✔ for inside and outside ✔ with integrated joint ✔ Protects the wall from dirt and deposits ✔ Easy installation ✔ Facades ✔ Elegant look ✔ Weatherproof ✔ Fences | Check it out at baubaY.de <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>14 tiles per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.52 m<sup>2</sup> per box</strong></p>
8735 <p style="text-align: justify;"><strong class="last-child" style="font-weight: normal;">RUSTIC 568</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 568 ➟ 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>
9481 <p style="text-align: justify;"><strong>BOSTON 1 (GREY)</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 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>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 brick slips with already integrated joints »Easy installation ✔ Long durability ✔ Weatherproof ✔ Order now | baubaY.de <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>
9483 <p style="text-align: justify;"><strong>BOSTON 3 (BEIGE)</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;">✓ Interior and exterior brick tiles with ready joint</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 BEIGE ✔ Facades ✔ Interiors ✔ Fences ✔ Weatherproof ✔ Elegant look ✔ with ready joint ✔ Easy assembly ✔ Protects the wall from dirt and deposits ✔ Buy cheap online | baubaY.de! <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>
9819 <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. Timber 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, <strong>TIMBER 2 (BEIGE)</strong> 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 BEIGE facing bricks in a noble wood look ✔ natural look ✔ weather-resistant ✔ inside & outside ✔ order online | 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.43 m<sup>2</sup> per box</strong></p>
9869 <p style="text-align: justify;">Natural stone gives the interior nobility, introduces serenity and a sense of communing with real nature. Nero is a minimalist elegance with surprisingly many faces. The black color of the stone is illuminated with natural silvering – depending on the angle of light and its source. Nero plays with light and shade, gently changing the colors oscillating around black, anthracite and dark gray. Tiles cut into geometric, longitudinal strips have different thicknesses (difference up to 5 mm), which, when installed, creates an elegant, flattened three-dimensional effect on the wall. Nero fits both traditional and very modern or even ascetic interiors. It enriches them and gives them a luxurious depth.</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>12,7 kg</td> </tr> </tbody> </table> NERO ✔ Natural stone for interior and exterior facades ✔ Natural look for modern interior design ✔ height – 10cm | Check it on 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.43 m<sup>2</sup> per box</strong></p>
9875 <p style="text-align: justify;"><strong>PARMA 2 (BEIGE)</strong> brick slip is an innovative product, which is is characterized by integrated joint. Thanks to its unique design, Parma interior decorative stone is incredibly easy to instal. Due to its thanks to its classic form, Parma brick slip perfectly suits both traditional and modern interiors. It can be easily painted in any other color with standard paints. Parma 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;">✓ Interior concrete brick tile with joint</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>30</td> <td>0,5 m<sup>2</sup></td> <td>10,5 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>12</td> <td>0,9 lm</td> <td>5,8 kg</td> </tr> </tbody> </table> PARMA BEIGE ➟ seamless system ➟ quick and easy installation ➟ brick slips with joints ➟ interior fittings ➟ classic form ➟ main decorative trends ✔✔✔ inexpensive at baubaY.de ! <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.5 m<sup>2</sup> per box</strong></p>
9879 <p style="text-align: justify;">Decorative stone <strong>GRENADA 4 (VOLCANIC)<span class="s1 last-child">,</span></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 VOLCANIC ✔ Facades ✔ Interiors ✔ Fences ✔ Weatherproof ✔ Elegant look ✔ Easy installation ✔ Protects the wall from dirt and deposits | Order now at baubaY.de! Grenada Volcanic <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>
10423 <p style="text-align: justify;">The <strong>JURA 1 (CREAM) </strong>decorative stone is an imitation of stone with an irregular shape, produced from the highest quality natural raw materials on the basis of aggregates and cement, it is perfect for the outside and inside of buildings. The shape and color of the Jura tiles allow to obtain a surprisingly accurate representation of a natural limestone finish. The warm, soft texture and elegant appearance of these tiles make them very successful among customers all over the world.</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">Meters</td> <td style="text-align: center;" width="95">Weight</td> </tr> <tr> <td><strong>Tiles</strong></td> <td>22-24</td> <td>1 m<sup>2</sup></td> <td>21 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>10</td> <td>1,8 lm</td> <td>9 kg</td> </tr> </tbody> </table> JURA CREAM facade decorative tiles ✔ Weatherproof ✔ for inside and outside »Buy cheap online at baubaY.de | ☎ 030 30 807 169 <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>22-24 tiles per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>1 m<sup>2</sup> per box</strong></p>
10428 <p style="text-align: justify;">Deeply textured frost resistant decorative stone <strong>LYON 1 (BEIGE)</strong> thanks to its subtle colour, matches both glass and metal. It’s a perfect cladding for any surface, from fencing, facades to sauna or hall.</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,54 m<sup>2</sup></td> <td>16,8 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>7</td> <td>1 lm</td> <td>16,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> LYON BEIGE - 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>7 pieces per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.54 m<sup>2</sup> per box</strong></p>