# app_states

state_type: view
name: value-period
created_at: 2012-08-01 07:48:54.847376
updated_at: 2012-08-01 07:48:54.847376
select_clause: total( o.total )
from_clause: companies c, orders o
where_clause:
  c.name = 'companyB' and o.company_id = c.id and o.date between date( '2012-03-01' ) and date( '2012-06-01' )


