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 '%eb%' and toltext like '%duet%' ) 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 ('','p10939','p5516','p4715212909381','p0749350264501','p4715212909237','p0749350264518','p264617','p0749350264556','p0749350264532','p0749350264525','p0749350264495','p9555568901333','pKWR20268003UM','p9555568901579','p4586','p2156','p5225','p11438','p11437','p5226','p6261','p7669','p11410','p8245','p11330','p10746')