SELECT pc.categories_id, pcd.categories_name, pc.categories_parent_id ,pc.categories_url_override, pc.category_append_cdpath,pc.categories_url_override_target
from TABLE_CDS_CATEGORIES pc,
TABLE_CDS_CATEGORIES_DESCRIPTION pcd
WHERE pc.categories_parent_id = '0'
and pc.categories_id = pcd.categories_id
and pcd.language_id='1'
and pc.categories_status = '1'
ORDER BY pc.categories_sort_order,pcd.categories_name
