SELECT 
  cscart_sd_labels_custom.*, 
  cscart_sd_labels_custom_descriptions.* 
FROM 
  cscart_sd_labels_custom 
  LEFT JOIN cscart_sd_labels_custom_descriptions ON cscart_sd_labels_custom_descriptions.label_code = cscart_sd_labels_custom.label_code 
  AND cscart_sd_labels_custom_descriptions.lang_code = 'en' 
WHERE 
  1 
  AND cscart_sd_labels_custom.used = 'Y' 
ORDER BY 
  cscart_sd_labels_custom_descriptions.name asc

Query time 0.00033

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_sd_labels_custom ALL 10 Using where; Using temporary; Using filesort
1 SIMPLE cscart_sd_labels_custom_descriptions eq_ref PRIMARY PRIMARY 56 mahm3t_cs443.cscart_sd_labels_custom.label_code,const 1 Using where

Result

label_code background_color text_color used filter_key name lang_code
label7 #cc0000 #ffffff Y X Elektro en
label4 #351c75 #ffffff Y T Laminated inter glass en
label10 #8e7cc3 #ffffff Y G Natural air inlet en
label5 #ff0000 #ffffff Y W New recipe en
label3 #0b5394 #ffd966 Y U Passive en
label1 #000000 #ffffff Y Z PVC en
label8 #cc0000 #ffd966 Y J Solar en
label9 #6aa84f #ffffff Y K Top-hung en
label2 #0b5394 #ffffff Y V Triple glazed en
label6 #6d9eeb #ffffff Y Q White en