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 (9854, 10012, 10011) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00059

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

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
9854 <p style="text-align: justify;"><strong>Finally pleasant coolness during the summer! This electric-powered awning blind provides solar heat reduction whilst ensuring you will maintain the view through your roof window.</strong><br /> Especially suited to south-facing roof windows, the blind stops the heat from the sun reaching the glass and radiating into the room. Their design also means they allow a pleasant diffused light to enter the room too.<br /> Designed to integrate perfectly with your VELUX roof window, the awning blind is made from weather resistant net fabric. When not in use, the external blind rolls up and is kept out of sight.<br /> <br /> <strong>Your benefits:</strong></p> <ul style="text-align: justify;"> <li>Heat reduction: Up to 72%</li> <li>Does not limit the view</li> <li>Good quality fabric: weather resistant and easy for cleaning</li> <li>Easy to install and operating from inside the room</li> </ul> <p><strong><span style="color:#FF0000;"><span style="background-color:#FFD700;">For roof windows manufactured before April 2001 you must also order ZOZ 228 to fit MML electric awning blinds.</span></span></strong></p> <p class="hd1"><b><i>How to select your blinds</i></b></p> <ol> <li><b>Select the blind</b>: Chose a product based on your room type and your needs;</li> <li><b>Select the colour</b>: All fabrics are marked with colour code, choose the one that matches your style;</li> <li><b>Select the operation</b>: Depending on your needs you can choose between manual operation, remote controlled electric or solar powered operation;</li> <li><b>Select the right size</b>: To identify your window size, check your window's data plate which details the type and size of your window (see video below).</li> </ol> <p><iframe allowfullscreen="" frameborder="0" height="360" src="https://www.youtube.com/embed/QN_m3aicwao" width="640"></iframe></p> ✓anit-heat blind ✓warmth control ✓lower temperature in the room ✓no view limit ✓no more heat in the attic! ✓check it right now!
10011 <h2>FAKRO awning blinds compatible with FAKRO FEP, FKP and FKU roof windows</h2> <p style="text-align: justify;">The awning blinds <strong>FAKRO AME</strong> &amp; <strong>FAKRO AMK</strong> 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 blinds<strong> FAKRO AME &amp; FAKRO AMK </strong>are 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. To control the blind an 80cm long rod is supplied in package. There is also available a rod ZSZ which is 150 cm long.</p> <p style="text-align: center;"><img alt="" src="/images/products/fakro_amz_heat_protection_en.jpg" style="width: 500px; height: 201px;" /></p> <h2>Advantages of the awning blind for FAKRO roof windows</h2> <h4>✓ the best protection from the heat</h4> <h4>✓ effective shading of the room whilst still allowing some light in</h4> <h4>✓ comfortable use – we can cover the window for a whole summer without the need to roll it up and down every day</h4> <h4>✓ easy installation – we install the blind from the inside (unscrew four screws and then rescrew them again in the same holes)</h4> <h4>✓ protection from harmful UV radiation,when used in rainy weather, reduces noise of rain and hailstones</h4> <p style="text-align: center;"><img alt="" src="/images/products/fakro_temp_en.jpg" style="width: 618px; height: 417px;" /></p> <h2>How to choose the right awning blind for my FAKRO roof window?</h2> <h4>Make sure that you know type of your FAKRO roof window</h4> <p style="text-align: justify; background: #eee">Awning blinds <strong>AME/AMK</strong> can be installed only on top-hung roof windows FAKRO FEP, FAKRO FKP and FAKRO FKU. For centre-pivot windows and top-hung-and-pivot windows FAKRO provides <a href="index.php?dispatch=products.view&amp;product_id=7353" style="color:#FF8C00;">awning blind FAKRO AMZ</a>.</p> <h4>Make sure that you know size of your FAKRO roof window</h4> <p><img align="right" alt="" src="images/products/fakro_nameplate_animated.gif" /></p> <p style="text-align: justify;">The size of e.g. 78x118 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.</p> <h2>Awning blind for FAKRO roof window: fabric</h2> <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> <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>
10012 <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. To control the blind an 80cm long rod is supplied in package. There is also available a rod ZSZ which is 150 cm long.</p> <p style="text-align: center;"><img alt="" src="/images/products/fakro_amz_heat_protection_en.jpg" style="width: 500px; height: 201px;" /></p> <h2>Z-Wave: wireless control system</h2> <p style="text-align: justify;">Fakro has equipped its products with a radio communication system named <strong>Z-Wave</strong>. This is a wireless protocol used for communication between household appliances which allows you to create a single network by combining a range of electrical devices such as: lighting, thermostats, alarms, computers, telephones, air conditioning and electric windows and blinds. Currently, there are over 200 manufacturers of electric household devices associated in the Z-Wave system (amongst others: Intel, Panasonic, Apple, General Electric).</p> <h2>Important information</h2> <ul style="text-align: justify; background: #00cc99"> <li>Awning blind <strong>AMZ Z-Wave</strong> is designed for centre-pivot and top-hung-and-pivot windows.</li> <li><strong>AMZ Z-Wave</strong> electrically controlled by remote control or by wall switch but in an emergency, the awning blind can be controlled by service button located on the awning blind.</li> <li>To use <strong>AMZ Z-Wave</strong> on a manual (not Z-Wave) window, power supply and control units have to be bought separately.</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> <h2>Installation how-to-video</h2> <p><iframe allowfullscreen="" frameborder="0" height="360" src="https://www.youtube.com/embed/Ymwl9Y7zmM4?feature=player_detailpage" width="640"></iframe></p> <p>&nbsp;</p> <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>