Sandbox

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

Query time 0.00029

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
716	en	2	Remote controllers for FAKRO devices			<h2>Control devices for FAKRO Z-Wave / SOLAR products</h2> <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>				Remote controllers for FAKRO devices				N	N