select count(distinct i.contact_id)
from iv_invoices i, cr_items ii, cr_items fi
where ii.latest_revision = i.invoice_id
and ii.item_id = fi.parent_id
and fi.item_id in ([join $file_id ,])
select max(i.contact_id) as contact_id, max(i.organization_id) as organization_id
from iv_invoices i, cr_items ii, cr_items fi
where ii.latest_revision = i.invoice_id
and ii.item_id = fi.parent_id
and fi.item_id in ([join $file_id ,])
select i.invoice_nr
from iv_invoices i, cr_items ii, cr_items fi
where ii.latest_revision = i.invoice_id
and ii.item_id = fi.parent_id
and fi.item_id in ([join $file_id ,])