- home
-
彩妆
-
美发护发
-
护肤&香水
-
保健产品
-
婴幼儿用品/食品
-
食品
-
厨具
-
宠物用品
- 汽车护理
-
小家电
-
Veltins/ 费尔廷斯啤酒
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