SELECT COUNT(*) AS cnt FROM g5_shop_item WHERE 1 AND (it_origin LIKE '%비틀즈%' OR it_name LIKE '%비틀즈%' OR it_basic LIKE '%비틀즈%' OR it_explan LIKE '%비틀즈%' ) AND (ca_id like '50%' or ca_id2 like '50%' or ca_id3 like '50%') and it_use = '1'
select * from `g5_shop_item` where it_use = '1' AND ( it_origin LIKE '%비틀즈%' OR it_origin LIKE '%비틀즈%' OR it_name LIKE '%비틀즈%' OR it_basic LIKE '%비틀즈%' OR it_explan LIKE '%비틀즈%' ) ORDER BY it_order, it_id desc limit 0 , 24