I use this to get 10 "Article" items, ranked by "RankingDate":
DataObject::get("Article", $q ,'RankingDate DESC','','10');
I only want ODD items to be returned. Only the 1st, 3rd, 5th, 7th and 9th item should be returned.
The MySQL query for that looks something like this:
select * from (select *, @rn:[email protected]+1 rn from (select @rn:=0) r, `sitetree` WHERE `ClassName` LIKE '%Article%' order by `Title` limit 10 ) sq where rn%2=1
How can I do this with DataObject::get()?