select oo.organization_id as customer_id, oo.name as customer_name, sum(i.total_amount) as amount_total, count(*) as invoice_count from organizations oo, iv_invoices i, cr_items ci, acs_objects ao where i.organization_id = oo.organization_id and ao.object_id = ci.item_id and i.invoice_id = ci.latest_revision and i.cancelled_p = 'f' [template::list::filter_where_clauses -and -name "reports"] group by oo.organization_id, oo.name [template::list::orderby_clause -name reports -orderby] select oo.organization_id as customer_id, oo.name as customer_name, sum(i.total_amount) as amount_total, count(*) as invoice_count from organizations oo, iv_invoices i, cr_items ci, acs_objects ao, postal_addresses p, ams_attribute_values av, cr_items ooi where i.organization_id = oo.organization_id and ao.object_id = ci.item_id and i.invoice_id = ci.latest_revision and i.cancelled_p = 'f' and ooi.item_id = oo.organization_id and av.object_id = ooi.latest_revision and av.attribute_id = :postal_attribute_id and p.address_id = av.value_id [template::list::filter_where_clauses -and -name "reports"] group by oo.organization_id, oo.name [template::list::orderby_clause -name reports -orderby]