select top 100 *,(CASE WHEN type = 'c' THEN 'category.asp?category_id=' WHEN type = 'p' THEN 'product.asp?prodid=' WHEN type = 'h' THEN 'news.asp?newsno=' end) linkstr from srh_cph (nolock) where partnerid='rwd1899' and type<>'c' and (1=1 and toltext like '%霍內克%' and toltext like '%指揮%' ) order by (CASE WHEN type = 'c' THEN 1 WHEN type = 'p' THEN 2 WHEN type = 'h' THEN 3 END) asc, clickC desc
and (type+cph_id) not in ('','p11288','p9737','p030911276928_RR','p11092','p11943','p11582','p030911273828','p10545','p9206','p11406','p9965','p8307','p10933','p9205','p10544')