Sandbox

SELECT 
  * 
FROM 
  cscart_ult_product_descriptions 
WHERE 
  product_id = 9870 
  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
9870	en	2	Telescopic pole control for roof windows and blinds			<h2>This telescopic pole is dedicated for operation of hard-to-reach roof windows and blinds. It will help you to ventilate rooms, where roof windows are installed high.</h2> <p style="text-align: justify;">If your roof windows are installed so high, that their operation is difficult, problematic and not comfortable - this product is perfect for you. Thanks to it you would be able to open and close the window standing on the floor. It's neat design allows for easy and comfortable usage. What's more - you don't need separate pole for high-mounted blinds! This product will deal with it too.</p> <p style="text-align: center;"><img alt="Operating rod for Rooflite roof windows" src="https://d2d2yzufo5fwh3.cloudfront.net/images/detailed/26/Bet%C3%A4tigungsstange_f%C3%BCr_Dachfenster.jpg?t=1635400867" style="height: 400px; width: 300px;" title="ZCA pole in handle operation" />        <img alt="Operating pole to blinds" src="https://d2d2yzufo5fwh3.cloudfront.net/images/detailed/26/Teleskop-Bet%C3%A4tigungsstange_f%C3%BCr_Dachfenster.jpg?t=1635400867" style="width: 300px; height: 400px;" title="ZCA pole in blind's operation" /></p> <p style="text-align: justify;">Properties:</p> <ul> <li><strong>Adjustable length: 100-180 cm</strong></li> <li><strong>4 stop-positions</strong></li> <li>Easy operation: choose one of 4 stop-positions and hook the grip to the window's handle or blind's operation bar</li> <li>Perfect for roof windows mounted in staircases, high rooms, halls</li> <li>Rubber, non-slip grip</li> <li>Compatible with <strong><a href="https://www.baubay.de/sonnenschutz-and-rollladen-en/fur-andere-dachfenster-en/?features_hash=75-6264-6265">Dakstra, DAKEA </a>and <a href="https://www.baubay.de/roof-windows/?features_hash=13-6131">RoofLITE+</a> roof windows</strong></li> <li>Compatible with Dakstra, DAKEA, <a href="https://www.baubay.de/sonnenschutz-and-rollladen-en/fur-andere-dachfenster-en/?features_hash=75-6266"><strong>RoofLITE+ blackout blinds</strong></a></li> <li>Other compatible brands: <strong>Aron, Artens, Luxtra,</strong> <strong>Balio, Magnetic, Aveline, Tyrem, Solstro, Luminatec roof windows and blinds</strong></li> <li>Please note that this telescopic pole <u>is not compatible with other roof windows and blinds</u></li> </ul> <p style="text-align: center;"><img alt="Telescopic pole fr high-installed Rooflite roof windows" src="https://d2d2yzufo5fwh3.cloudfront.net/images/detailed/26/Griff_der_Teleskop-Bet%C3%A4tigungsstange_f%C3%BCr_Dachfenster_.jpg?t=1635400867" style="width: 300px; height: 300px;" title="Anti-slip grip" />            <img alt="Telescopic pole for high-installed blinds" src="https://domshop.pl/?attachment_id=63707#main" style="width: 300px; height: 300px;" title="Head compatible with window's handle and blind's operating bar" /></p> <h2>How to check the window's producer?</h2> <p style="text-align: justify;">Each roof window has a nameplate placed on the sash, where you can find the producer's name, size, serial number. Just open the window and find the nameplate.</p> <p style="text-align: justify;">If you can't localize the nameplate, or you are not sure how to read it properly - <a href="http://info@baubay.de">contact us</a>. We will gladly help.</p> <p style="text-align: justify;"> </p> <p style="text-align: center;"><img alt="How to check wjhat size does my roof window have" src="https://d2d2yzufo5fwh3.cloudfront.net/images/products/rooflite/Nameplate%20rooflite.PNG" title="Nameplate of RooLITE and DAKSTRA roof windows" /></p>	telescopic pole, operating rod, operating pole, high roof windows	Problem with out-of-reach roof windows? This pole will help you to open and close even high-installed roof windows. 4 stop-positions, specially designed grip and length up to 180 cm make it usage easy anc comfortable! check it now!		Telescopic pole for Dakstra, DAKEA, RoofLITE+ roof windows and blinds \| baubaY.de				N	N