SELECT * FROM (SELECT ROWNUM AS WT_ROWNUM, WT_THISTABLE.* FROM ( SELECT enews.transparency.* FROM enews.transparency WHERE 1=1 AND Publish='Y' AND Period = ? AND Version = ? ORDER BY enews.transparency.service_lable asc, enews.transparency.payment_date asc, enews.transparency.transparency_id ASC) WT_THISTABLE WHERE ROWNUM <= 120 ) WHERE WT_ROWNUM >= 101 and REGEXP_LIKE ( organisational_unit, '[^a-zA-Z .''&,-]')
adus
8