181 : FROM (select Firm_id,Sale_No, Lot_No, htmlfile, currency, Realized as PRICE, INLINEIMG,LINKEDIMG,htmltext,row_number() over (order by dbo.Catalog_sort(Wlots.Lot_No)) as SANRowNo
182 : from WLOTS
183 : where WLOTS.SALE_NO = '#session.CURR_SALE#' and WLOTS.FIRM_ID = '#session.FIRM_ID#' and MAJGROUP LIKE '#MAJGROUP#' ) a ORDER BY a.SANRowNo
184 : <!--- WHERE a.SanRowNo between #session.nextrecordtoshow# and #session.lastrecordtoshow# ORDER BY a.SANRowNo --->
185 :
|