SELECT 
  a.code, 
  b.state 
FROM 
  cscart_states as a 
  LEFT JOIN cscart_state_descriptions as b ON b.state_id = a.state_id 
  AND b.lang_code = 'tr' 
WHERE 
  a.country_code = 'TR' 
ORDER BY 
  b.state

Query time 0.02059

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a ref cs,country_code cs 8 const 47 Using index condition; Using temporary; Using filesort
1 SIMPLE b eq_ref PRIMARY PRIMARY 9 hobilifedt.a.state_id,const 1 Using where

Result

code state
1 ADANA
2 ADIYAMAN
3 AFYON
4 AĞRI
68 AKSARAY
5 AMASYA
6 ANKARA
7 ANTALYA
75 ARDAHAN
8 ARTVİN
9 AYDIN
10 BALIKESİR
74 BARTIN
72 BATMAN
69 BAYBURT
11 BİLECİK
12 BİNGÖL
13 BİTLİS
14 BOLU
15 BURDUR
16 BURSA
17 ÇANAKKALE
18 ÇANKIRI
19 ÇORUM
20 DENİZLİ
21 DİYARBAKIR
81 DÜZCE
22 EDİRNE
23 ELAZIĞ
24 ERZİNCAN
25 ERZURUM
26 ESKİŞEHİR
27 GAZİANTEP
28 GİRESUN
29 GÜMÜŞHANE
30 HAKKARİ
31 HATAY
76 IĞDIR
32 ISPARTA
34 İSTANBUL
35 İZMİR
46 K.MARAŞ
78 KARABÜK
70 KARAMAN
36 KARS
37 KASTAMONU
38 KAYSERİ
79 KİLİS
71 KIRIKKALE
39 KIRKLARELİ
40 KIRŞEHİR
41 KOCAELİ
42 KONYA
43 KÜTAHYA
44 MALATYA
45 MANİSA
47 MARDİN
33 MERSİN(İÇEL)
48 MUĞLA
49 MUŞ
50 NEVŞEHİR
51 NİĞDE
52 ORDU
80 OSMANİYE
53 RİZE
54 SAKARYA
55 SAMSUN
63 ŞANLIURFA
56 SİİRT
57 SİNOP
73 ŞIRNAK
58 SİVAS
59 TEKİRDAĞ
60 TOKAT
61 TRABZON
62 TUNCELİ
64 UŞAK
65 VAN
77 YALOVA
66 YOZGAT
67 ZONGULDAK