select * from ebay_cate_recommendation
where SITE_ID = 100
select max(id) maxid from ebay_cate_recommendation
select * from ebay_user
where ebay_user_name = "xchzhang2013"
SELECT * from ebay_cate_recommendation where category_id = 33645 and site_id = 100
SELECT * from EBAY_CATE_NAME_RECO where reco_id = 49640
SELECT *from EBAY_CATE_VALID where name_id in (177570, 177571, 177572 , 177573, 177574, 177575, 177576, 177577, 177578)
ebay_sitedetailebay_sitedetailebay_sitedetailebay_sitedetail
SELECT * from EBAY_CATE_VALUE_RECO where siviomall_userviomall_userte_id = 100
SELECT * from EBAY_CATE_RELATIONSHIP where site_id = 100
where SITE_ID = 100
select max(id) maxid from ebay_cate_recommendation
select * from ebay_user
where ebay_user_name = "xchzhang2013"
SELECT * from ebay_cate_recommendation where category_id = 33645 and site_id = 100
SELECT * from EBAY_CATE_NAME_RECO where reco_id = 49640
SELECT *from EBAY_CATE_VALID where name_id in (177570, 177571, 177572 , 177573, 177574, 177575, 177576, 177577, 177578)
ebay_sitedetailebay_sitedetailebay_sitedetailebay_sitedetail
SELECT * from EBAY_CATE_VALUE_RECO where siviomall_userviomall_userte_id = 100
SELECT * from EBAY_CATE_RELATIONSHIP where site_id = 100