duplicate when you run a select query data from a table sorted by date and ustnovki limit for pagination.
SELECT iblock.ID AS ID, iblock.TIMESTAMP_X FROM b_iblock_element iblock WHERE iblock.ACTIVE = ‘Y’ AND iblock.ACTIVE_TO > ‘2016-03-29 10:54:00’ AND iblock.IBLOCK_ID = 39 ORDER BY iblock.TIMESTAMP_X DESC LIMIT 20, 10;
SELECT iblock.ID AS ID, iblock.TIMESTAMP_X FROM b_iblock_element iblock WHERE iblock.ACTIVE = ‘Y’ AND iblock.ACTIVE_TO > ‘2016-03-29 10:54:00’ AND iblock.IBLOCK_ID = 39 ORDER BY iblock.TIMESTAMP_X DESC LIMIT 30, 10;