校验分类匹配是否存在混乱

select DISTINCT n.category_relation_id,
                n.source_shop_type,
                n.purpose_shop_type,
                s1.combine_name,
                s2.combine_name
  from shopcategoryrelation n, shopcat s1, shopcat s2
 where n.source_category_id = s1.cid
   and n.purpose_category_id = s2.cid
   and s1.combine_name like '%男%'
   and s2.combine_name like '%女%';

校验分类匹配是否存在混乱,需要定时校验

posted @ 2014-09-17 09:41  举起希望之灯  阅读(195)  评论(0)    收藏  举报