select link_no,kind_name from kind_link l left join kind k on k.kind_no=l.link_no and k.active = '1' where level1=link_no and kind_name is not null order by sort,kind_name
SELECT * FROM ad where title='15' and status <>0 order by sort
品牌/商品
select open_not_mb from comp_data
select * from product_m where prod_no = 'WDD0831200CA' and ((prod_sell=1 and start_time_flag='0' and end_time_flag='0') or(prod_sell=1 and start_time_flag='1' and start_time<='1769702400' and end_time_flag=0) or(prod_sell=1 and start_time_flag='0' and end_time_flag='1' and end_time>='1769702400') or(prod_sell=1 and start_time_flag='1' and start_time<='1769702400' and end_time_flag='1' and end_time>='1769702400'))