$sql = "SELECT mb.*,ms.spacename,ms.sign FROM `dede_member` mb
        LEFT JOIN `dede_member_space` ms ON ms.mid = mb.mid
        $wheresql order by mb.{$orderby} DESC LIMIT 0,$row ";

if($orderby=='homecount')
    {
    $sql = "SELECT mb.*,ms.spacename,ms.sign,ht.homecount FROM `dede_member` mb
        LEFT JOIN `dede_member_space` ms ON ms.mid = mb.mid left join  `dede_member_tj` ht ON ht.mid = mb.mid
        $wheresql order by ht.homecount DESC LIMIT 0,$row ";
    }
    else
    {
        $sql = "SELECT mb.*,ms.spacename,ms.sign,ht.homecount FROM `dede_member` mb
        LEFT JOIN `dede_member_space` ms ON ms.mid = mb.mid left join  `dede_member_tj` ht ON ht.mid = mb.mid
        $wheresql order by mb.{$orderby} DESC LIMIT 0,$row ";
    }

while($row = $dsql->GetArray('mb'))

$GLOBALS['autoindex']='1';

$revalue .= $ctp->GetResult();

$GLOBALS['autoindex']++;

{dede:memberlist row='15' orderby='homecount'}
	
 
	[field:global.autoindex/]、[field:uname/]  
	
 {/dede:memberlist}