Deying

select c.entity_id, cv.store_id,cv.value as name, c.url_path from `catalog_category_flat_store_1` c left join `catalog_category_entity_varchar` cv on c.entity_id=cv.entity_id and (cv.store_id='1' or cv.store_id='0') and cv.attribute_id='41' where c.parent_id='2' and c.is_active = 1 and c.store_id='1' and c.sw_cat_hide_menu_item = 0 order by c.position, cv.store_id desc,c.entity_id