SELECT COUNT(*) AS cnt FROM g5_shop_item WHERE 1 AND (ca_id like '5010%' or ca_id2 like '5010%' or ca_id3 like '5010%') and it_use = '1'
select * from `g5_shop_item` where it_use = '1' and ( ca_id like '50%' or ca_id2 like '50%' or ca_id3 like '50%' ) ORDER BY it_order, it_id desc limit 0 , 24