织梦用sql主表关联栏目查询生成静态url语句的办法

	$dsql->SetQuery("SELECT arc.*,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,tp.namerule,
tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath FROM `dede_archives` arc LEFT JOIN `dede_arctype` tp
 on arc.typeid=tp.id WHERE 
        FROM_UNIXTIME(arc.senddate,&＃39;%Y-%m-%d&＃39;) = "."&＃39;".date(&＃39;Y-m-d&＃39;)."&＃39;");
	$dsql->Execute();
	while ($rows = $dsql->GetArray()) {
		$rows[&＃39;url&＃39;] = GetFileUrl($rows[&＃39;id&＃39;],$rows[&＃39;typeid&＃39;],$rows[&＃39;senddate&＃39;],$rows[&＃39;title&＃39;],$rows[&＃39;ismake&＃39;],
$rows[&＃39;arcrank&＃39;],$rows[&＃39;namerule&＃39;],$rows[&＃39;typedir&＃39;],$rows[&＃39;money&＃39;],$rows[&＃39;filename&＃39;],$rows[&＃39;moresite&＃39;],$rows[&＃39;siteurl&＃39;],
$rows[&＃39;sitepath&＃39;]);
		$arcArray[] = $rows;
	}