2 select * from `g5_shop_item` where it_use = '1' and (ca_id like '30%' or ca_id2 like '30%' or ca_id3 like '30%') order by it_order, pt_num desc, it_id desc limit 15, 15