Sandbox

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 (8295, 1310, 1311) 
  AND cscart_ult_product_descriptions.company_id = 1 
  AND cscart_ult_product_descriptions.lang_code = 'en'

Query time 0.00035

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	full_description	meta_keywords	meta_description
1310
1311
8295	<h2 style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 20px 0px 10px; color: rgb(0, 136, 204); font-size: 24px; font-family: "Source Sans Pro", "Helvetica Neue", "Lucida Grande", sans-serif; padding: 5px 0px; position: relative; line-height: 1.26; border-bottom: 1px solid rgb(217, 219, 221);">Insect screen for roof windows - reliable protection against insects</h2> <p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-family: "Open Sans", sans-serif; font-size: 15px; margin: 0px; padding: 6px 0px; text-align: justify;">Spring and summertime tempt us to open our windows more often and enjoy the warm air. But with fresh air come also small creatures that are not necessarily welcome in our homes, especially in the bedroom. We have a reliable solution for this. Thanks to the <strong style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);">insect screen</strong>, from now it is possible to rest well on warm nights with the roof window open without mosquitoes and co. robbing us of our sleep.<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);" /> <br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);" /> This product fits most available roof window brands: FAKRO, VELUX, OptiLIGHT, RoofLITE +, DAKEA, DAKSTRA, KEYLITE, STARLITE, MAGNETIC, BALIO, SOLSTRO, IMFENSTER, AURA, RoofART, AVALINE, ROTO. It is the only accessory that is attached to the inner lining and not to the window sash. Thus it protects against annoying insects even when the window is open.</p> <p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-family: "Open Sans", sans-serif; font-size: 15px; margin: 0px; padding: 6px 0px; text-align: justify;"><img alt="Insect screen for roof windows" src="https://d2d2yzufo5fwh3.cloudfront.net/images/products/rooflite/zia/Moustiquaire_pour_fen%C3%AAtre_de_toit_.jpg?1635408820596" /></p> <p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-family: "Open Sans", sans-serif; font-size: 15px; margin: 0px; padding: 6px 0px; text-align: justify;"> </p> <h2 style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 20px 0px 10px; color: rgb(0, 136, 204); font-size: 24px; font-family: "Source Sans Pro", "Helvetica Neue", "Lucida Grande", sans-serif; padding: 5px 0px; position: relative; line-height: 1.26; border-bottom: 1px solid rgb(217, 219, 221);">Product design and its operation</h2> <p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-family: "Open Sans", sans-serif; font-size: 15px; margin: 0px; padding: 6px 0px; text-align: justify;">In contrast to simple self-adhesive fly screens, Rooflite+ insect screens are made of high-quality aluminum frames in combination with hard-wearing functional net fabrics. This high-quality fine-meshed black fabrics keeps insects away, but still let pass a lot of light and air. The aluminum side rails allow the insect screen to open and close smoothly. When not in use, it's conveniently stowed away in the top casing, so it does not have to be removed after the season. This product is manually operated - simply grab the control bar and pull it up or down.<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);" /> <br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);" /> By large or high-mounted roof windows, the insect net can be operated with a special telescopic operation rod, which you can purchase in our online shop</p> <h2 style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 20px 0px 10px; color: rgb(0, 136, 204); font-size: 24px; font-family: "Source Sans Pro", "Helvetica Neue", "Lucida Grande", sans-serif; padding: 5px 0px; position: relative; line-height: 1.26; border-bottom: 1px solid rgb(217, 219, 221);">Size and installation of insect screens for roof windows</h2> <p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-family: "Open Sans", sans-serif; font-size: 15px; margin: 0px; padding: 6px 0px; text-align: justify;">The product offered is ready for installation and has all the necessary elements.<br style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);" /> It is available in different sizes. Using the illustration below, measure the width and height of the window opening on which the insect screen is to be mounted and use these measurements to select the appropriate size. Insect screens are mounted on the wall and not on the window frame!</p> <p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-family: "Open Sans", sans-serif; font-size: 15px; margin: 0px; padding: 6px 0px; text-align: justify;">When measuring, make sure that there are no differences in height of the opposite walls.</p> <p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-family: "Open Sans", sans-serif; font-size: 15px; margin: 0px; padding: 6px 0px; text-align: justify;"><img alt="Fitting the insect screen" src="https://d2d2yzufo5fwh3.cloudfront.net/images/products/rooflite/zia/insect_screen_montage_tips.png?1635415698481" /></p> <p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-family: "Open Sans", sans-serif; font-size: 15px; margin: 0px; padding: 6px 0px; text-align: justify;"> </p> <p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-family: "Open Sans", sans-serif; font-size: 15px; margin: 0px; padding: 6px 0px; text-align: justify;"><em style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);">If in doubt, please contact us by phone or email (info@baubay.de) we will help you choose the right size.</em></p> <h2 style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 20px 0px 10px; color: rgb(0, 136, 204); font-size: 24px; font-family: "Source Sans Pro", "Helvetica Neue", "Lucida Grande", sans-serif; padding: 5px 0px; position: relative; line-height: 1.26; border-bottom: 1px solid rgb(217, 219, 221);">Universal product</h2> <p style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-family: "Open Sans", sans-serif; font-size: 15px; margin: 0px; padding: 6px 0px; text-align: justify;">This insect screen is truly a <strong style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);">universal product</strong> that is ideal for any room in the home or office and does not interfere with any other window accessory, thanks to the fact that it is mounted on the wall and not on the window. It works perfectly in combination with, among others: blackout blinds, venetian blinds, awnings, etc. It is suitable for rooms such as:</p> <ul style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-right: 0px; padding-left: 20px; margin: 0px; list-style: none; font-family: "Open Sans", sans-serif;"> <li style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-size: 15px; margin: 0px; padding: 2px 0px; list-style-position: initial; list-style-image: initial; list-style-type: inherit; text-align: justify;">Bedroom,</li> <li style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-size: 15px; margin: 0px; padding: 2px 0px; list-style-position: initial; list-style-image: initial; list-style-type: inherit; text-align: justify;">Livingroom,</li> <li style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-size: 15px; margin: 0px; padding: 2px 0px; list-style-position: initial; list-style-image: initial; list-style-type: inherit; text-align: justify;">Children's room,</li> <li style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-size: 15px; margin: 0px; padding: 2px 0px; list-style-position: initial; list-style-image: initial; list-style-type: inherit; text-align: justify;">Kitchen,</li> <li style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-size: 15px; margin: 0px; padding: 2px 0px; list-style-position: initial; list-style-image: initial; list-style-type: inherit; text-align: justify;">Bathroom,</li> <li style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-size: 15px; margin: 0px; padding: 2px 0px; list-style-position: initial; list-style-image: initial; list-style-type: inherit; text-align: justify;">Home Office.</li> </ul> <h2 style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); margin: 20px 0px 10px; color: rgb(0, 136, 204); font-size: 24px; font-family: "Source Sans Pro", "Helvetica Neue", "Lucida Grande", sans-serif; padding: 5px 0px; position: relative; line-height: 1.26; border-bottom: 1px solid rgb(217, 219, 221);">The most important features of the insect screen</h2> <ul style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); padding-right: 0px; padding-left: 20px; margin: 0px; list-style: none; font-family: "Open Sans", sans-serif;"> <li style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-size: 15px; margin: 0px; padding: 2px 0px; list-style-position: initial; list-style-image: initial; list-style-type: inherit; text-align: justify;">100% insect-proof with the roof window open,</li> <li style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-size: 15px; margin: 0px; padding: 2px 0px; list-style-position: initial; list-style-image: initial; list-style-type: inherit; text-align: justify;">Easy to install and operate,</li> <li style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-size: 15px; margin: 0px; padding: 2px 0px; list-style-position: initial; list-style-image: initial; list-style-type: inherit; text-align: justify;">Can be completely opened or closed (no disassembly necessary after summer season),</li> <li style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-size: 15px; margin: 0px; padding: 2px 0px; list-style-position: initial; list-style-image: initial; list-style-type: inherit; text-align: justify;">Infinitely adjustable,</li> <li style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-size: 15px; margin: 0px; padding: 2px 0px; list-style-position: initial; list-style-image: initial; list-style-type: inherit; text-align: justify;">Light and air permeable net fabrics,</li> <li style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-size: 15px; margin: 0px; padding: 2px 0px; list-style-position: initial; list-style-image: initial; list-style-type: inherit; text-align: justify;">Manually operated with a control bar,</li> <li style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-size: 15px; margin: 0px; padding: 2px 0px; list-style-position: initial; list-style-image: initial; list-style-type: inherit; text-align: justify;">Works with suitable telescopic operating rod, for large or high installed windows</li> <li style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-size: 15px; margin: 0px; padding: 2px 0px; list-style-position: initial; list-style-image: initial; list-style-type: inherit; text-align: justify;">Can be combined with any accessories for roof windows.</li> </ul>	fait de matériaux de haute qualité, tissu filet durable et transparent, facile à nettoyer, permet d'ouvrir la fenêtre tout en se protégeant des insectes, permet de profiter de la vue sur l’extérieur et de l’air frais, installation à l'envers possible sur	Fabriquée à partir de matériaux de haute qualité, est durable et pratique. Elle compléte la fenêtre de toit. Même en position complètement abaissée, elle vous permet d'ouvrir la fenêtre sans bloquer la ventilation et le flux d'air sans être dérangé par le