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 `#@__archives` arc LEFT JOIN `#@__arctype` tp on arc.typeid=tp.id
WHERE arc.typeid IN (19) And arc.arcrank > -1 order by arc.weight asc LIMIT 10 寧波富達股份有限公司
