SELECT 
  * 
FROM 
  cscart_ult_product_descriptions 
WHERE 
  product_id = 526 
  AND company_id = 2 
  AND lang_code = 'en'

Query time 0.00025

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_ult_product_descriptions const PRIMARY,product_id,company_id PRIMARY 13 const,const,const 1

Result

product_id lang_code company_id product shortname short_description full_description meta_keywords meta_description search_words page_title age_warning_message promo_text youtube_link show_youtube_video replace_main_image custom_header
526 en 2 RoofLITE+ TRIO PVC | PVC, pivot, 3-glass roof window <p><span style="font-size:11px;"></span><span style="font-size:14px;"></span><span style="font-size:12px;"></span><img alt="" src="https://d2d2yzufo5fwh3.cloudfront.net/images/products/rooflite/trio_pvc_eng_banner.png?1612447601510" style="width: 1000px; height: 200px;" /></p> <h2>RoofLITE+ TRIO PVC: A super energy efficient triple-glazed PVC window with a reinforced frame – practicality and high performance in one.</h2> <p><strong>TRIO PVC</strong> is a window with a centre pivot (hinges mounted at half window height) manufactured from white PVC that is reinforced internally with steel profiles.</p> <p style="text-align: center;"><img alt="" src="https://domshop.pl/wp-content/uploads/2019/05/okno-dachowe-rooflite-trio-pvc-1.png" /></p> <p><strong>The TRIO PVC</strong> is set apart by its wide, reinforced frame, triple glazing, and enhanced moisture resistance. The first guarantees resistance to the most adverse weather conditions, including intense rain and strong winds.</p> <p style="margin-left: 40px;">✓ Window thermal insulation <strong>Uw= 1,1 W/m2K</strong></p> <p style="margin-left: 40px;">✓ Triple glazing with thermal insulation <strong>Ug= 0,8 W/m2K</strong></p> <p style="margin-left: 40px;">✓ Extra sliding gasket on the sash maximizes window air and water tightness.</p> <p style="margin-left: 40px;">✓ PVC</p> <p style="margin-left: 40px;">✓ Two low-emission (heat-reflective) coatings which prevent heat loss in the winter</p> <p style="margin-left: 40px;">✓ Toughened external pane</p> <p style="margin-left: 40px;">✓ Two-ventilation-positions handle, based at the bottom of the sash</p> <p style="margin-left: 40px;">✓ Durable hinges with teflon-coated rollers</p> <p style="margin-left: 40px;">✓ manufactured in Europe&nbsp;at an ISO 9001 ISO 14001 and OHSAS 18001-certified production facility.</p> <p style="margin-left: 40px;">✓ Otside color: Grey RAL 7043</p> <p style="margin-left: 40px;">✓ Installation in roof pitch: 15-90°</p> <p style="margin-left: 40px;">✓ Warranty: 10 years</p> <p style="text-align: justify;"><strong>RoofLITE+</strong> &nbsp;is a dynamic international company which operates in many European markets. Together with Velux, Altaterra Kft is part of the VKR Group – a leading manufacturer of roof windows with 75-years of industry experience. The company offers roof windows for the economic market segment. They are able to produce high quality products at a good price as a result of reducing unnecessary costs associated with the supply chain, marketing and by simplifying the range of products offered.</p> <p style="text-align: justify;">&nbsp;</p> <p style="text-align: justify;"><strong>RoofLITE+</strong> is a brand of roof windows and accessories manufactured by the Scandinavian expert in loft and attic roof windows. RoofLITE+ roof windows are reliable and their thermal insulation and tightness are thoroughly tested in accordance with the latest European standards. They are also exceptionally good value. High-quality RoofLITE+ windows are covered by a 10-year warranty. The wood used to produce them comes from independently certified, sustainably managed forests. RoofLITE+ windows are also “good price offer”.</p> <h2>Flashing for roof window: Do I need it?</h2> <p><img src="/images/products/rooflite/arl_tfx_00w.jpg" style="margin: 15px; float: right;" /></p> <p style="text-align: justify;">The flashing frame is an indispensable element for the proper installation of a roof window in the roof. It drains rain and melt water around the window and also protects it from the wind. An absolutely tight connection between the roof window and the roof can only be guaranteed with the flashing.</p> <p style="text-align: justify;">There are four available flashings to Rooflite Windows:</p> <ul style="text-align: justify;"> <li><strong>TFX</strong>: Flashing for flat and low profiled roofing materials from 1,6 up to 5,0 cm height, perfect for:<br /> plain tiles, concrete tiles, profiled ceramic tiles, or even corrugated metal roofing</li> <li><strong>UFX</strong>: Flashing for high profiled roofing materials with a tile profile from 1,5 up to 12 cm height</li> <li><strong>SFX</strong>: Flashing for slates and flat roofing with a profile height of 0-16 mm (2x8mm), with one piece-side element. Perfect for various types of flat roofing materials, including slate and bituminous shingle.</li> <li><strong>SSX</strong>: Flashing suitable for standing seam steel sheet coverings.</li> </ul> <h2>Available sizes of TRIO PINE roof window:</h2> <div style="overflow-x:auto;"> <table> <tbody> <tr> <td style="text-align: center;" width="25%">RoofLITE+<br /> size code</td> <td style="text-align: center;" width="15%"><strong>C2A</strong></td> <td style="text-align: center;" width="15%"><strong>F6A</strong></td> <td style="text-align: center;" width="15%"><strong>M4A</strong></td> <td style="text-align: center;" width="15%"><strong>M6A</strong></td> <td style="text-align: center;" width="15%"><strong>M8A</strong></td> </tr> <tr> <td style="text-align: center;"><span style="font-size:12px;">size [cm]</span></td> <td style="text-align: center;">55x78</td> <td style="text-align: center;">66x118</td> <td style="text-align: center;">78x98</td> <td style="text-align: center;">78x118</td> <td style="text-align: center;">78x140</td> </tr> <tr style="text-align: center;"> <td colspan="6">Window dimension</td> </tr> <tr> <td style="text-align: center;"><span style="font-size:12px;">Width [mm]</span></td> <td style="text-align: center;">550</td> <td style="text-align: center;">660</td> <td style="text-align: center;">780</td> <td style="text-align: center;">780</td> <td style="text-align: center;">780</td> </tr> <tr> <td style="text-align: center;"><span style="font-size:12px;">Height [mm]</span></td> <td style="text-align: center;">778</td> <td style="text-align: center;">1178</td> <td style="text-align: center;">978</td> <td style="text-align: center;">1178</td> <td style="text-align: center;">1398</td> </tr> <tr style="text-align: center;"> <td colspan="6">Glass dimension</td> </tr> <tr> <td style="text-align: center;"><span style="font-size:12px;">Width [mm]</span></td> <td style="text-align: center;">373</td> <td style="text-align: center;">483</td> <td style="text-align: center;">603</td> <td style="text-align: center;">603</td> <td style="text-align: center;">603</td> </tr> <tr> <td style="text-align: center;"> <p><span style="font-size:12px;">Height [mm]</span></p> </td> <td style="text-align: center;">590</td> <td style="text-align: center;">990</td> <td style="text-align: center;">790</td> <td style="text-align: center;">990</td> <td style="text-align: center;">1210</td> </tr> <tr> <td style="text-align: right;"> <p style="text-align: center;"><span style="font-size:12px;">Glass surface [m<sup>2</sup>]</span></p> </td> <td style="text-align: center;"><span style="font-size:12px;">0,220</span></td> <td style="text-align: center;">0,478</td> <td style="text-align: center;">0,476</td> <td style="text-align: center;">0,597</td> <td style="text-align: center;">0,729</td> </tr> </tbody> </table> </div> ✓PVC ✓rooflite ✓tripple glazing ✓pivot ✓for bedroom, kitchen, bathroom ✓easy to clean ✓moist resistant ✓U-value 1.3 ✓excellent thermal insulation ✓check it out! PVC, pivot, 3-glass TRIO PVC roof window | byggbaY.se N N