SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '', 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    10022, 10029, 10025, 10057, 10062, 10036, 
    10019, 10052, 10028, 10059, 10419, 
    10049
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00045

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_descriptions range PRIMARY,product_id PRIMARY 9 12 Using index condition

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
10019 <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 CREAM corner ✔ suitable for interiors ✔ produced in an ecological process ✔ white ✔ easy assembly ✔ height - 10 cm
10022 <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 GREY ✔ suitable for interiors ✔ based on synthetic plaster ✔ dark gray ✔ easy assembly ✔ height - 20cm | Order now ! ☎ 030 30 807 169
10025 <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 LATTE ✔ suitable for interiors ✔ imitation of the Venetian streets and sun ✔ easy assembly ✔ height - 15.2cm
10028 <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> Corner CALIFORNIA DESERT ✔ for inside and outside ✔ based on concrete and mineral raw materials ✔ similar to fine stone ✔ height - 15cm | ☎ 030 30 807 169
10029 <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> CALIFORNIA GREY corner ✔ for inside and outside ✔ based on concrete and mineral raw materials ✔ similar to fine stone ✔ height - 15cm | ☎ 030 30 807 169
10036 <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> Corner PALERMO WHITE ✔ for inside and outside ✔ based on concrete and mineral raw materials ✔ easy to care for ✔ height - 14.2cm | Consultation ! ☎ 030 30 807 169
10049 <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 BEIGE with integrated joint ✔ suitable for inside and outside ✔ made of concrete ✔ classic shape ✔ height - 7.3cm | Available online ! ☎ 030 30 807 169
10052 <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>63</td> <td>1m<sup>2</sup></td> <td>17,9 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>24</td> <td>1,8 lm</td> <td>10,4 kg</td> </tr> </tbody> </table> COUNTRY 618 corner ✔ for outside ✔ on the basis of pressed concrete ✔ imitation of the old Belgian brick wall ✔ light black ✔ height - 6.2cm | ☎ 030 30 807 169
10057 <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 WHITE corner ➟ for inside ➟ quick and easy assembly ➟ brick slips with joints ➟ classic shape ➟ height - 7.4 cm | Check now !
10059 <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 corner ➟ for inside and outside ➟ quick and easy assembly ➟ Weatherproof ➟ height - 6 cm | Check now !
10062 <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 corner ➟ for inside and outside ➟ quick and easy assembly ➟ Weatherproof ➟ height - 6 cm | Check now !
10419 <p style="text-align: justify;">The unusual structure and unique coloration give a realistic look of quarried stone to the <strong>CALIFORNIA 3 (MOCCA)</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;">✓ Decorative stone for indoor and outdoor use<br /> ✓ Concrete cladding board</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;">&nbsp;</h2> <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> CALIFORNIA MOCCA- elegant and modern design of concrete tiles. Check it out at baubaY.de »Order hotline ✆ 030 30 807 169 <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>