SELECT de.name as dataelementname, de.shortname as dataelementshortname, de.uid as de_uid, de.dataelementid, de.categorycomboid,
coc.name as cocname, coc.uid as cocuid, coc.categoryoptioncomboid, cc.categorycomboid, cc.name as ccname, cc.uid as ccuid 
FROM dataelement de LEFT JOIN categorycombos_optioncombos coccc on de.categorycomboid = coccc.categorycomboid
LEFT JOIN categorycombo cc ON coccc.categorycomboid = cc.categorycomboid
LEFT JOIN categoryoptioncombo coc ON coccc.categoryoptioncomboid = coc.categoryoptioncomboid
ORDER BY de.dataelementid