sql查询

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