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 (24) And arc.arcrank > -1 ORDER BY arc.sortrank desc LIMIT 0,1 宁波富达
  • 共 0 页/0 条记录
  • 共 0 页/0 条记录