select it.item_id, ic.item_category_name, xu.name from item as it, item_category_master as ic, xoops_users as xu where ( it.item_comment like '%ƥ顼%' or it.item_brand like '%ƥ顼%' or it.item_name like '%ƥ顼%' or ic.item_category_name like '%ƥ顼%' ) and it.item_category = ic.item_category_id and it.shop_id = xu.uid order by it.item_id desc, item_update desc;

select it.item_id, it.shop_id, it.item_category, it.item_brand, it.item_name, it.item_price, it.item_update, ic.item_category_name, xu.name, xu.uname, xu.user_from, xu.shop_tel from item as it, item_category_master as ic, xoops_users as xu where ( it.item_comment like '%ƥ顼%' or it.item_brand like '%ƥ顼%' or it.item_name like '%ƥ顼%' or ic.item_category_name like '%ƥ顼%' ) and it.item_category = ic.item_category_id and it.shop_id = xu.uid order by it.item_id desc, item_update desc, xu.chargeop desc limit 11 offset 0;