Order by, Limit y Offset - mayako/Spaguetti GitHub Wiki

ORDER BY

# ORDER BY date
$query->order('date');

# ORDER BY date1 ASC, date2 DESC
$query->order('date1 ASC, date2 DESC');

# ORDER BY date DESC
$query->order('date', 'desc');

# ORDER BY date1 DESC, date2 ASC
$query
  ->order('date1', 'desc');
  ->order('date2', 'asc');

LIMIT y OFFSET

# LIMIT 10 OFFSET 5
$query->limit(10)->offset(5);