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