SELECT 
  cscart_size_charts.size_chart_id, 
  cscart_size_charts.status, 
  cscart_size_charts.company_id, 
  cscart_size_chart_descriptions.content, 
  cscart_size_chart_descriptions.size_chart 
FROM 
  cscart_size_charts 
  LEFT JOIN cscart_size_chart_descriptions ON cscart_size_chart_descriptions.size_chart_id = cscart_size_charts.size_chart_id 
  AND cscart_size_chart_descriptions.lang_code = 'fr' 
WHERE 
  cscart_size_charts.size_chart_id = 1 
  AND cscart_size_charts.status IN ('A', 'H')

Query time 0.00025

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_size_charts system PRIMARY 1
1 SIMPLE cscart_size_chart_descriptions ALL 4 Using where

Result

size_chart_id status company_id content size_chart
1 A 0 <table> <tbody> <tr style="text-align: center;"> <td style="background: #ccc;">Largeur [cm]</td> <td colspan="1" rowspan="2" style="background: #ccc;">55</td> <td colspan="1" rowspan="2" style="background: #ccc;">66</td> <td colspan="1" rowspan="2" style="background: #ccc;">78</td> <td colspan="1" rowspan="2" style="background: #ccc;">94</td> <td colspan="1" rowspan="2" style="background: #ccc;">114</td> <td colspan="1" rowspan="2" style="background: #ccc;">134</td> </tr> <tr style="text-align: center;"> <td style="background: #999;">Hauteur [cm]</td> </tr> <tr style="text-align: center;"> <td style="background: #999;">70</td> <td style="text-align: top;"><strong>CK 01</strong></td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr style="text-align: center;"> <td style="background: #999;">78</td> <td><strong>CK 02</strong></td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr style="text-align: center;"> <td style="background: #999;">98</td> <td><strong>CK 04</strong></td> <td><strong>FK 04</strong></td> <td><strong>MK 04</strong></td> <td><strong>PK 04</strong></td> <td>&nbsp;</td> <td><strong>UK 04</strong></td> </tr> <tr style="text-align: center;"> <td style="background: #999;">118</td> <td><strong>CK 06</strong></td> <td><strong>FK 06</strong></td> <td><strong>MK 06</strong></td> <td><strong>PK 06</strong></td> <td><strong>SK 06</strong></td> <td>&nbsp;</td> </tr> <tr style="text-align: center;"> <td style="background: #999;">140</td> <td>&nbsp;</td> <td><strong>FK 08</strong></td> <td><strong>MK 08</strong></td> <td><strong>PK 08</strong></td> <td><strong>SK 08</strong></td> <td><strong>UK 08</strong></td> </tr> <tr style="text-align: center;"> <td style="background: #999;">160</td> <td>&nbsp;</td> <td>&nbsp;</td> <td><strong>MK 10</strong></td> <td><strong>PK 10</strong></td> <td><strong>SK 10</strong></td> <td><strong>UK 10</strong></td> </tr> <tr style="text-align: center;"> <td style="background: #999;">180</td> <td>&nbsp;</td> <td>&nbsp;</td> <td><strong>MK 12</strong></td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>&nbsp;</p> VELUX