SELECT 
  * 
FROM 
  cscart_ult_product_descriptions 
WHERE 
  product_id = 10013 
  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
10013 en 2 FAKRO AMZ SOLAR | solar-powered awnign blind for FAKRO roof windows ✓ OptiLight ✓ ARON ✓ ARTENS <h2>AMZ: awning blind for Fakro centre-pivot and top-hung-and-pivot roof windows</h2> <p style="text-align: justify;">The awning blind provides optimum protection from overheating while, at the same time providing a view to the outside. Fakro awning blind reflects sun rays before they reach the glass and thus protects against heat build-up on sunny days, providing relief for the eyes and protection from the harmful effects of strong reflected light, which is especially important when working with computers.</p> <p style="text-align: center;"><img alt="" src="/images/products/fakro_amz_all_3_en.jpg" style="width: 500px; height: 100px;" /></p> <p style="text-align: justify;">The awning blind<strong> AMZ</strong>&nbsp;is made of durable, weather- resistant fibre glass fabric. The fabric is roller mounted, spring loaded and fitted inside an aluminium casing which is installed at the top of the window. This enables easy control of the blind and makes it possible to use a wider fabric, thus providing additional protection against ingress of light.</p> <p style="text-align: center;"><img alt="" src="/images/products/fakro_amz_heat_protection_en.jpg" style="width: 500px; height: 201px;" /></p> <h2>Important information</h2> <ul style="text-align: justify; background: #00cc99"> <li>Awning blind <strong>AMZ Solar</strong> is designed for centre-pivot and top-hung-and-pivot windows.</li> <li><strong>AMZ Solar</strong> is powered by solar batteries</li> <li><strong>The remote control is not included</strong>.</li> </ul> <h2>Characteristic:</h2> <ul style="text-align: justify;"> <li>the best protection from the heat;</li> <li>effective shading of the room whilst still allowing some light in;</li> <li>comfortable use – we can cover the window for a whole summer without the need to roll it up and down every day;</li> <li>easy installation – we install the blind from the inside (unscrew four screws and then rescrew them again in the same holes);</li> <li>protection from harmful UV radiation,when used in rainy weather, reduces noise of rain and hailstones.</li> </ul> <h2>Size</h2> <table border="1" bordercolor="#00cc99" rules="typ"> <tbody> <tr> <td colspan="2" rowspan="1" style="text-align: center;"><strong>Warning!</strong></td> </tr> <tr> <td style="text-align: justify; width: 312px; height: 142px;">The size of e.g. 78x140 cm applies to roof window's size! The blind itself is smaller. Window's size can be found on the nameplate located at the top of the window. There is no need to measeure the window. Just read the size from the nameplate and order accessories in the corresponding size.</td> <td style="text-align: justify; width: 188px; height: 142px;"><img alt="" src="images/products/fakro_nameplate_animated.gif" /></td> </tr> </tbody> </table> <h2>Available fabrics of awning blind for FAKRO roof windows:</h2> <ul style="text-align: justify;"> <li>relative fabric transparency = 10%</li> </ul> <center> <p style="text-align: center;"><img alt="" src="/images/products/fakro/sun_prot/amz/fakro_amz_gr1.jpg" /></p> </center> <ul style="text-align: justify;"> <li>relative fabric transparency = 1%</li> </ul> <center> <p style="text-align: center;"><img alt="" src="/images/products/fakro/sun_prot/amz/fakro_amz_gr2.jpg" /></p> </center> <h2>Control devices for FAKRO Z-Wave / SOLAR products</h2> <h3>Kindly note: the product is sold separately!</h3> <p style="text-align: justify;">The products listed below are not delivered with a roof window, shutters or blinds. They are sold separately so that each customer can choose the product that best suits their needs.</p> <div style="overflow-x:auto;"> <table> <tbody> <tr> <td style="text-align: right;" width="20%">Product name:</td> <td style="text-align: center;" width="20%"><strong>ZRH1</strong></td> <td style="text-align: center;" width="20%"><strong>ZRH12</strong></td> <td style="text-align: center;" width="20%"><strong>ZRW7</strong></td> <td style="text-align: center;" width="20%"><strong>ZRS24</strong></td> </tr> <tr> <td style="text-align: right;">Device type:</td> <td style="text-align: center;">one-channel remote control</td> <td style="text-align: center;">multi-channel remote control</td> <td style="text-align: center;">wireless, multi-channel wall keyboard</td> <td style="text-align: center;">multi-channel remote control</td> </tr> <tr> <td style="text-align: right;">-</td> <td style="text-align: center;"><img src="/images/products/fakro/electric/fakro_ZRH1.png" /></td> <td style="text-align: center;"><img src="/images/products/fakro/electric/fakro_ZRH12.jpg" /></td> <td style="text-align: center;"><img src="/images/products/fakro/electric/fakro_ZWR7.jpg" /></td> <td style="text-align: center;"><img src="/images/products/fakro/electric/fakro_ZRS24.jpg" /></td> </tr> <tr> <td style="text-align: right;">Compatibility with FAKRO Z-WAVE products:</td> <td style="text-align: center;"><span style="color: green;"><big>✓</big></span></td> <td style="text-align: center;"><span style="color: green;"><big>✓</big></span></td> <td style="text-align: center;"><span style="color: green;"><big>✓</big></span></td> <td style="text-align: center;"><span style="color: green;"><big>✓</big></span></td> </tr> <tr> <td style="text-align: right;">Compatibility with FAKRO SOLAR products:</td> <td style="text-align: center;"><span style="color: green;"><big>✓</big></span></td> <td style="text-align: center;"><span style="color: green;"><big>✓</big></span></td> <td style="text-align: center;"><span style="color: green;"><big>✓</big></span></td> <td style="text-align: center;"><span style="color: green;"><big>✓</big></span></td> </tr> <tr> <td style="text-align: right;">Amount of supported devices:</td> <td style="text-align: center;">up to 12 devices in one group</td> <td style="text-align: center;">do 12 urządzeń w każdej z 12 grup</td> <td style="text-align: center;">up to 12 devices in each of the 7 groups</td> <td style="text-align: center;">up to 24 devices in each of the 24 groups</td> </tr> <tr> <td style="text-align: right;">"PLACE" function:</td> <td style="text-align: center;"><span style="color: red;"><big>✕</big></span></td> <td style="text-align: center;"><span style="color: red;"><big>✕</big></span></td> <td style="text-align: center;"><span style="color: red;"><big>✕</big></span></td> <td style="text-align: center;"><span style="color: green;"><big>✓</big></span><br /> up to 24 devices in each of the 24 places</td> </tr> <tr> <td style="text-align: right;">"SCENE" function:</td> <td style="text-align: center;"><span style="color: red;"><big>✕</big></span></td> <td style="text-align: center;"><span style="color: red;"><big>✕</big></span></td> <td style="text-align: center;"><span style="color: red;"><big>✕</big></span></td> <td style="text-align: center;"><span style="color: green;"><big>✓</big></span><br /> up to 24 sceens</td> </tr> <tr> <td colspan="5" style="text-align: center;">Appearance information</td> </tr> <tr> <td style="text-align: right;">Available in white:</td> <td style="text-align: center;"><span style="color: green;"><big>✓</big></span></td> <td style="text-align: center;"><span style="color: green;"><big>✓</big></span></td> <td style="text-align: center;"><span style="color: green;"><big>✓</big></span></td> <td style="text-align: center;"><span style="color: green;"><big>✓</big></span></td> </tr> <tr> <td style="text-align: right;">Available in black:</td> <td style="text-align: center;"><span style="color: red;"><big>✕</big></span></td> <td style="text-align: center;"><span style="color: green;"><big>✓</big></span></td> <td style="text-align: center;"><span style="color: red;"><big>✕</big></span></td> <td style="text-align: center;"><span style="color: green;"><big>✓</big></span></td> </tr> <tr> <td style="text-align: right;">Dimensions:</td> <td style="text-align: center;">48x125x17 mm</td> <td style="text-align: center;">48x125x17 mm</td> <td style="text-align: center;">80x80x20 mm</td> <td style="text-align: center;">52x180x20 mm</td> </tr> <tr> <td colspan="5" style="text-align: center;">Technical data</td> </tr> <tr> <td style="text-align: right;">LCD display:</td> <td style="text-align: center;">-</td> <td style="text-align: center;">-</td> <td style="text-align: center;">-</td> <td style="text-align: center;">240x320 px</td> </tr> <tr> <td style="text-align: right;">Radio protocol:</td> <td style="text-align: center;">Z-Wave</td> <td style="text-align: center;">Z-Wave</td> <td style="text-align: center;">Z-Wave</td> <td style="text-align: center;">Z-Wave</td> </tr> <tr> <td style="text-align: right;">Power supply:</td> <td style="text-align: center;">2x batteries AAA</td> <td style="text-align: center;">2x batteries AAA</td> <td style="text-align: center;">4x batteries AAA</td> <td style="text-align: center;">3x batteries AKU AAA</td> </tr> <tr> <td style="text-align: right;">USB charging possible:</td> <td style="text-align: center;"><span style="color: red;"><big>✕</big></span></td> <td style="text-align: center;"><span style="color: red;"><big>✕</big></span></td> <td style="text-align: center;"><span style="color: red;"><big>✕</big></span></td> <td style="text-align: center;"><span style="color: green;"><big>✓</big></span></td> </tr> <tr> <td style="text-align: right;">Working temperature:</td> <td style="text-align: center;">from +5°C to +40°C</td> <td style="text-align: center;">from +5°C to +40°C</td> <td style="text-align: center;">from 0°C to +40°C</td> <td style="text-align: center;">from +5°C to +40°C</td> </tr> </tbody> </table> </div> <p style="text-align:center"><strong>Finding out the right size</strong></p><p style="text-align:center"><img src="/images/products/fakro_nameplate_animated.gif" /></p><p style="text-align:center"><small>The size (e.g. 78/118) refers to the outer dimensions of the roof window! The blind itself is smaller.</small></p> N N