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 '%fim%' ) 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 ('','p4163','p10763','p7884','p7870','p8066','p11292','p10705','p10520','p9782','p6745','p10841','p10836','p8760','p10840','p8759','p1933','p8064','p8761','p10713','p8054','p7875','p7378','p8758','p7869','p10749','p8055','p10737','p8762','p10710','p8857','p11304','p10711','p10263','p10660','p10717','p10720','p10743','p10731','p10721','p10766','p10709','p10741','p10715','p10747','p10704','p11846','p10714','p10744','p10727','p10762','p10634','p10707','p7828','p10754','p10736','p10730','p10636','p10699','p10750','p10691','p10723','p10716','p11847','p10775','p10739','p10693','p10725','p10657','p10746','p10724','p10759','p10719','p10753','p10745','p10734','p10767','p10694','p10764','p10748','p10761','p1728','p10726','p10894','pM039A')