with q1 as 
(SELECT ADMIN777.MESSAGE.id, ADMIN777.MESSAGE.type_id, ADMIN777.MESSAGE.status_id, 
 ADMIN777.MESSAGE.title, ADMIN777.MESSAGE.anons, ADMIN777.MESSAGE.body, 
ADMIN777.MESSAGE.datecreate, ADMIN777.MESSAGE.author, ADMIN777.MESSAGE.visible_id, 
ADMIN777.MESSAGE.rank, ROW_NUMBER() OVER (ORDER BY ADMIN777.MESSAGE.id) as number 
FROM ADMIN777.MESSAGE 
left join ADMIN777.MESSAGE_REGION 
on (ADMIN777.MESSAGE.ID = ADMIN777.MESSAGE_REGION.MESSAGE_ID) 
left join ADMIN777.MESSAGE_TAG 
on (ADMIN777.MESSAGE.ID = ADMIN777.MESSAGE_TAG.MESSAGE_ID) 
Where ADMIN777.MESSAGE_REGION.REGION_ID in( 0 ) and ADMIN777.MESSAGE_TAG.TAG_ID in ( 0 ) and 
ADMIN777.MESSAGE.status_id= 0  and ADMIN777.MESSAGE.type_id= 0  
and (ADMIN777.MESSAGE.datecreate between '2008-04-03-00.00.00.00000' and '2008-07-03-
23.59.59.999999')) 
select * from q1 where number> 10  and number<= 20