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

Query time 0.00028

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
10967 en 2 Flashing for RoofLITE+ roof window <p><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;"><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><img src="/images/products/rooflite/arl_tfx_00w.jpg" style="margin: 15px;" /></h2> <h2>Flashing for roof window: Do I need it?</h2> <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. Flashing are avialable in <span style="font-size:11px;"></span><span style="font-size:14px;"></span><span style="font-size:12px;"></span> grey colour (RAL 7043).</p> <p style="text-align: justify;">There are four available flashings to Rooflite Windows:</p> <ul style="text-align: justify;"> <li><strong>LSX: </strong>Flashing for flat roofing materials up to 1,6 cm</li> <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>UCX13: </strong>Flashing for combi - 2 windows side by side only. For another combination of windows, please send us an inquairy.</li> </ul> <h2>&nbsp;</h2> Flashing for RoofLITE+ roof window | baubay.de N N