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 (
    10444, 10027, 10023, 10044, 10060, 10427, 
    10024, 10035, 10038, 10014, 10016, 
    10047
  ) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00047

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
10014 <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> Corner CRETA CREAM ✔ suitable for interiors ✔ based on synthetic plaster ✔ beige ✔ easy assembly ✔ height - 20cm | Order now ! ☎ 030 30 807 169
10016 <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 corner ✔ suitable for interiors ✔ easy assembly ✔ height - 11cm | Here ! ☎ 030 30 807 169
10023 <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> Corner RODOS SAND with joint ✔ suitable for interiors ✔ wonderful in combination with glass, wood and metal ✔ beige | Buy now! ☎ 030 30 807 169
10024 <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> Corner VENEZIA CREAM ✔ suitable for interiors ✔ imitation of the Venetian streets and sun ✔ easy assembly ✔ height - 15.2cm
10027 <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> Corner CALABRIA MOCCA ✔ suitable for inside and outside ✔ made of concrete ✔ reminiscent of the sun-drenched wall ✔ weatherproof | Buy online ! ☎ 030 30 807 169
10035 <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> <p>&nbsp;</p> NEPAL DESERT corner ✔ suitable for inside and outside ✔ made of concrete ✔ low weight ✔ orange-yellow ✔ modern design ✔ height - 10cm | Service ☎ 030 30 807 169
10038 <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> Corner GRENADA FROST ✔ for inside and outside ✔ made of concrete ✔ reminds of the atmosphere of Spanish cities ✔ light gray ✔ height - 11.7cm | Online! ☎ 030 30 807 169
10044 <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> Corner AMSTERDAM GRAPHITE ✔ for inside and outside ✔ based on concrete and mineral raw materials ✔ height – 7,6cm |
10047 <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> Corner BOSTON GREY with integrated joint ✔ suitable for inside and outside ✔ made of concrete ✔ classic shape ✔ height - 7.3cm | Order now ! ☎ 030 30 807 169
10060 <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 corner ➟ for inside and outside ➟ quick and easy assembly ➟ Weatherproof ➟ height - 6 cm | Check now !
10427 <p style="text-align: justify;"><strong>KENYA 2 (MOCCA)</strong> decorative stone is the result of a fascination with nature, its shapes, patterns and colors. Kenya is distinguished by a distinctive, irregular texture and its name is not accidental. Kenya 1 with a white-gray, slightly soiled color brings to mind the snowy Batian peak from the volcanic massif of Kenya. In contrast, Kenya 2 resembles volcanic lava. It is brownish red with dimmed, smoky elements. The volcanic origin is highlighted by noticeable pits. Kenya stones can be installed indoors and on facades.</p> <p style="text-align: justify;">✓ Interior and exterior decorative stone</p> <p style="text-align: justify;">Tile dimensions: 473 x 120 x 16-33 mm</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,4 m<sup>2</sup></td> <td>15,2 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> KENYA MOCCA ✔ elegant and modern design of concrete tiles ✔ for inside and outside ✔ 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.4 m<sup>2</sup> per box</strong></p>
10444 <p style="text-align: justify;"><strong class="last-child" style="font-weight: bold;">CAMBRIDGE 2 (CREAM)</strong>&nbsp;is a&nbsp; frostproof&nbsp; Frost-resistant brick-like tiles in the form of natural and platinum bricks with colourations.</p> <p style="text-align: justify;">✓ Interior and exterior decorative brick</p> <p style="text-align: justify;">✓ Concrete facing brick</p> <p style="text-align: justify;">&nbsp;</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>57</td> <td>0.91 m<sup>2</sup></td> <td>20 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>24</td> <td>1.75 lm</td> <td>13 kg</td> </tr> </tbody> </table> CAMBRIDGE CREAM Frost-resistant brick-like tiles » Easy installation ✔ for inside and outside ✔ Long durability ✔ Weather-resistant ✔ Order now <p style="text-align: center; color:#F0FFFF; background: #00cc99"><strong>57 pieces per box</strong></p> <p style="text-align: center; color:#6699cc; background: #ffcc00"><strong>0.91 m<sup>2</sup> per box</strong></p>