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 = 'se' 
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
label2 #0b5394 #ffffff Y V 3-glasruta se
label3 #0b5394 #ffd966 Y U 4-glasruta se
label7 #cc0000 #ffffff Y X Elektriskt se
label5 #ff0000 #ffffff Y W nytt recept se
label1 #000000 #ffffff Y Z PVC se
label4 #351c75 #ffffff Y T Säkerhetsglas – invändigt se
label8 #cc0000 #ffd966 Y J Solar se
label9 #6aa84f #ffffff Y K Topphängt se
label10 #8e7cc3 #ffffff Y G Ventil se
label6 #6d9eeb #ffffff Y Q Vit se