表

 

select * from prod_catalog; -- 目录

select * from prod_catalog_category where PROD_CATALOG_ID='DigitalPhone'; -- 目录

select * from product_category a where a.PRODUCT_CATEGORY_ID= 'mobile' ; -- 分类

 select * from product_category_rollup where PARENT_PRODUCT_CATEGORY_ID= 'mobile' ; -- 汇总

 select * from product_category_rollup where PARENT_PRODUCT_CATEGORY_ID= 'operator' ;

select LONG_DESCRIPTION ,PRIMARY_PRODUCT_CATEGORY_ID from product where PRIMARY_PRODUCT_CATEGORY_ID='mobileT';

 

select * product_category_member -- 产品关联分类

select * from prod_catalog; -- 目录

select * from prod_catalog_category where PROD_CATALOG_ID='XXXB'; -- 目录

select * from product_category a where a.PRODUCT_CATEGORY_ID in('XBXBZL','AD') ; -- 分类

select a.PROD_CATALOG_ID,a.PROD_CATALOG_CATEGORY_TYPE_ID,a.PRODUCT_CATEGORY_ID,b.CATEGORY_NAME,b.PRODUCT_CATEGORY_TYPE_ID from prod_catalog_category a , product_category b where a.PRODUCT_CATEGORY_ID=b.PRODUCT_CATEGORY_ID and a.PROD_CATALOG_ID='XXXB'

select * from prod_catalog; -- 目录

select * from prod_catalog_category where PROD_CATALOG_ID='XXXB'; -- 目录

select * from product_category a where a.PRODUCT_CATEGORY_ID in('XBXBZL','AD') ; -- 分类

select a.PROD_CATALOG_ID,a.PROD_CATALOG_CATEGORY_TYPE_ID,a.PRODUCT_CATEGORY_ID,b.CATEGORY_NAME,b.PRODUCT_CATEGORY_TYPE_ID from prod_catalog_category a , product_category b where a.PRODUCT_CATEGORY_ID=b.PRODUCT_CATEGORY_ID and a.PROD_CATALOG_ID='XXXB'

;

 select * from product_category_rollup where PARENT_PRODUCT_CATEGORY_ID= 'XBXBZL' ;

select b.CATEGORY_NAME from product_category_rollup a, product_category b

 where a.PRODUCT_CATEGORY_ID=b.PRODUCT_CATEGORY_ID and PARENT_PRODUCT_CATEGORY_ID= 'NANX' ;