select('*').from('table').where('1 = 1').groupBy('column').orderBy('count DESC').limit(0, 100) - View it on GitHub