select *
from shop_goods
where shop_state = '0'
and isopen IN('1','2')
and (mb_goods = '0' or ( mb_goods = '1' and (mb_id = 'tailwind' or mb_id = 'tailwind' or pt_id = 'tailwind' or sub_url = 'tailwind') ) )
and find_in_set('tailwind', mb_pid) = '0'
and find_in_set('tailwind', re_pid) = '0'
and (ca_id like '015001003%'
or ca_id2 like '015001003%'
or ca_id3 like '015001003%')
order by index_no desc, goods_price asc
limit 0, 200