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 (439, 10161, 438, 10162) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00037

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 4 Using index condition

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
438 <h2>Façade thermal insulation<br />ROCKWOOL FRONTROCK L</h2><p style="text-align: justify;"><strong>Rockwool Frontrock L</strong> is a stone wool insulation lamella slab for external wall cladding in combination with mortar, mesh and special layered finish coating. Facade lamellas are generally adhesive fix and may therefore be used on substrates that are problematic for mechanical fix. They are ideally suited to new build constructions with a height limit of 20m.</p><p style="text-align: justify;"><strong>Application</strong></p><p style="text-align: justify;">Lamella Frontrock L is robust and easy to install on even surfaces while it is also flexible enough to bend slightly, accommodating curved facades. Lamellas are always installed horizontally and the adhesive mortar is generally spread over their entire inner surface with a toothed trowel. Mortar can also be applied with a toothed trowel directly to the wall, if the surface is flat enough, before adhering lamellas to it. When choosing this application method, it is essential that the wall surface is flat and level. It is also important to have the proper consistency of mortar adhesive.</p><table><tbody><tr><td colspan="2" rowspan="1" style="text-align: center; width: 430px;"><strong>Technical Information</strong></td></tr><tr><td style="text-align: center; width: 215px;">Fire Classification<br />(Euro Class)</td><td style="text-align: center; width: 215px;">non-flammable<br />A1</td></tr><tr><td style="text-align: center;">Thermal Conductivity <strong>λ<sub>D</sub></strong></td><td style="text-align: center;">0.041 <sup>W</sup>/<sub>mK</sub></td></tr><tr><td style="text-align: center;">Length</td><td style="text-align: center;">1200 mm</td></tr><tr><td style="text-align: center;">Width</td><td style="text-align: center;">200 mm</td></tr></tbody></table><table><tbody><tr><td colspan="4" rowspan="1" style="text-align: center; width: 400px;"><strong>Product Range</strong></td></tr><tr><td style="text-align: center; width: 90px;">Thickness<br /><i>mm</i></td><td style="text-align: center; width: 130px;">Thermal resistance<br /><i><sup>m<sup>2</sup>K</sup>/<sub>W</sub></i></td><td style="text-align: center; width: 90px;">Area/Pack<br /><i>m<sup>2</sup></i></td><td style="text-align: center; width: 90px;">Area/Pallet<br /><i>m<sup>2</sup></i></td></tr><tr><td style="text-align: center;">50</td><td style="text-align: center;"><strong>1.20</strong></td><td style="text-align: center;">1.92</td><td style="text-align: center;">57.60</td></tr><tr><td style="text-align: center;">100</td><td style="text-align: center;"><strong>2.40</strong></td><td style="text-align: center;">0.96</td><td style="text-align: center;">28.80</td></tr><tr><td style="text-align: center;">120</td><td style="text-align: center;"><strong>2.90</strong></td><td style="text-align: center;">0.96</td><td style="text-align: center;">24.00</td></tr><tr><td style="text-align: center;">150</td><td style="text-align: center;"><strong>3.65</strong></td><td style="text-align: center;">0.96</td><td style="text-align: center;">19.20</td></tr><tr><td style="text-align: center;">200</td><td style="text-align: center;"><strong>4.85</strong></td><td style="text-align: center;">0.96</td><td style="text-align: center;">14.40</td></tr></tbody></table>
439 <h2>Façade thermal insulation<br />ROCKWOOL FRONTROCK SUPER</h2><p style="text-align: justify;">A dual-density rigid slab for external wall systems. Due to its high density top side, it can be used for thin coat systems, as well as also for thicker coat systems.</p><p style="text-align: justify;"><strong>Rockwool Frontrock Super</strong> is a dual density slab for external wall systems with excellent thermal conductivity performance and high sound absorption. It can be used for rendering systems with all kind of finish coatings – light or heavy, thin or thicker. The advantage of Rockwool Frontrock Super compared with lamella is, that the outside surface, which is visibly marked, is highly compressed. While supported with mechanical fixings, Frontrock Super can be suitable also for extremely heavy loads, such as appear to be various thicker coated rendering systems. Due to its excellent lambda value (0,036 W/mK), we achieve a 15% better U-value for the external wall, as if we were using the same insulation thickness of the standard EPS or mineral wool lamella.</p><p style="text-align: justify;">Rockwool Frontrock Super is an excellent thermal insulator. It is not flamable when exposed to open flame and does not generate smoke nor burning droplets. It helps to prevent spread of fire. Frontrock Super has also very good acoustic properties and helps to reduce the noise transmission from outside into the dwelling units. It is water repellent through the whole section and at the same time diffusion open for the vapour transmission.</p><p style="text-align: justify;">Rockwool Frontrock Super slabs are being produced in dimension 1000 x 600. We deliver the product in packs, stacked on small format pallets, covered with PE plastic cover hood.</p><ul style="text-aling: justify;"><li>Compliance:<br />EN 13162:2012 + A1:2015</li><li>Fire Classification:<br />non-flammable (Euro Class <strong>A1</strong>)</li><li>Thermal Conductivity:<br /><strong>λ<sub>D</sub></strong> = <strong>0.036</strong> <sup>W</sup>/<sub>mK</sub></li><li>Compressive stress at 10% relative deformation:<br /><strong>CS(10)</strong> ≥ 20 kPa</li><li>Tensile resistance to a force perpendicular to front surfaces:<br /><strong>TR</strong> ≥ 10 kPa</li><li>Full coed:<br />MW-EN 13162-T5-DS(70,-)-DS(70,90)-CS(10)20-TR10-PL(5)250-WS–WL(P)-MU1</li><li>CE-certificates:<br />1390-CPR-0255/10/P; 1390-CPR-0256/10/P; 1390-CPR-0168/09/P; 1390-CPR-0452/16/P</li></ul><h4>Product range and ancillaries</h4><div style="overflow-x:auto;"><table><tbody><tr><td style="text-align: center;">Width</td><td style="text-align: center;">Length</td><td style="text-align: center;">Thickness</td><td style="text-align: center;">Thermal resistance</td><td style="text-align: center;">Area/Pack</td><td style="text-align: center;">Area/Pallet</td></tr><tr><td style="text-align: center;"><i>mm</i></td><td style="text-align: center;"><i>mm</i></td><td style="text-align: center;"><i>mm</i></td><td style="text-align: center;"><i><sup>m<sup>2</sup>K</sup>/<sub>W</sub></i></td><td style="text-align: center;"><i>m<sup>2</sup></i></td><td style="text-align: center;"><i>m<sup>2</sup></i></td></tr><tr><td rowspan="7" style="text-align: center;">600</td><td rowspan="7" style="text-align: center;">1000</td><td style="text-align: center;">80</td><td style="text-align: center;"><strong>2.20</strong></td><td style="text-align: center;">1.80</td><td style="text-align: center;">36.00</td></tr><tr><td style="text-align: center;">100</td><td style="text-align: center;"><strong>2.75</strong></td><td style="text-align: center;">1.80</td><td style="text-align: center;">28.80</td></tr><tr><td style="text-align: center;">120</td><td style="text-align: center;"><strong>3.30</strong></td><td style="text-align: center;">1.80</td><td style="text-align: center;">21.60</td></tr><tr><td style="text-align: center;">140</td><td style="text-align: center;"><strong>3.85</strong></td><td style="text-align: center;">1.20</td><td style="text-align: center;">19.20</td></tr><tr><td style="text-align: center;">150</td><td style="text-align: center;"><strong>4.15</strong></td><td style="text-align: center;">1.20</td><td style="text-align: center;">19.20</td></tr><tr><td style="text-align: center;">160</td><td style="text-align: center;"><strong>4.40</strong></td><td style="text-align: center;">1.20</td><td style="text-align: center;">14.40</td></tr><tr><td style="text-align: center;">180</td><td style="text-align: center;"><strong>5.00</strong></td><td style="text-align: center;">1.20</td><td style="text-align: center;">14.40</td></tr></tbody></table></div>
10161 <h2>Façade thermal insulation FRONTROCK PLUS</h2><ul style="text-aling: justify;"><li>Compliance:<br />EN 13162:2012+A1:2015</li><li>Fire Classification:<br />non-flammable (Euro Class <strong>A1</strong>)</li><li>Thermal Conductivity:<br /><strong>λ<sub>D</sub></strong> = <strong>0.035</strong> <sup>W</sup>/<sub>mK</sub></li><li>Compressive stress at 10% relative deformation:<br /><strong>CS(10)</strong> ≥ 20 kPa</li><li>Tensile resistance to a force perpendicular to front surfaces:<br /><strong>TR</strong> ≥ 10 kPa</li><li>Full coed:<br />MW-EN 13162-T5-DS(70,90)-CS(10)20-TR10-PL(5)200-WS-WL(P)-MU1</li><li>CE-certificates:<br />1390-CPR-0275/10/P, 1390-CPR-0453/16/P, 1390-CPR-0168/09/P</li></ul><h4>Product range and ancillaries</h4><div style="overflow-x:auto;"><table><tbody><tr><td style="text-align: center;">Width</td><td style="text-align: center;">Length</td><td style="text-align: center;">Thickness</td><td style="text-align: center;">Thermal resistance</td><td style="text-align: center;">Area/Pack</td><td style="text-align: center;">Area/Pallet</td></tr><tr><td style="text-align: center;"><i>mm</i></td><td style="text-align: center;"><i>mm</i></td><td style="text-align: center;"><i>mm</i></td><td style="text-align: center;"><i><sup>m<sup>2</sup>K</sup>/<sub>W</sub></i></td><td style="text-align: center;"><i>m<sup>2</sup></i></td><td style="text-align: center;"><i>m<sup>2</sup></i></td></tr><tr><td rowspan="13" style="text-align: center;">600</td><td rowspan="13" style="text-align: center;">1000</td><td style="text-align: center;">50</td><td style="text-align: center;"><strong>1.40</strong></td><td style="text-align: center;">3.60</td><td style="text-align: center;">57.60</td></tr><tr><td style="text-align: center;">60</td><td style="text-align: center;"><strong>1.70</strong></td><td style="text-align: center;">4.20</td><td style="text-align: center;">50.40</td></tr><tr><td style="text-align: center;">80</td><td style="text-align: center;"><strong>2.25</strong></td><td style="text-align: center;">3.00</td><td style="text-align: center;">36.00</td></tr><tr><td style="text-align: center;">100</td><td style="text-align: center;"><strong>2.85</strong></td><td style="text-align: center;">1.80</td><td style="text-align: center;">28.80</td></tr><tr><td style="text-align: center;">120</td><td style="text-align: center;"><strong>3.40</strong></td><td style="text-align: center;">1.20</td><td style="text-align: center;">24.00</td></tr><tr><td style="text-align: center;">140</td><td style="text-align: center;"><strong>4.00</strong></td><td style="text-align: center;">1.20</td><td style="text-align: center;">19.20</td></tr><tr><td style="text-align: center;">150</td><td style="text-align: center;"><strong>4.25</strong></td><td style="text-align: center;">1.20</td><td style="text-align: center;">19.20</td></tr><tr><td style="text-align: center;">160</td><td style="text-align: center;"><strong>4.55</strong></td><td style="text-align: center;">1.20</td><td style="text-align: center;">14.40</td></tr><tr><td style="text-align: center;">180</td><td style="text-align: center;"><strong>5.10</strong></td><td style="text-align: center;">1.20</td><td style="text-align: center;">14.40</td></tr><tr><td style="text-align: center;">200</td><td style="text-align: center;"><strong>5.70</strong></td><td style="text-align: center;">1.20</td><td style="text-align: center;">14.40</td></tr><tr><td style="text-align: center;">220</td><td style="text-align: center;"><strong>6.25</strong></td><td style="text-align: center;">0.60</td><td style="text-align: center;">12.00</td></tr><tr><td style="text-align: center;">240</td><td style="text-align: center;"><strong>6.85</strong></td><td style="text-align: center;">0.60</td><td style="text-align: center;">12.00</td></tr><tr><td style="text-align: center;">250</td><td style="text-align: center;"><strong>7.10</strong></td><td style="text-align: center;">0.60</td><td style="text-align: center;">9.60</td></tr></tbody></table></div>
10162 <h2>Thermal insulation ROCKWOOL FRONTROCK S</h2> <ul style="text-aling: justify;"> <li>Compliance:<br /> EN 13162:2012+A1:2015</li> <li>Fire Classification:<br /> non-flammable (Euro Class <strong>A1</strong>)</li> <li>Thermal Conductivity:<br /> <strong>λ<sub>D</sub></strong> = <strong>0.037</strong> <sup>W</sup>/<sub>mK</sub></li> <li>Compressive stress at 10% relative deformation:<br /> <strong>CS(10)</strong> ≥ 30 kPa</li> <li>Tensile resistance to a force perpendicular to front surfaces:<br /> <strong>TR</strong> ≥ 10 kPa</li> <li>Full coed:<br /> MW-EN 13162-T5-DS(70,90)-CS(10)30-TR10-WS-WL(P)-MU1</li> <li>CE-certificates:<br /> CE: 1390-CPR-275/10/P, 1390-CPR-0274/10/P, 1390-CPR-0168/09/P</li> </ul> <table> <tbody> <tr> <td colspan="4" rowspan="1" style="text-align: center; width: 400px;"><strong>Product Range</strong></td> </tr> <tr> <td style="text-align: center; width: 90px;">Thickness<br /> <i>mm</i></td> <td style="text-align: center; width: 130px;">Thermal resistance<br /> <i><sup>m<sup>2</sup>K</sup>/<sub>W</sub></i></td> <td style="text-align: center; width: 90px;">Area/Pack<br /> <i>m<sup>2</sup></i></td> <td style="text-align: center; width: 90px;">Area/Pallet<br /> <i>m<sup>2</sup></i></td> </tr> <tr> <td style="text-align: center;">20</td> <td style="text-align: center;"><strong>0.50</strong></td> <td style="text-align: center;">4.80</td> <td style="text-align: center;">134.40</td> </tr> <tr> <td style="text-align: center;">30</td> <td style="text-align: center;"><strong>0.80</strong></td> <td style="text-align: center;">4.80</td> <td style="text-align: center;">96.00</td> </tr> <tr> <td style="text-align: center;">40</td> <td style="text-align: center;"><strong>1.05</strong></td> <td style="text-align: center;">3.60</td> <td style="text-align: center;">72.00</td> </tr> <tr> <td style="text-align: center;">50</td> <td style="text-align: center;"><strong>1.35</strong></td> <td style="text-align: center;">2.40</td> <td style="text-align: center;">57.60</td> </tr> </tbody> </table>