0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Joomla! administrators, users, developers and designers

select * from posts
where YEAR(creationdate)>=2010 AND YEAR(creationdate)<2014 and parentid is null
order by creationdate asc
OFFSET 1950000 ROWS FETCH NEXT 50000 ROWS ONLY

view current version

edited oct 18 21

created oct 18 21 green.fuzer