SELECT /*top*/ /*TOP 10*/
  Objects_tbl.DataSetName,
  Objects_tbl.DataSetType,
  Objects_tbl.DataSetFromSiteID,
  Objects_tbl.DataSetIrRelation,
  Objects_tbl.DataSetOwningSiteID,
  Objects_tbl.DataSetFs_Vol,
  Objects_tbl.DataSetLastModDate
FROM
  dbo.DataSet_tbl Objects_tbl
/*WHERE
  (Objects_tbl.ProcStateCol01 IS NULL OR
  Objects_tbl.ProcStateCol01 = 'N') AND
  'where' = 'where'*/
  /*where*/
ORDER BY
  DataSetUgMaster_CompCount DESC,
  DataSetUgMaster_FsHitCount,
  DataSetLastModDate