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

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 '%女%';