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 (
    9869, 10428, 8735, 8287, 9817, 8732, 
    8291, 8734, 10430, 8284, 9878, 10434
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00049

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
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>
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>
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>
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>
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>
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>
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>
9878 <p style="text-align: justify;">Decorative stone <strong>GRENADA 3 (MOCCA),</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 MOCCA ✔ Facades ✔ Interiors ✔ Fences ✔ Weatherproof ✔ Elegant look ✔ Easy installation ✔ Protects the wall from dirt and deposits | Order now at baubaY.de! <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>
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>
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>
10434 <p style="text-align: justify;"><strong class="last-child" style="font-weight: bold;">ROMA 1 (DESERT)</strong><strong class="last-child" style="font-weight: normal;"> </strong>- decorative stone made from concrete imitates polished sandstone.&nbsp;It&nbsp;<strong class="last-child" style="font-weight: normal;">reminiscent of the hot sun Italian vineyards and calm atmosphere of local towns. It is perfect as a cladding of any stable surface.</strong></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">Package</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>Tiles</td> <td>15</td> <td>0.75 m<sup>2</sup></td> <td>16.3 kg</td> </tr> <tr> <td>Corner</td> <td>7</td> <td>1.19 lm</td> <td>9.5 kg</td> </tr> </tbody> </table> ROMA DESERT - 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>15 tiles per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0,75 m<sup>2</sup> per box</strong></p>