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 (
    10051, 10061, 10026, 10058, 10054, 10048, 
    10053, 10459, 10050, 10056, 10021, 
    10031
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00050

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
10021 <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>
10026 <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 GRAPHITE ✔ for interiors ✔ on the basis of synthetic plaster ✔ precisely manufactured ✔ easy assembly ✔ height - 15.2cm | Here ! ☎ 030 30 807 169
10031 <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>24</td> <td>0,42 m<sup>2</sup></td> <td>15 kg</td> </tr> <tr> <td><strong>Corner</strong></td> <td>10</td> <td>0,8 lm</td> <td>7 kg</td> </tr> </tbody> </table> MONSANTO RED corner ➟ for inside and outside ➟ quick and easy assembly ❄ frost-resistant ➟ perfect for facades ✓ visual authenticity of the demolition brick ➟ height - 7.8 cm
10048 <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 WHITE with integrated joint ✔ suitable for inside and outside ✔ made of concrete ✔ classic shape ✔ height - 7.3cm | Available online ! ☎ 030 30 807 169
10050 <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 MOONLIGHT with integrated joint ✔ for inside and outside ✔ made of concrete ✔ gray ✔ classic shape ✔ height - 7.3cm | In the online shop! ☎ 030 30 807 169
10051 <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 610 corner ✔ for outside ✔ on the basis of pressed concrete ✔ imitation of the old Belgian brick wall ✔ yellow-brown ✔ height - 6.2cm | ☎ 030 30 807 169
10053 <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 640 corner ✔ for outside and inside ✔ on the basis of pressed concrete ✔ imitation of the old Belgian brick wall ✔ brown red ✔ height - 6.2cm | ☎ 030 30 807 169
10054 <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 668 corner ✔ for outside and inside ✔ on the basis of pressed concrete ✔ imitation of the old Belgian brick wall ✔ brown red ✔ height - 6.2cm | ☎ 030 30 807 169
10056 <p style="text-align: justify;">Loft 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> <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> Corner LOFT WHITE ✔ suitable for interiors ✔ based on synthetic plaster ✔ easy assembly ✔ height - 6.3cm | Have a look now! ☎ 030 30 807 169
10058 <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 corner ➟ for inside ➟ quick and easy assembly ➟ brick slips with joints ➟ classic shape ➟ height - 7.4 cm | Check now !
10061 <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 corner ➟ for inside and outside ➟ quick and easy assembly ➟ Weatherproof ➟ height - 6 cm | Check now !
10459 <p style="text-align: justify;"><strong class="last-child" style="font-weight: normal;">COUNTRY 680</strong> is a frost- proof, brick slip which is a perfect imitation of old Belgian brick. Hand-cast, from natural components only, on the base of pressed cement. They perfectly&nbsp; serve us a finishing material to every type of a building.</p> <p style="text-align: justify;">✓ Brick tile inside and outside.</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>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> Structured brick slips from the COUNTRY series »Easy installation ✔ Long durability ✔ Weatherproof ✔ Order now | 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>