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

Query time 0.00030

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
414 en 2 Lintel <p style="text-align: justify;">Flat lintels are made of reinforced cellular concrete and used to execute load-bearing lintels in a building. Height of flat lintel beams is 125 mm. Maximal width of covered hole is 250cm. Depending of wall thickness, the elements are installed as single or multiple ones. In order to achieve a load-bearing lintel the elements should be extended by a layer of blocks.</p> <table border="1" cellpadding="0" cellspacing="0"> <tbody> <tr bgcolor="#cccccc"> <td colspan="3" style="text-align: center;"><strong>Dimension [mm]</strong></td> <td style="text-align: center;" width="150"><strong>Maximum opening</strong></td> </tr> <tr bgcolor="#cccccc" height="21"> <td style="text-align: center;" width="74"><strong>Length</strong></td> <td style="text-align: center;" width="63"><strong>Height</strong></td> <td style="text-align: center;" width="79"><strong>Thickness</strong></td> <td style="text-align: center;"><strong>[mm]</strong></td> </tr> <tr bgcolor="#f0f1ff"> <td style="text-align: center;">1300</td> <td rowspan="12"> <p style="text-align: center;">125</p> </td> <td rowspan="12"> <p style="text-align: center;"><strong>115</strong></p> </td> <td style="text-align: center;">900</td> </tr> <tr bgcolor="#f0f1ff"> <td style="text-align: center;">1500</td> <td style="text-align: center;">1100</td> </tr> <tr bgcolor="#f0f1ff"> <td style="text-align: center;">2000</td> <td style="text-align: center;">1500</td> </tr> <tr bgcolor="#f0f1ff"> <td style="text-align: center;">2500</td> <td style="text-align: center;">2000</td> </tr> <tr bgcolor="#f0f1ff"> <td style="text-align: center;">3000</td> <td style="text-align: center;">2500</td> </tr> </tbody> </table> <p>&nbsp;</p> <p><strong>Combination of 115mm and 175mm </strong><strong>lintels in different wall thicknesses.</strong></p> <table border="1" cellpadding="0" cellspacing="0" width="350"> <tbody> <tr bgcolor="#cccccc"> <td align="center"><strong>Wall</strong></td> <td colspan="2" style="text-align: center;"><strong>Lintel</strong></td> </tr> <tr bgcolor="#cccccc" height="21"> <td align="center"><strong>Thickness</strong></td> <td style="text-align: center;"><strong>115 mm </strong></td> <td style="text-align: center;"><strong>175 mm </strong></td> </tr> <tr bgcolor="#f0f1ff"> <td align="center">115 mm</td> <td style="text-align: center;">1x</td> <td style="text-align: center;">-</td> </tr> <tr bgcolor="#f0f1ff"> <td align="center">175 mm</td> <td style="text-align: center;">-</td> <td style="text-align: center;">1x</td> </tr> <tr bgcolor="#f0f1ff"> <td align="center">240 mm</td> <td style="text-align: center;">2x</td> <td style="text-align: center;">-</td> </tr> <tr bgcolor="#f0f1ff"> <td align="center">300 mm</td> <td style="text-align: center;">1x</td> <td style="text-align: center;">1x</td> </tr> <tr bgcolor="#f0f1ff"> <td align="center">365 mm</td> <td style="text-align: center;">-</td> <td style="text-align: center;">2x</td> </tr> <tr bgcolor="#f0f1ff"> <td align="center">420 mm</td> <td style="text-align: center;">2x</td> <td style="text-align: center;">1x</td> </tr> </tbody> </table> <p>&nbsp;</p> N N