Laravel по-русски

SELECT COUNT(DISTINCT hash_code) AS `aggregate` FROM `cars`

SELECT
 f1.hash_code, f1.field1, f1.field2
 count(firm_code) as cntm, max(f1.price) as price_max, min(f1.price) as price_min
FROM
 `cars` f1
GROUP BY f1.hash_code
ORDER BY cntm DESC

  public function paginate_with_group_by($per_page = 20, $columns = array('*'))
  {
    // Because some database engines may throw errors if we leave orderings
    // on the query when retrieving the total number of records, we'll drop
    // all of the ordreings and put them back on the query.
    list($orderings, $this->orderings) = array($this->orderings, null);

    $temp_distinct = $this->distinct;
    $temp_groups = $this->groupings;
    $this->distinct();
    $this->groupings = null;
    $total = $this->count(reset($columns));
    $this->distinct = $temp_distinct;
    $this->groupings = $temp_groups;

    $page = Paginator::page($total, $per_page);
    $this->orderings = $orderings;

    // Now we're ready to get the actual pagination results from the table
    // using the for_page and get methods. The "for_page" method provides
    // a convenient way to set the paging limit and offset.
    $results = $this->for_page($page, $per_page)->get($columns);

    return Paginator::make($results, $total, $per_page);
  }