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 FIND_IN_SET('h', arc.flag)>0 And arc.typeid IN (21) And arc.arcrank > -1 ORDER BY arc.sortrank desc LIMIT 0,1 寧波富達股份有限公司