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:=@rn+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()?