$dsql->SetQuery("Select tid From `dede_taglist` where arcrank<=-1");  
        $dsql->Execute();
        $ids = '';
        while($row = $dsql->GetArray())
        {
            $tid = $row['tid'];
            $cquery = "Select count(*) as dd From `dede_taglist` where tid = $tid and arcrank<=-1";
            $crow = $dsql->GetOne($cquery);
            if(!$crow['dd'])
            {
                $ids .= ( $ids=='' ? $row['tid'] : ','.$row['tid'] );
            }
        }
        if($ids != '')
        {
            $addsql= " where id not in($ids) ";
        }
        if(!empty($typeid))
        {
            if($addsql)
            {
                $addsql= " and typeid='$typeid' ";
            }else{
                $addsql= " where typeid='$typeid'" ;
            }
        }