select * from posts where YEAR(creationdate)>=2010 AND YE...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla Meta

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 2250000 ROWS FETCH NEXT 50000 ROWS ONLY

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results