SELECT if(c.id=30559,30559,c.id) AS comp_id, if(r.category != '其它地区', substring_index(r.category, '/', 1), '其它') as c_region, c.company, c.tel, c.fax, c.company_http, c.email, c.address, c.zip, c.shows, c.cate AS mkt, if( c.shows LIKE '%F%' or c.shows LIKE 'A%','A','') AS chinasupplier_comp, p.id AS prod_id, p.product, p.spec, p.shows LIKE '%A%' AS chinasupplier_prod, if( p.shows LIKE 'A%' and (c.shows LIKE 'A%' or c.shows LIKE '%F%') AND p.rank > 10, 11, if(p.rank > 10, 12, abs(p.rank) )) AS rank, if( c.shows LIKE '%F%', c.shows, '') AS chinasupplier_pic, replace( p.rank, '-', 'a' ) AS srank, c.id as cid, c.poster, if( p.shows LIKE 'A%' AND p.rank < 11, replace( p.rank, '-', 'a' ), 'A') AS showsx, is_link FROM suppliers.company_cn AS c, suppliers.product_cn AS p, supplier_search.w_chemnet_supp_list_cn AS s, netsun_cate.regional as r WHERE s.entry_id = 261397 AND s.prod_id = p.id AND p.asid = c.id AND c.regional = r.cat_id AND 1 and r.category like '%广东%' ORDER BY rank ASC,comp_id ASC