select count(*) as cnt
from 	project p,
	importrec rhe
	inner join imprec_sewerinsps ihe on rhe.importrecid=ihe.imprecid
	inner join inspection iihe on ihe.inspectionid=iihe.id
	inner join headerconflict che on iihe.id=che.inspectionid
	inner join conflict rche on che.rawconflict=rche.conflictid
	inner join conflict_error eche on rche.conflictid=eche.conflictid
	inner join value vvhe on eche.valueid=vvhe.valueid,
	importrec rho
	inner join imprec_sewerinsps iho on rho.importrecid=iho.imprecid
	inner join inspection iiho on iho.inspectionid=iiho.id
	inner join headerconflict cho on iiho.id=cho.inspectionid
	inner join conflict rcho on cho.rawconflict=rcho.conflictid
	inner join conflict_obmission vho on rcho.conflictid=vho.conflictid
	inner join value vvho on vho.valueid=vvho.valueid,
	importrec r
	inner join imprectype t on r.rectypeid=t.imprectypeid
	inner join imprectype_propnames n on t.imprectypeid=n.imprectypeid