5.5要关联多张表查询了,你看看ks_specialr和ks_product关联吧

试试

select top 10 id,title from ks_product a inner join ks_specialr b on a.id=b.infoid where b.specialid={$CurrSpecialID} order by a.id desc