and (type+cph_id) not in ('','pAQ_DRAGONFLYCOPPER','pAQ_Rocket88','pAQ_USB_Diamond','pAQ_DRAGONFLYRED','pAQ_Rocket33','pAQ_Evergreen','pAQ_Rocket44','pAQ_Tower','pAQ_USB_Coffee','pAQ_Type5','pAQ_Type9DBS','pAQ_GoldenGate','pAQ_USB_Carbon','pAQ_USB_Forest','pAQ_COAX_Coffee','pAQ_Type9','pAQ_COAX_Carbon','pAQ_USB_Pearl','pAQ_POWERQUEST3','pAQ_USB_Cinnamon','pAQ_Cinnamon48','pAQ_Niagara5000','pAQ_303','pAQ_707','pAQ_505','pAQ_HDMI_Dragon48','pAQ_909','pAQ_HDMI_PEARL48','pAQ_Niagara3000','pAQ_Niagara7000','pAQ_Forest48','pAQ_Opt_Pearl','pAQ_ThunderBird48','pAQ_HDMI_FireBird48','pAQ_Vodka48','pAQ_Opt_Carbon','pAQ_Carbon48','pAQ_Opt_Vodka','pAQ_Angel','pAQ_RJE_DIAMOND','pAQ_Opt_Cinnamon','pAQ_COAX_Cinnamon','pAQ_RedRiver','pAQ_Opt_Forest','pAQ_Sydney','pAQ_G8','pAQ_RJE_Cinnamon','pAQ_RJE_Vodka','pAQ_Yosemite','pAQ_RJE_Pearl','pAQ_RJE_Forest','pAQ_COAX_Forest','pAQ_BigSur','pAQ_Chicago','pAQ_ALL','pAQ_RecordBrush','h40') select top 50 *,(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='rwd1709' /*and type<>'c'*/ and ( toltext like '%audioquest%' ) and (type+cph_id) not in ('','pAQ_DRAGONFLYCOPPER','pAQ_Rocket88','pAQ_USB_Diamond','pAQ_DRAGONFLYRED','pAQ_Rocket33','pAQ_Evergreen','pAQ_Rocket44','pAQ_Tower','pAQ_USB_Coffee','pAQ_Type5','pAQ_Type9DBS','pAQ_GoldenGate','pAQ_USB_Carbon','pAQ_USB_Forest','pAQ_COAX_Coffee','pAQ_Type9','pAQ_COAX_Carbon','pAQ_USB_Pearl','pAQ_POWERQUEST3','pAQ_USB_Cinnamon','pAQ_Cinnamon48','pAQ_Niagara5000','pAQ_303','pAQ_707','pAQ_505','pAQ_HDMI_Dragon48','pAQ_909','pAQ_HDMI_PEARL48','pAQ_Niagara3000','pAQ_Niagara7000','pAQ_Forest48','pAQ_Opt_Pearl','pAQ_ThunderBird48','pAQ_HDMI_FireBird48','pAQ_Vodka48','pAQ_Opt_Carbon','pAQ_Carbon48','pAQ_Opt_Vodka','pAQ_Angel','pAQ_RJE_DIAMOND','pAQ_Opt_Cinnamon','pAQ_COAX_Cinnamon','pAQ_RedRiver','pAQ_Opt_Forest','pAQ_Sydney','pAQ_G8','pAQ_RJE_Cinnamon','pAQ_RJE_Vodka','pAQ_Yosemite','pAQ_RJE_Pearl','pAQ_RJE_Forest','pAQ_COAX_Forest','pAQ_BigSur','pAQ_Chicago','pAQ_ALL','pAQ_RecordBrush','h40') order by (CASE WHEN type = 'c' THEN 1 WHEN type = 'p' THEN 2 WHEN type = 'h' THEN 3 END) asc, clickC desc