Laravel 4 - Eager Load Constraints

eloquent_example.php

<?php

Quota::with(
  array(
    'codes' => function($query) {
      $query->where('number', '=', 11);
    }
  )
)
->where('label', '=', 'foo')
->whereRaw('quotas.count < quotas.limit')
->orderBy('count')
->orderBy('id', 'desc')
->get();

sql_example.sql

Select *

From quotas as q

Join codes as c
  on (c.quotaId = q.id)

Where
  q.label = 'foo' and
  c.number = 11 and
  q.count < q.limit

Order by
  q.count asc,
  q.id desc;