SELECT 
  sd.param_id, 
  sd.param, 
  cscart_static_data_descriptions.descr, 
  sd.param_2, 
  sd.param_3, 
  sd.param_4, 
  sd.param_5, 
  sd.param_6, 
  sd.status, 
  sd.position, 
  sd.parent_id, 
  sd.id_path, 
  sd.class 
FROM 
  cscart_static_data AS sd 
  LEFT JOIN cscart_static_data_descriptions ON sd.param_id = cscart_static_data_descriptions.param_id 
  AND cscart_static_data_descriptions.lang_code = 'en' 
WHERE 
  sd.section = 'A' 
  AND sd.status = 'A' 
  AND sd.param_5 = '3' 
ORDER BY 
  sd.position

Query time 0.00054

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE sd ref section section 6 const,const 120 Using index condition; Using where; Using filesort
1 SIMPLE cscart_static_data_descriptions eq_ref PRIMARY PRIMARY 9 toolboxdigitalshop_dev.sd.param_id,const 1 Using where

Result

param_id param descr param_2 param_3 param_4 param_5 param_6 status position parent_id id_path class
175 index.php?dispatch=categories.view&category_id=83 T-Shirts 3 A 0 174 52/174/175
176 index.php?dispatch=categories.view&category_id=84 Baby Vests 3 A 0 174 52/174/176
89 index.php?dispatch=categories.view&category_id=44 Mens Clothing 3 A 1 52 52/89
162 http://www.toolboxdigitalshop.com/podcasts.html Podcasts 3 A 1 161 161/162
57 index.php?dispatch=categories.view&category_id=45 Womens Clothing 3 A 2 52 52/57
179 http://www.toolboxdigitalshop.com/essential-hard-house-mixes.html 'Essential Hard House' DJ Mixes 3 A 2 161 161/179
115 http://www.toolboxdigitalshop.com/live-stream.html Live Stream Feed 3 A 3 161 161/115
163 http://www.toolboxdigitalshop.com/live-streams.html Past Live Streams 3 A 4 161 161/163
173 index.php?dispatch=categories.view&category_id=48 Hoodies 3 A 4 52 52/173
109 index.php?dispatch=categories.view&category_id=71 DJ Charts 3 A 5 85 85/109
171 index.php?dispatch=categories.view&category_id=81 Slipmats 3 A 5 52 52/171
103 index.php?dispatch=categories.view&category_id=69 Mugs 3 A 6 52 52/103
61 index.php?dispatch=categories.view&category_id=52 Hats 3 A 8 52 52/61
64 index.php?dispatch=gift_certificates.add Gift Certificates 3 A 9 52 52/64
40 index.php?dispatch=categories.view&category_id=6 Exclusive 3 A 10 0 40
43 index.php?dispatch=categories.view&category_id=4 Hard House 3 A 10 42 42/43
58 index.php?dispatch=categories.view&category_id=47 T-Shirts 3 A 10 57 52/57/58
72 index.php?dispatch=categories.view&category_id=17 Hard Dance 3 A 10 49 49/72
77 index.php?dispatch=categories.view&category_id=36 Top 10 3 A 10 43 42/43/77
78 index.php?dispatch=categories.view&category_id=37 Top 10 3 A 10 44 42/44/78
79 index.php?dispatch=categories.view&category_id=38 Top 10 3 A 10 45 42/45/79
80 index.php?dispatch=categories.view&category_id=39 Top 10 3 A 10 46 42/46/80
82 index.php?dispatch=categories.view&category_id=42 Top 10 3 A 10 48 42/48/82
84 index.php?dispatch=categories.view&category_id=35 Top 10 3 A 10 40 40/84
90 index.php?dispatch=categories.view&category_id=46 T-Shirts 3 A 10 89 52/89/90
104 index.php?dispatch=categories.view&category_id=61 CD's 3 A 10 99 99/104
110 index.php?dispatch=categories.view&category_id=72 Bundles 3 A 10 85 85/110
111 index.php?dispatch=categories.view&category_id=74 Sample Packs 3 A 10 51 51/111
102 index.php?dispatch=categories.view&category_id=68 Label Back Catalogue Bundles 3 A 15 85 85/102
41 https://www.toolboxdigitalshop.com/top-100.html Top 100 3 A 20 0 41
44 index.php?dispatch=categories.view&category_id=1 Hard Dance 3 A 20 42 42/44
65 index.php?dispatch=categories.view&category_id=29 Bounce 3 A 20 43 42/43/65
67 index.php?dispatch=categories.view&category_id=28 Tech Dance 3 A 20 44 42/44/67
68 index.php?dispatch=categories.view&category_id=31 German Trance 3 A 20 45 42/45/68
70 index.php?dispatch=categories.view&category_id=33 Gabba 3 A 20 46 42/46/70
73 index.php?dispatch=categories.view&category_id=18 Hard House 3 A 20 49 49/73
93 https://www.toolboxdigitalshop.com/exclusive/?preorder=Y#releases Pre-Orders 3 A 20 40 40/93
96 http://www.toolboxdigitalshop.com/hard-trance/?preorder=Y#releases Pre-Orders 3 A 20 45 42/45/96
98 http://www.toolboxdigitalshop.com/hardstyle/?preorder=Y#releases Pre-Orders 3 A 20 47 42/47/98
105 index.php?dispatch=categories.view&category_id=70 USB's 3 A 20 99 99/105
108 http://www.toolboxdigitalshop.com/submit-dj-chart.html Submit DJ Chart 3 A 20 85 85/108
112 index.php?dispatch=categories.view&category_id=75 VST Preset Banks 3 A 20 51 51/112
172 index.php?dispatch=categories.view&category_id=56 Vests 3 A 20 57 52/57/172
42 Genres 3 A 30 0 42
45 index.php?dispatch=categories.view&category_id=3 Hard Trance 3 A 30 42 42/45
66 index.php?dispatch=categories.view&category_id=30 NRG 3 A 30 43 42/43/66
71 index.php?dispatch=categories.view&category_id=34 Old Skool 3 A 30 46 42/46/71
74 index.php?dispatch=categories.view&category_id=19 Hard Trance 3 A 30 49 49/74
94 http://www.toolboxdigitalshop.com/hard-dance/?preorder=Y#releases Pre-Orders 3 A 30 44 42/44/94
106 index.php?dispatch=categories.view&category_id=62 Vinyl 3 A 30 99 99/106
170 index.php?dispatch=categories.view&category_id=78 Project Files 3 A 30 51 51/170
46 index.php?dispatch=categories.view&category_id=22 Hardcore 3 A 40 42 42/46
69 index.php?dispatch=categories.view&category_id=32 Free Form 3 A 40 46 42/46/69
75 index.php?dispatch=categories.view&category_id=23 Hardcore 3 A 40 49 49/75
85 index.php?dispatch=categories.view&category_id=57 Charts/Bundles 3 A 40 0 85
95 http://www.toolboxdigitalshop.com/hard-house/?preorder=Y#releases Pre-Orders 3 A 40 43 42/43/95
178 index.php?dispatch=categories.view&category_id=86 Track Stems 3 A 40 51 51/178
47 index.php?dispatch=categories.view&category_id=25 Hardstyle 3 A 50 42 42/47
49 index.php?dispatch=categories.view&category_id=13 Compilations 3 A 50 0 49
76 index.php?dispatch=categories.view&category_id=26 Hardstyle 3 A 50 49 49/76
97 http://www.toolboxdigitalshop.com/hardcore/?preorder=Y#releases Pre-Orders 3 A 50 46 42/46/97
48 index.php?dispatch=categories.view&category_id=21 Classics 3 A 60 42 42/48
51 index.php?dispatch=categories.view&category_id=20 Sample Packs 3 A 60 0 51
99 index.php?dispatch=categories.view&category_id=60 CD/USB 3 A 65 0 99
83 Other 3 A 70 42 42/83
50 index.php?dispatch=categories.view&category_id=50 Free Downloads 3 A 80 83 42/83/50
100 http://www.toolboxdigitalshop.com/compilations/?preorder=Y#releases Pre-Orders 3 A 100 49 49/100
113 index.php?dispatch=categories.view&category_id=77 Top 50 3 A 110 49 49/113