CATEGORY IDS

category_id name
24 Avionics
25 Nav-Comms
26 Instruments
27 Transponders
28 ADFs
29 Flight Instruments
30 Engine Instruments
31 Other Instruments
32 Airline Instruments
33 Warbird Instruments
34 WWII Instruments
35 Korean & Vietnam War Instr
36 Other Warbird Instruments
37 Turbine instruments
38 Audio Panels
39 Other Avionics
40 DMEs
41 Marker Beacons
43 LORANs
44 Airframe Parts
45 Engine Parts
47 Aircraft Hardware
48 Helicopter Parts
49 Aircraft Tools
50 Aircraft Upholstery
52 Misc Aircraft Supplies
54 Aircraft Manuals
56 Aviation Memorabilia
59 NEW Beechcraft Parts
60 Instrument Panels
61 Other
62 Interior Parts
63 Electrical Parts
64 Landing Gear
65 Wheels and Brakes
66 All Other
67 Fairings
68 Warbird Avionics
69 Recip Engine
70 Radial Engine
71 Turbine Engine
72 Cherry Rivets
73 Titanium
74 Leather
75 Naugahyde
76 Fabric
77 Carpet
78 Sound Proofing
79 All Other
80 Airframe
81 Engine
82 Avionics
83 Flight and Pilot
84 Component and Accessory
85 All Other
86 Hand Tools
87 Power Tools
88 Special Tools
89 Radial Engine
90 Turbine Engine
91 All Other
92 WWII Aviation
93 Koren and Vietnam War
94 Airline
95 All Other
96 Antennas
97 Airline
99 Navigation Instruments
100 GPSs
101 Airline Avionics
102 Airline Parts
103 Warbird Parts
104 AN, MS, NAS & Other
105 NEW Cessna Parts
106 Pilot Supplies
107 Avionics Parts
108 Helicopter Instruments
109 NEW Piper parts
110 Instrument Parts
111 Recip Engine
112 Used Cessna Parts
113 Used Beechcraft Parts
114 Used Piper Parts
116 Avionics Connectors
117 Other
   
sql query  
   
SELECT c.category_id,cd.name FROM `oc_category` c left join `oc_category_description` cd on c.category_id = cd.category_id WHERE c.status = 1