SELECT * FROM `list` WHERE user='1' ORDER BY date DESC, id DESC LIMIT 0, 25
WITH
cte AS (
SELECT * ,
ROW_NUMBER() OVER (ORDER BY `date` DESC, id DESC) rn,
DENSE_RANK() OVER (ORDER BY `date` DESC, id DESC) dr
FROM `list`
WHERE user='1'
)
SELECT *
FROM cte
WHERE dr <= (
SELECT dr
FROM cte
WHERE rn = 25
)
Версия сервера: 5.6.51 - MySQL Community Server (GPL)
SELECT *
FROM `list`
WHERE user='1'
AND `date` >= (
SELECT `date`
FROM 'list'
WHERE user='1'
ORDER BY `date` DESC, id DESC LIMIT 24, 1
)